> Markdown version of [/jobs/ext/3701125-data-warehouse-lead-information-technology-spec-5](https://www.wearedevelopers.com/jobs/ext/3701125-data-warehouse-lead-information-technology-spec-5). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Warehouse Lead - Information Technology Spec 5 - **Company:** State of Minnesota - **Location:** Saint Paul, MN, United States (Remote available) - **Experience:** Expert - **Salary:** $84,094.0 - $143,749.0 - **Contract:** Temporary contract - **Skills:** Application Programming Interfaces (APIs), Application Integration Architecture, Microsoft Azure, Batch Processing, Cloud Computing, Databases, Data Validation, Data Integration, Extract Transform Load (ETL), Data Warehousing, Database Design, Data Intelligence, Job Scheduling, Oracle SQL Developer, Oracle Warehouse Builder, PeopleSoft Customer Relationship Management (CRM), Performance Tuning, Query Optimization, Swagger, SQL Stored Procedures, Systems Integration, Web Services, Azure Service Bus, Snowflake, Information Technology, People Soft, Restful APIs, Pagination - **Published:** October 12, 2026 - **Apply:** https://www.techcareers.com/job.asp?id=3438492547&tx=KR2121FFG&pt=1&aff=0B19D771-A501-4A5E-8338-2A822B784D54&utm_source=Job%20Feed&utm_medium=textkernel&utm_campaign=DE&utm_term=0B19D771-A501-4A5E-8338-2A822B784D54 ## About the Role To qualify, candidates must clearly show all of the following qualifications in their resume. Resume tips available here (https://mn.gov/mnit/about-mnit/careers/hiringprocess.jsp) : 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 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. * Informatica Intelligence Data Management Cloud (IDMC) (Application Integration/Data Integration) development. * Webservice, REST, API, flows/pipelines development expertise. 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. ## Description 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 (https://mn.gov/mmb-stat/policies/1422-telework.pdf) 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., 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 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.