Talent.com
ETL Developer

ETL Developer

Metropolitan Family ServicesChicago, IL, US
job_description.job_card.variable_hours_ago
serp_jobs.job_preview.job_type
  • serp_jobs.job_card.full_time
job_description.job_card.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.

    serp_jobs.job_alerts.create_a_job

    Etl Developer • Chicago, IL, US

    Job_description.internal_linking.related_jobs
    • serp_jobs.job_card.promoted
    React Developer Tech Lead

    React Developer Tech Lead

    VirtualVocationsGary, Indiana, United States
    serp_jobs.job_card.full_time
    A company is looking for a React Developer - Tech Lead.Key Responsibilities Manage teams and projects effectively while ensuring high-quality code delivery Develop innovative digital products us...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Senior Business Data Analyst

    Senior Business Data Analyst

    VirtualVocationsGary, Indiana, United States
    serp_jobs.job_card.full_time
    A company is looking for a Sr Business Data Analyst to support the creation of a KPI dashboard for actionable insights.Key Responsibilities Design, develop, and deploy a KPI dashboard using Table...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    • serp_jobs.job_card.new
    Illinois Licensed Data Analyst

    Illinois Licensed Data Analyst

    VirtualVocationsGary, Indiana, United States
    serp_jobs.job_card.full_time
    A company is looking for a Data Analyst.Key Responsibilities Support the development and quality monitoring of Medicare & Retirement CAHPS / HOS Survey programs Design, build, and maintain Alteryx...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_less
    • serp_jobs.job_card.promoted
    Senior Duck Creek Developer (Policy)

    Senior Duck Creek Developer (Policy)

    TEKsystemsChicago, IL, United States
    serp_jobs.job_card.full_time
    We are hiring a Senior Duck Creek Developer on a remote basis!.Additional Skills & Qualifications •.Lead the end-to-end technical delivery of Duck Creek Policy implementations and upgrades, includin...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    • serp_jobs.job_card.new
    QA Analyst III

    QA Analyst III

    VirtualVocationsGary, Indiana, United States
    serp_jobs.job_card.full_time
    A company is looking for a QA Analyst III to support the Developer Compliance Operations team in ensuring the integrity and quality of Data Protection Assessment reviews.Key Responsibilities Inde...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_hours
    • serp_jobs.job_card.promoted
    Data Analyst 2

    Data Analyst 2

    VirtualVocationsGary, Indiana, United States
    serp_jobs.job_card.full_time
    A company is looking for a Data Analyst 2 to work remotely.Key Responsibilities Assist in designing and implementing analytics platform components using Microsoft Azure, Databricks, and PowerBI ...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    Senior ETL Developer

    Senior ETL Developer

    Barrow Wise ConsultingChicago, IL, USA
    serp_jobs.job_card.full_time
    serp_jobs.filters_job_card.quick_apply
    Enjoy problem-solving, need a venue to display your creativity, and emerging technologies pique your interest; if so, Barrow Wise Consulting, LLC is for you. As a multi-disciplined leader, you under...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Senior AEM Developer

    Senior AEM Developer

    VirtualVocationsGary, Indiana, United States
    serp_jobs.job_card.full_time
    A company is looking for a Frontend Developer to join their Digital Experience team.Key Responsibilities Design, develop, and implement scalable AEM backend solutions using Java, OSGi, and Sling ...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    • serp_jobs.job_card.new
    Remote Customer Engineer

    Remote Customer Engineer

    VirtualVocationsNaperville, Illinois, United States
    serp_jobs.filters.remote
    serp_jobs.job_card.full_time
    A company is looking for a Remote Product Owner / Customer Engineer to lead technical implementations and integrations while ensuring customer needs are met. Key Responsibilities Lead onboarding and...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_hours
    • serp_jobs.job_card.promoted
    B-Level Technician

    B-Level Technician

    GreatWater GaragesHighland Park, IL, United States
    serp_jobs.job_card.full_time
    General Service Automotive Technician with a great attitude who takes pride in their work to deliver exceptional vehicle repairs to both our existing and our growing customers.Expect to stay challe...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Brake and Alignment Specialist

    Brake and Alignment Specialist

    GreatWater GaragesHighland Park, IL, United States
    serp_jobs.job_card.full_time
    General Service Automotive Technician with a great attitude who takes pride in their work to deliver exceptional vehicle repairs to both our existing and our growing customers.Expect to stay challe...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    • serp_jobs.job_card.new
    Workday ERP Leader

    Workday ERP Leader

    Plante MoranChicago, IL, United States
    serp_jobs.job_card.full_time
    Our "we-care" culture is more than just a motto; it's a promise.From day one, we prioritize your growth, well-being, and success. You can count on us to support your career journey and help you achi...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_less
    • serp_jobs.job_card.promoted
    • serp_jobs.job_card.new
    Senior Release Engineer

    Senior Release Engineer

    VirtualVocationsGary, Indiana, United States
    serp_jobs.job_card.full_time
    A company is looking for a Senior Release Engineer to manage and enhance its release infrastructure and processes.Key Responsibilities Own and evolve CI / CD infrastructure and release processes wi...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_hours
    • serp_jobs.job_card.promoted
    • serp_jobs.job_card.new
    Senior Customer Development Manager, Ulta

    Senior Customer Development Manager, Ulta

    KenvueWheeling, Illinois, United States
    serp_jobs.job_card.full_time
    Kenvue is currently recruiting for a : .Senior Customer Development Manager, Ulta.At Kenvue , we realize the extraordinary power of everyday care. Built on over a century of heritage and rooted in sc...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_hours
    • serp_jobs.job_card.promoted
    • serp_jobs.job_card.new
    Salesforce Email Developer

    Salesforce Email Developer

    VirtualVocationsNaperville, Illinois, United States
    serp_jobs.job_card.full_time
    A company is looking for a Salesforce Marketing Cloud (SFMC) Email Developer to build and deploy personalized email campaigns. Key Responsibilities : Develop responsive emails using Content Builder...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_hours
    • serp_jobs.job_card.promoted
    • serp_jobs.job_card.new
    Rhapsody Consultant

    Rhapsody Consultant

    VirtualVocationsGary, Indiana, United States
    serp_jobs.job_card.full_time
    A company is looking for a Rhapsody Consultant to support backend processing and ELC Modernization Projects.Key Responsibilities Participate in planning, design, and configuration of Systems Inte...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_hours
    • serp_jobs.job_card.promoted
    CDL-A Lease Purchase – $2,000 / Wk NET, $0 Down Lease

    CDL-A Lease Purchase – $2,000 / Wk NET, $0 Down Lease

    DriveLine SolutionsJoliet, IL, USA
    serp_jobs.job_card.full_time
    CDL-A Lease Purchase – $2,000 / Wk NET, $0 Down Lease.Why Drivers Love This Opportunity.Trailer rental available : dry van $225 / week. Weekly truck payments : $300–$650 (varies by truck).Fuel card provid...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    • serp_jobs.job_card.new
    JD Edwards Developer

    JD Edwards Developer

    VirtualVocationsLincolnwood, Illinois, United States
    serp_jobs.job_card.full_time
    A company is looking for a JD Edwards Developer to design, develop, and support custom solutions within JD Edwards EnterpriseOne. Key Responsibilities : Develop and maintain custom applications wit...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_hours