Data Warehouse Developer - ITS3 or ITS4

Data Warehouse Developer - ITS3 or ITS4

21 Oct 2024
Minnesota, Stpaul 00000 Stpaul USA

Data Warehouse Developer - ITS3 or ITS4

Working Title: Data Warehouse DeveloperJob Class: Information Technology Specialist 3 or 4Agency: Minnesota IT Services

Job ID : 81076

Location : St. Paul

Telework Eligible : Yes, #LI - Hybrid

Full/Part Time : Full-Time

Regular/Temporary : Unlimited

Who May Apply : Open to all qualified job seekers

Date Posted : 10/21/2024

Closing Date : 11/04/2024

Hiring Agency/Seniority Unit : Minnesota IT Services

Division/Unit : MMB

Work Shift/Work Hours : Day Shift

Days of Work : Monday - Friday

Travel Required : No

Salary Range: $32.89 - $54.06 / hourly; $68,674 - $112,877 / annually (ITS3); $36.52 - $60.24 / hourly; $75,254 / hourly - $125,781 / annually (ITS4)

Job Class Option : Data Systems

Classified Status : Classified

Bargaining Unit/Union : 214 - MN Assoc of Professional Empl/MAPE

FLSA Status : Exempt - Administrative

Designated in Connect 700 Program for Applicants with Disabilities (https://mn.gov/mmb/careers/diverse-workforce/people-with-disabilities/connect700/) : Yes

The work you'll do is more than just a job.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,600+ professionals of Minnesota IT Services (https://mn.gov/mnit/about-mnit/careers/) (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.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 vacancy is being posted at the Information Technology Specialist 3 and Information Technology Specialist 4 levels. Only one (1) vacancy will be filled, and the classification will be determined by the selected candidate’s qualifications.This position is currently eligible for full-time telework:

Telework (https://mn.gov/mmb-stat/policies/1422-telework.pdf) 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.

Minimum QualificationsCandidates must clearly demonstrate all of the following qualifications in their resume. Resume tip here. (https://mn.gov/mnit/about-mnit/careers/hiringprocess.jsp) :Information Technology Specialist 3Position 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

SQL and Oracle PL/SQL development experience

Report development experience

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 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.Information Technology Specialist 4Position requires a minimum of four (4) 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

SQL and Oracle PL/SQL development experience

Report development experience

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 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

Additional RequirementsThis 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 does not participate in E-Verify. Minnesota IT Services will not sponsor applicants for work visas, including F-1 STEM OPT extensions. All applicants must be legally authorized to work in the United States.AN EQUAL OPPORTUNITY EMPLOYERMinnesota State Colleges and Universities is an Equal Opportunity employer/educator committed to the principles of diversity. We prohibit discrimination against qualified individuals based on their race, sex, color, creed, religion, age, national origin, disability, protected veteran status, marital status, status with regard to public assistance, sexual orientation, gender identity, gender expression, or membership in a local commission as defined by law. As an affirmative action employer, we actively seek and encourage applications from women, minorities, persons with disabilities, and individuals with protected veteran status.Reasonable accommodations will be made 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 . Please indicate what assistance is needed.

Related jobs

Job Details

Jocancy Online Job Portal by jobSearchi.