You are viewing a preview of this job. Log in or register to view more details about this job.

SENIOR DATA WAREHOUSE DEVELOPER (TECHNICAL MANAGER IV) - REQ#41855

Illinois Department of Transportation *
Email

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 & Mathematicsand Vaticinate for data analysis

If you meet the qualifications for this position, please follow the link and apply today! https://illinois.jobs2web.com/job/Springfield-SENIOR-DATA-WAREHOUSE-DEVELOPER-%28TECHNICAL-MANAGER-IV%29-IL-62764/1220002400/

 

*If you have questions about the Job Responsibilities or Qualifications, please reach out to the Agency Contact listed above

*If you have questions about the application process, please reach out to DOT.Recruitment@Illinois.gov