BI Engineer/Senior Data Analyst

Capital Consultancy

Capital Consultancy is at the forefront of data-driven decision-making, employing cutting-edge data engineering to support their clients. The role of a Senior Data Analyst/Data Engineer is critical as it contributes to creating reliable, scalable solutions with Databricks and other modern tools. The successful candidate will collaborate with cross-functional teams to ensure data integrity and security, all while mentoring junior team members.

In this role you can expect to have the responsibilities:

• Develop and implement pipelines for data extraction, transformation, and load using SQL and Azure services.
• Create data products with analytics tools to enhance insights for improved passenger experience and efficiency.
• Collaborate on designing and developing RESTful APIs that enrich applications.
• Design scalable data pipelines and ETL processes using Databricks, SQL, and cloud tools.
• Optimize solutions for handling large volumes of structured and unstructured data.
• Work closely with teams to translate requirements into effective data architectures.
• Ensure data quality, integrity, and security across projects.
• Mentor junior engineers, sharing best practices.
• Evaluate and implement new tools to advance engineering capabilities.
• Lead development of seamless data integration and consistency solutions.

This role comes with the following benefits:

• Dental care
• Extended health care
• Paid time off
• RRSP match

This role requires you to have:

• Databricks expertise
• Cloud platforms (Azure, AWS)
• SQL proficiency
• ETL processes
• Data modeling
• Problem-solving skills
• Communication skills

You would benefit from having:

• Databricks certification
• Azure or AWS certifications

This remote opportunity supports flexible language requirements; French is not needed. The schedule is a standard Monday to Friday, 8-hour shift. Starting from 2025-03-24, the company promotes a supportive work environment that fosters professional growth.