Minnesota IT Services · 1 day ago
Data Warehouse ETL Analyst - ITS4
St Paul, MN
Full-time
Hybrid
Mid Level
$37.07/hr - $61.14/hr
4+ years expMinnesota IT Services is the information technology agency for the State of Minnesota, seeking a Data Warehouse ETL Analyst to join their Human and Social Digital Services team. The role involves the analysis, design, development, implementation, and support of ETL processes for various data systems within a relational data warehouse environment.
AppsInformation TechnologyIT Infrastructure
No H1B
Responsibilities
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 and MAXIS/MEC2 (in a primary capacity) and some MMIS (in a backup capacity), and other source system data within the data warehouse relational environment
Provide additional support of other HSDS applications relating specifically to ETL responsibilities as needed
Qualification
Required
Position requires a minimum of four (4) years of IT related experience in data warehousing, ETL processes, and SQL Scripting
Advanced hands on experience with Microsoft SSIS development
Strong SQL skills, including stored procedures, performance tuning, and complex queries
Experience with Azure data services such as Azure Data Factory, Azure SQL, Azure Blob Storage, or Synapse
Solid understanding of ETL concepts, data warehousing, and data modeling
Familiarity with Git or other version control systems
Ability to work independently and in a collaborative team environment
Demonstrated ability to communicate clearly and effectively in a manner that facilitates mutual understanding
Customer-focused approach grounded in active listening, empathy, and solution-oriented problem-solving to deliver positive user experiences
Education in Information Technology (IT) or an IT related field may substitute for experience as follows: a master's degree for eighteen (18) months of experience; a bachelor's degree for one (1) year; and an associate's degree for six (6) months
Preferred
3+ years of hands-on experience with Microsoft SSIS development
Experience with Azure DevOps pipelines or CI/CD automation
Knowledge of Power BI or other reporting tools
Exposure to Python, C#, or other scripting languages
Experience with on-prem to cloud migration projects
Experience with Informatica
Benefits
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
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
Company
Minnesota IT Services
Minnesota IT Services is an information technology agency that offers leadership and planning services.
1001-5000 employees
Funding
Current Stage
Late StageLeadership Team
J
Jeff Nyberg
Chief Technology Officer
Recent News
Government Technology US
2025-04-10
2025-03-08
Company data provided by crunchbase