Working Title: Lead ETL Developer
Job Class: Information Technology Specialist 4
Agency: Minnesota IT Services
Job ID : 88130
Location : Various
Telework Eligible : Yes / Remote Worker
Full/Part Time : Full-Time
Regular/Temporary : Unlimited
Who May Apply : Open to all qualified job seekers
Date Posted : 08/09/2025
Closing Date : 08/15/2025
Hiring Agency/Seniority Unit : Minnesota IT Services (MNIT)
Division/Unit : Enterprise / Human & Social Digital Services (HSDS)
Work Shift/Work Hours : Day Shift
Days of Work : Monday - Friday
Travel Required : No
Salary Range: $36.52 - $60.24 / hourly; $76,253 - $125,781 / annually
Job Class Option : Application
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/) : No
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.
The Lead ETL Developer will be responsible for the design, development, implementation, and maintenance of ETL processes used to manage and optimize data workflows in the MAXIS/MEC2 environments. This role will focus on extracting, transforming, and loading data into the data warehouse, ensuring data integrity, security, and efficiency. The Lead ETL Developer will collaborate with various teams, including Data Warehouse architects, source system teams, and program staff, to develop high-quality, reliable, and automated solutions. Additionally, this position requires troubleshooting and production support to ensure seamless data operations.
This is a Remote Worker position (https://mn.gov/mmb-stat/policies/1447-remoteworker.pdf) , where the employees home address shall serve as their official work location and must be located within the continental United States. Remote work is a condition of employment.
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 experience in data warehousing, ETL processes, and SQL scripting.
Experience must include:
Working with data transformation 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, Natural, 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.
Excellent written and verbal communication skills to effectively convey complex technical details to both technical and non-technical stakeholders.
Providing excellent customer service, including active listening, empathy, and effective 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 MAXIS/MEC2, 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 lineage and data integrity verification processes.
Experience leading small to medium-sized teams or projects, including the ability to manage tasks, timelines, and stakeholder communication.
Demonstrated ability to mentor junior team members and assist with career development.
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 applicants 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.
