ETL Data Engineer

CYNET SYSTEMS

  • Mississauga, ON
  • Permanent
  • Temps-plein
  • Il y a 6 jours
  • Postuler facilement
Job Description:
  • 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.
Qualifications:
  • 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.

CYNET SYSTEMS