Working Title: Data Warehouse ETL Analyst - ITS4
Job Class: Information Technology Specialist 4
Agency: Minnesota IT Services
Job ID : 88705
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 : 09/09/2025
Closing Date : 09/15/2025
Hiring Agency/Seniority Unit : Minnesota IT Services
Division/Unit : Human and Social Digital Svcs
Work Shift/Work Hours : Day Shift
Days of Work : Monday - Friday
Travel Required : No
Salary Range: $37.07 - $61.14 / hourly; $77,402 - $127,660 / annually
Job Class Option : Data Systems
Classified Status : Classified
Bargaining Unit/Union : 214 - MN Assoc of Professional Empl/MAPE
FLSA Status : Exempt - Professional
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,800+ 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 will be part of MNIT's Human and Social Digital Services (HSDS) team, which supports agency teams at these state agencies: Department of Human Services (DHS), MNsure, the Department of Children, Youth, and Families (DCYF), and Direct Care and Treatment (DCT). The MNIT HSDS team combines development and IT operations with a DevOps approach to ensure the reliable and efficient delivery of critical technology systems that serve counties, families, and individuals across Minnesota.
As a Data Warehouse ETL Analyst you will provide advanced professional knowledge and skills in the analysis, design, development, implementation and support of the programs and jobs used in the extraction, conversion, loading, and maintenance of MMIS and other source system data (especially Health Care data) within the data warehouse relational environment. Additional support of other Data Warehouse applications relating specifically to ETL responsibilities will be provided as needed.
This position requires an employee to be onsite at 540 Cedar Street, St. Paul, Minnesota at least 50% of the time, with some opportunity to perform work from a telework location. Telework (https://mn.gov/mmb-stat/policies/1422-telework.pdf) for Minnesota IT Services is available on a limited basis. Employees will be required to meet current telework eligibility requirements.
Minimum Qualifications
Candidates must clearly demonstrate all of the following 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 IT related experience in data warehousing, ETL processes, and SQL Scripting.
Experience must include:
Working with data transformations and load processes using Teradata or similar relational database platforms
Strong proficiency in SQL, including complex queries, joins, and scripts for data extraction and transformation
Hands-on experience with ETL tools such as BTEQ, FastLoad, TRelational, Teredata utilities, and mainframe utilities (JCL, COBOL, UNIX, IOF/SPF)
Solid understanding of data schema design, relational databases, data encryption (at rest and in transit), and optimizing data retrieval
Strong problem solving and trouble shooting skills to address complex data integration, transformation, and performance issues
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 an IT related field substitutes for three (3) years of experience, OR an IT related bachelor's degree substitutes for two (2) years, OR an IT related associate's degree substitutes for one (1) year.
Preferred Qualifications
Proven experience with MMIS, or a similar data integration environment, including working knowledge of systems architecture, design, and data management.
Expertise in automating ETL processes using modern tools and technologies to streamline workflows.
Knowledge of data retention and data security best practices for handling sensitive information.
Familiarity with data governance principles, including data quality, metadata management, and compliance with data security standards.
Experience with data and ETL process migration from on-prem databases to Cloud (Azure, AWS, Oracle etc).
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 applicant 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.
