ETL Lead

TechDigital Group; Chicago (IL); On-site; USD 140,000 - 190,000; Full time

Job summary

TechDigital Group in Chicago seeks a Technical Leader to define and implement ETL architecture, standards, and best practices. You will select ETL tools, monitor performance, and oversee data quality across the pipeline.

You will lead projects from initiation to deployment, manage budgets, and collaborate with cross-functional teams. Strong SQL, data warehousing, and communication skills are essential for success.

Qualifications

• Proficient in ETL concepts and tools with hands-on experience.
• Strong SQL querying and database design skills (Oracle/SQL Server/MySQL).
• Scripting knowledge (Python/Java) is a plus for automation.
• Understanding of data warehouse architecture and data modeling concepts.
• Experience planning, executing, and monitoring complex ETL projects.
• Excellent communication and collaboration with business stakeholders.

Responsibilities

• Define and implement ETL architecture, standards, and best practices.
• Monitor and optimize ETL job performance and resolve bottlenecks.
• Oversee data quality checks and validation throughout the ETL pipeline.
• Lead ETL projects from initiation to deployment, including requirements and design.
• Manage project timelines, budgets, and resources for ETL initiatives.
• Mentor ETL developers and guide technical best practices.
• Recruit and hire ETL developers as needed.
• Collaborate with data analysts, business users, and DBAs to meet data integration needs.

Skills

ETL concepts

SQL

Python/Java

Data warehousing

Project management

Communication

Tools

Informatica

SAP BODS

Tableau

Job description

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.