About the Role:
We are looking for a highly skilled Data Engineer / Analytics Engineer to design, develop, and optimize scalable data pipelines and analytics solutions. The ideal candidate will have strong expertise in Python, Advanced SQL, DBT, and Snowflake, with a passion for building efficient and reliable data infrastructure that supports business intelligence and analytics needs.
Key Responsibilities:
- Design, develop, and maintain robust data pipelines using Python, DBT, and Snowflake.
- Write and optimize complex SQL queries for data extraction, transformation, and analysis.
- Implement and manage data models in Snowflake to support reporting and analytical workloads.
- Collaborate with data analysts, data scientists, and business stakeholders to understand data requirements and deliver high-quality data solutions.
- Ensure data quality, integrity, and performance optimization across all data systems.
- Develop and maintain DBT models with modular, testable, and version-controlled transformations.
- Automate and monitor data workflows using modern orchestration tools (e.g., Airflow, Prefect).
- Support data governance and documentation best practices.
Required Skills and Qualifications:
- 4+ years of experience as a Data Engineer or Analytics Engineer.
- Strong proficiency in Python for data processing and automation.
- Expertise in Advanced SQL (CTEs, window functions, performance tuning).
- Hands-on experience with DBT (Data Build Tool) for data transformations.
- Solid experience with Snowflake (data modeling, warehouse design, performance optimization).
- Experience working with cloud data platforms (AWS, GCP, or Azure).
- Strong understanding of ETL/ELT processes and data lifecycle management.
- Excellent problem-solving and communication skills.