Data Warehouse Architect

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

The Data Warehouse Architect will be responsible for duties such as:

• 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 dont hesitate to apply!

Additional benefits for eligible candidates:

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

What are we looking for

Education and Experience:

• Bachelors 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

Preference will be given to candidates with specific experience:

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

Competencies:

Knowledge of or ability to learn:

• 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

Ability to:

• 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

Does this sound like a fit for you

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

What can you expect from us in return for your work at our agency

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

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

Other important information to be aware of.

• This position requires the successful completion of a criminal background check.
• Only online applications are accepted. By applying online you are able to receive updates and monitor the status of your application.