State of Minnesota
Data Warehouse Server Administrator - ITS4
State of Minnesota, Saint Paul, Minnesota, United States, 55130
Working Title: Data Warehouse Server Administrator
Job Class: Information Technology Specialist 4
Agency: Minnesota IT Services
Job ID: 81885
Location: St. Paul
Telework Eligible: Yes#LI-Hybrid
Full/Part Time: Full-Time
Regular/Temporary: Unlimited
Who May Apply: Open to all qualified job seekers
Date Posted: 11/16/2024
Closing Date: 11/25/2024
Hiring Agency/Seniority Unit: Minnesota IT Services
Division/Unit: Department of Human Services (DHS)
Work Shift/Work Hours: Day
Days of Work: Monday - Friday
Travel Required: No
Salary Range: $36.52 - $60.24 / hourly; $76,253 - $125,781 / annually
Job Class Option: Data Systems
Classified Status: Classified
Bargaining Unit/Union: 214 - MN Assoc of Professional Empl/MAPE
FLSA Status: Exempt - Administrative
Designated in Connect 700 Program for Applicants with Disabilities (https://mn.gov/mmb/careers/diverse-workforce/people-with-disabilities/connect700/) : Yes
The work you'll do is more than just a job.
At the State of Minnesota, employees play a critical role in developing policies, providing essential services, and working to improve the well-being and quality of life for all Minnesotans. The State of Minnesota is committed to equity and inclusion, and invests in employees by providing benefits, support resources, and training and development opportunities.
Join the 2,600+ professionals of Minnesota IT Services (https://mn.gov/mnit/about-mnit/careers/) (MNIT) who connect Minnesotans to services that will improve their lives. This position serves our partners at Minnesota’s largest state agency, the Department of Human Services (DHS) . The MNIT DHS team supports complex and varied technical needs, including systems that provide health care coverage, deliver child protection and welfare services, and provide support for Minnesotans with special needs including mental illness, chemical dependencies, and physical or developmental disabilities.
As a Data Warehouse Server Administrator with MNIT and DHS, you’ll leverage your advanced professional knowledge and skills to maintain and optimize the hardware supporting our Data Warehouse. This work includes testing, upgrades and creation of macros to support our Teradata and Linux hardware.
You’ll provide essential technical assistance, fostering optimum server performance and security. Additionally, you’ll ensure a seamless transition of ongoing maintenance and technical expertise to business staff by providing optimized hardware and software solutions, encouraging greater independence and proficiency in utilizing the DHS Data Warehouse.
At MNIT and DHS, you’ll be at the forefront of driving impactful solutions that support the wellbeing of Minnesotans. Your contributions will play a critical role in ensuring data-driven decision-making and enhanced service delivery. If you’re passionate about technology and making a difference, we would love to have you on-board.
This position is currently eligible for full-time telework:
Telework (https://mn.gov/mmb-stat/policies/1422-telework.pdf) for Minnesota IT Services allows an employee to perform work from a telework location and an employee may be required to be in the office based on business needs and other dependencies in St. Paul, Minnesota.
Only candidates located in Minnesota and bordering states (Iowa, North Dakota, South Dakota, or Wisconsin) are telework eligible.
Minimum Qualifications
Candidates must clearly demonstrate these qualifications in their resume. Resume tips here. (https://mn.gov/mnit/about-mnit/careers/hiringprocess.jsp) :
Position requires a minimum of four (4) years of experience Implementing database, data warehouse, and/or business intelligence (BI) solutions in an enterprise environment.
Experience must include:
Experience in Linux system administration (Ubuntu, Redhat).
Strong knowledge of networking fundamentals (TCP/IP, DNS, HTTP, SSH, VPN).
SQL experience in Data Definition Language (DDL) and Data Manipulation Language (DML)
Optimizing data schema and architecture for best performance
Experience with configuration management tools (e.g., Ansible, Puppet, Chef) is a plus.
Ability to deliver effective verbal or written messages that facilitate a mutual understanding on both parties.
Customer service skills that include active listening, empathy, and problem-solving.
A master’s degree in Information Technology or a related field substitutes for three (3) years of experience, OR a related bachelor’s degree substitutes for two (2) years, OR a related associate’s degree substitutes for one (1) year.
Preferred Qualifications
Two years or more experience with Linux server management
Two years or more experience with Teradata
Two years or more experience using SQL (Structured Query Language)
A high degree of creative analytic and problem-solving skills
Knowledge of health care claims and/or public assistance program eligibility data content and structures
Experience with modernizing Extract, Transform, Load (ETL) processes – Application Programming Interface (API) and Microsoft Sql Server Integration Services (SSIS)
Good communication skills, with ability to communicate with both technical and non-technical staff
Additional Requirements
It is the policy of Minnesota IT Services that a successful candidate must pass all legally required checks prior to employment which may consist of the following:
SEMA4 Records Check (applies to current and past state employees only)
Criminal History Check
Reference Check
Social Security and Address Verification
Education Verification
Other legally required checks
Minnesota IT Services does not participate in E-Verify. Minnesota IT Services will not sponsor applicants for work visas, including F-1 STEM OPT extensions. All applicants must be legally authorized to work in the United States.
AN EQUAL OPPORTUNITY EMPLOYER
Minnesota State Colleges and Universities is an Equal Opportunity employer/educator committed to the principles of diversity. We prohibit discrimination against qualified individuals based on their race, sex, color, creed, religion, age, national origin, disability, protected veteran status, marital status, status with regard to public assistance, sexual orientation, gender identity, gender expression, or membership in a local commission as defined by law. As an affirmative action employer, we actively seek and encourage applications from women, minorities, persons with disabilities, and individuals with protected veteran status.
Reasonable accommodations will be made to all qualified applicants with disabilities. If you are an individual with a disability who needs assistance or cannot access the online job application system, please contact the job information line at 651-259-3637 or email careers@state.mn.us . Please indicate what assistance is needed.
Job Class: Information Technology Specialist 4
Agency: Minnesota IT Services
Job ID: 81885
Location: St. Paul
Telework Eligible: Yes#LI-Hybrid
Full/Part Time: Full-Time
Regular/Temporary: Unlimited
Who May Apply: Open to all qualified job seekers
Date Posted: 11/16/2024
Closing Date: 11/25/2024
Hiring Agency/Seniority Unit: Minnesota IT Services
Division/Unit: Department of Human Services (DHS)
Work Shift/Work Hours: Day
Days of Work: Monday - Friday
Travel Required: No
Salary Range: $36.52 - $60.24 / hourly; $76,253 - $125,781 / annually
Job Class Option: Data Systems
Classified Status: Classified
Bargaining Unit/Union: 214 - MN Assoc of Professional Empl/MAPE
FLSA Status: Exempt - Administrative
Designated in Connect 700 Program for Applicants with Disabilities (https://mn.gov/mmb/careers/diverse-workforce/people-with-disabilities/connect700/) : Yes
The work you'll do is more than just a job.
At the State of Minnesota, employees play a critical role in developing policies, providing essential services, and working to improve the well-being and quality of life for all Minnesotans. The State of Minnesota is committed to equity and inclusion, and invests in employees by providing benefits, support resources, and training and development opportunities.
Join the 2,600+ professionals of Minnesota IT Services (https://mn.gov/mnit/about-mnit/careers/) (MNIT) who connect Minnesotans to services that will improve their lives. This position serves our partners at Minnesota’s largest state agency, the Department of Human Services (DHS) . The MNIT DHS team supports complex and varied technical needs, including systems that provide health care coverage, deliver child protection and welfare services, and provide support for Minnesotans with special needs including mental illness, chemical dependencies, and physical or developmental disabilities.
As a Data Warehouse Server Administrator with MNIT and DHS, you’ll leverage your advanced professional knowledge and skills to maintain and optimize the hardware supporting our Data Warehouse. This work includes testing, upgrades and creation of macros to support our Teradata and Linux hardware.
You’ll provide essential technical assistance, fostering optimum server performance and security. Additionally, you’ll ensure a seamless transition of ongoing maintenance and technical expertise to business staff by providing optimized hardware and software solutions, encouraging greater independence and proficiency in utilizing the DHS Data Warehouse.
At MNIT and DHS, you’ll be at the forefront of driving impactful solutions that support the wellbeing of Minnesotans. Your contributions will play a critical role in ensuring data-driven decision-making and enhanced service delivery. If you’re passionate about technology and making a difference, we would love to have you on-board.
This position is currently eligible for full-time telework:
Telework (https://mn.gov/mmb-stat/policies/1422-telework.pdf) for Minnesota IT Services allows an employee to perform work from a telework location and an employee may be required to be in the office based on business needs and other dependencies in St. Paul, Minnesota.
Only candidates located in Minnesota and bordering states (Iowa, North Dakota, South Dakota, or Wisconsin) are telework eligible.
Minimum Qualifications
Candidates must clearly demonstrate these qualifications in their resume. Resume tips here. (https://mn.gov/mnit/about-mnit/careers/hiringprocess.jsp) :
Position requires a minimum of four (4) years of experience Implementing database, data warehouse, and/or business intelligence (BI) solutions in an enterprise environment.
Experience must include:
Experience in Linux system administration (Ubuntu, Redhat).
Strong knowledge of networking fundamentals (TCP/IP, DNS, HTTP, SSH, VPN).
SQL experience in Data Definition Language (DDL) and Data Manipulation Language (DML)
Optimizing data schema and architecture for best performance
Experience with configuration management tools (e.g., Ansible, Puppet, Chef) is a plus.
Ability to deliver effective verbal or written messages that facilitate a mutual understanding on both parties.
Customer service skills that include active listening, empathy, and problem-solving.
A master’s degree in Information Technology or a related field substitutes for three (3) years of experience, OR a related bachelor’s degree substitutes for two (2) years, OR a related associate’s degree substitutes for one (1) year.
Preferred Qualifications
Two years or more experience with Linux server management
Two years or more experience with Teradata
Two years or more experience using SQL (Structured Query Language)
A high degree of creative analytic and problem-solving skills
Knowledge of health care claims and/or public assistance program eligibility data content and structures
Experience with modernizing Extract, Transform, Load (ETL) processes – Application Programming Interface (API) and Microsoft Sql Server Integration Services (SSIS)
Good communication skills, with ability to communicate with both technical and non-technical staff
Additional Requirements
It is the policy of Minnesota IT Services that a successful candidate must pass all legally required checks prior to employment which may consist of the following:
SEMA4 Records Check (applies to current and past state employees only)
Criminal History Check
Reference Check
Social Security and Address Verification
Education Verification
Other legally required checks
Minnesota IT Services does not participate in E-Verify. Minnesota IT Services will not sponsor applicants for work visas, including F-1 STEM OPT extensions. All applicants must be legally authorized to work in the United States.
AN EQUAL OPPORTUNITY EMPLOYER
Minnesota State Colleges and Universities is an Equal Opportunity employer/educator committed to the principles of diversity. We prohibit discrimination against qualified individuals based on their race, sex, color, creed, religion, age, national origin, disability, protected veteran status, marital status, status with regard to public assistance, sexual orientation, gender identity, gender expression, or membership in a local commission as defined by law. As an affirmative action employer, we actively seek and encourage applications from women, minorities, persons with disabilities, and individuals with protected veteran status.
Reasonable accommodations will be made to all qualified applicants with disabilities. If you are an individual with a disability who needs assistance or cannot access the online job application system, please contact the job information line at 651-259-3637 or email careers@state.mn.us . Please indicate what assistance is needed.