Senior Healthcare Data Architect Lead Data Modeler (Healthcare, SQL)

Description:

7. What is the specific title of the position

Principal Data Analyst

8. Work location

MN101

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)

9am -5pm

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

Strong problem solving influencing communication and presentation skills self-starter. Expertise in Data Modeling Data Strategy and Roadmap for large and complex health entity and systems and implemented large scale end-to-end Data Management & Analytics solutions for more than one large client. Strong knowledge of regulatory security requirements regarding HIPPA PHI PII and other health care data security standards. Strong Healthcare domain knowledge of Medicaid Medicare and Commercial healthcare data sets. Expertise with normalized OLTP OLAP MDM and Dimensional modeling techniques Star schemas slowly changing dimensions role-playing dimensions dimensional hierarchies and data classification. Expert level SQL skills with direct experience writing complex analytic queries stored procedures DDL DML and DCL. Thorough knowledge of query optimization techniques with the ability to write code to ANSI standards and inspect code written by other developers. Expertise in Data Quality Data Profiling Data Governance Data Security Metadata Management MDM Data Archival and Data Migration strategies using appropriate tools.

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

Experience with Microsoft Azure cloud infrastructure and services (Azure Data Lake Storage Azure Data Factory Purview Azure Maps etc.) Experience with Snowflake DBMS Experience with PowerBI or Tableau

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 currently seeking a hands-on Senior Health Data Modeler to support our CT EDW within the Enterprise Datawarehouse and Analytics group. The Data Modeler will work with large healthcare datasets and will translate clients business requirements into enterprise systems applications or process designs for large complex health data solutions. The role will drive and support initiatives for the CT EDW as well as participate in the wider EDW groups areas of data usage and governance information management privacy and security SOA data analytics and visualization and information modeling.

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.

Data modeler with Medicaid/Healthcare experience

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

Strong problem solving influencing communication and presentation skills self-starter. Expertise in Data Modeling Data Strategy and Roadmap for large and complex health entity and systems and implemented large scale end-to-end Data Management & Analytics solutions for more than one large client. Strong knowledge of regulatory security requirements regarding HIPPA PHI PII and other health care data security standards. Strong Healthcare domain knowledge of Medicaid Medicare and Commercial healthcare data sets. 5 years of experience with Erwin data modeler

18. What experience will set candidates apart from one another

Data modeler with Medicaid/Healthcare experience

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

Yes

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.)

Data Manager Data Modeler Data Integration Lead Data Engineers

21. What does the interview process look like

a. How many rounds

3

b. Video vs. phone

Video

c. How technical will the interviews be

Very

Required Skills :

Basic Qualification :

Additional Skills :

Background Check : No

Drug Screen : No