Apply »

SENIOR DATA WAREHOUSE DEVELOPER (TECHNICAL MANAGER IV)

We continually strive for a workforce that reflects the growing diversity within the State of Illinois. A variety of employee backgrounds, perspectives, ideas and experiences are crucial to our ability to most effectively serve the public. Bilingual skills welcome

Reasonable Accommodation Statement

The State of Illinois is committed to working with and providing reasonable accommodations to people with disabilities. Further, federal law requires employers to provide reasonable accommodation to qualified individuals with disabilities. Please tell us if you require a reasonable accommodation to apply for a job, interview for a job, or for any other activity related to the hiring process. Examples of reasonable accommodation include, but are not limited to, making a change to the application process (if possible), providing documents in an alternate format, using a sign language interpreter, or using specialized equipment.

To be provided a Reasonable Accommodation during the hiring process, you will need to provide a certification of disability from a physician, psychiatrist, school official or an Illinois Department of Human Services (DHS) Division of Rehabilitation Services (DRS) Vocational Rehabilitation (VR) Counselor. Supporting documentation should be uploaded under My Documents → Additional Documents section for each application.

Any questions on Reasonable Accommodations can be directed to Central Management Services Disability Resource Center at CMS.DisabilityResCen@illinois.gov or call (217) 524-7514 for further information and to request or discuss an accommodation.

Sponsorship for Employment

The State of Illinois does not provide sponsorship for employment visa status (e.g. H-1B visa status). To be considered for permanent employment with the State of Illinois, applicants must be currently authorized to work in the United States on a full-time basis.

Disclosure of Salary Information

In compliance with the Illinois Equal Pay Act, 820 ILCS 112/1 et seq., the State does not seek, request, or require a job applicant’s wage or salary history.  Employment decisions are not made based on an applicant’s wage or salary history.  To that end, please do not include wage or salary information in your resume or other profile or application materials.
Date:  Oct 4, 2024
Location: 

Springfield, IL, US, 62764

Job Requisition ID:  41855

Agency: Department of Transportation

Position Title: Technical Manager IV
Closing Date/Time: 10/21/2024
Salary: Anticipated Starting Salary $5,432 Monthly; Full Range $5,432 - $9,713 Monthly  
Job Type: Salaried
Category: Full Time
County: Sangamon
Number of Vacancies: 1

Plan/BU: NR916 Pro-Tech Teamsters

 

This position is a union position; therefore, provisions of the relevant collective bargaining agreement/labor contract apply to the filling of this position.

 

All applicants who want to be considered for this position MUST apply electronically through the illinois.jobs2web.com website. State of Illinois employees should click the link near the top left to apply through the SuccessFactors employee career portal.

 

Applications submitted via email or any paper manner (mail, fax, hand delivery) will not be considered.

 

Posting Identification Number  41855 - IPR# 47336

Position Overview

Under the direct supervision of the Information Technology (IT) Security and Data Manager, this position performs highly technical analysis, development, support, enhancement, and documentation of data warehouse applications and data mart user interfaces.  The incumbent is responsible for working with legacy applications developed in a mainframe environment, developing data extraction models, and transforming them to data warehouse objects while providing ongoing maintenance and support of Sequel (SQL) Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), analysis services, and SQL department-wide systems used in enterprise operations.

Essential Functions

  • Provides analysis, development, and support of data warehouse systems and models using SSRS, SSIS, Power BI, and SQL department-wide systems used in enterprise operations and investigates project requests or mandated system changes from external policy groups.
  • Investigates project requests or mandated system changes from external policy groups.
  • Maintains contact with stakeholders and end-users of assigned enterprise production systems to ensure that the technology environment and application system meet their functional needs.
  • Acts as a subject-matter expert on supported systems.
  • Produces extract, transform, and load (ETL) design guidelines to ensure a manageable infrastructure for data marts and business intelligence systems.
  • Evaluates database and data warehouse components including hardware, relational database management systems, ETL software, metadata management tools, and database design solutions.
  • Analyzes and implements cost-effective technology solutions for management problems.
  • Serves as a project team member on scoping, developing, and upgrading existing systems using data warehouse or SQL tools.
  • Provides informational materials and curriculum concerning enhancements and/or changes to development projects for sponsors, stakeholders, and end-user staff and evaluates new software for applicability and value to the department.
  • Evaluates new technology application software for enterprise applicability and value to the department.
  • Performs duties in compliance with departmental safety rules. Performs all duties in a manner conducive to the fair and equitable treatment of all employees.
  • Performs other duties as assigned.

Minimum Qualifications

  • Completion of a bachelor's degree majoring in computer science, computer information systems, computer networking, or database management plus two years of experience with data warehousing and database architecture, OR
  • Eight years of experience with data warehousing and database architecture.

Preferred Qualifications

  • Proficiency utilizing various software including SQL, SSRS, SSIS, Analysis Services, Power BI, and other Microsoft analytical tools.
  • Proficiency utilizing data warehouse ETL and business intelligence systems.
  • Proficiency using the Microsoft Office Suite including SharePoint.
  • Experience with Microsoft development tools
  • Experience with mainframe environments such as IMS/MVS and COBOL
  • Proficient in at least one programming language
  • Ability to communicate effectively both verbally and in writing

Conditions of Employment

  • The conditions of employment listed here are incorporated and related to any of the job duties as listed in the job description.
  • Occasional statewide travel which may include overnight stays to attend meetings and/or training sessions.
  • Valid driver's license.
  • Successful completion of a background screening.

About the Agency

 

The Illinois Department of Transportation is seeking to hire a Senior Data Warehouse Developer.

 

The IDOT team works diligently to provide safe, cost-effective transportation for Illinois in ways that enhance quality of life, promote economic prosperity, and protect our environment. We are problem solvers and leaders, constantly searching for innovations and improvements in support of our commitment to providing the best multimodal transportation system for Illinois.

 

Our team fosters a culture of inclusivity. We value diversity and hold ourselves to the highest ethical standards as we work together for a common purpose. Team members frequently collaborate with colleagues and others outside the department to best meet customer needs. 

 

The department offers extensive training and career advancement opportunities. Employees also receive a robust benefit package including:

  • Monday-Friday work schedule
  • Flexible work schedules in several program areas (flexible time, hybrid scheduling)
  • Health, Life, Vision, and Dental Insurance
  • Pension Plan
  • (12) Weeks paid Maternity/Paternity Leave
  • Deferred Compensation Program and other pre-tax benefit programs (Medical/Daycare)
  • Employees earn (12) paid Sick Days annually
  • New Employees earn (10) paid Vacation Days their first year of service and can earn up to (25) paid Vacation Days annually
  • Employees earn (3) paid Personal Days annually
  • (13-14) paid holidays annually (based on start date)
  • Tuition Reimbursement
  • Employee Assistance Program and/or mental health resources

 

We invite qualified applicants to apply to become part of our team. We are confident that you will take pride in serving Illinois and its residents and visitors.

 

Work Hours: 8:00 am - 4:30 pm Monday-Friday

Work Location: 2300 S Dirksen Pkwy Springfield, IL 62764-0001

Office: Office of Finance and Administration/Bureau of Information Processing

Agency Contact: DOT.CONTACTHR@ILLINOIS.GOV

Posting Group: Transportation ; Science, Technology, Engineering & Mathematics

 

APPLICATION INSTRUCTIONS

Use the “Apply” button at the top right or bottom right of this posting to begin the application process.

If you are not already signed in, you will be prompted to do so. 

State employees should sign in to the career portal for State of Illinois employees – a link is available at the top left of the Illinois.jobs2web.com homepage in the blue ribbon. 

Non-State employees should log in on the using the “View Profile” link in the top right of the Illinois.jobs2web.com homepage in the blue ribbon.  If you have never before signed in, you will be prompted to create an account.

If you have questions about how to apply, please see the following resources:

State employees: Log in to the career portal for State employees and review the Internal Candidate Application Job Aid

Non-State employees: on Illinois.jobs2web.com – click “Application Procedures” in the footer of every page of the website.

 

Seasonal and temporary workers should use a personal e-mail address when applying for jobs.

 

The main form of communication will be through email. Please check your “junk mail”, “spam”, or “other” folder for communication(s) regarding any submitted application(s). You may receive emails from the following addresses:

  • donotreply@SIL-P1.ns2cloud.com
  • systems@SIL-P1.ns2cloud.com


Nearest Major Market: Springfield

Apply »