Senior Principal Data Engineer - 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. Functions may include database architecture, engineering, design, optimization, security, and administration; as well as data modeling, big data development, Extract, Transform, and Load (ETL) development, storage engineering, data warehousing, data provisioning and other similar roles. Responsibilities may include Platform-as-a-Service and Cloud solution with a focus on data stores and associated eco systems. Duties may include management of design services, providing sizing and configuration assistance, ensuring strict data quality, and performing needs assessments. Analyzes current business practices, processes and procedures as well as identifying future business opportunities for leveraging data storage and retrieval system capabilities. Manages relationships with software and hardware vendors to understand the potential architectural impact of different vendor strategies and data acquisition. May design schemas, write SQL or other data markup scripting and helps to support development of Analytics and Applications that build on top of data. Selects, develops and evaluates personnel to ensure the efficient operation of the function. 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 experience with billing systems (TRACS, MEP, PeopleSoft)
- Knowledge of Medicare Advantage operations and billing adjustments
- Understanding of healthcare billing models (PMPM, enrollment fees)
- Familiarity with CMS monthly files (MMR) and dual status logic
- Proficiency in SQL/Azure and data transformation scripting
- Proven solid attention to detail in transaction validation and reconciliation
- Proven ability to interpret and apply complex billing rules and contract terms
- Proven ability to work cross-functionally with technical and operational teams
- Clear documentation and reporting of billing logic and outcomes
- All employees working remotely will be required to adhere to UnitedHealth Group's Telecommuter Policy
Responsibilities
- Data Conversion & Migration
- Extract and transform legacy TRACS bill plan data into MEP enrollment format.
- Translate legacy member IDs, product codes, and dual status indicators.
- Load transformed data into MEP transaction tables
- Billing Transaction Generation
- Generate monthly prospective billing based on active bill plans and dual status.
- Generate annual retrospective billing to reconcile and "true up" prior transactions
- Apply logic to determine billing eligibility and calculate billing durations (e.g., DEA = 24 months, Recert = 12 months)
- Overlap Management
- Identify and remediate overlaps between legacy and MEP-generated enrollments
- Develop scripts to manage retention enrollments and prevent duplicate billing
- Reporting & Evidence Migration
- Migrate transaction records and evidence from TRACS to MEP for reporting and trending.
- Identify and move necessary tables for future reporting needs
- Operational Coordination
- Collaborate with MMS, Data Platform, and PeopleSoft teams to ensure billing continuity.
- Support transition planning and execution as TRACS sunsets in January 2026
Benefits
- a comprehensive benefits package
- incentive and recognition programs
- equity stock purchase
- 401k contribution
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
Industry
Insurance Carriers and Related Activities
Education Level
No Education Listed
Number of Employees
5,001-10,000 employees
