Senior data warehouse developer technical manager Job at Illinois Department of Transportation, Springfield, IL

YWtIdzB3UE5DUmtuWTBQSXYrMExVWXN3M3c9PQ==
  • Illinois Department of Transportation
  • Springfield, IL

Job Description

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!

*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

Job Type: Full-time

Pay: $5,432.00 - $9,713.00 per month

Benefits:

  • 401(k)
  • 401(k) matching
  • Dental insurance
  • Employee assistance program
  • Flexible schedule
  • Flexible spending account
  • Health insurance
  • Health savings account
  • Life insurance
  • Paid time off
  • Parental leave
  • Professional development assistance
  • Referral program
  • Relocation assistance
  • Retirement plan
  • Tuition reimbursement
  • Vision insurance

Schedule:

  • Monday to Friday

Work Location: Hybrid remote in Springfield, IL 62764

Job Tags

Holiday work, Full time, Contract work, Remote job, Relocation package, Flexible hours, Night shift, Monday to Friday,

Similar Jobs

Hidden Talent Bee

Female Model Job at Hidden Talent Bee

About Us: Hidden Talent Bee is a premier agency specializing in adult modeling, dedicated to celebrating and showcasing diverse and bold forms of expression. We are a dynamic team passionate about pushing boundaries and redefining beauty standards in the adult industry... 

Shanghai junxuan Human Resources Co., Ltd

English teacher online Job at Shanghai junxuan Human Resources Co., Ltd

ASAP! Online English teachingThe class size is 1 Chinese student between the ages of 5-12. Classes are 28 minutes long and count as a half-hour lesson with regards to coach salary. The class time would be in North American mornings before traditional work hours. Coaches... 

Seeking Alpha

Senior UX/UI Designer Job at Seeking Alpha

 ...passionate about fostering a flexible, balanced environment with remote work options and an array of perks that make a real difference...  ...We're Looking For Seeking Alpha is looking for a talented UX/UI Designer to become an integral part of our Product Design team. This... 

SGS

International Solution Manager Job at SGS

 ...and more interconnected world. Job Description The International Sales Managers (ISM) main objective is to sell SGSs Business...  ...Manage customer expectations and contributes to a high level of customer satisfaction Monitor customer, market and competitor... 

University of Alaska Fairbanks

Art Model (Nude and Clothed) Job at University of Alaska Fairbanks

 ...The UAA College of Arts & Sciences, Department of Art, is recruiting for both clothed and nude art models for the 2024-2025 Academic Year. All shapes and sizes are encouraged to apply! Please indicate in your application which type of sessions you wish to be considered...