ETL Lead

Chicago, Illinois

Omni Inclusive
Apply for this Job
  • Technical Leadership:
    1. Define and implement ETL architecture, standards, and best practices.
    2. Select and manage ETL tools and technologies (e.g., Informatica, SAP BODS, Tableau, Unix, Oracle, SQL Server).
    3. Monitor and optimize ETL job performance, identifying and resolving bottlenecks.
    4. Oversee data quality checks and validation processes throughout the ETL pipeline.
  • Project Management:
    1. Lead ETL projects from initiation to deployment, including requirement gathering, design, development, testing, and implementation.
    2. Manage project timelines, budgets, and resource allocation for ETL initiatives.
    3. Collaborate with cross-functional teams (data analysts, business users, database administrators) to ensure data integration needs are met.
  • Team Management:
    1. Mentor and guide ETL developers on technical best practices and problem-solving.
    2. Conduct performance evaluations and provide feedback to team members.
    3. Recruit and hire new ETL developers as needed.
  • Data Governance:
    1. Establish data quality standards and metrics to monitor data integrity.
    2. Implement data security protocols to protect sensitive information.
    3. Ensure compliance with data privacy regulations.
Required Skills and Experience:
  • Strong technical expertise in ETL concepts and tools: Deep understanding of data extraction, transformation, and loading techniques, proficiency in at least one major ETL tool.
  • Database knowledge: Expertise in SQL querying and database design (e.g., Oracle, SQL Server, MySQL).
  • Programming skills: Familiarity with scripting languages (e.g., Python, Java) can be beneficial.
  • Data warehousing knowledge: Understanding of data warehouse architecture and data modeling concepts.
  • Project management skills: Experience in planning, executing, and monitoring complex ETL projects.
  • Communication and collaboration skills: Ability to effectively communicate technical concepts to business stakeholders and work collaboratively with cross-functional teams.
Date Posted: 06 April 2025
Apply for this Job