ETL Development Lead

Role/Position Summary:
Under the supervision of the Manager, the Development Lead is responsible for leading the design, development, implementation, maintenance, and continuous improvement of ETL/ELT solutions, data pipelines, and related data-processing tools.
The position manages and provides technical direction to ETL Developers and works closely with Data Operations, Data Analysts, Database Administrators, Software Delivery, GIS Developers and other stakeholders to ensure data-processing solutions are accurate, secure, scalable, maintainable, and aligned with operational, business, and technical requirements.
Duties & Responsibilities:
ETL Solution Design and Development
Lead the design, development, implementation, and maintenance of ETL solutions, data pipelines, transformation processes, and related data-processing tools. Creates wireframe, storyboard, prototype, or mock-up if and when necessary.
Review and approve data mappings, transformation rules, technical designs, and implementation approaches.
Perform hands-on development, troubleshooting, and optimization for complex, critical, or high-priority ETL requirements when necessary.
Team Leadership and Development
Manage the ETL Development team, including work assignment, delivery monitoring, coaching, performance management, and capability development.
Provide technical direction and ensure adherence to established development, documentation, security, data management, and compliance standards.
Promote code reviews, technical walkthroughs, knowledge sharing, cross-training, mentoring, and continuous improvement within the team.
Requirements and Delivery Management
Collaborate with Data Operations, Data Analysts, Software Delivery, and other stakeholders to analyze data-processing requirements and translate them into appropriate technical solutions.
Assess scope, dependencies, risks, effort, and resource requirements to support the planning and prioritization of ETL development activities.
Ensure ETL solutions are properly reviewed, tested, demonstrated, approved, documented, deployed, and transitioned to users and operational support teams, including appropriate training or knowledge transfer.
Quality, Governance and Compliance
Ensure ETL solutions and deliverables meet established quality, security, reliability, documentation, and software development standards.
Ensure processing issues and defects are investigated through root-cause analysis, appropriately resolved, and used to identify opportunities for continual improvement.
Ensure the team complies with applicable software development policies and procedures, and client-specific controls, including the use of prescribed workflow and document management systems.
Qualifications:
Bachelor's degree in information technology, Computer Science, Information Systems, Software Engineering, Data Engineering, or another related field.
At least 5 years of relevant experience in ETL development, data engineering, software development, or related technical roles.
At least 2 years of experience in a technical lead, team lead, supervisory, or equivalent role.
Experience supporting production data pipelines, data-processing operations, and cross-functional technology initiatives
Strong knowledge of ETL/ELT concepts, data integration, data transformation, data mapping, and pipeline design
Experience developing and supporting batch, scheduled, event-driven, and other data-processing solutions
Strong knowledge of relational databases, SQL development, stored procedures, query optimization, and database design principles
Experience with Microsoft SQL Server, PostgreSQL, MySQL, Oracle, or comparable database platforms
Knowledge of at least one programming or scripting language used for data processing, such as Python, .NET, Java, or shell scripting
NOTICE: As this website allows us to collect your information through your resumes, please read our Privacy Notice before proceeding: https://www.adec-innovations.com/privacy-statement/

Work arrangement
Yes