We are seeking experienced Data Engineers to design, build, and support scalable cloud-based data solutions. The role will involve developing modern data pipelines, ETL/ELT frameworks, and data integration solutions using Snowflake, DBT, AWS, Python, and SQL.
The ideal candidate will have strong hands-on experience building and operating data platforms, transforming data from multiple sources, implementing robust data quality controls, and developing data models that support analytics and business reporting. Candidates should be self-starters who can work independently, contribute to solution design, and ensure security and governance standards are maintained.
Key Responsibilities
- Design, develop, and maintain scalable ETL/ELT pipelines using Snowflake, DBT, AWS, and Python.
- Build and optimize data models, transformations, and orchestration workflows.
- Develop frameworks to ingest data from databases, APIs, flat files, CSVs, and other enterprise data sources.
- Create reusable and automated data transformation processes using DBT.
- Design and implement Snowflake data warehouses, schemas, tables, views, and performance optimization strategies.
- Develop data quality, validation, reconciliation, and monitoring solutions.
- Implement secure data movement and integration patterns across cloud and on-premise systems.
- Work closely with business stakeholders, architects, analysts, and downstream consumers to understand requirements and deliver scalable solutions.
- Support deployment and release activities across development, test, and production environments.
- Ensure compliance with security, governance, and PII data protection requirements.
- Troubleshoot and resolve production data issues while maintaining high availability and reliability.
Mandatory Skills & Experience
Technical Skills
- Strong experience with Snowflake Data Cloud.
- Hands-on expertise in DBT (Data Build Tool) for transformations and data modeling.
- Strong experience with AWS services including:
- S3
- Lambda
- Glue
- IAM
- CloudWatch
- Step Functions (preferred)
- Advanced SQL development and query optimization skills.
- Strong Python programming experience for data engineering and automation.
- Experience building enterprise ETL/ELT pipelines.
- Experience working with structured and semi-structured data (JSON, XML, CSV).
- Knowledge of data governance, security, and access management.
- Experience in CI/CD and DevOps practices for data platforms.
Snowflake Expertise
- Snowflake architecture and administration.
- Snowpipe, Streams & Tasks.
- Data sharing and secure views.
- Performance tuning and query optimization.
- Role-based access controls (RBAC).
- Data ingestion and transformation frameworks.
DBT Expertise
- DBT models and macros.
- Incremental loading strategies.
- Data testing and validation.
- Source-to-target mapping.
- Documentation and lineage.
- CI/CD integration with DBT.
Desirable Skills
- Experience with Airflow, Prefect, or similar orchestration tools.
- Knowledge of data lake and lakehouse architectures.
- Experience with AI-assisted development tools such as:
- Claude Code
- GitHub Copilot
- Amazon Q
- Experience within Banking, Financial Services, or regulated environments.
- Exposure to real-time and streaming data solutions.
SYNECHRON’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.
Candidate Application Notice
Skills Required
- Strong experience with Snowflake Data Cloud
- Hands-on expertise with DBT for data transformations and modeling
- Strong experience with AWS services, including S3, Lambda, Glue, IAM, and CloudWatch
- Advanced SQL development and query optimization skills
- Strong Python programming experience for data engineering and automation
- Experience building enterprise ETL/ELT pipelines
- Experience with structured and semi-structured data, including JSON, XML, and CSV
- Knowledge of data governance, security, and access management
- Experience with CI/CD and DevOps practices for data platforms
- Snowflake architecture and administration experience
- Experience with Snowpipe, Streams, and Tasks
- Experience with Snowflake data sharing, secure views, performance tuning, query optimization, and RBAC
- Experience with DBT models, macros, incremental loading, testing, validation, documentation, lineage, and CI/CD integration
- Experience with Step Functions
- Experience with Airflow, Prefect, or similar orchestration tools
- Knowledge of data lake and lakehouse architectures
- Experience with AI-assisted development tools such as Claude Code, GitHub Copilot, or Amazon Q
- Experience in banking, financial services, or regulated environments
- Exposure to real-time and streaming data solutions
Synechron Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Synechron and has not been reviewed or approved by Synechron.
-
Fair & Transparent Compensation — Pay is frequently characterized as competitive, particularly relative to large service-consulting peers and in certain in-demand skill areas. Compensation sentiment appears strongest when staffing is stable on strong client engagements and for market-aligned roles in major hubs.
-
Healthcare Strength — Healthcare coverage is often portrayed as a strong point in the U.S., with broad coverage and relatively favorable out-of-pocket experiences. Core medical, dental, and vision options are consistently described as meeting or exceeding a baseline expectation for consulting roles.
-
Equity Value & Accessibility — Equity was made broadly accessible through a company-wide RSU grant tied to a major revenue milestone. This is positioned as a notable upside even if it is framed as a one-time recognition event rather than an ongoing program.
Synechron Insights
What We Do
At Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver industry-leading digital solutions. Synechron’s progressive technologies and optimization strategies span end-to-end Artificial Intelligence, Consulting, Digital, Cloud & DevOps, Data, and Software Engineering, servicing an array of noteworthy financial services and technology firms. Through research and development initiatives in our FinLabs we develop solutions for modernization, from Artificial Intelligence and Blockchain to Data Science models, Digital Underwriting, mobile-first applications and more. Over the last 20+ years, our company has been honored with multiple employer awards, recognizing our commitment to our talented teams. With top clients to boast about, Synechron has a global workforce of 14,700+, and has 48 offices in 19 countries within key global markets. For more information on the company, please visit our website: www.synechron.com.
