Data Warehouse Manager

Salary: $91,312.00 - $112,665.28 Annually

Location : Waukegan, IL

Job Type: Full-Time

Remote Employment: Flexible/Hybrid

Job Number: 16521

Department: Health Department

Opening Date: 10/25/2024

General Description

The Data Warehouse Manager is responsible for ensuring the efficient and effective management of data processes, integration, and delivery to support the organization's data strategy. This role will oversee the development, implementation, and maintenance of data systems and processes, ensuring data quality, accessibility, and security.

To be successful in this role, we are looking for someone who can:

• Lead, mentor, and manage a team of data engineers, integration engineers, and data analysts.
• Act as a liaison between data services and other departments to ensure alignment and support for data initiatives.
• Promote a data-driven culture within the organization.

Scheduled Hours: 40 hours a week

• Hybrid: 2 days remote / 3 days on-site.

Essential Functions

• Set performance goals, provide regular feedback, and support professional development of team members.
• Foster a collaborative and innovative team environment.
• Develop and implement data management strategies that align with organizational goals.
• Oversee the design, development, and maintenance of data systems and infrastructure.
• Ensure data quality, integrity, and security across all data processes.
• Supervise the integration of data from various sources, ensuring seamless data flow and interoperability.
• Manage the ETL (Extract, Transform, Load) processes to support data warehousing and analytics.
• Collaborate with staff and other departments to ensure data systems are integrated with existing infrastructure.
• Oversee the delivery of data reports, dashboards, and visualizations to stakeholders.
• Ensure data delivery solutions meet user needs and enhance data accessibility and understanding.
• Monitor and optimize data delivery processes for efficiency and effectiveness.
• Plan and manage data-related projects, ensuring they are completed on time, within scope, and within budget.
• Coordinate with stakeholders to gather requirements, define project goals, and ensure alignment with organizational priorities.
• Develop and maintain project documentation and status reports.
• Communicate effectively with stakeholders to understand their data needs and provide appropriate solutions.

Knowledge Skills Abilities and Education Required

• Bachelor's degree in Computer Science, Information Technology, Data Science, or a related field. Master's degree preferred.
• Proven progressive experience in data management, data engineering, or a related field, with a minimum of 5 years in a leadership or managerial role.
• Strong understanding of data integration, ETL processes, data warehousing, and data quality management.
• Proficiency in data management and visualization tools (e.g., SQL, Python, Tableau, PowerBI).
• Excellent project management skills with the ability to lead and execute complex data projects.
• Strong communication and collaboration skills.
• Knowledge of healthcare regulations and data privacy (e.g., HIPAA) is highly desirable.
• Proven experience with data visualization tools (Tableau, PowerBI) and data delivery methods (spreadsheet, API).
• Strong understanding of user experience principles.
• Excellent leadership and team management skills.
• Strong analytical and problem-solving skills.
• Ability to establish and maintain effective working relationships with others.

Supplemental Information

As the largest human service provider in Lake County, we believe that services must be available without barriers. No residents are turned away due to the inability to pay. We believe in providing services in an environment of mutual respect, free of discrimination or bias. Whether assuring accessible and effective care, impacting policy, or assessing and monitoring risks, the Lake County Health Department and Community Health Center has been an essential part of the public health system in Lake County for 60 years. We are looking for passionate, qualified team members who can help make a difference in our agency and, most importantly, in our community.

Additional information about the Lake County Health Department, our culture, and why you should join our team can be found at

Currently, you must reside in Illinois or Wisconsin to work for the Lake County Health Department. Any offer of employment is conditioned on the successful completion of a background screening, drug and alcohol testing and may include a pre-employment medical exam.

The Lake County Health Department and Community Health Center is an Equal Opportunity Employer. We evaluate qualified applicants without regard to race, color, religion, sexual orientation, gender identity or gender expression, national origin, disability, veteran status, and other protected characteristics.

Here at the Health Department, we are proud to employ a diverse workforce of dedicated individuals focused on promoting the health and well-being of all who live, work, and play in Lake County. We are committed to cultivating an inclusive culture that values diversity of thought and collaboration, enabling each employee to perform at their maximum potential and to more effectively work with clients, patients, and employees. We offer:

• Comprehensive Benefits package (medical, dental, vision, etc.) for full-time employees
• Paid Time Off to support work-life balance
• IMRF Pension and 457 retirement plans
• Paid Parental Leave
• Tuition Reimbursement

You can find more details on our benefits on our website at

01

Explain your experience in data management and/or data engineering.

02

Describe (in detail) your supervisory experience. Explain how many employees you have supervised and the nature of the roles.

03

Please share why you are interested in working for this program and how your experience directly relates to this opening.

04

What are your benefits and salary expectations?

Required Question