Principal Engineer I - Data Engg & AI

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.