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

Description:

7. What is the specific title of the position

Sr Data Analyst

8. Work location

CT039

9. Work Location Type

100% Telecommute

9a. How many days would the resource need to come into the office

10. Work hours (ex. 9am-5pm day/night shifts rotating shifts etc)

8am-5pm EST

12. What skills/attributes are required (please be detailed as to number of years of experience for each skill)

3 years of demonstrated experience in soliciting reviewing analyzing and writing function and non-functional business requirements 3 years of experience performing requirements gathering and validation 3 years of demonstrated experience in the Healthcare industry operations or implementations focused on data warehouse data analysis or decision support systems 2 years of experience managing project controls including issues risks requirements scope schedules Proven experience with Power BI and/or Tableau dashboards and SQL Proven ability to understand and analyze database data Power BI and/or Tableau dashboards data lineage and integrations with backend databases Proven experience in using Microsoft Word PowerPoint Visio and Excel

13. What skills/attributes are preferred (what will set a candidate apart)

Snowflake SQL PowerBI Direct Medicaid experience (Claims Member Provider) and/or MARS or T-MSIS

14. Does this position require a professional license or certification

No

14a. Please list all necessary professional license or certifications

15. Can you please provide a summary of the project/initiative which describes whats being done

Optum is implementing our Enterprise Data Warehouse & Analytics solution for the State of Connecticut. We have a 20-month implementation to implement the solution including all the operational State and Federal reporting requirements to meet the States needs.

16. What does the ideal candidate background look like (ex: healthcare specific background etc.) We want to be as specific as possible with our firms so they can find the type of candidate youre looking for.

Top 3 skills plus direct experience supporting a Medicaid contract with direct experience creating and mapping State and Federal reporting (MARS and/or T-MSIS)

17. Of the required skills listed which would you consider the top 3 Please list your expectations regarding years of experience for each requirement.

3 years of demonstrated experience in soliciting reviewing analyzing and writing function and non-functional business requirements Proven ability to understand and analyze database data Power BI and/or Tableau dashboards data lineage and integrations with backend databases 3 years of demonstrated experience in the Healthcare industry operations or implementations focused on data warehouse data analysis or decision support systems

18. What experience will set candidates apart from one another

Level of experience in working with SMEs and customers to create business requirements complete source-to-target mappings. Level of experience within Healthcare - Medicaid MARS/T-MSIS

19. (If a Contract to Hire) Are you open to candidates that cannot convert to FTE without sponsorship

This position may be offered to a candidate authorized to work in the US for his/her/their stated employer without any restrictions which would prevent the candidate from working on the proposed assignment for the duration of the assignment period.

20. What does the team structure look like how many members and what is the break-down of the teams skill sets (ex: 1 PM 4 Developers etc.)

The implementation team is a matrixed organiziation with a PMO leading the project and several front-line functional managers over major project areas. This position will report into the State and Federal Reporting Manager for their day-to-day responsibilities.

21. What does the interview process look like

a. How many rounds

1-2

b. Video vs. phone

Video

c. How technical will the interviews be

Technical - we need to assess the candidates database analysis skills and background

Required Skills :

Basic Qualification :

Additional Skills :

Background Check : No

Drug Screen : No