Senior Full Stack Data Engineer

About this role

Optum is a global organization that delivers care, aided by technology to help millions of people live healthier lives. The work you do with our team will directly improve health outcomes by connecting people with the care, pharmacy benefits, data and resources they need to feel their best.Here, you will find a culture guided by inclusion, talented peers, comprehensive benefits and career development opportunities. Come make an impact on the communities we serve as you help us advance health optimization on a global scale.Join us to start Caring. Connecting. Growing together.

You will enjoy the flexibility to telecommute\* from anywhere within the U.S. as you take on some tough challenges.

Primary Responsibilities:

• Collaborate closely with product owners, business users, and stakeholders to translate data product and reporting requirements into scalable, reliable data engineering solutions, incorporating feedback iteratively throughout the delivery lifecycle
• Design, develop, and maintain end to end data pipelines across staging, integration, and consumption layers, leveraging Azure Data Factory, DBT, Snowflake SQL, and metadata driven frameworks
• Develop and optimize high performance SQL queries, views, and stored procedures to support analytics, reporting, and provide guidance to analytics team members on effective and cost-efficient usage
• Architect, Develop and support data integration processes including batch file ingestion and automated extracts
• Partner with internal stakeholders to understand business objectives, study requirements, and identify appropriate technical solutions, integration patterns, and data models that balance performance, scalability, and maintainability
• Serve as a technical subject matter expert and mentor, providing training, design guidance, and code reviews for associates on data engineering best practices, Snowflake optimization, and ADF/DBT pipeline design
• Author and maintain detailed technical documentation, in...