Data Engineer - Remote

Change Healthcare•Eden Prairie, MN

6d•Remote

About The Position

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. Optum Program Integrity Analytics is a suite of complementary, web-based components that mine provider, member and claims data for potential fraud, waste and abuse; provide software research tools; and track subsequent investigation activity. The PI Analytics team is comprised of individuals with a variety of technical expertise from databases, business intelligence reporting, and web-based tools. The PI team is looking for a data-focused data engineer to quickly develop a comprehensive understanding of fraud, waste and abuse detection software. The analyst should have the ability to collaborate with multiple roles including fellow business analysts, data engineers, software engineers and report developers. This individual will be involved in many phases of an implementation project and/or an operational project and become familiar with the database structures, testing software, ND documentation. This role will be key in the successful implementation of new projects and the maintenance of existing projects. You'll enjoy the flexibility to work remotely from anywhere within the U.S. as you take on some tough challenges. For all hires in the Minneapolis or Washington, D.C. area, you will be required to work in the office a minimum of four days per week. 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.

Requirements

5+ years of hands-on expertise in cloud-based data engineering and data warehousing, with a strong emphasis on building scalable and efficient data solutions
5+ years of focused experience in Snowflake, including the design, development, and maintenance of automated data ingestion workflows using Snowflake SQL procedures and Python scripting
5+ years of hands-on experience with Azure data tools such as Azure Data Factory (ADF), SQL Server, and Blob Storage, alongside Snowflake
2+ years of experience with Python and other scripting languages for data manipulation and automation

Nice To Haves

Certification in Azure or Snowflake
Experience with data modeling and database design
Recent experience with medical claims processing systems, including familiarity with core functionalities, workflows, and data structures used in healthcare claims management
Data science and analytics experience
Knowledge of data governance and data quality best practices
Familiarity with other cloud platforms (e.g., AWS, Google Cloud)

Responsibilities

Support the full software development and implementation lifecycle
Lead the development and management of ETL processes for Program Integrity data marts in Snowflake and SQL Server
Design, build, and maintain data pipelines using Azure Data Factory (ADF) to support ETL operations and Peer Group Profiling procedures and outputs
Implement and manage DevOps practices to ensure efficient data loading and workload balancing within the Program Integrity data mart
Collaborate with cross-functional teams to ensure seamless data integration and consistent data flow across platforms
Monitor, optimize, and troubleshoot data pipelines and workflows to maintain performance and reliability
Independently identify and resolve complex technical issues to maintain operational efficiency
Communicate effectively and foster collaboration across teams to support project execution and alignment
Apply advanced analytical skills and attention to detail to uphold data accuracy and quality in all deliverables
Lead cloud-based project delivery, ensuring adherence to timelines, scope, and performance benchmarks
Ensure data security and compliance with relevant industry standards and regulatory requirements
Share knowledge (train) other team members and business users on any of the skills listed above