The Official Employment Site of Wisconsin State Government
Facebook Twitter LinkedIn  
We are an Equal Opportunity Employer seeking a diverse and talented workforce.

Job View

Department of Health Services
Data Warehouse Architect - Medicaid Services - Re-Announcement
Job Announcement Code(s): 20-02721

Organization Logo
Classification Title: / JAC:
  Job Working Title:
    Data Warehouse Architect - Medicaid Services

Type of Employment:
Full Time (40 hrs/week)
Pay for this position is between $87,360 and $101,920 per year depending on qualifications, plus excellent benefits. A 12-month probationary period is required. This position is in pay schedule and range 07/32. Pay for current state employees will be set in accordance with the compensation plan in effect at the time of appointment.
Roanne Quinn, Human Resources Generalist,
Bargaining Unit:
Area of Competition:
Deadline to Apply:
The previous publication date was 12/7/2020. The previous deadline date was 01/08/2021.
Assessment Information:
Preview Assessment  

Login to ApplyEmail A FriendPrintable Version

**If you applied for this position between December 7th and January 8th, you do not need to reapply.

The Department of Health Services (DHS), Division of Medicaid Services (DMS), Bureau of Systems Management (BSM) is recruiting for a Data Warehouse Architect in Madison, WI.

This position will be located at 1 W. Wilson Street in Madison, WI in the heart of downtown Madison, near the State Capitol, the Madison Metro route and the Capital City bike path. In addition, there are plenty of nearby restaurants, shopping venues, and the Wednesday farmer's market. We offer a team-orientated atmosphere and a focus on work-life balance.

State of Wisconsin benefits include nearly 4 weeks of vacation, 9 paid holidays, ample sick time, a top-rated health plan, low-cost insurance options starting at $32/month for single plans and $80/month for family plans after 2 months of state service, and an exceptional retirement plan.

Click here to see what working for the State of Wisconsin is all about!

NOTE: Interviews will be conducted virtually. The position will be required to report to 1 W. Wilson Street in Madison, WI. Training may be conducted remotely due to the current pandemic until the building is open to DHS employees.

Position Summary:   

The Enterprise Data Warehouse Architect works in the Data Management, Security, and Storage Section in BSM. This position will play a critical role in implementing innovative enterprise data warehouse and data analytics modules to advance data-driven decision making capabilities.

This position is the DMS subject matter expert for data warehouse strategy, architecture, design and implementation, and is responsible for technical oversight of the Medicaid enterprise data warehouse, and data analytics and reporting systems.

This position will lead the development of data warehouse modeling and best practices for DMS. The Enterprise Data Warehouse Architect will provide oversight of vendors and review proposed solutions to ensure they both follow best practices and meet the needs of the consumers of DMS data.

Special Notes:   

All applicants who may be appointed will be required to allow DHS to conduct a background check to determine whether the circumstances of any conviction may be related to the job being filled.


Minimally qualified applicants will have:

  • Experience evaluating or reviewing the architectural design of data warehouses and making recommendations to meet the needs of data consumers.

  • Experience creating and reviewing data models for accuracy, security and efficiency.

  • Experience working with relational database technologies.

  • Experience providing technical service, troubleshooting, or consultation to internal and external stakeholders regarding data management or interpretation.

  • Effective communication skills.

Well-qualified applicants will have:

  • Experience with data warehouse development in a health care or government setting.

  • Experience designing a new data warehouse and creating plans for migrating existing sources to a new environment.

  • Experience implementing data governance policies into data warehouses.

How To Apply:   

Click on the "Preview Assessment" link near the top of this announcement to view the qualifications that will be evaluated in the initial part of the selection process.

After you have previewed the assessment, interested applicants who would like to apply for this position will apply online via Wisc.Jobs. Click "Log In" to access your existing account or to create a new account if you do not already have an account in the system. After you have logged in, click "Apply Now." You will be asked to provide your personal information. Attach your current resume and letter of qualifications (in a Word or PDF compatible format). Your resume and letter of qualifications are very important parts of your application at DHS and are used during the evaluation process to determine your qualifications as they are related to this job. For suggestions on what to include when developing your resume and letter of qualifications, please click here. To be considered for this position, applicants must complete the online process. Failure to submit all required materials will result in an incomplete application and ineligibility for this position. Application materials will not be accepted if received in an incomplete format, an email, as a hard copy, or as a fax.

Applicants deemed eligible may be invited to participate in the next step of the selection process. If you have any questions regarding the application process, please contact the HR Specialist on this announcement.

Permanent classified State employees who are eligible for consideration (transfer, voluntary demotion) must complete the application process to apply. Pay on transfer, demotion, or reinstatement are based on the State of Wisconsin Compensation Plan.

Please note: Important communication regarding this recruitment will be sent via email.

DHS is an Equal Opportunity and Affirmative Action employer seeking a diverse and talented workforce.

Veterans are encouraged to apply. For complete information on veterans hiring programs that may benefit you, please visit the Employment Assistance page on WDVA's website.

Login to ApplyEmail A FriendPrintable Version

State of Wisconsin
Division of Personnel Management
101 East Wilson Street • PO Box 7855 • Madison, WI 53707
WiscJobs © 2001 - 2021