Talent.com
ETL Developer

ETL Developer

Metropolitan Family ServicesChicago, IL, US
2 days ago
Job type
  • Full-time
Job description

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 required
  • for 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 and
  • deliver 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 data
  • warehouse 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 reference
  • and 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.

    Create a job alert for this search

    Etl Developer • Chicago, IL, US

    Related jobs
    • Promoted
    • New!
    EDI Analyst

    EDI Analyst

    VirtualVocationsNaperville, Illinois, United States
    Full-time
    A company is looking for an EDI Analyst responsible for internal EDI processes and implementation.Key Responsibilities Maintain knowledge of employee benefit systems and processes related to EDI ...Show moreLast updated: 13 hours ago
    • Promoted
    • New!
    Data and Automation Lead

    Data and Automation Lead

    VirtualVocationsNaperville, Illinois, United States
    Full-time
    A company is looking for a Data and Automation Lead to support program management, automation engineering, data configuration, data analytics, and reporting activities. Key Responsibilities Provid...Show moreLast updated: 11 hours ago
    • Promoted
    ADABAS DB2 Database Specialist

    ADABAS DB2 Database Specialist

    VirtualVocationsGary, Indiana, United States
    Full-time
    A company is looking for an ADABAS / DB2 Database Specialist to provide expert-level technical support in a remote setting. Key Responsibilities Plan, install, configure, and implement SAG ADABAS so...Show moreLast updated: 1 day ago
    • Promoted
    • New!
    Senior UX Analyst

    Senior UX Analyst

    VirtualVocationsGary, Indiana, United States
    Full-time
    A company is looking for a Senior UX Conversion Specialist who is passionate about analyzing user behavior and optimizing conversion rates. Key Responsibilities Analyze user behavior data to ident...Show moreLast updated: 3 hours ago
    • Promoted
    Senior Data Engineer

    Senior Data Engineer

    Sprout SocialChicago, IL, United States
    Full-time
    Sprout Social is looking for a Data Engineer to join our Data Foundations team.This team builds the internal data infrastructure, pipelines, and products that empower analytics, data science, and b...Show moreLast updated: 28 days ago
    • Promoted
    Data Engineer Senior

    Data Engineer Senior

    Associated Bank - CorpChicago, IL, United States
    Full-time
    At Associated Bank we strive to create an inclusive culture where different perspectives are valued and recognized as strengths critical to our success. If you thrive in an environment where your gr...Show moreLast updated: 30+ days ago
    • Promoted
    Senior Big Data Engineer

    Senior Big Data Engineer

    VirtualVocationsGary, Indiana, United States
    Full-time
    A company is looking for a Senior Big Data Engineer to join their team.Key Responsibilities Support the transition from a monolithic application to loosely coupled microservices Ensure data is c...Show moreLast updated: 30+ days ago
    • Promoted
    ETL Implementation Engineer

    ETL Implementation Engineer

    VirtualVocationsGary, Indiana, United States
    Full-time
    A company is looking for an ETL Implementation Engineer to develop and maintain ETL pipelines and ensure data quality within financial services. Key Responsibilities Design, build, and maintain ro...Show moreLast updated: 1 day ago
    • Promoted
    CJIS Licensed Data Conversion Engineer

    CJIS Licensed Data Conversion Engineer

    VirtualVocationsGary, Indiana, United States
    Full-time
    A company is looking for a Data Conversion Engineer - Public Safety.Key Responsibilities Collaborate with stakeholders to define data migration requirements and objectives Develop data migration...Show moreLast updated: 2 days ago
    • Promoted
    Data Engineer

    Data Engineer

    Sprout SocialChicago, IL, United States
    Full-time
    Sprout Social is looking for a Data Engineer to join our Data Foundations team.This team builds the internal data infrastructure, pipelines, and products that empower analytics, data science, and b...Show moreLast updated: 21 days ago
    • Promoted
    ETL Data Architect

    ETL Data Architect

    VirtualVocationsGary, Indiana, United States
    Full-time
    A company is looking for an ETL Data Architect to design and develop enterprise-wide application systems.Key Responsibilities Collaborate with business partners and teams to identify technical an...Show moreLast updated: 2 days ago
    • Promoted
    Principal Database Programmer

    Principal Database Programmer

    VirtualVocationsGary, Indiana, United States
    Full-time
    A company is looking for a Principal Database Programmer.Key Responsibilities Provide training and mentoring to (Senior) Database Programmers on CDMS systems and processes Plan client deliverabl...Show moreLast updated: 1 day ago
    • Promoted
    Senior Business Intelligence Developer

    Senior Business Intelligence Developer

    VirtualVocationsNaperville, Illinois, United States
    Full-time
    A company is looking for a Senior Business Intelligence Developer - Product & Platform Innovation.Key Responsibilities Collaborate with cross-functional teams to drive data enablement and support...Show moreLast updated: 30+ days ago
    • Promoted
    Tech Lead for AI & Data

    Tech Lead for AI & Data

    VirtualVocationsNaperville, Illinois, United States
    Full-time
    A company is looking for a Tech Lead with AI & Data expertise (Remote, LATAM).Key Responsibilities Lead the technical effort for the Delivery Team, ensuring clarity and confidence with clients an...Show moreLast updated: 1 day ago
    • Promoted
    Reserving Data & Applications Lead

    Reserving Data & Applications Lead

    Axis CapitalChicago, IL, United States
    Full-time
    This is your opportunity to join AXIS Capital - a trusted.We stand apart for our outstanding client service, intelligent risk taking and superior risk adjusted returns for our shareholders.We also ...Show moreLast updated: 26 days ago
    • Promoted
    ETL Developer Consultant

    ETL Developer Consultant

    VirtualVocationsLincolnwood, Illinois, United States
    Full-time
    A company is looking for an ETL Developer Lead / Consultant.Key Responsibilities Design, build, and maintain ETL pipelines for data ingestion into the TradingHub platform Configure and integrate ...Show moreLast updated: 1 day ago
    • Promoted
    Data Engineer

    Data Engineer

    Associated Bank - CorpChicago, IL, United States
    Full-time
    At Associated Bank we strive to create an inclusive culture where different perspectives are valued and recognized as strengths critical to our success. If you thrive in an environment where your gr...Show moreLast updated: 30+ days ago
    • Promoted
    Data Engineer with GCP Certification

    Data Engineer with GCP Certification

    VirtualVocationsLincolnwood, Illinois, United States
    Full-time
    A company is looking for a Data Engineer (Gen AI).Key Responsibilities Install and test Looker and Looker Studio extensions or API plugins Identify and deprecate unused Looker dashboards Enhanc...Show moreLast updated: 1 day ago
    • Promoted
    Deep Learning Software Engineer

    Deep Learning Software Engineer

    VirtualVocationsNaperville, Illinois, United States
    Full-time
    A company is looking for a Deep Learning Software Engineer, Inference and Model Optimization - New College Grad 2025.Key Responsibilities Train, develop, and deploy generative AI models using the...Show moreLast updated: 1 day ago
    • Promoted
    Junior Machine Learning Engineer

    Junior Machine Learning Engineer

    VirtualVocationsGary, Indiana, United States
    Full-time
    A company is looking for a Junior Machine Learning Engineer to support the design, development, and deployment of machine learning models. Key Responsibilities Support the end-to-end lifecycle of ...Show moreLast updated: 30+ days ago