ETL Data Engineer
CYNET SYSTEMS
- Mississauga, ON
- Permanent
- Full-time
- Contribute to the design, development, maintenance and evolution of scalable data pipelines, data structures, source systems and warehouse/lake environments.
- Partner closely with data team members, cross-functional stakeholders to manage, structure, and analyse data from various sources to solve business problems.
- Contribute to documentation of data models, dictionaries, data flow maps, and metadata to support transparency and data governance.
- Hands on support of the current ETL processes, share responsibilities for monitoring the current data pipelines and processes.
- Effectively manages project requirements, ensures timely delivery, and maintains high-quality standards.
- Ability to find opportunities, assess problems, effectively recommend and implement the best solution.
- Partner with technical teams and stakeholders to implement data capture, ETL, validation, and QA.
- Candidate's methodical and intentional approach, crucial for establishing a focused context, will be vital in supporting diverse team efforts while candidates manage multiple projects and ensuring quality and timeliness.
- Staying abreast of the latest developments in technology and data management practices.
- BS in Computer Science, Software engineering, Information technology, Data and Analytics or equivalent degree.
- 4 - 5 years experience with building and maintaining data lake and data solutions.
- Strong understanding of data structures, database objects, data normalization and data transformation techniques required.
- Proficiency in SQL with the ability to write complex stored procedures for data processing. Experience with Snowflake.
- Proficiency in Python required. Experience in building highly insightful dashboards using Power BI.
- Automated and scaled application deployments leveraging AWS Lambda functions, containerized solutions with Elastic Container Service (ECS), and secure credential handling via AWS Secrets Manager.
- Thorough understanding and ability to lead through the agile and waterfall methodologies. Excellent written and verbal communication skills required.
- Strong analytical, troubleshooting and problem-solving skills.
We are sorry but this recruiter does not accept applications from abroad.