Data Warehouse Architect
3.
4 Helena, MT Helena, MT Full-time Full-time $39.
00 - $40.
50 an hour $39.
00 - $40.
50 an hour Data Warehouse Architect - (24140801) 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 must 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 at email protected via File Transfer Service.
To request an accommodation with the application process, please contact the HR office.
Your service is rewarded with competitive compensation and generous State 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 the Public Service Loan Forgiveness (PSLF) program.
This Organization Participates in E-Verify.
Minorities are under-represented in this position and are encouraged to apply.
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:
Not Applicable Salary:
$ 39.
00 - 40.
50 Hourly Telework Eligibility:
Not Telework Eligible 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:
Board of Crime Control Union:
000 - None Posting Date:
Apr 3, 2024, 12:
27:
35 PM Closing Date (based on your computer's timezone):
Ongoing Required Application Materials:
Cover Letter, Resume Contact Name:
DOJ Human Resources Contact Email:
email protected Contact Phone:
406-444-5528.
Estimated Salary: $20 to $28 per hour based on qualifications.
4 Helena, MT Helena, MT Full-time Full-time $39.
00 - $40.
50 an hour $39.
00 - $40.
50 an hour Data Warehouse Architect - (24140801) 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 must 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 at email protected via File Transfer Service.
To request an accommodation with the application process, please contact the HR office.
Your service is rewarded with competitive compensation and generous State 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 the Public Service Loan Forgiveness (PSLF) program.
This Organization Participates in E-Verify.
Minorities are under-represented in this position and are encouraged to apply.
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:
Not Applicable Salary:
$ 39.
00 - 40.
50 Hourly Telework Eligibility:
Not Telework Eligible 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:
Board of Crime Control Union:
000 - None Posting Date:
Apr 3, 2024, 12:
27:
35 PM Closing Date (based on your computer's timezone):
Ongoing Required Application Materials:
Cover Letter, Resume Contact Name:
DOJ Human Resources Contact Email:
email protected Contact Phone:
406-444-5528.
Estimated Salary: $20 to $28 per hour based on qualifications.
|
|
 | |
