Python Developer – Snowflake, ETL/ELT, Advanced SQL & Cloud Data Engineering
Job Summary
Synechron is seeking a Senior Python Developer with Snowflake expertise to build, optimize, and support scalable cloud-based data solutions. The role focuses on Python development, Snowflake data warehousing, ETL/ELT pipelines, SQL optimization, and data integration.
Software Requirements
Required:
- 7+ years of Python development experience
- Strong Snowflake data warehouse experience
- Advanced SQL, stored procedures, and query optimization
- ETL/ELT pipeline development
- Pandas, NumPy, and PySpark
- Apache Airflow, Matillion, Informatica, or Azure Data Factory
- AWS, Azure, or Google Cloud experience
- Git and REST API integration
Preferred:
- Snowflake Streams, Tasks, Snowpipe, and dynamic tables
- dbt, Docker, Kubernetes, and CI/CD
- Kafka or other data-streaming platforms
- Data quality and monitoring tools
Overall Responsibilities
- Design, develop, and maintain Python and Snowflake data pipelines.
- Build and optimize ETL/ELT workflows for large-scale data.
- Create Snowflake databases, schemas, tables, views, procedures, streams, and tasks.
- Develop data models for reporting, analytics, and business intelligence.
- Optimize SQL queries, Snowflake warehouses, clustering, and compute usage.
- Integrate APIs, relational databases, cloud storage, and external systems.
- Implement data quality, security, governance, and compliance controls.
- Troubleshoot production issues and improve pipeline reliability.
- Collaborate with architects, analysts, developers, and business stakeholders.
- Mentor team members and contribute to data engineering standards.
Technical Skills
Programming: Essential: Python, advanced SQL, scripting, testing, and error handling. Preferred: Java, Scala, or asynchronous Python.
Databases/Data Management: Essential: Snowflake, data modeling, dimensional modeling, schemas, tables, views, stored procedures, Streams, Tasks, and query tuning. Preferred: Snowpipe, dbt, NoSQL, and data cataloging.
Cloud: Essential: AWS, Azure, or Google Cloud. Preferred: Cloud storage, Docker, Kubernetes, and infrastructure automation.
Frameworks and Libraries: Essential: Pandas, NumPy, PySpark, and an orchestration tool. Preferred: Great Expectations, FastAPI, Flask, or Kafka.
Development Tools: Essential: Git, CI/CD, Agile, code reviews, automated testing, logging, and monitoring. Preferred: Docker, SonarQube, infrastructure-as-code, and observability tools.
Security: Essential: Access control, encryption, secure credentials, data privacy, and secure API integration. Preferred: OAuth 2.0, OpenID Connect, Snowflake masking policies, and row-access policies.
Experience Requirements
- 7+ years of professional Python development experience.
- Strong experience in Snowflake, data engineering, ETL/ELT, SQL, and data modeling.
- Experience integrating APIs, databases, cloud storage, and external systems.
- Experience supporting production data platforms and resolving performance issues.
- Financial services or regulated-industry experience is preferred.
- Equivalent technical experience, training, or relevant projects may be considered.
Day-to-Day Activities
- Develop Python code, SQL scripts, Snowflake objects, and orchestration workflows.
- Build data ingestion, transformation, validation, and publishing processes.
- Monitor pipelines, data quality, query performance, and warehouse utilization.
- Investigate failed jobs, data issues, and production incidents.
- Participate in planning meetings, design discussions, code reviews, and retrospectives.
- Collaborate with technical teams and business stakeholders.
- Prepare technical documentation and support materials.
- Make implementation decisions within approved architecture and security standards.
Qualifications
- Bachelor’s degree in computer science, information technology, data engineering, or a related field, or equivalent practical experience.
- Snowflake, cloud, Python, or data engineering certifications are preferred.
- Completion of Synechron security, compliance, and role-specific training is required.
- Ongoing learning in Python, Snowflake, cloud technologies, security, and data governance is expected.
Professional Competencies
- Strong analytical and problem-solving skills.
- Clear communication with technical and non-technical stakeholders.
- Effective collaboration and mentoring abilities.
- Ability to manage priorities and meet delivery commitments.
- Adaptability to changing requirements and technologies.
- Focus on automation, data quality, security, performance, and efficient resource use.
S YNECHRON’S DIVERSITY & INCLUSION STATEMENT
Diversity & Inclusion are fundamental to our culture, and Synechron is proud to be an equal opportunity workplace and is an affirmative action employer. Our Diversity, Equity, and Inclusion (DEI) initiative ‘Same Difference’ is committed to fostering an inclusive culture - promoting equality, diversity and an environment that is respectful to all. We strongly believe that a diverse workforce helps build stronger, successful businesses as a global company. We encourage applicants from across diverse backgrounds, race, ethnicities, religion, age, marital status, gender, sexual orientations, or disabilities to apply. We empower our global workforce by offering flexible workplace arrangements, mentoring, internal mobility, learning and development programs, and more.
All employment decisions at Synechron are based on business needs, job requirements and individual qualifications, without regard to the applicant’s gender, gender identity, sexual orientation, race, ethnicity, disabled or veteran status, or any other characteristic protected by law.