The posting
- Lead the design, development, optimization, and maintenance of scalable data pipelines using Snowflake and dbt.
- Own data engineering solutions end-to-end, from requirements analysis and data modeling through development, testing, and production deployment.
- Design efficient data models and transformation frameworks supporting enterprise analytics and business consumption.
- Develop and optimize complex SQL transformations, incremental processing, CDC, and ELT workflows.
- Troubleshoot complex data issues, perform root cause analysis, and implement sustainable engineering solutions.
- Establish engineering best practices around code quality, modularity, reusability, performance optimization, and cost efficiency.
- Build robust data quality, reconciliation, monitoring, and validation frameworks.
- Collaborate with architects, business stakeholders, and engineering teams to translate business requirements into scalable technical solutions.
- Lead technical design reviews, mentor engineers, and ensure high-quality deliverables.
- Identify opportunities for automation, simplification, and continuous improvement.
Required Technical Skills
- Snowflake: Strong hands-on expertise in Snowflake architecture, performance tuning, query optimization, warehouse sizing, Snowpark, and data loading strategies.
- dbt: Advanced experience with dbt models, incremental strategies, macros, Jinja, testing, snapshots, documentation, and CI/CD integration.
- SQL: Expert-level SQL skills, including complex joins, window functions, query optimization, and troubleshooting.
- Python: Strong programming skills for data engineering, automation, and integration.
- Data Modeling: Experience with dimensional modeling, medallion architecture, data warehousing, and enterprise data models.
- Data Engineering: Strong understanding of ETL/ELT, batch and incremental processing, CDC, data quality, and reconciliation.
- Cloud Platforms: Experience with Azure data services.
- DevOps: Experience with Git, CI/CD pipelines, deployment automation, and engineering standards.



