Data Warehouse & SQL Server Supervisor - SAUS

Innovation * Opportunity * Work that Matters

Join the 2,000+ professionals who are bringing strategic vision to state government as part of Minnesota's information technology agency. Work for Minnesota IT Services (MNIT) and be part of a cutting-edge organization that is emerging as a national leader in government IT. This position exists to serve 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, ensure child protection and welfare services, and provide support for Minnesotans with special needs including mental illness, chemical dependencies, and physical or developmental disabilities.

Our culture promotes collaboration, demands continuous improvement, and encourages innovation in IT delivery. Be a part of something bigger than yourself, something to be inspired by; come to work for MNIT DHS.

Job Class: Systems Analysis Unit Supervisor

Working Title: Data Warehouse & SQL Server Supervisor

• Who May Apply: Open to all qualified job seekers
• Date Posted: 10/02/2021
• Closing Date: 10/15/2021
• Hiring Agency/Seniority Unit: Minnesota IT Services
• Division/Unit: Department of Human Services/Data Warehouse Administration
• Work Shift/Work Hours: Day Shift
• Days of Work: Monday - Friday
• Travel Required: No
• Salary Range: $33.44 - $57.78/hourly; $69,822 - $120,644/annually
• Classified Status: Classified
• Bargaining Unit/Union: 216 - Middle Management Association/MMA
• FLSA Status: Exempt - Executive
• Connect 700 Program Eligible: Yes

As the Data Warehouse Supervisor, you will supervise and manage the DHS Data Warehouse team (including system administration staff and ETL programmers), the DHS Data Warehouse system (hardware, software, and associated platforms), the Microsoft SQL Server Database Administration team, and the Microsoft SQL Server environment. Additionally, you will provide advanced professional knowledge and skills in the areas of data warehousing and data management and develop and implement the requirements definition, determination of alternative solutions, design, implementation and support for the data warehouse needs of DHS, partners and customers, including project management for assigned work.

Candidates must clearly demonstrate all of the following qualifications on their resume:

Positions require a minimum of three (3) years of experience in data warehousing and relational database development.

Experience must include:

• Database design and development
• Data extraction and cleansing
• Use of query tools and query management
• Data base security

• Lead work or supervisory experience
• Experience supporting Teradata data warehouse platform
• Experience with Linux administration
• Experience with large database workload management
• Experience with Microsoft SQL Server Integration Services
• Knowledge of the state’s budget and accounting system sufficient to monitor the budget
• Understanding DHS business needs, programs, clients/customers, organizational structure, and procedures sufficient to integrate strategic systems plans with other DHS operations
• Experience communicating with technical staff about broad organizational and strategic and tactical directions and issues
• Experience managing service level expectations
• Experience negotiating and managing contracts
• Strong ability to identify, conceptualize, analyze and solve problems, and recommend effective and integrated solutions
• Decision making ability sufficient to make timely definitive decisions with consideration to political, employee, and resource variables
• Ability to communicate on both a technical and non-technical level
• A high degree of creative analytic and problem solving skills
• Ability to plan, lead, and provide work direction and guidance to others
• Thorough knowledge of the methods and techniques of systems analysis and design in a large mainframe environment

GREAT BENEFITS PACKAGE! The State of Minnesota offers a comprehensive benefits package including low cost medical and dental insurance, employer paid life insurance, short and long term disability, pre-tax flexible spending accounts, retirement plan, tax-deferred compensation, generous vacation and sick leave, and 11 paid holidays each year.

Our differences make us stronger and leveraging them helps us create a workforce where everyone can thrive. The State of Minnesota is an equal opportunity employer. We are committed to embedding diversity, equity, inclusion, and accessibility at our workplace. We do this by developing strong leaders and advocates, increasing cultural competence and understanding among all employees, and removing institutional barriers and attitudes that prevent employees from advancing as far as their talents will take them. We prohibit discrimination and harassment of any kind based on race, color, creed, religion, national origin, sex (including pregnancy, childbirth and related medical conditions), marital status, familial status, receipt of public assistance, membership or activity in a local human rights commission, disability, genetic information, sexual orientation, gender expression, gender identity, or age.

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 a Systems Analysis Unit Supervisor 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.

Select “Apply for Job” at the top of this page. If you have questions about applying for jobs, contact the job information line at 651-259-3637.

For additional information about the application process, go to http://www.mn.gov/careers.

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. To qualify, you must meet the following: 1) have separated under honorable conditions from any branch of the armed forces of the United States; 2) have served on active duty for 181 consecutive days or more or for the full period ordered to active duty or have separated by reason of disability incurred while serving on active duty; 3) be a United States citizen or resident alien; and 4) have served in active military service at any time on or after September 11, 2001, as shown on your DD-214 form. To be considered under this legislation, you must: 1) meet all Minimum Qualifications identified in this posting; 2) meet all of the above RSV criteria; and 3) submit a copy of your DD-214 form by the closing date to: MNIT.Recruitment@state.mn.us. Failure to submit your DD-214 form will affect your consideration for an interview under this legislation.

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: 1) meet service requirements and have a verified service-connected disability rating of at least 30%; 2) provide qualifying documentation verifying the disability; and 3) meet all Minimum Qualifications identified in this posting. To be considered under this legislation you must submit all documentation by the closing date to: MNIT.Recruitment@state.mn.us.

If you have questions about the position, contact Kristen Haider at kristen.haider@state.mn.us.

AN EQUAL OPPORTUNITY EMPLOYER

The State of Minnesota is an equal opportunity, affirmative action, and veteran-friendly employer. We are committed to providing culturally responsive services to all Minnesotans. The State of Minnesota recognizes that a diverse workforce is essential and strongly encourages qualified women, minorities, individuals with disabilities, and veterans to apply.

We will make reasonable accommodations 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 you need.