Address
Form of work Logo
Job Details
Working Title: Data Warehouse Developer
Job Class: Information Technology Specialist 3
Agency: Minnesota IT Services
This position was previously announced on 12/05/2023. If you had previously applied for this job, you do not need to reapply.
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 a developer in an area of Data Warehousing/Business Intelligence. This 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 position is currently eligible for full-time telework:
Qualifications
Minimum Qualifications
Candidates must clearly demonstrate all of the following qualifications in their resume:
Position requires a minimum of three (3) years of experienceof analysis, design, development, and implementation in data warehousing/business intelligence.
Experience must include:
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
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:
Minnesota IT Services will not sponsor applicants for work visas. All applicants must be legally authorized to work in the United States.
Application Details
How to Apply
Select "Apply for Job" at the top of this page. If you have questions about applying for jobs, contact the job information line at 651-259-3637 or email careers@state.mn.us . For additional information about the application process, go to http://www.mn.gov/careers .
If you have questions about the position, contact Shanna Vah at shanna.vah@state.mn.us
Connect 700 Program
To receive consideration as a Connect 700 Program applicant, apply online, email the Job ID#, the Working Title and your valid Proof of Eligibility Certificate by the closing date to shanna.vah@state.mn.us
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:
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:
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.
Why Work for Us
Diverse Workforce
We are committed to continually developing a workforce that reflects the diversity of our state and the populations we serve. The varied experiences and perspectives of employees strengthen the work we do together and our ability to best serve the people of Minnesota.
A recent engagement survey of State of Minnesota employees found:
Comprehensive Benefits
Our benefits aim to balance four key elements that make life and work meaningful: health and wellness, financial well-being, professional development, and work/life harmony. As an employee, your benefits may include:
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.
AN EQUAL OPPORTUNITY EMPLOYER
Minnesota state agencies are equal opportunity, affirmative action, and veteran-friendly employers. The State of Minnesota recognizes that a diverse workforce is essential and strongly encourages qualified women, minorities, individuals with disabilities, and veterans to apply.
We will make reasonable accommodations to all qualified applicants with disabilities. If you are an individual with a disability who needs assistance or cannot access the online job application system, please contact the job information line at 651-259-3637 or email careers@state.mn.us and indicate what assistance is needed.
Job Details
Working Title: Data Warehouse Developer
Job Class: Information Technology Specialist 3
Agency: Minnesota IT Services
This position was previously announced on 12/05/2023. 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: 12/29/2023
- Closing Date: 01/08/2024
- Hiring Agency/Seniority Unit: Minnesota IT Services
- Division/Unit: Minnesota Management and Budget
- Work Shift/Work Hours: Day Shift
- 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 a developer in an area of Data Warehousing/Business Intelligence. This 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 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 in St. Paul, Minnesota.
- Only candidates located in Minnesota and bordering states (Iowa, North Dakota, South Dakota, or Wisconsin) are telework eligible.
Qualifications
Minimum Qualifications
Candidates must clearly demonstrate all of the following qualifications in their resume:
Position requires a minimum of three (3) years of experienceof analysis, design, development, and implementation in data warehousing/business intelligence.
Experience must include:
- Extract, transform, and load (ETL) development experience using IBM DataStage
- 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.
Application Details
How to Apply
Select "Apply for Job" at the top of this page. If you have questions about applying for jobs, contact the job information line at 651-259-3637 or email careers@state.mn.us . For additional information about the application process, go to http://www.mn.gov/careers .
If you have questions about the position, contact Shanna Vah at shanna.vah@state.mn.us
Connect 700 Program
To receive consideration as a Connect 700 Program applicant, apply online, email the Job ID#, the Working Title and your valid Proof of Eligibility Certificate by the closing date to shanna.vah@state.mn.us
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.
- Meet all of the RSV criteria.
- Submit a copy of your DD-214 form by the closing date to: MNIT.Recruitment@state.mn.us .
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.
- You must submit all documentation by the closing date to: MNIT.Recruitment@state.mn.us .
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.
Why Work for Us
Diverse Workforce
We are committed to continually developing a workforce that reflects the diversity of our state and the populations we serve. The varied experiences and perspectives of employees strengthen the work we do together and our ability to best serve the people of Minnesota.
A recent engagement survey of State of Minnesota employees found:
- 95% of employees understand how their work helps achieve their agency's mission
- 91% of employees feel trusted to do their jobs
- 88% of employees feel equipped to look at situations from other cultural perspectives when doing their job
- 87% of employees report flexibility in their work schedule
Comprehensive Benefits
Our benefits aim to balance four key elements that make life and work meaningful: health and wellness, financial well-being, professional development, and work/life harmony. As an employee, your benefits may include:
- Public pension plan
- Training and professional development
- Paid vacation and sick leave
- 12paid holidays each year
- Paid parental leave
- Low-cost medical and dental coverage
- Prescription drug coverage
- Vision coverage
- Wellness programs and resources
- Employer paid life insurance
- Short-term and long-term disability
- Health care spending and savings accounts
- Dependent care spending account
- Tax-deferred compensation
- Employee Assistance Program (EAP)
- Tuition reimbursement
- Federal Public Service Student Loan Forgiveness Program
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.
AN EQUAL OPPORTUNITY EMPLOYER
Minnesota state agencies are equal opportunity, affirmative action, and veteran-friendly employers. The State of Minnesota recognizes that a diverse workforce is essential and strongly encourages qualified women, minorities, individuals with disabilities, and veterans to apply.
We will make reasonable accommodations to all qualified applicants with disabilities. If you are an individual with a disability who needs assistance or cannot access the online job application system, please contact the job information line at 651-259-3637 or email careers@state.mn.us and indicate what assistance is needed.
