Data Warehouse ETL Analyst ITS4

Job description

**Working Title: Data Warehouse ETL Analyst**
**Job Class: Information Technology Specialist 4**
**Agency: Minnesota IT Services**

+ **Job ID** : 89429
+ **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** : 10/10/2025
+ **Closing Date** : 10/20/2025
+ **Hiring Agency/Seniority Unit** : Minnesota IT Services
+ **Division/Unit** : Human and Social Digital Svcs (HSDS)
+ **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** : Application
+ **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,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 PRISM (in a primary capacity, MAXIS/MEC2 (in a backup capacity), and some MMIS(in a backup capacity), and other source system data within the data warehouse relational environment.

Additional support of other MSDD 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 PRISM, 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).
+ Experience with data lineage and data integrity verification processes
+ Experience with migrating data process flows to a cloud integration such as Azure or AWS.

**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.

Required Skill Profession

Other General