Database Architect

Database Architect

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

Qualifications

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

Your service is rewarded with competitive compensation and generous State of Montana Benefits. State of Montana employment may qualify for student loan forgiveness under the Public Service Loan Forgiveness (PSLF) program.

Application Instructions

Only online applications are accepted. By applying online, you are able to receive updates and monitor the status of your application. To initiate an application and be considered, you must attach your resume, cover letter, and mark the attachments as a "Relevant File". In your cover letter, state why you are applying for the position and anything that makes you uniquely qualified. Applications missing required documentation may not be considered. Successful applicants will be subject to: Criminal history check, Child/patient/offender abuse registries, Reference checks. The Department of Corrections participates in E-Verify to confirm employment eligibility. After accepting a job offer and completing form I-9, your information will be submitted to the Department of Homeland Security and Social Security Administration for verification. For more information about E-Verify, please visit the E-Verify website found here.

Prison Rape Elimination Act (PREA) - Any person who has engaged in sexual abuse in a prison, jail, lockup, community confinement facility, juvenile facility, or other institution; been convicted of engaging in or attempting to engage in sexual activity in the community facilitated by force, overt or implied threats of force, or coercion, or if the victim did not consent or was unable to consent or refuse; or been civilly or administratively adjudicated to have engaged in activity as described in the latter, are not qualified for this position. Tobacco Free - The use of all tobacco products, including smokeless tobacco products and tobacco substitutes is prohibited in Department of Corrections buildings. In secure care facilities possession of tobacco products is prohibited.

Applicant Pool Statement: If another department vacancy occurs in this job title within six months, the same applicant pool may be used for the selection. Training Assignment: This agency may use a training assignment. Employees in training assignments may be paid below the base pay established by the agency pay rules. Conditions of the training assignment will be stated in writing at the time of hire. Salary: $40.77-40.77 Hourly. Telework Eligibility: Telework Eligible (Full-time telework is not available. Telework schedule must be supervisor approved.) Benefits Package Eligibility: Health Insurance, Paid Leave & Holidays, Retirement Plan. Number of Openings: 1. Employee Status: Regular. Schedule: Full-Time. Job Type: Standard. Shift: Day Job. Travel: Yes, 5 % of the Time. Primary Location: Helena. Agency: Department of Corrections. Union: 000 - None.