IT Data Analyst

UnitedHealth   •  

Lansing, MI

Industry: Insurance


Less than 5 years

Posted 363 days ago

Position Description

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. This candidate will 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.  This candidate will also perform data analysis, data cleansing, test data creation, and data verification as part of design and testing activities.  The candidate will create the testing documents and matrixes, and will be responsible for assisting the customer with user testing.  They will also be responsible for helping the technical and business teams with project-related formal documentation.  They will meet with users for clarification and elaboration as may be necessary to clearly define a problem and conceptualize a development plan.

Required Qualifications:

  • Bachelor's degree or equivalent work experience

  • 3+ years of Data Analyst or Technical Business Analyst experience preferably in a Data Warehouse project environment

  • 3+ years working with end users / customers to understand and develop requirements for technical solutions to meet business needs

  • 3+ years working with technical developers to strategize solutions to align with business requirements

  • 2+ years analyzing database structures and developing detailed specifications for ETL, Web API, or reporting requirements

  • 2+ years performing data analysis, data cleansing, data generation, and data validation

  • 2+ years facilitating customer requirements gathering meetings / sessions / JAD Sessions

  • 2+ years working knowledge of relational databases / database structures

  • 2+ years with Requirements Traceability


Preferred Qualifications:

  • 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


Soft Skills:

  • Communicate effectively, verbally and in writing, with programmers, analysts, immediate supervisor, management, system users, operations, other State agencies and the private sector

  • Needs to be able to work independently and not rely on State or other team members

  • Excellent communication, time / project management, problem solving, organizational, and analytical skills