About the role
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.
About ALTO
ALTO is one of the fastest growing advisory firms in Poland. We render professional services in the areas of Tax, Accounting and Payroll, Risk and ESG advisory, as well as Technology in Tax Services.
We have extensive experience advising international businesses from a wide variety of industries. We also cooperate with leading European consulting companies, providing the highest quality services in all international aspects relating to activities of Clients operating in foreign jurisdictions. When dealing with our Clients, we focus on partnership and on maintaining good and long-term relations.
We have been working for our Clients since 2011. Since then, we have steadily expanded our team of advisors and the range of services offered. We specialise in advising companies from 8 industry sectors: real estate, financial services, PE/VC, insurance, technology, healthcare/life sciences, energy and logistics.
As of today, our team consists of ca. 150 tax and legal advisors, certified accountants and other professionals who proactively assist our Clients on every step of their business path, in order to give them the best client experience on the market.
The strength of our professionals and our undisputed growing market position have been repeatedly confirmed in major international and local rankings over the last 13 years.
Get to know us better at www.altoadvisory.pl
We are a member of Allinial Global - an international association of advisory and accounting firms.
About the role
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.
About ALTO
ALTO is one of the fastest growing advisory firms in Poland. We render professional services in the areas of Tax, Accounting and Payroll, Risk and ESG advisory, as well as Technology in Tax Services.
We have extensive experience advising international businesses from a wide variety of industries. We also cooperate with leading European consulting companies, providing the highest quality services in all international aspects relating to activities of Clients operating in foreign jurisdictions. When dealing with our Clients, we focus on partnership and on maintaining good and long-term relations.
We have been working for our Clients since 2011. Since then, we have steadily expanded our team of advisors and the range of services offered. We specialise in advising companies from 8 industry sectors: real estate, financial services, PE/VC, insurance, technology, healthcare/life sciences, energy and logistics.
As of today, our team consists of ca. 150 tax and legal advisors, certified accountants and other professionals who proactively assist our Clients on every step of their business path, in order to give them the best client experience on the market.
The strength of our professionals and our undisputed growing market position have been repeatedly confirmed in major international and local rankings over the last 13 years.
Get to know us better at www.altoadvisory.pl
We are a member of Allinial Global - an international association of advisory and accounting firms.