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 : [email protected]
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 :
- [email protected]
- [email protected]
Data Center Contracts Integration Senior Program Manager
This role conducts data center assessments, and facilitates comprehensive OCI data center assessment tracking, data capture, and analytics, to investigate, interpret and summarize data center health trends and root cause. It’s why we’re committed to expanding our inclusive workforce that promotes di...
Mcsap Compliance Officer (technical Manager Iv)
Works with unit managers to meet the Bureau of Investigations and Compliance’s goals and objectives set forth by the Federal Commercial Vehicle Safety Plan. Working knowledge of evidence within a civil administrative process. This position is a union position; therefore, provisions of the relevant c...
Senior Manager of Technical Support - Remote
The Senior Manager of Technical Support will lead and provide technical vision and strategy for Technical Support and Services. The Senior Manager will oversee a team of global technical Support Engineers who interface directly with our Enterprise (Commercial, Government, K12) customers via live cha...
Roadside Maintenance Resource Specialist (technical Manager Iv)
This position is accountable for the design, technical expertise, and interagency coordination of roadway landscape features and activities to ensure safety, compatibility, aesthetics, and preservation of natural resources and department assets within the highway system. This position is a union pos...
Senior Project Manager IV (E4)
Senior Project Manager IV (E4). The senior technical project manager is responsible for successful execution of Applied Materials’ Automation Product Group’s deployments. A successful candidate will have experience managing large technical projects involving all or multiple applications in the CIM e...
Rules Manager (technical Manager Iv)
This position ensures policies implemented by the department are in compliance with the Illinois Administrative Procedure Act (IAPA) and the Joint Committee on Administrative Rules (JCAR). Maintains a comprehensive index of subpoenas received, status of responses, and other information necessary to ...
Senior Technical Program Manager
Senior Technical Program Manager Responsibilities Key responsibility includes connecting business objectives with the execution of complex technical projects ( like building or enhancing new technical capabilities, integration and data migration) by partnering with engineers to establish technology ...
Senior Application Developer - Data Integration Services
Actively takes a leading role and participates on project teams in various project roles, including, but not limited to, Developer, Technical Lead and Project Manager, based upon level of experience. Highmark Health and its affiliates prohibit discrimination against qualified individuals based on th...
Senior Data Analyst
A Leading Health & Welling franchise is looking for a data analyst who will play a crucial role in turning data into actionable insights that shape our business strategies. Ensure data integrity and accuracy by performing regular data audits and cleansing. Are you excited by data-driven solutions th...
Mainframe Senior Software Developer
Mainframe Senior Software Developer. We are seeking a highly experienced Mainframe Senior Software Developer to join our team. Experience in mentoring junior developers. ...