Metropolitan Family Services
Data Warehouse Manager
Metropolitan Family Services, Chicago, Illinois, United States, 60290
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:
Bachelor's degree in the related field
required . Master's 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,000Metropolitan 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 Options12 paid HolidaysPaid Time Off (PTO)401K PlanTraining and Professional Development Plan with E- LearningWellness Initiative ProgramEmployee 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)
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:
Bachelor's degree in the related field
required . Master's 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,000Metropolitan 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 Options12 paid HolidaysPaid Time Off (PTO)401K PlanTraining and Professional Development Plan with E- LearningWellness Initiative ProgramEmployee 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)