Senior Snowflake Data Engineer / Database Developer

JPS Tech Solutions Pvt Ltd; Charlotte (NC); On-site; CAD 120,000 - 180,000; Full time

Job summary

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.

Qualifications

• 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.

Responsibilities

• 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.

Skills

Data engineering

SQL proficiency

Problem solving

Stakeholder management

Independent work

Tools

Snowflake

Python

MySQL

Git

Azure DevOps

CI/CD

Snowpipe

Job description

JOB SUMMARY

We are seeking a Senior Snowflake Data Engineer / Database Developer with 8+ years of professional experience and strong expertise in Snowflake, Python, MySQL, and advanced SQL. The ideal candidate will design and optimize enterprise data pipelines, develop scalable database solutions, support Snowflake environments, and collaborate directly with business and technical teams. Local candidates in Charlotte, NC are preferred.

KEY RESPONSIBILITIES

• 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.

REQUIRED QUALIFICATIONS

• 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.
• Strong 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 experience with data validation, reconciliation, and data quality processes.
• Excellent problem-solving, communication, documentation, and stakeholder management skills.
• Ability to work independently and collaborate directly with business and technical teams.

PREFERRED QUALIFICATIONS

• Experience in Residential Mortgage, Mortgage Servicing, Banking, or Financial Services data environments.
• Advanced Snowflake capabilities including Snowpark, Snowpipe, clustering, and warehouse optimization.
• Experience with source-to-target mapping, data mastering, and complex data reconciliation.
• Experience with AI-assisted development tools and Agile methodologies.