Sr.Data Analyst (SQL, Medicaid, PowerBI, T-MSIS OR MARS)

Codetech • Hartford, CT

2d • Remote

About The Position

Optum is implementing an Enterprise Data Warehouse & Analytics solution for the State of Connecticut. The 20-month implementation covers operational, State, and Federal reporting requirements. The Sr Data Analyst will support the implementation and report day to day to the State and Federal Reporting Manager within a matrixed team led by a PMO and functional managers.

Requirements

• At least 3 years of experience soliciting, reviewing, analyzing, and writing functional and non-functional business requirements.
• At least 3 years of experience gathering and validating requirements.
• At least 3 years of experience in healthcare industry operations or implementations focused on data warehousing, data analysis, or decision support systems.
• At least 2 years of experience managing project controls, including issues, risks, requirements, scope, and schedules.
• Experience with Power BI and/or Tableau dashboards and SQL.
• Ability to understand and analyze database data, Power BI and/or Tableau dashboards, data lineage, and integrations with backend databases.
• Experience using Microsoft Word, PowerPoint, Visio, and Excel.

Nice To Haves

• Experience with Snowflake, SQL, and Power BI.
• Direct Medicaid experience, including claims, member, or provider data, and/or experience with MARS or T-MSIS.
• Experience supporting a Medicaid contract and creating and mapping State and Federal reporting, including MARS and/or T-MSIS.
• Experience working with subject matter experts and customers to create business requirements and complete source-to-target mappings.

Responsibilities

• Solicit, review, analyze, and write functional and non-functional business requirements.
• Gather and validate requirements.
• Analyze database data, dashboards, data lineage, and integrations with backend databases.
• Manage project controls, including issues, risks, requirements, scope, and schedules.
• Work with subject matter experts and customers to develop business requirements and complete source-to-target mappings.
• Support State and Federal reporting requirements, including reporting such as MARS and T-MSIS.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed