Job Description
Job Description
If asked to describe the culture at Metropolitan Family Services, we could do that in one word. COMMUNITY ! Reflected in both our internal culture as well as through the services we provide, community is at the heart of all we do.
Metropolitan Family Services (MFS) empowers families to learn, to earn, to heal, to thrive. Part mentor, part motivator, part advocate, since 1857, Metropolitan Family Services has been the engine of change that empowers families to reach their greatest potential and positively impact their communities. Are you looking to have an impact on more than just a company’s bottom line? Then we’d love to hear from you!
We are currently looking to fill an ETL Developer role at our Headquarters office.
SALARY :
- The average starting salary for this position will fall in the range of $70,000 and $75,000 annually. Where candidates fall in this range will be based on skill and experience level.
ESSENTIAL JOB FUNCTIONS :
Design, develop, and maintain ETL processes to extract, transform, and load data from multiple sources into staging tables, data warehouses, and data marts.Collect and extract data from various sources, including databases, applications, external systems, cloud platforms, APIs, and streaming data sources as requiredfor data ingestion.
Work closely with the data warehouse and business intelligence team members as well as end users to understand data needs and business requirements anddeliver effective and scalable ETL solutions.
Lead the development of logical and physical data models for data warehouses and data marts, based on best practices and in collaboration with the datawarehouse and BI team members.
Implement data quality checks, error handling, and monitoring processes to ensure accuracy and maintain data integrity throughout the ETL process.Assist in making decisions regarding tool selection to support ETL processes, increasing data quality and performance.Optimize ETL processes and SQL queries, data transformations, and workflows for high performance, scalability, and efficiency.Troubleshoot and resolve ETL job failures and address any data-related issues or bottlenecks that may arise.Develop and maintain clear documentation related to ETL processes, job scheduling data sources, data mapping, and transformations for future referenceand compliance.
Develop and maintain metadata repositories, data dictionaries, and documentation of the data warehouse / data mart architecture.Other duties as assigned.KNOWLEDGE, SKILLS, and ABILITIES :
Strong proficiency in writing SQL queries for major RDBMS platforms, including especially MS SQL and or MySQL.Proficient in consuming and processing data from web services / calling REST APIs.Excellent problem-solving skills and attention to details.Strong communication and collaboration skills to work across technical and business teams.QUALIFICATIONS :
Bachelor’s degree in computer science, Information Systems, or related field from an accredited college or university required.
2+ years of relevant ETL experience required.Master’s degree in computer science, information systems, or related field from an accredited college or university preferred.Hands-on data modeling experience, including the previous development of data marts and / or working with a data warehouse preferred.Hands-on experience with data warehousing concepts and design methodologies (e.g., Kimball or Inmon) preferred.Strong understanding of APIs, and common flat data formats, such as JSON, and XML preferred.Hands-on-experience working on extracting data from an Electronic Health Records (EHR) and / or Salesforce preferred.Working within strict regulatory requirements, such as handling of electronic personal health information (HIPAA) preferred.ADDITIONAL REQUIREMENTS :
Satisfactorily pass all relevant screenings and criminal background checks.TRANSPORTATION / TRAVEL REQUIREMENTS :
Driving not required. Travel between sites not required.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 will lift and / or move objects weighing at least 50 pounds.Metropolitan Family Services puts our people first with a top-of-the-line benefits package. Find out more by clicking here !
Some highlights include :
Blue Cross and Blue Shield Medical Coverage, Guardian Dental Coverage, and VSP Vision Coverage.Metropolitan Family Services contributions of $2,000 to the individual and $4,000 to the family HSA accounts, pro-rated to your benefits start date.FREE General Medicine and Behavioral Health Teladoc services provided to all team members.Ascensus 401K plan services with a 4% employer match, vested at 100% on day one of eligibility.And so much more! Make sure you click here to see the full suite of benefits offered!
MORE ABOUT US :
Metropolitan is Illinois' first comprehensive human services agency and reaches more than 122,970 individuals and families in Chicago, Evanston / Skokie, the southwest suburbs, and DuPage County with services promoting education, economic stability, emotional wellness, and empowerment.