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, we've 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: www.tridentconsultinginc.com