At VIA HFR, we are re-imagining passenger rail service on behalf of the Government of Canada! Our goal is to create a new sustainable train network that that will run faster, more often and will be more reliable between Toronto and Québec City. The HFR project is Canada's largest infrastructure project in generations.
Are you ready to take on a stimulating and impactful challenge? Look no further: VIA HFR is looking for a Database Developer. We are seeking a knowledgeable and driven Database Developer with a background in SQL and data warehousing to support our enterprise level systems.
The role
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.
-
Extend SharePoint functionality with forms, web parts, and application technologies.
-
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.
-
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).
Technical Skills
-
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.
-
Proficient writing SQL queries and programming including stored procedures and reverse engineering existing process.
-
Strong knowledge of ADF, ADLS, Azure Sql database.
-
Understanding of AZURE DEVOPS.
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 Canadian Federal Government clearance at the Secret level.
Why join our innovative team?
-
Group insurance that is fully paid for you and your family, including medical, dental, life, disability, etc.
-
A pension plan and saving options (RRSP and TFSA)
-
Flexible benefits: access to wellness and health accounts to support your lifestyle
-
Vacation based on experience, available as soon as you're hired
-
Incentive bonus program
-
Work in flexible hybrid mode
-
A work environment that encourages initiative, innovation and forward-thinking solutions
-
A unique opportunity to craft the future of transportation in Canada
We strive to create strong and diverse teams
At VIA HFR, we believe in the strength of diverse teams. We aspire to offer an inclusive and equitable work environment where everyone can develop and flourish. We therefore invite all qualified individuals, regardless of their identity or differences, to apply. You can learn more about the whole project on our VIA HFR webpage.
Please let us know if you require any accommodation during the recruitment process. We will do our utmost to provide you with a fair and pleasant experience, while keeping any accommodation confidential.
Please note that only those candidates selected for an interview will be contacted.
