Senior Data Engineer

The responsibilities of the Senior Data Engineer will cover:

Database Management:

• Design, develop and maintain databases and data warehouses ensuring optimal performance and reliabilitythrough 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,enforceand 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