The Senior Business Analyst will gather requirements, develop ETL processes, write SQL, and ensure high-quality data delivery for healthcare data solutions.
Requisition Number: 2345405
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.
The Senior Data Analyst partners with business and technical teams to design, build, and support healthcare data warehouse and reporting solutions. This role leads requirements gathering, develops and supports ETL processes using Informatica, writes advanced Teradata SQL, and ensures high quality, compliant data delivery.
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.
Primary Responsibilities:
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:
*All employees working remotely will be required to adhere to UnitedHealth Group's Telecommuter Policy
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). No matter where or when you begin a career with us, you'll find a far-reaching choice of benefits and incentives. 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.
Application Deadline: This will be posted for a minimum of 2 business days or until a sufficient candidate pool has been collected. Job posting may come down early due to volume of applicants.
At UnitedHealth Group, our mission is to help people live healthier lives and make the health system work better for everyone. We believe everyone-of every race, gender, sexuality, age, location and income-deserves the opportunity to live their healthiest life. Today, however, there are still far too many barriers to good health which are disproportionately experienced by people of color, historically marginalized groups and those with lower incomes. We are committed to mitigating our impact on the environment and enabling and delivering equitable care that addresses health disparities and improves health outcomes - an enterprise priority reflected in our mission.
UnitedHealth Group is an Equal Employment Opportunity employer under applicable law and qualified applicants will receive consideration for employment without regard to race, national origin, religion, age, color, sex, sexual orientation, gender identity, disability, or protected veteran status, or any other characteristic protected by local, state, or federal laws, rules, or regulations.
UnitedHealth Group is a drug - free workplace. Candidates are required to pass a drug test before beginning employment.
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.
The Senior Data Analyst partners with business and technical teams to design, build, and support healthcare data warehouse and reporting solutions. This role leads requirements gathering, develops and supports ETL processes using Informatica, writes advanced Teradata SQL, and ensures high quality, compliant data delivery.
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.
Primary Responsibilities:
- Gathering business requirements for the data warehouse as well as business intelligence reports used by the Virginia DMAS management. Adhere to development process and creating and posting all documents, deliverables such as the Business Requirements Document (BRD), production implementation documents, etc
- Analyzing existing design and recommending industry best practice design for optimal performance and maintenance
- Applying Full Software Development Life Cycle (SDLC) experience, including Analysis, Design and Review of Business and Software Requirement Specifications, and Testing as per the SDLC waterfall methodology
- Participating in project meetings/design groups as a team member with other Data Analysts to design, engineer and develop solutions
- Communication with the business analyst and project manager on daily basis including meetings and written communications
- Assisting the Project Manager/Team lead in providing the estimation of project status. Work on the given timelines to ensure quality delivery happens on time
- Expert in analyzing (reviewing) the business, technical and functional requirements to develop the Test plans, Test cases, Test Scripts, Use Cases and Test strategies
- Testing skills include performing Regression, Integration, Functional, System, Database, end to end testing, volume, and stress testing as well as development, execution, Test specifications and Test scenarios
- Build and optimize extraction, transformation, and loading (ETL) processes using Informatica PowerCenter to move data from heterogeneous source systems into enterprise data warehouses or operational data stores
- Support on call for production loads and resolve ETL load failures, database performance issues, data mismatches, and dependency failures in a timely manner
- Develop and maintain advanced Teradata SQL, including joins, window functions, and complex analytical queries
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:
- 8+ years of experience with Full Software Development Life Cycle (SDLC) experience
- 6+ years of hands-on experience with healthcare domain knowledge; working with healthcare data, including claims, eligibility, provider data, encounter processing, HIPAA regulations, and government/compliance driven data integrations
- 6+ years of experience in ETL development and data integration using ETL tools such as Informatica PowerCenter/IDQ
- 4+ years of experience working with Teradata databases, including hands-on development using BTEQ scripts, FastLoad, MultiLoad, and TPT (Teradata Parallel Transporter) utilities
- 3+ years of experience developing Test plans, Test cases, Test Scripts, Use Cases and Test strategies
- 2+ years of experience testing the, Informatica mappings and other ETL Processes (Data Warehouse Testing)
- Software Skills: Informatica, Teradata, Unix shell script, Oracle skills
- Proven excellent communication and interpersonal skills, with the ability to work effectively in a team environment
*All employees working remotely will be required to adhere to UnitedHealth Group's Telecommuter Policy
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). No matter where or when you begin a career with us, you'll find a far-reaching choice of benefits and incentives. 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.
Application Deadline: This will be posted for a minimum of 2 business days or until a sufficient candidate pool has been collected. Job posting may come down early due to volume of applicants.
At UnitedHealth Group, our mission is to help people live healthier lives and make the health system work better for everyone. We believe everyone-of every race, gender, sexuality, age, location and income-deserves the opportunity to live their healthiest life. Today, however, there are still far too many barriers to good health which are disproportionately experienced by people of color, historically marginalized groups and those with lower incomes. We are committed to mitigating our impact on the environment and enabling and delivering equitable care that addresses health disparities and improves health outcomes - an enterprise priority reflected in our mission.
UnitedHealth Group is an Equal Employment Opportunity employer under applicable law and qualified applicants will receive consideration for employment without regard to race, national origin, religion, age, color, sex, sexual orientation, gender identity, disability, or protected veteran status, or any other characteristic protected by local, state, or federal laws, rules, or regulations.
UnitedHealth Group is a drug - free workplace. Candidates are required to pass a drug test before beginning employment.
Top Skills
Informatica
SQL
Teradata
Unix
Optum Belfast, Northern Ireland Office
Belfast, United Kingdom
Similar Jobs at Optum
Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
Support audit operations for implants and high-cost drugs by validating, repricing claims, writing SQL queries, and producing reports.
Top Skills:
ExcelSQL
7 Days Ago
Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
Provide clinical oversight for utilization management and care transitions, perform daily UM reviews and peer-to-peer discussions, liaise with network and community providers, support care coordination and analytics needs, participate in medical advisory activities, and provide intermittent weekend/evening coverage.
Top Skills:
Electronic Health Records
Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
Lead strategic and operational oversight of a multi-asset real estate portfolio—optimize asset performance, oversee property management, manage vendors, drive financial planning and lease strategies, mentor a team, and present recommendations to senior leadership.
What you need to know about the Belfast Tech Scene
If asked to name the birthplace of the RMS Titanic, you might not say Belfast. Similarly, if asked to name Europe's leading destination for foreign direct investment in new software development, Belfast might not come to mind. Yet, both are true. The city has emerged as a tech powerhouse, recently ranked among the best in the U.K. for tech careers — especially for software developers. It also leads the U.K. with the highest percentage of software development jobs advertised.
