Minnesota IT Services
Data Warehouse ETL Analyst - ITS4
Minnesota IT Services, Saint Paul, Minnesota, United States, 55199
Overview
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/16/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 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 improving the well-being and quality of life for all Minnesotans. The State is committed to equity and inclusion and invests in employees with benefits, support resources, and training opportunities. Join the 2,800+ MNIT professionals who connect Minnesotans to services that 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 HSDS team combines development and IT operations with a DevOps approach to ensure reliable delivery of critical technology systems for counties, families, and individuals across Minnesota. Position Summary As a Data Warehouse ETL Analyst you will provide advanced professional knowledge and skills in the analysis, design, development, implementation and support of programs and jobs used in the extraction, conversion, loading, and maintenance of PRISM (primary), MAXIS/MEC2 (backup), and other source system data within the data warehouse relational environment. Additional support of other MSDD applications related to ETL responsibilities will be provided as needed. Onsite Requirement This position requires an employee to be onsite at 540 Cedar Street, St. Paul, Minnesota at least 50% of the time, with some opportunity for telework. Telework is available on a limited basis; employees must meet current telework eligibility requirements. Minimum Qualifications
Candidates must clearly demonstrate all of the following qualifications in their resume. A master’s degree substitutes for 3 years of experience; IT-related bachelor’s substitutes for 2 years; IT-related associate’s substitutes for 1 year. 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 troubleshooting skills to address complex data integration, transformation, and performance issues Ability to deliver effective verbal or written messages that facilitate mutual understanding Customer service skills including active listening, empathy, and problem-solving A master’s degree substitutes for 3 years of experience, OR an IT-related bachelor’s substitutes for 2 years, OR an IT-related associate’s substitutes for 1 year. Preferred Qualifications
Proven experience with PRISM or a similar data integration environment, including knowledge of systems architecture, design, and data management Expertise in automating ETL processes using modern tools and technologies Knowledge of data retention and data security best practices 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 migrating data process flows to 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 (e.g., SEMA4 Records Check, Criminal History Check, Reference Check, SSN and Address Verification, Education Verification, Other checks) Minnesota IT Services does not participate in E-Verify. They will not sponsor work visas. 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. For questions about applying, contact the Careers Help Desk at 651-259-3637 or email careers@state.mn.us. For more information about the application process, visit 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 or email the Job ID, Working Title, and your Proof of Eligibility Certificate by the closing date to Michele Lamm at michele.lamm@state.mn.us. Veterans
To be considered for Veteran's Status, indicate this on your application. RSV and certain disabled veteran provisions are described in the posting with specific submission requirements. Current State Employees
Bidders: This vacancy is open for bids and will be filled per union contract provisions. Current MNIT employees eligible to bid will be considered prior to other methods. Current State Employees: Employment provisions vary by state branches; consult your HR office for guidance. About Minnesota IT Services
MNIT provides secure, reliable technology solutions across Minnesota. Our culture emphasizes collaboration, agility, and continuous learning. Working together to improve the state we love. Benefits
Benefits include health insurance, paid leave, holidays, retirement plan, life insurance, disability coverage, flexible spending accounts, and professional development opportunities. Eligibility varies by employment type and other factors. EQUAL OPPORTUNITY EMPLOYERS: Minnesota state agencies are equal opportunity, affirmative action, and veteran-friendly. All qualified applicants will receive consideration without regard to protected characteristics. Accommodations are available for applicants with disabilities.
#J-18808-Ljbffr
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/16/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 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 improving the well-being and quality of life for all Minnesotans. The State is committed to equity and inclusion and invests in employees with benefits, support resources, and training opportunities. Join the 2,800+ MNIT professionals who connect Minnesotans to services that 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 HSDS team combines development and IT operations with a DevOps approach to ensure reliable delivery of critical technology systems for counties, families, and individuals across Minnesota. Position Summary As a Data Warehouse ETL Analyst you will provide advanced professional knowledge and skills in the analysis, design, development, implementation and support of programs and jobs used in the extraction, conversion, loading, and maintenance of PRISM (primary), MAXIS/MEC2 (backup), and other source system data within the data warehouse relational environment. Additional support of other MSDD applications related to ETL responsibilities will be provided as needed. Onsite Requirement This position requires an employee to be onsite at 540 Cedar Street, St. Paul, Minnesota at least 50% of the time, with some opportunity for telework. Telework is available on a limited basis; employees must meet current telework eligibility requirements. Minimum Qualifications
Candidates must clearly demonstrate all of the following qualifications in their resume. A master’s degree substitutes for 3 years of experience; IT-related bachelor’s substitutes for 2 years; IT-related associate’s substitutes for 1 year. 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 troubleshooting skills to address complex data integration, transformation, and performance issues Ability to deliver effective verbal or written messages that facilitate mutual understanding Customer service skills including active listening, empathy, and problem-solving A master’s degree substitutes for 3 years of experience, OR an IT-related bachelor’s substitutes for 2 years, OR an IT-related associate’s substitutes for 1 year. Preferred Qualifications
Proven experience with PRISM or a similar data integration environment, including knowledge of systems architecture, design, and data management Expertise in automating ETL processes using modern tools and technologies Knowledge of data retention and data security best practices 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 migrating data process flows to 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 (e.g., SEMA4 Records Check, Criminal History Check, Reference Check, SSN and Address Verification, Education Verification, Other checks) Minnesota IT Services does not participate in E-Verify. They will not sponsor work visas. 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. For questions about applying, contact the Careers Help Desk at 651-259-3637 or email careers@state.mn.us. For more information about the application process, visit 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 or email the Job ID, Working Title, and your Proof of Eligibility Certificate by the closing date to Michele Lamm at michele.lamm@state.mn.us. Veterans
To be considered for Veteran's Status, indicate this on your application. RSV and certain disabled veteran provisions are described in the posting with specific submission requirements. Current State Employees
Bidders: This vacancy is open for bids and will be filled per union contract provisions. Current MNIT employees eligible to bid will be considered prior to other methods. Current State Employees: Employment provisions vary by state branches; consult your HR office for guidance. About Minnesota IT Services
MNIT provides secure, reliable technology solutions across Minnesota. Our culture emphasizes collaboration, agility, and continuous learning. Working together to improve the state we love. Benefits
Benefits include health insurance, paid leave, holidays, retirement plan, life insurance, disability coverage, flexible spending accounts, and professional development opportunities. Eligibility varies by employment type and other factors. EQUAL OPPORTUNITY EMPLOYERS: Minnesota state agencies are equal opportunity, affirmative action, and veteran-friendly. All qualified applicants will receive consideration without regard to protected characteristics. Accommodations are available for applicants with disabilities.
#J-18808-Ljbffr