Metropolitan Family Services empowers families to learn, to earn, to heal, to thrive.
Part mentor, part motivator, part advocate, since 1857, Metropolitan Family Services (MFS) has been the engine of change that empowers families to reach their greatest potential and positively impact their communities.
Metropolitan is Illinois first comprehensive human services agency and reaches more than 122,900 individuals and families in Chicago, Evanston/Skokie, the southwest suburbs and DuPage County with services promoting education, economic stability, emotional wellness and empowerment.
We are now hiring for a full-time Data Warehouse Manager to join our Headquarters Team ESSENTIAL JOB FUNCTIONS: Work closely with existing data warehouse team and stakeholders to understand business requirements and to translate these requirements into high-quality data solutions using existing standards and conventions.
Hands-on oversight and mentorship of ETL developer and DBA.
Build upon existing monitoring of enterprise data quality.
Develop and execute data quality rules (i.e.
completeness, validity, and timeliness) used in monitoring dashboards.
Provides ongoing efforts to ensure that data is accessible, reliable, and used appropriately.
Analyze emerging needs around risk, regulatory, and compliance initiatives through data management policies.
Maintain documentation for master data dictionary; this is critical for data consumers to have a clear understanding of data elements, source systems, and appropriate use.
Other duties as assigned.
QUALIFICATIONS: Bachelors degree in the related field required .
Masters degree preferred.
Three years of Data Management experience required .
Expertise with ETL and major DBMS platforms, specifically MS SQL and MySQL required.
Familiarity with Master Data Management (MDM) processes preferred.
Experience with cloud databases (i.e.
Salesforce) preferred.
Hands-on, applied experience with Enterprise Data Management Policy/Standards preferred.
Highly motivated, proactive and a self-starter; strong sense of ownership & ability to create and execute plans without daily oversight.
Ability to work across multiple teams and to manage multiple priorities.
Highly organized; able to effectively prioritize and balance multiple efforts in a fast-paced, regulatory driven environment; detail oriented.
Ability to decompose complex issues and drive timely decisions, knowing when to engage others for additional input, and when to act independently.
Excellent verbal and written communication skills; ability to simplify and summarize complex topics.
Ability to enforce policy decisions.
Ability to lead and to influence stakeholders across multiple levels and organizations.
PHYSICAL DEMANDS: While performing the essential duties of this job, the employee is required to sit and stand for sustained periods of time, frequently talk, hear, use hands and fingers to feel, handle and operate objects or controls, and occasionally stand, bend, stretch, stoop, kneel and crouch.
The employee is required to have close visual acuity to perform an activity such as preparing and analyzing data and figures, transcribing and viewing a computer terminal.
The employee may occasionally lift and/or move up to 25 pounds.
SALARY: Compensation is commensurate with years of related experience, position requirements, and candidate qualifications.
The average salary for the position is $90,000 Metropolitan Family Services offers a very generous benefits packet to our professionals: Blue Cross and Blue Shield Medical Coverage: HMO, Traditional PPO, or PPO w/ HSA contributions.
Dental and Vision Insurance Options 12 paid Holidays Paid Time Off (PTO) 401K Plan Training and Professional Development Plan with E- Learning Wellness Initiative Program Employee Assistance Network Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant.
However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information.
41 CFR 60-1.35(c)