Sr.data analyst(Snowflake, SQL, PowerBI Direct Medicaid exp,T-MSIS

Codetech • Hartford, CT

2d • Remote

About The Position

Optum is implementing an Enterprise Data Warehouse and Analytics solution for the State of Connecticut. The 20-month implementation includes operational, State, and Federal reporting requirements. The Sr Data Analyst will support the implementation, with day-to-day responsibilities reporting to the State and Federal Reporting Manager. The implementation team is matrixed, with a PMO leading the project and functional managers overseeing major project areas. The position is 100% telecommute, with work hours of 8:00 a.m.–5:00 p.m. EST. The interview process consists of one to two video interviews and includes a technical assessment of database analysis skills and background.

Requirements

• At least 3 years of demonstrated experience soliciting, reviewing, analyzing, and writing functional and non-functional business requirements.
• At least 3 years of experience performing requirements gathering and validation.
• At least 3 years of demonstrated experience in healthcare industry operations or implementations, focused on data warehouses, data analysis, or decision-support systems.
• At least 2 years of experience managing project controls, including issues, risks, requirements, scope, and schedules.
• Proven 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.
• Proven experience using Microsoft Word, PowerPoint, Visio, and Excel.

Nice To Haves

• Experience with Snowflake, SQL, and Power BI.
• Direct Medicaid experience, including Claims, Member, and 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.
• Support data warehouse, data analysis, or decision-support work in the healthcare industry.
• 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, including reporting requirements for the State of Connecticut implementation.

What This Job Offers

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