Senior Data | , NC

Senior Data Engineer

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, and data they need to feel their best. Here, you will find a culture guided by diversity and inclusion, talented peers, comprehensive benefits, and career development opportunities. Come make an impact on the communities we serve as you help us advance health equity on a global scale. Join us to start Caring. Connecting. Growing together.

Join the Magnus Lake House team within Optum Insight as a Senior Data Engineer. In this role, you will be a key contributor to a high-profile migration project, transitioning our legacy Cornerstone Data Warehouse to a modern cloud-based Lakehouse architecture. This position offers a hybrid work environment based out of our Eden Prairie, MN or Raleigh, NC offices. You will be responsible for designing diverse ingestion patterns to bring data into the lakehouse and developing sophisticated solutions to share that data with consumers. We are looking for a hands-on developer who is eager to use modern AI-assisted tools to drive productivity and innovation in a fast-paced environment.

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

Primary Responsibilities:

• Use enterprise-approved AI tools and coding assistants to streamline development workflows, automate complex tasks, and drive continuous improvement in code quality and efficiency
• Design and implement robust data ingestion patterns to migrate legacy Cornerstone Data Warehouse assets into the Magnus Lake House
• Develop and deploy scalable data-sharing solutions to provide consumers with efficient access to data using various architectural patterns
• Build and manage automated data pipelines using Azure Data Factory (ADF) to ingest and process files within Databricks
• Utilize the dbt (data build tool) framework to execute complex data transformations following Medallion Architecture (Bronze, Silver, and Gold layers)
• Interpret, maintain, and enhance existing codebases in both Java and Python to support project requirements
• Evaluate emerging trends in data engineering and AI-assisted development to inform solution design and identify opportunities for strategic innovation
• Collaborate with cross-functional teams to ensure data pipelines meet security, scalability, and performance standards

You'll be rewarded and recognized for your performance in an environment that will challenge you and give you clear direction on what it takes to succeed in your role as well as provide development for other roles you may be interested in.

Required Qualifications:

• Bachelor's degree in Computer Science, Mathematics, or a related field; OR a High School Diploma/GED with 4+ years of equivalent data engineering experience
• 5+ years of experience in data engineering or software development
• 3+ years of professional programming expertise in either Python or Java, with the demonstrated ability to read and modify code in both languages
• 2+ years of experience building and orchestrating data pipelines in an Azure environment (ADF, Databricks)
• 1+ year of experience utilizing AI-assisted development tools (e.g., GitHub Copilot, Codex) to enhance development productivity

Preferred Qualifications:

• Experience with legacy data warehouse migrations and modernizing data architectures
• Proven experience designing and implementing data-sharing patterns for downstream consumers
• Deep understanding of Medallion Architecture and Delta Lake
• Experience with CI/CD practices and version control in a cloud-native environment (e.g., Azure DevOps, GitHub)
• Hands-on experience using the dbt (data build tool) framework for data transformation
• Ability to work effectively in a hybrid team environment, balancing independent development with collaborative design sessions

Pay is based on several factors including but not limited to local labor markets, education, work experience, certifications, etc. In addition to your salary, we offer benefits such as, a comprehensive benefits package, incentive and recognition programs, equity stock purchase and 401k contribution (all benefits are subject to eligibility requirements). The salary for this role will range from $91,700 to $163,700 annually based on full-time employment. We comply with all minimum wage laws as applicable.