Senior/Lead Data Engineer
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 Remote Skills: Accounting, Amazon Web Services (AWS), Analysis Skills, Automation, Business Operations, Business Services, Cloud Computing, Code Reviews, Consulting, Continuous Deployment/Delivery, Continuous Integration, Cost Control, Data Analysis, Data Management, Data Quality, Data Warehousing, Database Extract Transform and Load (ETL), DevOps, Dimensional Modeling, Documentation, Finance, Fortune 500 Customers, Git, GitHub, Healthcare, Identify Issues, Informatica, Information/Data Security (InfoSec), International Business, Internet Security, Jenkins, Mentoring, Microsoft Windows Azure, Operational Audit, Performance Tuning/Optimization, Production Support, Professional Services, Python Programming/Scripting Language, Quality Assurance, Reconciliation, SQL (Structured Query Language), Scalable System Development, Snowflake Schema, Test Plan/Schedule, Testing, Use Cases Trident Consulting