Data Warehouse Lead - Information Technology Spec

• Job
• Job Class:
  Information Technology Specialist 5
• Agency:
  Minnesota IT Services
• 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/2026
• Closing Date: 10/16/2026
• Hiring Agency/Seniority Unit:
  Minnesota IT Services
• Division/Unit:
  Department of Transportation (Use the "Apply for this Job" box below). 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)
• FLSA Status:
  Exempt
  - Professional
• 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 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.

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 People Soft 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.

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.
• 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…