Database Developer

At Alto, we are actively contributing to the transformation of Canada's future with our high-speed train project connecting Quebec City and Toronto. With the support of the Government of Canada, this innovative project aims to improve the quality of life of our citizens, strengthen ties between communities and stimulate economic growth.

Would you like to take on a stimulating, high-impact challenge? We are looking for a Database Developer.

The role

We are seeking a knowledgeable and driven Data Developer with a background in SQL and data warehousing to support our enterprise level systems. This role requires the ability to collaborate with business users and analysts ensuring that our data solutions meet organizational needs while driving impactful results.

The Responsibilities

• Design and implement robust data pipelines using a medallion architecture for efficient storage and retrieval;
• Develop and maintain Power BI reports;
• Engage directly with clients to lead the implementation of analytics solutions, ensuring a successful user experience;
• Manage structured, semi structured and unstructured data sources across the organization’s storage layers including Sharepoint, OneDrive, and ADLSG2;
• Design and implement Azure Data Factory Pipelines to support centralization of analytics data sources;
• Assist in establishing and documenting best practices related to data movement, transformation, storage and analytics;
• Help promote and educate on the use of data and analytics tools including PowerBI, ADF and Fabric;
• Perform code reviews to ensure fit to requirements, optimal execution patterns and adherence to established standards;
• Manage O365 technologies (Teams, OneDrive, Power Platform and SharePoint).
  
  

Skills

• In depth knowledge of techniques and experience using scalable tools to implement data lakes and marts to support enterprise-wide analytics and reporting.
• A solid understanding of Data Architecture best practices, including data modeling techniques, design principles for data warehousing and lakes, and strategies for data integration and lifecycle management to build robust and scalable data ecosystems.
• Knowledge and experience in implementing Data Governance best practices, including developing and enforcing data policies, standards, and procedures to ensure data accuracy, consistency, and security, while promoting compliant data usage and management.
• Proficient writing SQL queries and programming including stored procedures and reverse engineering existing process.
• Strong knowledge of PowerBI, Fabric, ADF, API, ADLS, Azure SQL database.
• Understanding of AZURE DEVOPS, version control and Infrastructure as Code (IaC).
  
  

The Requirements

• A degree in computer science or equivalent experience in Data Analytics, Data Engineering and/or Data Science.
• Minimum 5 years of SQL Server based development of large datasets.
• Minimum 5 years of experience with Power BI.
• Minimum 5 years of hands-on experience in data warehousing with Azure, Synapse, Fabric.
• Cloud certification(s).
• Ability to attain or currently hold a Canadian Federal Government reliability status clearance.
  
  

Why join our innovative team?

• Basic paid group insurance for you and your family: medical, dental, life, disability, etc.
• Access to wellness and health accounts to support your lifestyle.
• Flex-Alto account of $500 to encourage a healthier approach and a more sustainable mode of transportation.
• A retirement plan and savings options (RRSP and TFSA).
• Vacations based on experience, available upon hiring.
• An incentive compensation program.
• Flexible hybrid work mode.
• A work environment that encourages initiative, innovation, and forward-thinking solutions.
• A unique opportunity to shape the future of transportation in Canada.
  
  

We work to create high-performance, diversified teams

At Alto, we believe in the power of diverse teams. We aspire to provide an inclusive and equitable work environment where everyone can develop and flourish. Alto offers equal employment opportunities to all and invites qualified individuals, regardless of their identity, origin or situation, to apply.

Please let us know if you need any adjustments during the recruitment process. We will do our utmost to provide you with a fair and pleasant experience, while keeping any adjustments confidential.

Pleas note that we will communicate only with those candidates whose applications are selected for further consideration. To find out more about the entire project, visit Alto - Home.