Define and implement ETL architecture, standards, and best practices.
Select and manage ETL tools and technologies (e.g., Informatica, SAP BODS, Tableau, Unix, Oracle, SQL Server).
Monitor and optimize ETL job performance, identifying and resolving bottlenecks.
Oversee data quality checks and validation processes throughout the ETL pipeline.
Project Management:
Lead ETL projects from initiation to deployment, including requirement gathering, design, development, testing, and implementation.
Manage project timelines, budgets, and resource allocation for ETL initiatives.
Collaborate with cross-functional teams (data analysts, business users, database administrators) to ensure data integration needs are met.
Team Management:
Mentor and guide ETL developers on technical best practices and problem-solving.
Conduct performance evaluations and provide feedback to team members.
Recruit and hire new ETL developers as needed.
Data Governance:
Establish data quality standards and metrics to monitor data integrity.
Implement data security protocols to protect sensitive information.
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.
Numbers & Facts
Location
Chicago, IL
Industry
Other/Not Classified
Company Size
100 to 499 employees
Skills
Best Practicesunmatched
Budgetingunmatched
Communication Skillsunmatched
Computer Programmingunmatched
Cross-Functionalunmatched
Data Analysisunmatched
Data Qualityunmatched
Data Warehousingunmatched
Database Administrationunmatched
Database Designunmatched
Database Extract Transform and Load (ETL)unmatched
Informaticaunmatched
Information/Data Security (InfoSec)unmatched
Javaunmatched
Maintain Complianceunmatched
Mentoringunmatched
Microsoft SQL Serverunmatched
MySQLunmatched
Oracle Databaseunmatched
Performance Analysisunmatched
Performance Reviewsunmatched
Performance Tuning/Optimizationunmatched
Privacy Regulationsunmatched
Problem Solving Skillsunmatched
Project Trackingunmatched
Project/Program Managementunmatched
Python Programming/Scripting Languageunmatched
Quality Managementunmatched
Quality Metricsunmatched
Regulatory Complianceunmatched
Requirements Managementunmatched
Resource Managementunmatched
SAPunmatched
SQL Databasesunmatched
Scripting (Scripting Languages)unmatched
Security Protocolsunmatched
Tableauunmatched
Team Lead/Managerunmatched
Team Playerunmatched
Technical Leadershipunmatched
Test Plan/Scheduleunmatched
Time Managementunmatched
Unix Operating Systemsunmatched
User Documentationunmatched
Validation Testingunmatched
🎯
Be found by employers
5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.
Level up your application
Professional resume templates
Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.