Sign In
 [New User? Sign Up]
Mobile Version

IT Data Warehouse and Analytics Specialist

UnitedHealth Group

Lansing, MI
Job Code:
Apply on the Company Site
  • Save Ad
  • Email Friend
  • Print
  • Research Salary

Job Details

730391 IT Data Warehouse and Analytics Specialist

IT Data Warehouse and Analytics Specialist (730391)

Position Description

At Optum, we create hundreds of custom applications and manage thousands of hardware components.
Together, we deliver smarter, faster and simpler solutions for a modern, innovative health system. We are also the career home to Senior IT Data Analysts who bring compassion and passion, energy and focus to their work every day. If you strive to help people live healthier lives by building your career with a leader in health care, this is the career for you! Come share your expertise and your passion and do your life's best work.SM
As part of this group, you will predominantly 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. This role will prepare you for significant career growth.

This is a unique development role where you will be part of a 40 person Data Warehouse team that includes Project Managers, Teradata and Web Developers, Data Modelers, DBAs, Business Analysts, Report Developers, Help Desk Analysts and Subject Matter Experts.  You will be working with the customers (Michigan Department of Health and Human Services) identifying and developing data warehouse-based solutions..

Primary Responsibilities:


  • Gather and analyze business requirements
  • Architect and design Data Warehouse infrastructure and solutions
  • Develop technical specifications and design documents
  • Develop, enhance, and integrate Data Warehouses/Data Marts and Business Intelligence Solutions
  • Test Data Warehouses/Data Marts
  • Deploy and maintain Data Warehouses/Data Marts
  • Communicate effectively, verbally and in writing, with programmers, analysts, immediate supervisor, management, system users, operations, other State agencies and the private sector.
  • Able to work independently and not rely on State or other team members
  • Excellent communication, time/project management, problem solving, organizational, and analytical skills required.


Required Qualifications:
  • Bachelor’s degree or equivalent work experience
  • 5+ years Project Lead and/or Technical Business Analyst experience preferably in a Data Warehouse project environment
  • 5+ years working with end users/customers to understand and develop requirements for technical solutions to meet business needs
  • 5+ years working with technical developers to strategize solutions to align with business requirements
  • 5+ years Teradata experience, including v14 or higher
  • 5+ years using Teradata in a Unix/Linux environment
  • 3+ years facilitating customer requirements gathering meetings/sessions/JAD Sessions
  • 3+ years working knowledge of relational databases/database structures
  • 3+ years with Requirements Traceability
  • 3+ years with BI reporting
  • 3+ years analyzing project requirements and developing detailed specifications for reporting requirements
  • 3+ years developing test data and test scenarios
Preferred Qualifications:
  • Experience with the State of Michigan PMM/SUITE methodology
  • Experience with Agile methodologies
  • Experience working with the Data Modelers and developers, facilitating 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.
  • Business Analyst experience in a state government environment
  • Medicaid/Medicare or Healthcare IT experience
  • Experience with Teradata SQL Assistant
  • Experience using Teradata Utilities (FastLoad, MultiLoad, BTEQ, TPT)
  • Experience with Data Cleansing
  • Experience using ERWin for data modeling
  • Open Text BI Query experience

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 Details

  • Contest Number730391
  • Job TitleIT Data Warehouse and Analytics Specialist
  • Job FamilyInformation Technology
  • Business SegmentOptumInsight

Job Location Information

  • Lansing, MI
    United States
    North America

Additional Job Detail Information

  • Employee StatusRegular
  • ScheduleFull-time
  • Job LevelIndividual Contributor
  • ShiftDay Job
  • TravelNo
  • Telecommuter PositionNo
  • Overtime StatusExempt

UnitedHealth Group is the most diversified health care company in the United States and a leader worldwide in helping people live healthier lives and helping to make the health system work better for everyone.

Powered ByLogo

Featured Jobs[ View All ]

Featured Employers [ View All ]