DATABASE ARCHITECT

State of Montana
Helena, MT, United States
21 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Experienced
Experience required
4 years minimum
Working hours
Regular working hours

Tech stack

Data Analysis Databases Data Architecture Data Integrity Data Warehousing Database Theory Freeform SQL Information Technology Enterprise Integration

Job description

The Data Architect supports the Research, Analytics, and Planning Unit within the Innovation Bureau. This position plays a critical role in producing accurate high-quality data for high-visibility reports, dashboards, and data products used by the Department, other state agencies, partner organizations, and the public. As a Data Architect, you’ll play a key role in delivering the Department’s data warehouse and supporting data driven decision making.

The ideal candidate will demonstrate exceptional technical proficiency, strong analytical judgment, and the ability to communicate effectively with audiences possessing varied levels of technical expertise. A meticulous approach to data integrity and security is essential.

  • Develop, review, and maintain complex SQL queries, views, procedures, and functions within the Department’s data warehouse
  • Model complex correctional data into logical schemas for multiple use cases
  • Produce high-quality data reports and visualizations
  • Deliver timely and accurate data for internal and external requests
  • Manage user access and data collection within the Department’s data warehouse
  • Support the implementation of data security standards
  • Maintain data shares between DOC internal and external partners

Requirements

The knowledge, skills and abilities for this position are typically acquired through a combination of education and experience equivalent to:

  • Bachelor’s degree in an Information Technology related field.
  • Coursework related to database concepts, security principles, and data architecture.
  • Four years of experience working in a database environment which includes the application of systems design and integration concepts.

Alternative combinations of education and experience will be considered on a case-by-case basis.

Benefits & conditions

Your service is rewarded with competitive compensation and generous State of Montana Benefits.

About the company

The Montana Department of Corrections (DOC) is creating a safer Montana through Accountability, Rehabilitation and Empowerment. If you want to work making positive changes in your community, the Montana Department of Corrections is the place for you!

At the Montana Department of Corrections, data is more than numbers-it’s the foundation for smarter policy, stronger outcomes, and meaningful change.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on mtstatejobs.taleo.net

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

1:48 min

Automating exploratory data analysis within training pipelines

Dora Petrella · WWC 2023

3:04 min

Database evolution and the funding behind vector databases

Erik Bamberg · LIVE

1:49 min

Abstracting infrastructure complexity with automated toolsets

Jeremy Murray Jeremy Murray · WWC Europe 2026

1:36 min

Performing exploratory data analysis to uncover underlying patterns

Julian Joseph · LIVE

4:01 min

Managing application isolation via pluggable database models

Wei Hu Wei Hu · WWC 2022

19:28 min

Trivia game round exploring software architecture and networking protocols

James Seconde · WWC 2023

Videos

See all

Related articles

See all