Working Title: Senior Data Warehouse Developer
Job Class: Information Technology Specialist 4
Agency: Minnesota IT Services
This position was previously announced on 03/27/2024 through 04/09/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: 04/13/2024
- Closing Date: 04/29/2024
- Hiring Agency/Seniority Unit: Minnesota IT Services
- Division/Unit: Department of Transportation (DOT)
- Work Shift/Work Hours: Day Shift / 07:00 a.m. – 03:30 p.m.
- Days of Work: Monday – Friday
- Travel Required: No
- Salary Range: $34.95 – $57.65 / hourly; $72,975 – $120,373 / annually
- Classified Status: Unclassified
- Bargaining Unit/Union: 214 – MN Assoc of Professional Empl/MAPE
- Anticipated Start Date: 04/15/2024
- End Date: 04/14/2027
- FLSA Status: Exempt – Administrative
- Telework Eligible: Yes, #LI-Hybrid
- Designated in Connect 700 Program for Applicants with Disabilities: No
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,600+ 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
As the Senior Data Warehouse Developer, you will design, develop, and support data warehouses and data lakes using a variety of technologies. You will be responsible for the technical analysis, design, development, testing, and deployment of IT data warehouse solutions as needed by Business or IT. This position works on delivering technology including Oracle PL/SQL Packages, batch processing, JAMS enterprise job scheduler, ETL / API to support downstream sub-systems, data warehouses, and data lakes. It will play a critical role in developing and migrating the data warehouse on-premises and into the Azure environment. The senior data warehouse developer will act as a subject matter expert in PeopleSoft financials, human resources, and procurement foundational data. You will work closely with architects, subject matter experts, other data, and application developers for department-wide integrations. This position will be involved with the most complex and critical systems at MnDOT.
This position 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.
- Candidates residing outside of Minnesota and bordering states (Iowa, North Dakota, South Dakota, or Wisconsin) require additional review prior to telework approval upon becoming a finalist.
- Candidates located in Minnesota, or a bordering state, do not require additional review.
*This position is temporary and includes full state fringe benefits; it is anticipated to last until 04/14/2027.
Qualifications
Minimum Qualifications
Position requires a minimum of four (4) years of IT related experience designing, developing, and supporting data warehouses and data lakes.
Experience must include:
- Expert understanding of financial and accounting data
- Demonstrated proficiency in database design, PL/SQL programming of packages and procedures
- In-depth grasp of Oracle data warehousing principles, relational databases, multidimensional data modeling
- Experience in orchestrating complex data integration workflows, optimizing data transformations, ensuring data quality, and managing end-to-end ETL processes
- Ability to deliver effective verbal or written messages that facilitate a mutual understanding on both parties
- Customer service skills that include active listening, empathy, and problem-solving
A master’s degree in Information Technology or an IT related field substitutes for three (3) years of experience, OR an IT related bachelor’s degree substitutes for two (2) years, OR an IT related associate’s degree substitutes for one (1) year.
Preferred Qualifications
- Expert understanding of PeopleSoft (SWIFT) financials, HR, and procurement database design and table logic
- Experience with Azure cloud data integration and data warehousing toolset and platform
- Experience with JAMS Enterprise Job scheduling, automation, workflow management
- Experience with Informatica Intelligence Cloud Services (IICS) or IDMC (Data Integration / Application Integration)
- Proficiency in designing and deploying cloud based ETL solutions, data integration patterns, and API integration, with expertise in leveraging Azure
- Experience with Quest software’s TOAD database tools
- Experience with Microsoft SQL Server DBMS
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
- 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.
