Technical Lead (Data Engineer)

Job Title: Onshore Technical Lead Developer (Snowflake & AWS)

Position Summary

We are seeking an experienced Onshore Technical Lead Developer to support TennCare Medicaid Programs by leading the design, development, testing, deployment, and support of data solutions built on Snowflake and AWS. This role will serve as the primary technical point of contact, ensuring high-quality delivery, production stability, and effective collaboration across business and offshore teams.

Key Responsibilities

• Design and own end-to-end Snowflake and AWS-based data solutions.
• Translate business requirements into scalable, efficient technical solutions.
• Conduct design reviews, code reviews, and provide deployment guidance.
• Lead data validation, ETL/ELT testing, reconciliation, and quality assurance activities.
• Troubleshoot production issues, perform root-cause analysis, and implement permanent fixes.
• Collaborate closely with offshore teams to drive timely delivery.
• Coordinate with architects, product managers, analysts, SMEs, and business stakeholders.
• Act as the primary technical POC and mentor team members.

Required Skills & Experience

• 10+ years of experience in Data Engineering, Data Warehousing, or Analytics.
• Advanced Snowflake SQL development, optimization, and data validation expertise.
• Experience testing and supporting Snowflake-based data warehouse solutions.
• Strong knowledge of AWS Cloud services and cloud-native architectures.
• Hands-on experience with:
  • ETL/ELT validation
  • Data reconciliation
  • Data quality testing
  • Production support and troubleshooting
• Experience working in Agile/Scrum environments.
• Strong communication, leadership, and stakeholder management skills.

Preferred Skills

• Healthcare, Medicaid, or TennCare experience.
• Experience with Python, DBT, Airflow, Informatica, or similar data integration tools.
• Knowledge of CI/CD and automated testing frameworks.

Work Schedule

• Must be available during EST/ET business hours (8:00 AM - 5:00 PM ET).
• Provide operational and production support as required, including release support and critical issue resolution.

Primary Technologies: Snowflake, AWS, SQL, ETL/ELT, Data Warehousing, Data Quality, Agile Delivery, Production Support.