Data Warehouse Architect

Data Warehouse Architect-(24140801)

Division Overview:

The (MBCC) mission is to proactively contribute to public safety, crime prevention, victim assistance through planning, policy development and coordination of the justice system in partnership with citizens, government, and communities. 

Job Overview :

The role of the Data Warehouse Architect is to strategically design and implement a data warehouse composed of data received from multiple agencies, at both the state and local levels, in varying formats while ensuring high levels of data availability. This position is responsible for architecting and structuring data in a scalable manner providing a means to model data, support analyses and reporting, all while ensuring data quality and data integrity. This position will lead and/or support activities such as data analysis, data profiling, and data validation. The incumbent will also be supporting integration of data from various sources. The data architect position is a critical contributor that will participate in defining data standards and appropriate models for data warehouse needs. This position will work closely with agency business partners, data consumers, and other key business and MBCC leadership stakeholders. The data architect will be developing processes to support data flows from their source into the target data warehouse models.

Minimum Qualifications:

Bachelor’s degree in an Information Technology related field. Coursework related to database concepts, security principles, and IT architecture. Four years of related experience in database schema development, database administration, data warehouse operations and/support, data modeling experience, and SQL. Other combinations of education or experience may be substituted.

Preferred Qualifications:

Experience with criminal justice data. Tableau or other dashboarding skills and knowledge

Knowledge, Skills, and Abilities:

Special Instructions:

The selection procedures to be used in evaluating the applicant's qualification may include but are not limited to an evaluation of the résumé and cover letter, a structured interview, reference/background checks and fingerprint checks.

Applicants must submit a resume and cover letter to be considered for this position.

Additional materials, references or information submitted by the applicant, but not requested, will not be considered.

Successful applicant(s) will be subject to:

Criminal History Fingerprint Check Driving History

REAL ID Compliant Credential Required and/or Passport:

State employees are required to present legally binding photo identification at the time of hire. Generally, this is a valid driver license, U.S. Passport or Employment Authorization ID (Form I-766).

All DOJ positions require a valid REAL ID or U.S. Passport within 60 days of hire, effective May 3, 2025.

For further information go to or .

HOW TO APPLY: 

.

Tip: When attaching your cover letter and resume, you must mark the attachment as a “Relevant File”.

Your Résumé: Please include all work experience as well as job duties that demonstrate your qualifications for this position.Include dates of employment (month & year- start & end) and the reason you left each job.

A complete online state application is not required. To initiate an application, attach the résumé to be considered for this position.Failure to attach résumé will result in an incomplete application that will not be considered further.

Only electronic applications will be accepted.Materials submitted but not requested will not be considered in the selection process.

All documents for Veteran or Disability preference must be received or date stamped by the closing date.Please submit preference documentation to Terri Christianson at via .

To request an accommodation with the application process, please contact the HR office.

Your service is rewarded with competitive compensation and generous

Medical, dental and vision coverage Retirement plans  Generous paid vacation, sick and holidays Pre-tax Flexibility Spending Accounts Employee Assistance Program

State of Montana employment may qualify for student loan forgiveness under the .

This Organization Participates in .

Minorities are under-represented in this position and are encouraged to apply.

---