Director of Data Engineering (Senior Public Service Administrator, Option 1)

Are you looking for a rewarding career with an organization that values their staff? The Department of Innovation & Technology (DoIT) is seeking to hire qualified candidates with the opportunity to work in a dynamic, creative thinking, problem solving environment. This position serves as the Director of Data Engineering for the DoIT supporting the Department of Early Childhood (IDEC) verifying that clean, organized, and timely data is available to downstream users. In this role, you will design, develop, evaluate, and maintain scalable data pipelines and infrastructure to support analytics, reporting, and business intelligence needs. In addition, you will direct, plan, and manage the Data Engineering Section database and infrastructure management programs. This position serves as a full-line supervisor assigning and reviewing work, providing guidance and training to staff, preparing and signing evaluations, and monitoring and reviewing timekeeping requests. If you possess these knowledges, skills, abilities, and experience, we invite you to apply for this position to join the DoIT Team!, * Subject to management approval, serves as the Director of Data Engineering for the Department of Innovation & Technology (DoIT) supporting the Department of Early Childhood (IDEC), verifying that clean, organized, and timely data is available to downstream users, including designing, developing, evaluating, and maintaining scalable data pipelines and infrastructure to support analytics, reporting, and business intelligence needs.

• Directs, plans, and manages DoIT/IDEC Data Engineering Section databases and infrastructure management programs, including collaborating with DoIT and other stakeholders on various projects, using existing cloud-based data platforms (e.g., Amazon Web Services (AWS), Azure, IBM, CloudPad, Google Cloud).
• Directs, plans, and manages agency Data Engineering integration functions, including collaborating with agency executive leadership and DoIT data scientists, analysts, and software engineers to create trusted, high-quality, and scalable data systems.
• Serves as a full-line supervisor.
• Performs other duties as required or assigned which are reasonably within the scope of the duties enumerated above., * Requires compliance with the provisions outlined in section 4A-101 of the Illinois Governmental Ethics Act, necessitating the occupant of this position to file of a Statement of Economic Interest. Pursuant to the Illinois Governmental Ethics Act (5 ILCS 420/4A et seq.), specific state officials and employees are required to annually submit Statements of Economic Interest to the Office of the Secretary of State, which will be accessible to the public for examination and copying. Employees subject to this requirement must also file a Supplemental Statement of Economic Interest with the Executive Ethics Commission, as specified in Executive Order 15-09. Failure to submit these statements in a timely manner may result in fines and penalties.
• The conditions of employment listed are incorporated and/or related to any duties included in the position description., This position is subject to Statement of Economic Interests filing as required by the Illinois Governmental Ethics Act.

• Requires knowledge, skill, and mental development equivalent to completion of four (4) years of college with coursework in business or public administration, data science, data engineering, analytics, or a directly related field.
• Requires prior experience equivalent to four (4) years of progressively responsible administrative experience in public or business organization in data science, data engineering, education policy, statistics, or economics.
• Requires three (3) years of professional supervisory experience in a large organization., * Five (5) years of professional experience designing and developing complex structured and unstructured data architectures and ETL/ELT pipelines using Python, Structured Query Language (SQL), Databricks, and Data Build Tool (DBT), including managing cloud-based platforms (e.g., Amazon Web Services [AWS], Azure, or Google Cloud) and implementing scalable storage and computing solutions that support analytics and downstream users.
• Five (5) years of professional experience overseeing and maintaining enterprise ETL/ELT transformation models, modular DAG workflows, incremental processing strategies, and semantic layer configurations.
• Five (5) years of professional experience applying data modeling, governance, quality assurance, cataloging, and lineage practices, including supporting Batch, Near Time, or Real Time Streaming data processes, including those that leverage built-in Artificial Intelligence (AI)/Machine Learning (ML) models, to maintain data accuracy, consistency, integrity, and compliance with applicable privacy and security requirements.
• Five (5) years of professional experience designing and maintaining data lakes/warehouses (e.g., SQL Server. Databricks, Snowflake, Startburst, BigQuery or Azure Fabric/Synapse).
• Four (4) years of professional experience building normalization and aggregation views in a medallion architecture for consumption in GIS systems, Agency portals, Reports, and interactive dashboards (Including Tableau and PowerBI), that contribute to improving decision-making, transparency, and verifying timely mandated report submissions.
• Four (4) years of professional experience modernizing data infrastructure to automate and improve performance, reliability, efficiency, and cost-effectiveness, including data quality profiling, error handling and alerting, performance monitoring, troubleshooting, and optimizing data workflows and distributed processing.
• Four (4) years of professional experience developing electronic step-by-step procedures for pipelines, architectures, or workflows, including onboarding staff, supporting audits and quality control, and collaborating on privacy training and awareness programs.
• Two (2) years of professional experience leading teams in delivering CI/CD frameworks, including schema design, managing branching strategies, managing incremental strategies, workflow triggers, automated testing, deployment gates, and production change management to support reliable and reproducible data engineering operations.
• Two (2) years of professional experience maintaining compliance in firms with regulatory oversight, with requirements under Family Educational Rights and Privacy Act (FERPA), Health Insurance Portability and Accountability Act (HIPAA), General Data Protection Regulation (GDPR), Children's Online Privacy Protection Act (COPPA), or similar state or federal policies, including implementing encryption, role-based access controls, and breach notification procedures.
• Master's Degree with coursework in one or more of the following: Information Management, Data Science, Data Analytics, Computer Science, Data Engineering, Information Systems, or similar directly related degrees.

Conditions of Employment

NOTE: Applicants must possess the ability to meet ALL of the following conditions of employment, with or without reasonable accommodation, to be considered for this position.

• Requires the ability to verify identity.
• Requires employment authorization to accept permanent full-time position with the State of Illinois.
• Requires the ability to pass a position specific, agency required background check and requires self-disclosure of criminal history.
• Requires a valid driver's license and the ability to travel, including occasional overnight stays.
• Requires the ability to use agency supplied equipment such as laptop, personal computer, work cell phone, etc.
• Requires the ability to work outside of normal hours to meet deadlines.
• Requires the ability to work overtime including scheduled, unscheduled, short notice, evening, weekends, and holidays.
• Requires adherence to the revolving door restrictions outlined in 5 ILCS 430/5-45. Consequently, employees should be aware that in the event of receiving a non-State employment offer during state employment or within one year immediately following the termination of State employment, they are required to inform the Office of the Executive Inspector General for the Agencies (OEIG) of the Illinois Governor before accepting such non-State employment. Failure to notify the OEIG may result in the imposition of a fine.

As a State of Illinois employee, you receive a comprehensive benefits package including:

• Competitive Group Insurance benefits including health, life, dental and vision plans.
• Flexible work schedules (when available and dependent upon position).
• 10 -25 days of paid vacation time annually (10 days for first year of state employment).
• 12 days of paid sick time annually which carry over year to year.
• 3 paid personal business days per year.
• 13-14 paid holidays per year dependent on election years.
• 12 weeks of paid parental leave.
• Pension plan through the State Employees Retirement System.
• Deferred Compensation Program - voluntary supplemental retirement plan.
• Optional pre-tax programs -Medical Care Assistance Plan (MCAP) & Dependent Care Assistant Plan (DCAP).
• Tuition Reimbursement Program and Federal Public Service Loan Forgiveness Program eligibility.

For more information regarding State of Illinois Benefits follow this link: https://www2.illinois.gov/cms/benefits/Pages/default.aspx

Why Work for Illinois?

Working with the State of Illinois is a testament to the values of compassion, equity, and dedication that define our state. Whether you're helping to improve schools, protect our natural resources, or support families in need, you're part of something bigger-something that touches the lives of every person who calls Illinois home.

No matter what state career you're looking for, we offer jobs that fit your life and your schedule-flexible jobs that provide the gold standard of benefits. Our employees can take advantage of various avenues to advance their careers and realize their dreams. Our top-tier benefits and great retirement packages can help you build a rewarding career and lasting future with the State of Illinois.

The Department of Innovation & Technology (DolT) is the state's IT agency delivering an enterprise approach to statewide technology, innovation, and telecommunication services, as well as policy and standards development, lifecycle investment planning, and cybersecurity services. With over 1,500 employees, DolT delivers IT services and innovative solutions to customer agencies to improve services provided to Illinois residents, DolT offers employees the opportunity to advance their careers, develop new skills and reach their potential, both personally and professionally. DoIT is committed to promoting and preserving a workplace culture that embraces diversity and inclusion. We welcome and value employees with different backgrounds, life experiences and talents. It is the collective sum of our individual differences that provides a broad perspective, leading to greater innovation and achievement. In recruiting for our team, we recognize the unique contributions of