Data Analyst

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. 

Primary Responsibilities:

• Business Data Analysts act as a bridge between the technology and business (non-technology) teams providing business growth and expansion to a capability
• Understand and document the business requirements based on the customer’s needs. This includes understanding and evaluating the request, the business process or use case, and general system capabilities
  • Determine operational objectives by defining business functions; gathering information; evaluating output requirements and formats
  • Analyze large amounts of data and business processes to form ideas and solutions to fix the problem
    • Ensure business rules are clearly defined
    • Ensure metrics are clear and have supporting data
    • Ensure metrics are measurable
    • Ensure requirement collection is standardized – Data Selection or Transformations
    • Ensure Data Governance standards are incorporated
• Research and gain a high-level understanding of Data Elements and Sources
  • Define the source of data – type of ingestion, relationships, tables, variables, and transformations that may be needed
  • Become a SME in how the data will be used and how it functions
  • Test Data Profiling and Creation
    • Ensure that individual requirements do not contradict each other or describe the same requirement using different wording
    • Individual requirements must never be unclear/ambiguous
    • Related requirements must be grouped together so that requirements can be modifiable. This characteristic is exhibited by a logical structuring of the requirements
    • There must be a way to prove that a requirement has been fulfilled. Each requirement should be testable – it must be possible to design a test case that can be used to determine if a solution has met the requirement
• Presentation and Handoff to IT
  • BDA creates and ensures that artifacts (SAD) are complete per the business and the artifact is ready for review with IT teams to begin the Solutioning phase of the Software Development Life Cycle (SDLC)
  • Presenting ideas and findings in meetings
  • Complete the necessary reviews to hand off to development
  • Create process flows to simplify hand off from business to IT resources
  • Partner and collaborate with developers during solutioning/development phase
• QA/UAT and Operational Readiness
  • Develop QA and User Acceptance Plan (UAT) and Testing in coordination project and business leads
  • Issue resolution – Proactively troubleshoot data quality issues by identifying the root cause of data discrepancies and determining and implementing recommendations for resolution
  • Work with business counterparts on operational readiness activities to ensure that necessary training and procedure updates have occurred
• Data troubleshooting and issue management
  • Identify, analyze, and resolve data inconsistencies, errors, and discrepancies in databases and reporting systems
    • Utilize troubleshooting techniques to diagnose the root causes of data-related problems
    • Collaborate with cross-functional teams, including IT, data analysts, and business stakeholders, to investigate and resolve data issues
    • Develop and implement data quality control procedures and perform regular audits to maintain data accuracy and integrity
    • Document data troubleshooting processes, solutions, and resolutions for future reference and knowledge sharing
    • Provide technical support and guidance to system users regarding data-related issues
• Comply with the terms and conditions of the employment contract, company policies and procedures, and any and all directives (such as, but not limited to, transfer and/or re-assignment to different work locations, change in teams and/or work shifts, policies in regards to flexibility of work benefits and/or work environment, alternative work arrangements, and other decisions that may arise due to the changing business environment). The Company may adopt, vary or rescind these policies and directives in its absolute discretion and without any limitation (implied or otherwise) on its ability to do so

Required Qualifications:

• Bachelor’s degree
• 3+ years of experience supporting data related initiatives (system integration, data warehouse build, data mart build or related)
• 3+ years of business analyst experience
• 3+ years of QA/UAT experience
• 3+ years of problem solving and troubleshooting issues
• Proven ability to write/understand complex SQL queries involving advanced unions, joins, aggregations, and groups

Preferred Qualifications:

• Experience with Healthcare data
• Experience with marketing or reporting capabilities
• Project management experience
• Knowledge of JSON
• Knowledge of Azure
• Knowledge of SAS
• Knowledge of Adobe products: Adobe Experience Platform, Adobe Journey Optimizer or Customer Journey Analytics
• Proven solid communication skills

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.