Enterprise Data Warehouse Analyst

Dept of Med Assistance Svcs

Located in Richmond, Virginia, the Department of Medical Assistance Services enhances health care quality for Virginians. They are looking for a skilled Enterprise Data Warehouse Analyst to drive data solutions, support operations, and uphold the agency's mission emphasizing health quality and well-being.

In this role you can expect to have the responsibilities:

• Plan and execute the analytics roadmap for DMAS.
• Analyze client applications for data quality, integration, and transformation.
• Evaluate load processes into the Data Warehouse and address migration issues.
• Ensure data integrity and resolve production issues.
• Educate and train users.
• Create metrics and complex reports to support the agency's mission.
• Manage metadata and monitor data quality and profiling.

This role comes with the following benefits:

• Rich cultural and natural surroundings with proximity to major landmarks.

This role requires you to have:

• Knowledge of data analysis, transformation, and cleaning.
• Experience with databases such as Oracle, SQL server, and others.
• Understanding of data warehouse design and data organization.
• Proficiency in BI tools like SAS, R, or Tableau.
• Experience writing PL/SQL scripts.
• Ability to meet deadlines and work with stakeholders.

You would benefit from having:

• Experience in data modeling and schema design.
• Knowledge of healthcare systems like Medicaid or Medicare.
• Experience with BTEQ and UNIX scripting.
• Familiarity with ETL tools like Informatica or Oracle Data Integrator.

DMAS is an equal opportunity employer committed to inclusion. They encourage applications from veterans and individuals with disabilities through dedicated hiring processes.