SeniorLead Data Engineer
Posted:
18 September 2026 (Yesterday)
Application Deadline:
16 December 2026
Vacancies:
1 Vacancy
Job Summary
Trident Consulting is seeking a Senior/Lead Data Engineer for one of our client. A global leader in business and technology services.
Job Title: Senior/Lead Data Engineer
Location: Remote
Job Type: Contract
Pay Rate: $60
Position Summary
Seeking a hands-on Senior/Lead Data Engineer with 8 years of experience to design build and support scalable cloud data solutions for healthcare reporting analytics and operational use cases. The role requires strong expertise in Snowflake Informatica IDMC ETL/ELT dimensional data warehousing Python CI/CD and AWS or Databricks with technical ownership expected at the Lead level.
Key Responsibilities
Design develop test deploy and support scalable batch and near-real-time data pipelines using Snowflake and IDMC.
Implement ETL/ELT solutions dimensional models and SCD Types 1 and 2 for enterprise DW.
Develop efficient SQL and Python components reusable frameworks automation and validation utilities.
Build CI/CD pipelines for data code IDMC assets Snowflake objects testing and environment promotion.
Optimize Snowflake performance scalability reliability security and cost; support AWS and/or Databricks workloads.
Implement data quality reconciliation lineage monitoring governance and audit controls.
Troubleshoot production issues and partner with architecture QA DevOps analytics and business teams.
Lead design and code reviews mentor engineers and drive engineering standards and solution ownership.
Required Qualifications
8 years in data engineering ETL development and enterprise data warehousing.
Strong Snowflake expertise in SQL data loading security performance tuning scalability and cost optimization.
Strong IDMC development experience with CDI mappings tasks taskflows parameters deployment and monitoring.
Proficiency in Python and SQL plus Git-based CI/CD using Jenkins Azure DevOps GitHub Actions or similar tools.
Hands-on experience with AWS data services and/or Databricks/Spark including data quality governance and production support.
Strong analytical troubleshooting communication documentation and stakeholder-management skills.
About Trident Consulting
Trident Consulting is an award-winning staffing and consulting firm headquartered in San Ramon CA. Since 2005 weve partnered with Fortune 500 and high-growth companies to deliver high-quality talent across technology engineering business operations and professional services.
We specialize in contract contract-to-hire and direct hire placements supporting roles across IT data & analytics cloud cybersecurity finance & accounting HR operations and more. With a strong focus on hard-to-fill and niche positions our global recruiting engine enables us to deliver speed quality and scale.
Learn more:
Job Title: Senior/Lead Data Engineer
Location: Remote
Job Type: Contract
Pay Rate: $60
Position Summary
Seeking a hands-on Senior/Lead Data Engineer with 8 years of experience to design build and support scalable cloud data solutions for healthcare reporting analytics and operational use cases. The role requires strong expertise in Snowflake Informatica IDMC ETL/ELT dimensional data warehousing Python CI/CD and AWS or Databricks with technical ownership expected at the Lead level.
Key Responsibilities
Design develop test deploy and support scalable batch and near-real-time data pipelines using Snowflake and IDMC.
Implement ETL/ELT solutions dimensional models and SCD Types 1 and 2 for enterprise DW.
Develop efficient SQL and Python components reusable frameworks automation and validation utilities.
Build CI/CD pipelines for data code IDMC assets Snowflake objects testing and environment promotion.
Optimize Snowflake performance scalability reliability security and cost; support AWS and/or Databricks workloads.
Implement data quality reconciliation lineage monitoring governance and audit controls.
Troubleshoot production issues and partner with architecture QA DevOps analytics and business teams.
Lead design and code reviews mentor engineers and drive engineering standards and solution ownership.
Required Qualifications
8 years in data engineering ETL development and enterprise data warehousing.
Strong Snowflake expertise in SQL data loading security performance tuning scalability and cost optimization.
Strong IDMC development experience with CDI mappings tasks taskflows parameters deployment and monitoring.
Proficiency in Python and SQL plus Git-based CI/CD using Jenkins Azure DevOps GitHub Actions or similar tools.
Hands-on experience with AWS data services and/or Databricks/Spark including data quality governance and production support.
Strong analytical troubleshooting communication documentation and stakeholder-management skills.
About Trident Consulting
Trident Consulting is an award-winning staffing and consulting firm headquartered in San Ramon CA. Since 2005 weve partnered with Fortune 500 and high-growth companies to deliver high-quality talent across technology engineering business operations and professional services.
We specialize in contract contract-to-hire and direct hire placements supporting roles across IT data & analytics cloud cybersecurity finance & accounting HR operations and more. With a strong focus on hard-to-fill and niche positions our global recruiting engine enables us to deliver speed quality and scale.
Learn more:
Required Experience:
Senior IC