Ride the next mile with us!
The responsibilities of the Senior Data Engineer will cover:

Database Management:

• Design, develop and maintain databases and data warehouses ensuring optimal performance and reliability through the implementation of automated solutions
• Implement data modeling and database design best practices

Data Pipeline Development:

• Design, develop and maintain scalable and efficient ELT/ETL processes
• Improve the organization of the data to better support all the different loading frequencies
• Feed the different business analytical environments (business datamarts)

Data Quality and Governance:

• Implement, enforce and ensure the data governance policies and standards (accesses, security etc.)
• Ensure the quality, accuracy and completeness of data through automated data validation and cleansing processes
• Investigate and resolve data quality and ELT/ETL issues

Collaboration:

• Collaborate with business leaders, end-users and data scientists to understand their data requirements
• Translate business requirements into technical specifications and deliver effective BI solutions

Data Analysis and Modeling: analyze and interpret complex data sets, providing actionable insights for business stakeholders

Performance Optimization:

• Monitor and optimize the performance of BI systems, proactively addressing bottlenecks and inefficiencies
• Always be on the lookout for possible improvements to the platform and methodology

Documentation:

• Document BI processes, data models and flows, data engineering processes, database structures and technical specifications
• Define specifications and requirements for mandates in collaboration with the necessary stakeholders across the organization
• Ensure that the documentation is up-to-date and accessible to the relevant stakeholders

Security:

• Implement and maintain data security measures, including access controls and encryption
• Ensure compliance with data privacy regulations and standards

Technical skills and background

• 6+ years :
• Developer experience, working in BI development and data analysis projects
• SQL experience, with a strong understanding of database management
• Bachelor’s degree or higher in Computer Science, Data Engineering, Information Technology, Business Analytics, Business Intelligence, Mathematics etc. or equivalent experience
• Strong Proficiency with:
• ETL processes and tools
• Data warehousing methodologies
• Programming languages such as Python/R (or any similar language) for data transformation and analysis
• SQL language, Window functions and recursive queries
• Cloud Technologies :
• Azure (Data Factory, Azure SQL DB, etc.)
• AWS (Lambda, Kinesis firehose, S3, etc.)
• Snowflake (Tasks, Stream, Pipe)
• Etc.
• Apache Airflow or equivalent
• DBT or equivalent
• GIT or equivalent
• Experience with:
• Data modeling (Kimball)
• Understanding the architecture of Power BI services in order to offer relevant solutions (workspace concepts, dashboards versus reports, Apps, etc.)

Other skills

• Team-player
• Self-motivated and resourceful
• Ability to speak with business people and translate their needs into technical requirements
• Ability to explain a complex technical concept to a non-expert
• Be able and comfortable evolving in fast-moving environment
• Strong interest in cloud computing technologies and modern platforms
• Can operate under tight deadlines
• Be a force for proposal
• Strong analytical and problem-solving skills, with the ability to think critically and strategically
• Strong communication and interpersonal skills in both French and English

Intelcom is a leading last-mile carrier in the e-commerce sector. Our teams across Canada as well as our network of independent contractors contribute to Intelcom’s daily operations.
Our goal is simple: in a constantly evolving business sector, we don’t just follow, we get ahead. In addition to standing out through innovative services and delivery methods, Intelcom is also undergoing a technological transformation where the integration of customer experience and logistics technologies are at the heart of its evolution.
At Intelcom, we know experience comes in many forms and are committed to building a culture where difference is valued. We are always looking for talented and diverse individuals to join our teams. With over 60 delivery centers across Canada, we may have the right opportunity for you.

Please refer the Job description for details