Data Warehouse Developer | Minnestar

Minnesota IT Services

Working Title: Data Warehouse Developer
Job Class: Information Technology Specialist 3
Agency: Minnesota IT Services


*This position was previously announced on 2/21/2024.  If you had previously applied for this job, you do not need to reapply. 

  • Who May Apply: Open to all qualified job seekers
  • Date Posted: 03/28/2024
  • Closing Date: 04/10/2024
  • Hiring Agency/Seniority Unit: Minnesota IT Services
  • Division/Unit: Minnesota Management and Budget
  • Work Shift/Work Hours: Day
  • Days of Work: Monday – Friday
  • Travel Required: No
  • Salary Range: $31.47 – $51.73 / hourly; $65,709 – $108,012 / annually
  • Job Class Option:  Data Systems
  • Classified Status: Classified
  • Bargaining Unit/Union: 214 – MN Assoc of Professional empl/MAPE
  • FLSA Status:  Exempt – Professional
  • Telework Eligible: Yes #LI-Hybrid
  • Designated in Connect 700 Program for Applicants with Disabilities: Yes

Make a difference in the lives of Minnesotans.

The work you’ll do is more than just a job. Join the talented, engaged and inclusive workforce dedicated to creating a better Minnesota.

Join the 2,500+ professionals of Minnesota IT Services (MNIT) who connect Minnesotans to services that will improve their lives.  This position serves our partners at Minnesota Management and Budget (MMB). MNIT MMB supports critical business operations for the State of Minnesota, including enterprise human resources and payroll, state employee insurance, and benefits administration. The team also provides the technical expertise necessary to manage the state budget and provide economic forecasts to policymakers.

Job Summary

This position will function as developers in an area of Data Warehousing/Business Intelligence. The position will be responsible for analysis, design, development, and implementation of the staging and multi-dimensional warehouse.  Including support and maintenance of the EPM Data Warehouse, applications, and business intelligence modules.

This positions is currently eligible for full-time telework:

  • Telework for Minnesota IT Services allows an employee to perform work from a telework location and an employee may be required to be in the office based on business needs and other dependencies in St. Paul, Minnesota.
  • Only candidates located in Minnesota and bordering states (Iowa, North Dakota, South Dakota, or Wisconsin) are telework eligible.


Minimum Qualifications

Candidates must clearly demonstrate all of the following qualifications in their resume:

Position requires a minimum of three (3) years of experience of analysis, design, development, and implementation in data warehousing/business intelligence.

Experience must include:

  • Extract, transform, and load (ETL) development experience using IBM DataStage, Informatica, or Oracle Data Integrator (ODI)
  • SQL and Oracle PL/SQL development experience
  • Report development experience

A Master’s degree in Information Technology or a related field may substitute for three years of experience, OR a related Bachelor’s degree may substitute for two years, OR a related Associate’s may substitute for one year.

Preferred Qualifications

  • Experience with Oracle Business Intelligence Enterprise Edition (OBIEE)
  • Experience with Oracle BI Publisher
  • Experience with Activity Diagrams and Process Modeling
  • Experience gathering business requirements
  • Experience creating and testing design specifications
  • Knowledge of batch scheduling tools, i.e., Automic, Control-M, etc.
  • Knowledge of PeopleSoft Human Resources and Finance modules or data
  • Customer Service experience responding to requests in an appropriate and professional manner
  • Ability to communicate clearly, present complex information to users in a comprehensive style, and translate technical and system information for non-technical stakeholders

Additional Requirements

This position is based in St. Paul, Minnesota. This position will require the employee to be in the office based on business needs and other dependencies.

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 will not sponsor applicants for work visas. All applicants must be legally authorized to work in the United States.

Job Type: Full-time
Compensation: $31.47 - $51.73 / hourly - $65,709 - $108,012 / annually
Compensation Type: Salaried
Location: St Paul, MN - Telework
Posted by Karla Larson on March 29, 2024