Data Warehouse Architect - Helena, United States - Montana Department of Justice

Description

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.

This is a modified position, legislatively funded through the legislature every two yearsPlease submit a resume and cover letter.


Salary:
$ HourlyState of Montana benefits packageThis position is open until filled.
The 1st review of applicants will occur on 4/5/2024.This position may be eligible for a $1.

50 statutory increase on 7/1/2024Minimum Qualifications:
Bachelors 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 knowledgeKnowledge, Skills, and Abilities:
Strong knowledge and hands on experience developing data warehouse architecture, including relational and dimensional database structures.
Knowledge of and experience working with Scaled Agile development.
Hands on experience with business intelligence tools.
Detail oriented with excellent organization and analytical skills.
Ability to prioritize work and meet deadlines.

Ability to establish and maintain effective working relationships with the business, project team members, supervisors, and employees from other departments.

Proven experience and competency in programming languages, including SQL, PL/SQL, etc.
Experience with modeling tools and ETL products.
Knowledge of/or experience with information models, XML, SOAP, and NIEM.Knowledge of/or experience with JSON objects, OAS, and REST APIs.
Experience with business and technical requirements analysis, data processing flowcharting, and data mapping.
Proven experience with data integration architectures supporting data analytics.
Proven experience with database platforms, including Oracle, SQL Server, and Snowflake.
Proven experience with designing, building, installing, configuring, and supporting multi-terabyte data warehouses.
Applicants must submit a resume and cover letter to be considered for this position.
Successful applicant(s) will be subject to:Criminal History Fingerprint CheckDriving History


HOW TO APPLY:
To be considered for this position, you must attach a cover letter and a resume at the time of application

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

RESUME:
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.#J-18808-Ljbffr