Data Warehouse Lead - Information Technology Spec 5

State of Minnesota; Saint Paul (MN); On-site; USD 84,000 - 144,000; Full time

Job summary

State of Minnesota is seeking a Data Warehouse Lead to guide the data warehouse development, supervise technical staff, and deliver sophisticated Oracle PL/SQL solutions for MnDOT partnerships. The role emphasizes governance, ETL, and API-driven integration within an enterprise data architecture.

The position requires strong leadership, advanced SQL skills, and experience in data modeling, with onsite work at 395 John Ireland Blvd, St. Paul, MN, and limited telework eligibility.

Qualifications

• Five years of IT experience in large-scale Oracle data warehouse design and data integration.
• Experience leading a team, mentoring members, and ensuring timely, quality deliverables.
• Proficiency with complex Oracle PL/SQL development (stored procedures, triggers, functions, packages).
• Experience with job scheduling/orchestration and tools such as JAMS.
• Strong data modeling knowledge and schema design (star/snowflake, normalization).
• Advanced Oracle SQL development including query optimization and data validation.

Responsibilities

• Coordinate and direct daily activities of technical staff in data warehouse development.
• Lead advanced Oracle PL/SQL development and manage operational batch processing.
• Support integration of PeopleSoft financial, HR, and procurement data.
• Provide technical leadership to ensure consistent data warehouse practices and standards.
• Collaborate on ETL processes, APIs, and enterprise architecture alignment.

Skills

Oracle PL/SQL

Data integration

Team leadership

Communication

SQL performance

Education

Information Technology degree

Tools

JAMS

Job description

Data Warehouse Lead - Information Technology Spec 5

Working Title: Data Warehouse Lead
Job Class: Information Technology Specialist 5
Agency: Minnesota IT Services

• Job ID: 97555
• Location: St. Paul
• Full/Part Time: Full-Time
• Regular/Temporary: Unlimited
• Who May Apply: Open to all qualified job seekers
• Date Posted: 10/10/2026
• Closing Date: 10/16/2026
• Hiring Agency/Seniority Unit: Minnesota IT Services
• Division/Unit: Department of Transportation (DOT)
• Work Shift/Work Hours: Day Shift / 7:00 AM - 3:30 PM
• Days of Work: Monday - Friday
• Travel Required: No
• Salary Range: $40.43 - $69.11 / hourly; $84,417 - $144,301 / annually
• Job Class Option: Data Systems
• Classified Status: Classified
• Bargaining Unit/Union: 214 - Professional Employees (MAPE)

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 (MNIT) who connect Minnesotans to services that will improve their lives in government IT. This position serves our partners at the Minnesota Department of Transportation (MnDOT). MNIT MnDOT supports an agency with technology integrated into all areas of business. From business intelligence and solutions for critical transportation infrastructure to planning and operating a safe, efficient, and reliable multimodal transportation system, the team connects people and markets across Minnesota.

Job Summary

This position serves as the lead worker responsible for coordinating and directing the daily activities of technical staff in data warehouse development, performing advanced Oracle PL/SQL work, managing operational batch processing, and supporting integration of PeopleSoft financial, HR, and procurement data. It provides technical leadership to ensure consistent data warehouse practices, supports established architectural standards, and oversees system integration for MNIT partnering with MnDOT. The role collaborates with system architects to apply standards for data and application integration, including ETL processes and APIs, ensuring alignment with enterprise architecture and MnDOT strategic goals. As a lead for the Data Integration Team, the position guides daily technical work, advises on data warehouse practices, contributes to technology evaluation through research and proof-of-concept efforts, and ensures adherence to established processes and standards.

This position requires an employee to work onsite at 395 John Ireland Blvd., St. Paul , Minnesota at least 50% of the time, with limited telework available. Telework eligibility depends on residence:

Candidates living in Minnesota or within 50 miles of the worksite in a bordering state (Iowa, North Dakota, South Dakota, and Wisconsin) may telework up to 50%.

Minnesota residents living more than 50 miles from the worksite may be eligible to telework more than 50%.

Candidates living 50 miles or more from the worksite in a bordering state are not eligible for hire unless relocating within 50 miles.

Qualifications

Minimum Qualifications

To qualify, candidates must clearly show all of the following qualifications in their resume. Resume tips available here :

Position requires a minimum of five (5) years of IT related experience in large scale Oracle data warehouse system design, development, and data integration.

Experience must include:

Demonstrated experience serving as a lead worker responsible for coordinating daily work, mentoring team members, and ensuring quality and timeliness of deliverables.

Proficiency with complex custom Oracle PL/SQL development using stored procedures, triggers, functions, and packages.

Job scheduling, orchestration, and automation with toolsets such as JAMS.

Data modeling techniques and concepts (Normalized/Denormalized, Conceptual/Logical/Physical, Star, Snowflake) and schema design.

Advanced experience in complex Oracle SQL development, including query optimization, performance tuning, troubleshooting, and comprehensive data validation.

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.

Strongly Preferred Qualifications

Advanced system administration skills in development and implementing database operating system scripts.

Experience with Azure Service Bus Cloud Messaging Service used for messaging between entities.

Preferred Qualifications

Oracle PeopleSoft ERP database design and table logic.

Strong functional knowledge of financial modules - AP, AR, GL, Project Costing, and Billing.

Experience with Azure cloud data integration and data warehousing toolset and platform and Informatica swagger files and pagination.

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
• Other legally required checks

Minnesota IT Services does not participate in the federal E-Verify program. Minnesota IT Services is unable to sponsor applicants for work visas, including F-1 STEM OPT extensions, and cannot complete Form I-9 or any other documentation requiring employer participation in E-Verify. All applicants must be legally authorized to work in the United States at the time of application.

Veterans

To be considered for any Veteran's Status, you MUST indicate this on your application.

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.

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.

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 ITS5/Data Systems 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

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.

Your benefits may include:

• 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
• 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 [e-mail] and let us know the support you need.