Senior Snowflake Data Engineer - AI-Assisted ETL

JPS Tech Solutions Pvt Ltd; Charlotte (NC); In loco; CAD 120.000 - 180.000; Tempo pieno

Descrizione del lavoro

JPS Tech Solutions Pvt Ltd is seeking a Senior Snowflake Data Engineer / Database Developer with 8+ years of experience. The role focuses on building scalable data pipelines, optimizing Snowflake environments, and delivering enterprise data solutions. Collaboration with business and technical teams is essential for success.

The ideal candidate will design data models, advanced SQL solutions, and implement robust testing, governance, and CI/CD practices to ensure data quality and performance.

Competenze

• 8+ years of professional experience in data engineering and database development.
• Strong hands-on expertise with Snowflake, Python, MySQL, and advanced SQL.
• Extensive experience developing ETL/ELT pipelines and enterprise data solutions.
• Knowledge of database design, data modeling, and relational databases.
• Hands-on experience with Snowflake infrastructure, data ingestion, performance tuning, and cost optimization.
• Experience with production troubleshooting, testing, code reviews, and SDLC processes.
• Hands-on experience with Git, Azure DevOps, and CI/CD pipelines.
• Strong data validation, reconciliation, and data quality processes.
• Excellent problem-solving, communication, documentation, and stakeholder management.

Mansioni

• Design, develop, and maintain scalable data pipelines using Python, Snowflake, and MySQL.
• Develop data models, schemas, stored procedures, and complex SQL solutions.
• Configure and optimize Snowflake warehouses, Snowpipe, clustering, and data ingestion processes.
• Improve data quality, reconciliation, performance, reliability, and cost efficiency.
• Troubleshoot complex production data issues and implement long-term solutions.
• Develop data sourcing, mastering, mapping, and reconciliation processes.
• Establish unit, integration, and data-quality testing practices.
• Participate in code reviews and maintain technical standards and architecture documentation.
• Support the complete SDLC, including design, development, testing, deployment, and production support.
• Use Git, Azure DevOps, and CI/CD tools for source control and delivery.
• Collaborate with business stakeholders, data stewards, engineers, and cross-functional teams.
• Apply AI-assisted development tools while maintaining independent coding and technical decision-making.
• Support knowledge transfer, technical documentation, and continuous improvement initiatives.

Conoscenze

Data engineering

SQL proficiency

Problem solving

Stakeholder management

Independent work

Strumenti

Snowflake

Python

MySQL

Git

Azure DevOps

CI/CD

Snowpipe

Descrizione del lavoro

JPS Tech Solutions Pvt Ltd is seeking a Senior Snowflake Data Engineer / Database Developer with 8+ years of experience. The role focuses on building scalable data pipelines, optimizing Snowflake environments, and delivering enterprise data solutions. Collaboration with business and technical teams is essential for success.

The ideal candidate will design data models, advanced SQL solutions, and implement robust testing, governance, and CI/CD practices to ensure data quality and performance.