Job Information
State of Montana Data Warehouse Architect in Helena, Montana
[${$EscapeTool.xml($name)} Logo] *Division Overview:* The*Montana Board of Crime Control(MBCC) mission*is to proactively contribute to public safety, crime prevention, victim assistance through planning, policy development and coordination of the justice system in partnership with citizens, government, and communities. *Job Overview*: 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 years/ /This 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/2024._ *Minimum Qualifications:* * Bachelor’s 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 knowledge *Knowledge, 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 API’s./ * /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./ *Special Instructions:*/ / The selection procedures to be used in evaluating the applicant's qualification may include but are not limited to an evaluation of the résumé and cover letter, a structured interview, reference/background checks and fingerprint checks. *Applicants; Please submit a resume and cover letter to be considered for this position.* Additional materials, references or information submitted by the applicant, but not requested, will not be considered. Successful applicant(s) will be subject to: * Criminal History Fingerprint Check * Driving History ** *HOW TO APPLY: * /To be considered for this position, you must attach a*cover letter and a résumé*at the time of application/. Tip: When attaching your cover letter and resume, you must mark the attachment as a “Relevant File”. _Your Résumé: 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. A complete online state application is not required. To initiate an application, attach the résumé to be considered for this position. Failure to attach résumé will result in an incomplete application that will not be considered further. Only electronic applications will be accepted. Materials submitted but not requested will not be considered in the selection process. All documents for Veteran or Disability preference must be received or date stamped by the closing date. Please submit preference documentation to Terri Christianson atTerese.Christianson@mt.govviaFile Transfer Service. To request an accommodation with the application process, please contact the HR office. Your service is rewarded with competitive compensation and generousState of Montana Benefits. * Medical, dental and vision coverage * Retirement plans * Generous paid vacation, sick and holidays * Pre-tax Flexibility Spending Accounts * Employee Assistance Program State of Montana employment may qualify for student loan forgiveness under thePublic Service Loan Forgiveness (PSLF) program. This Organization Participates in E-Verify. [E-Verify® Logo] Minorities are under-represented in this position and are encouraged to apply. *Title: *Data Warehouse Architect Location: Helena Requisition ID: 24140801