Snowflake, Python and Talend Data Engineer (Senior Level)
Job/Project Description / Prerequisite Skills / Knowledge
- Native or Advanced/Proficiency in English is a must
- 4-5+ years of python experience is a must.
- Snowflake’s knowledge is a must.
- Structured Query Language (SQL) is a must
- Information systems/network architecture is a must.
- Relational database management experience is desired.
- Advanced PowerBI and Tableau is desired
- Talend is desired.
- Total I.T experience around 10 years is desired.
Role and Responsibilities
- As a Snowflake, Python, Talend, ETL/ELT – Data Engineer, you will be responsible for the following key tasks:
-
- Data Modeling: Collaborate with stakeholders to understand data requirements and design efficient data models within the Snowflake data warehouse. Develop and maintain data models, ensuring scalability, performance, and data integrity.
- ETL/ETL Development: Design and implement efficient Extract, Transform, Load (ETL) processes to ingest data from various sources into Snowflake. Ensure data quality and accuracy throughout the data pipeline, using Python, Talend or Native Snowflake functionalities.
- Snowflake Administration: Manage and optimize Snowflake databases, including configuring warehouses, monitoring performance, and troubleshooting issues.
- Power BI or Tableau Integration: Work closely with the Business Intelligence team to integrate Snowflake data into Power BI and Tableau for effective data visualization and reporting.
- Data Governance and Security: Implement and enforce data governance policies to ensure data security, privacy, and compliance with industry standards and regulations.
- Performance Tuning: Continuously monitor and optimize the performance of Snowflake queries and processes to meet SLAs and enhance overall system efficiency.
- Collaborative Team Player: Collaborate with cross-functional teams including Data Scientists, Analysts, and other stakeholders to understand data requirements and deliver solutions that meet business needs.
Qualifications and Skills
- To succeed in this role, the ideal candidate should possess the following qualifications and skills:
-
- Education: Bachelor’s degree in Computer Science, Information Systems, or a related field.
- Experience: A minimum of 3 years of experience in data engineering with a focus on Snowflake data warehousing.
- Data Modeling: Proven experience in designing and implementing data models using Snowflake or similar data warehousing technologies.
- ETL Development: Hands-on experience with ETL tools and processes, ensuring data accuracy and consistency.
- Power BI and Tableau: Proficiency in integrating Snowflake data into Power BI and Tableau for data visualization and reporting.
- SQL and Scripting: Strong SQL skills and knowledge of scripting languages (e.g., Python, Bash) to support data processing tasks.
- Problem-Solving: Analytical mindset with the ability to troubleshoot issues and optimize data processes for performance.
- Communication: Excellent verbal and written communication skills with the ability to convey complex technical concepts to non-technical stakeholders.
- Team Player: A collaborative attitude with a strong ability to work effectively within a team-oriented environment.
- Snowflake Certification: Optional but preferred, Snowflake certifications will be considered a plus.
Hiring Model: Contractor or FTE
Type of job: Home Office/Hybrid/Full time
Location: Dallas, Tx – USA (only)
