About UHG

Careers at UnitedHealth Group


We have modest goals: Improve the lives of others. Change the landscape of health care forever. Leave the world a better place than we found it. Such aspirations tend to attract a certain type of person. Crazy talented. Compassionate. Driven. To these individuals, we offer the global reach, resources and can-do culture of a Fortune 5 company. We provide an environment where you’re empowered to be your best. We encourage you to take risks and in return, offer a world of rewards and benefits for performance. Exceeding your limits is an exceptional start to your life's best work.SM


Just like you, we are driven by a set of fundamental principles that are guiding our way forward. Our values of integrity, compassion, relationships, innovation, and performance serve as a foundation to transform health care. Are you in? Learn more about your future at UnitedHealth Group at careers.unitedhealthgroup.com


Job Category:

Information Technology


United States

Postal Code:


Approximate Salary:

Not Specified

Position Type:

Full Time

This job has expired and you can't apply for it anymore. Start a new search.

IT Data Analyst Consultant - Lansing, MI

UHG - Lansing, Michigan

Posted: 09/8/2018

Is it time to build on your skills and knowledge in a setting that makes the most of both? We can challenge you in ways that require you to bring it all, every day. Optum, part of the UnitedHealth Group family of businesses, has more technology, greater data resources and far broader expertise than any competitor anywhere. We're creating hundreds of custom applications and manage thousands of hardware components. And that complexity is where you come in. In this role, you'll be involved in architecting and designing data warehouse solutions. You will be a primary contributor in developing, testing and deploying key data warehouses, data marts and will be working with cutting edge technology. You'll find yourself stretching, learning and expanding your impact.


This candidate will be part of a 40 person team made up of 6-7 Senior Analysts, along with Project Managers, Teradata and Web Developers, Data Modelers, DBAs, and Report Analysts. This candidate will be working with the customers (Michigan Department of Health and Human Services) gathering requirements for various projects; utilizing the standard SUITE methodology; creating detailed design specifications and then following the project through implementation.


Primary Responsibilities:

  • Analyze entity relationship diagrams, file specifications, and physical or logical database data models to create detailed ETL mappings, Web API designs or business intelligence report specifications
  • Perform data analysis, data cleansing, test data creation, and data verification as part of design and testing activities
  • Create the testing documents and matrixes, and will be responsible for assisting the customer with user testing
  • Assist the technical and business teams with project-related formal documentation
  • Meet with users for clarification and elaboration as may be necessary to clearly define a problem and conceptualize a development plan

Required Qualifications:

  • 5+ years Data Analyst, Technical Business Analyst, Systems Analyst or Business Analyst experience preferably in a Data Warehouse project environment
  • 5+ years working with technical developers end users/customers to strategize solutions to align with business requirements 
  • 4+ years analyzing database structures and developing detailed specifications for ETL, Web API, or reporting requirements
    5+ years working knowledge of relational databases/database structures
  • Bachelor’s degree or equivalent work experience

Preferred Qualifications:

  • Experience facilitating customer requirements gathering meetings/sessions/JAD Sessions
  • Experience with the State of Michigan PMM/SUITE methodology
  • Experience with Agile methodologies
  • Previous experience working with the Data Modelers and developers, facilitate modification of the logical design to create a physical design most suited to the reporting needs of the customer
  • Ability to design applications taking into consideration data reconciliation, (to the source system) query/reporting performance, and analytical business value
  • Meet with users for clarification and elaboration as may be necessary to clearly define a problem and conceptualize a development plan
  • Recognize, gather, correlate, and analyze facts, draw conclusions, define problems, and devise solutions and alternatives and make appropriate recommendations
  • Business Analyst experience in a state government environment
  • Medicaid/Medicare or Healthcare industry experience
  • Experience with Teradata SQL Assistant
  • Experience with Data Cleansing

Careers with Optum. Here's the idea. We built an entire organization around one giant objective; make health care work better for everyone. So when it comes to how we use the world's large accumulation of health-related information, or guide health and lifestyle choices or manage pharmacy benefits for millions, our first goal is to leap beyond the status quo and uncover new ways to serve. Optum, part of the UnitedHealth Group family of businesses, brings together some of the greatest minds and most advanced ideas on where health care has to go in order to reach its fullest potential. For you, that means working on high performance teams against sophisticated challenges that matter. Optum, incredible ideas in one incredible company and a singular opportunity to do your life's best work.(sm)

Diversity creates a healthier atmosphere: UnitedHealth Group is an Equal Employment Opportunity/Affirmative Action employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, protected veteran status, disability status, sexual orientation, gender identity or expression, marital status, genetic information, or any other characteristic protected by law.

UnitedHealth Group is a drug-free workplace. Candidates are required to pass a drug test before beginning employment.



Job keywords: Data Analyst, Lansing, Michigan, MI

Apply Now
This job has expired and you can't apply for it anymore