Data Warehouse Architect

Data Warehouse Architect )

The Montana Board of Crime Control’s (MBCC) mission is to proactively contribute to public safety, crime prevention and victim assistance through planning, policy development and coordination of the justice system in partnership with citizens, government and communities in Montana. In support of this mission, MBCC is comprised of twenty‑one dedicated employees possessing a shared vision of public service for Montana’s most vulnerable citizens.

To support and inform the work of the MBCC, Montana’s Statistical Analysis Center (SAC) is housed within the Board. The SAC collects, analyzes, and reports statistics on crime and justice to all levels of government, and manages grants to improve criminal justice data quality and to support criminal justice research.

Joined the agency? ..

The Data Warehouse Architect, housed in the SAC, serves as the lead designer for the Criminal Justice Data Warehouse (JDW) project authorized through the 2023 Montana Legislative Session. The JDW contributes to the comprehensive and cohesive criminal justice system to aid efforts in resource allocation, policy changes, and aims to enhance outcomes for both offenders and crime victims. More information on this critical project can be found HERE.

• Architecting and structuring data in a scalable manner providing a means to model data;
• Performing a variety of data analyses, data profiling and data validation functions;
• Defining data standards and appropriate models for data warehouse needs;
• Developing processes to support data flows from their source into data warehouse models; and
• Supporting integration of data from various sources.

If you want to join a small state agency with a positive work culture built on a shared desire to serve citizens of Montana, don’t hesitate to apply!

• This position is eligible for part‑time telework opportunity following a period of training. Weekly in‑office days are required.

• Bachelor’s degree in an Information Technology related field with coursework emphasizing database concepts, security principles and IT architecture;
• Substantive professional and progressive experience operating in complex database environments.
• Alternate forms of education/experience considered on a case‑by‑case basis

• Working with criminal justice data;
• Operating in Tableau or other dashboarding tools;
• Administering or working within an AWS environment; and/or
• Leading the design of a complex database environment.

• Data warehouse architecture and relational database structures
• Scaled Agile development methodologies
• Database platforms including Oracle, SQL Server and Snowflake
• Information models such as XML, SOAP, and NIEM
• Modeling tools and ETL products

• Utilize Business Intelligence tools
• Program in common languages such as SQL, PL/SQL, etc.
• Establish and maintain effective professional relationships
• Design, install, configure and support multi‑terabyte data warehouses
• Prioritize a complex workload and meet project deadlines
• Conduct technical requirements analyses, data processing flowcharting and data mapping

Please tell us how and why by submitting your resume and cover letter. (

Please note:

You do not need to complete the “work experience” or the “education & certifications” portion of the application process in our recruiting system. You only need to upload the requested documentation.)

• Benefits include:
• Work/life Balance
• Health Coverage
• Paid Vacation and Sick Leave and Holidays

Public Service Loan Forgiveness (PSLF) – Employment with the State of Montana may qualify you to receive student loan forgiveness under the PSLF.

• This position requires the successful completion of a criminal background check.
• Only online applications are…