Minnesota Careers
Data Warehouse Server Administrator - ITS4
Minnesota Careers, Saint Paul, Minnesota, United States, 55130
Job Details
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 : 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 (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.
Job Summary
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 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. Qualifications
Minimum Qualifications
Candidates must clearly demonstrate these qualifications in their resume.
Resume tips here.
:
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 thata 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 Servicesdoes 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.
Application Details
How to Apply
Select "Apply for Job" at the top of this page. If you have questions about applying for jobs, contact the Careers Help Desk at 651-259-3637 or email careers@state.mn.us . For additional information about the application process, go to http://www.mn.gov/careers .
Contact
If you have questions about this position, contact Mandie Stevenson at mandie.stevenson@state.mn.us .
Connect 700 Program
To receive consideration as a Connect 700 Program applicant, apply online, email the Job ID#, the Working Title and your valid Proof of Eligibility Certificate by the closing date to Mandie Stevenson at mandie.stevenson@state.mn.us .
Veterans
To be considered for any Veteran's Status , you MUST indicate this on your application.
RECENTLY SEPARATED VETERANS (RSV) : Effective July 1, 2009, legislation provides that the top five RSV applicants who apply and meet the qualifications for a vacancy shall be granted an interview. You must: Meet all Minimum Qualifications identified in this posting. Meet all of the RSV criteria. Submit a copy of your DD-214 form by the closing date to: MNIT.Recruitment@state.mn.us . CERTAIN DISABLED VETERANS : Effective August 1, 2012, legislation provides state agencies with the option to appoint certain disabled veterans on a noncompetitive basis if you:
Meet service requirements and have a verified service-connected disability rating of at least 30%. Provide qualifying documentation verifying the disability. Meet all Minimum Qualifications identified in this posting. You must submit all documentation by the closing date to: MNIT.Recruitment@state.mn.us .
Current State Employees
Bidders: This vacancy is open for bids and all qualified applicants simultaneously. This vacancy will be filled in accordance with applicable union contract provisions. Current employees of Minnesota IT Services who are currently in an
Information Technology Specialist 4/
Data Systems
position and who are eligible to bid and apply within the seven (7) day bidding period will be considered prior to filling the position via other means. Current State Employees: Please note that employment provisions (including but not limited to seniority and leave accrual) vary among the three branches of Minnesota State government. When considering a job with another branch of state government, you are highly encouraged to explore these differences. For assistance, please direct questions to your current or anticipated Human Resources office. About Minnesota IT Services
Minnesota IT Services is the information technology agency for the State of Minnesota. MNIT partners with agencies, boards, councils, and commissions to deliver secure, reliable technology solutions as we set IT strategy, direction, policies, and standards statewide. Work for MNIT and be part of a nation-leading IT organization that helps to create an innovative government that works for everyone. Our culture promotes collaboration, demands agility, and encourages us to embrace change. Be a part of something bigger than yourself, something to be inspired by; come to work for MNIT.
Working together to improve the state we love.
What do Minnesota's State employees have in common?
A sense of purpose in their work Connection with their coworkers and communities Opportunities for personal and professional growth Benefits
As an employee, you'll have access to one of the most affordable health insurance plans in Minnesota, along with other benefits to help you and your family be well.
Your benefits may include:
Paid vacation and sick leave 12 paid holidays each year Low-cost medical, dental, vision, and prescription drug plans
Fertility care, including IVF Diabetes care Dental and orthodontic care for adults and children
6 weeks paid leave for parents of newborn or newly adopted children Pension plan that provides income when you retire (after working at least three years) Employer paid life insurance to provide support for your family in the event of death Short-term and long-term disability insurance that can provide income if you are unable to work due to illness or injury Tax-free expense accounts for health, dental, and dependent care Resources that provide support and promote physical, emotional, social, and financial well-being Support to help you reach your career goals:
Training, classes, and professional development Tuition reimbursement Federal Public Service Loan Forgiveness Program (Some positions may qualify for the Public Service Loan Forgiveness Program. For more information, visit the Federal Student Aid website at studentaid.gov ) Employee Assistance Program (EAP) for work/life support:
A voluntary confidential program that helps employees and their families with life challenges that may impact overall health, personal well-being, or job performance Common sources of stress can be addressed through the EAP: mental health, relationship challenges (personal and work), grief and loss, finances, and legal issues Daily Living/Convenience Services: Chore services, home repair, trip planning, child/elder care
Programs, resources and benefits eligibility varies
based on type of employment, agency, funding availability, union/collective bargaining agreement, location, and length of service with the State of Minnesota.
EQUAL OPPORTUNITY EMPLOYERS
Minnesota state agencies are equal opportunity, affirmative action, and veteran-friendly employers. State agencies are committed to creating a workforce that reflects the diversity of the state and strongly encourages persons of color and Indigenous communities, members of the LGBTQIA2S+ community, individuals with disabilities, women, and veterans to apply. The varied experiences and perspectives of employees strengthen the work we do together and our ability to best serve Minnesotans.
All qualified applicants will receive consideration for employment without regard to race, color, creed, religion, national origin, sex (including pregnancy, childbirth, and disabilities related to pregnancy or childbirth), gender identity, gender expression, marital status, familial status, age, sexual orientation, status regarding public assistance, disability, veteran status or activity in a local Human Rights Commission or any other characteristic protected by law.
APPLICANTS WITH DISABILITIES
Minnesota state agencies make reasonable accommodations to their employees and applicants with disabilities. If you have a disability and need assistance in searching or applying for jobs with the State of Minnesota, call the Careers Help Desk at 651-259-3637 or email careers@state.mn.us and let us know the support you need.
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 : 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 (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.
Job Summary
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 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. Qualifications
Minimum Qualifications
Candidates must clearly demonstrate these qualifications in their resume.
Resume tips here.
:
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 thata 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 Servicesdoes 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.
Application Details
How to Apply
Select "Apply for Job" at the top of this page. If you have questions about applying for jobs, contact the Careers Help Desk at 651-259-3637 or email careers@state.mn.us . For additional information about the application process, go to http://www.mn.gov/careers .
Contact
If you have questions about this position, contact Mandie Stevenson at mandie.stevenson@state.mn.us .
Connect 700 Program
To receive consideration as a Connect 700 Program applicant, apply online, email the Job ID#, the Working Title and your valid Proof of Eligibility Certificate by the closing date to Mandie Stevenson at mandie.stevenson@state.mn.us .
Veterans
To be considered for any Veteran's Status , you MUST indicate this on your application.
RECENTLY SEPARATED VETERANS (RSV) : Effective July 1, 2009, legislation provides that the top five RSV applicants who apply and meet the qualifications for a vacancy shall be granted an interview. You must: Meet all Minimum Qualifications identified in this posting. Meet all of the RSV criteria. Submit a copy of your DD-214 form by the closing date to: MNIT.Recruitment@state.mn.us . CERTAIN DISABLED VETERANS : Effective August 1, 2012, legislation provides state agencies with the option to appoint certain disabled veterans on a noncompetitive basis if you:
Meet service requirements and have a verified service-connected disability rating of at least 30%. Provide qualifying documentation verifying the disability. Meet all Minimum Qualifications identified in this posting. You must submit all documentation by the closing date to: MNIT.Recruitment@state.mn.us .
Current State Employees
Bidders: This vacancy is open for bids and all qualified applicants simultaneously. This vacancy will be filled in accordance with applicable union contract provisions. Current employees of Minnesota IT Services who are currently in an
Information Technology Specialist 4/
Data Systems
position and who are eligible to bid and apply within the seven (7) day bidding period will be considered prior to filling the position via other means. Current State Employees: Please note that employment provisions (including but not limited to seniority and leave accrual) vary among the three branches of Minnesota State government. When considering a job with another branch of state government, you are highly encouraged to explore these differences. For assistance, please direct questions to your current or anticipated Human Resources office. About Minnesota IT Services
Minnesota IT Services is the information technology agency for the State of Minnesota. MNIT partners with agencies, boards, councils, and commissions to deliver secure, reliable technology solutions as we set IT strategy, direction, policies, and standards statewide. Work for MNIT and be part of a nation-leading IT organization that helps to create an innovative government that works for everyone. Our culture promotes collaboration, demands agility, and encourages us to embrace change. Be a part of something bigger than yourself, something to be inspired by; come to work for MNIT.
Working together to improve the state we love.
What do Minnesota's State employees have in common?
A sense of purpose in their work Connection with their coworkers and communities Opportunities for personal and professional growth Benefits
As an employee, you'll have access to one of the most affordable health insurance plans in Minnesota, along with other benefits to help you and your family be well.
Your benefits may include:
Paid vacation and sick leave 12 paid holidays each year Low-cost medical, dental, vision, and prescription drug plans
Fertility care, including IVF Diabetes care Dental and orthodontic care for adults and children
6 weeks paid leave for parents of newborn or newly adopted children Pension plan that provides income when you retire (after working at least three years) Employer paid life insurance to provide support for your family in the event of death Short-term and long-term disability insurance that can provide income if you are unable to work due to illness or injury Tax-free expense accounts for health, dental, and dependent care Resources that provide support and promote physical, emotional, social, and financial well-being Support to help you reach your career goals:
Training, classes, and professional development Tuition reimbursement Federal Public Service Loan Forgiveness Program (Some positions may qualify for the Public Service Loan Forgiveness Program. For more information, visit the Federal Student Aid website at studentaid.gov ) Employee Assistance Program (EAP) for work/life support:
A voluntary confidential program that helps employees and their families with life challenges that may impact overall health, personal well-being, or job performance Common sources of stress can be addressed through the EAP: mental health, relationship challenges (personal and work), grief and loss, finances, and legal issues Daily Living/Convenience Services: Chore services, home repair, trip planning, child/elder care
Programs, resources and benefits eligibility varies
based on type of employment, agency, funding availability, union/collective bargaining agreement, location, and length of service with the State of Minnesota.
EQUAL OPPORTUNITY EMPLOYERS
Minnesota state agencies are equal opportunity, affirmative action, and veteran-friendly employers. State agencies are committed to creating a workforce that reflects the diversity of the state and strongly encourages persons of color and Indigenous communities, members of the LGBTQIA2S+ community, individuals with disabilities, women, and veterans to apply. The varied experiences and perspectives of employees strengthen the work we do together and our ability to best serve Minnesotans.
All qualified applicants will receive consideration for employment without regard to race, color, creed, religion, national origin, sex (including pregnancy, childbirth, and disabilities related to pregnancy or childbirth), gender identity, gender expression, marital status, familial status, age, sexual orientation, status regarding public assistance, disability, veteran status or activity in a local Human Rights Commission or any other characteristic protected by law.
APPLICANTS WITH DISABILITIES
Minnesota state agencies make reasonable accommodations to their employees and applicants with disabilities. If you have a disability and need assistance in searching or applying for jobs with the State of Minnesota, call the Careers Help Desk at 651-259-3637 or email careers@state.mn.us and let us know the support you need.