Minnesota IT Services
Data Warehouse ETL Analyst - ITS4
Minnesota IT Services, Saint Paul, Minnesota, United States, 55199
Join to apply for the
Data Warehouse ETL Analyst - ITS4
role at
Minnesota IT Services
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
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: Yes
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 (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 for Minnesota IT Services is available on a limited basis. Employees will be required to meet current telework eligibility requirements.
Minimum Qualifications
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, Teradata 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 a 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.
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: Michele Lamm at michele.lamm@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 Michele Lamm at michele.lamm@state.mn.us.
Veterans
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: michele.lamm@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: michele.lamm@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/Application 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.
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.
Seniority level Mid‑Senior level
Employment type Full‑time
Job function Information Technology
Industries IT Services and IT Consulting
Referrals increase your chances of interviewing at Minnesota IT Services by 2x
Get notified about new Data Warehouse Analyst jobs in
St Paul, MN .
Data Warehouse Production Support Manager Minnetonka, MN $70,000.00-$140,000.00 2 months ago
Business Analyst, application via RippleMatch Plymouth, MN $73,300.00-$117,200.00 3 days ago
St Paul, MN $50,000.00-$55,000.00 3 weeks ago
St Paul, MN $90,000.00-$100,000.00 3 weeks ago
Minneapolis, MN $68,000.00-$142,000.00 3 months ago
Inver Grove Heights, MN $81,135.00-$105,863.00 1 week ago
Minneapolis, MN $90,000.00-$120,000.00 2 days ago
Minneapolis, MN $65,000.00-$85,000.00 4 months ago
SAP - EWM - Senior - Consulting - Location OPEN Minneapolis, MN $102,500.00-$187,900.00 3 days ago
Clinical Services Optimization Business Analyst III Hopkins, MN $77,100.00-$132,200.00 1 day ago
Hopkins, MN $85,000.00-$125,000.00 2 days ago
Minneapolis, MN $75,000.00-$115,000.00 2 weeks ago
Minneapolis, MN $74,985.00-$114,128.00 1 week ago
We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr
Data Warehouse ETL Analyst - ITS4
role at
Minnesota IT Services
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
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: Yes
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 (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 for Minnesota IT Services is available on a limited basis. Employees will be required to meet current telework eligibility requirements.
Minimum Qualifications
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, Teradata 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 a 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.
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: Michele Lamm at michele.lamm@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 Michele Lamm at michele.lamm@state.mn.us.
Veterans
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: michele.lamm@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: michele.lamm@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/Application 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.
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.
Seniority level Mid‑Senior level
Employment type Full‑time
Job function Information Technology
Industries IT Services and IT Consulting
Referrals increase your chances of interviewing at Minnesota IT Services by 2x
Get notified about new Data Warehouse Analyst jobs in
St Paul, MN .
Data Warehouse Production Support Manager Minnetonka, MN $70,000.00-$140,000.00 2 months ago
Business Analyst, application via RippleMatch Plymouth, MN $73,300.00-$117,200.00 3 days ago
St Paul, MN $50,000.00-$55,000.00 3 weeks ago
St Paul, MN $90,000.00-$100,000.00 3 weeks ago
Minneapolis, MN $68,000.00-$142,000.00 3 months ago
Inver Grove Heights, MN $81,135.00-$105,863.00 1 week ago
Minneapolis, MN $90,000.00-$120,000.00 2 days ago
Minneapolis, MN $65,000.00-$85,000.00 4 months ago
SAP - EWM - Senior - Consulting - Location OPEN Minneapolis, MN $102,500.00-$187,900.00 3 days ago
Clinical Services Optimization Business Analyst III Hopkins, MN $77,100.00-$132,200.00 1 day ago
Hopkins, MN $85,000.00-$125,000.00 2 days ago
Minneapolis, MN $75,000.00-$115,000.00 2 weeks ago
Minneapolis, MN $74,985.00-$114,128.00 1 week ago
We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr