Job Details
Description
Inspirational, innovative and entrepreneurial - this is how we describe our empowered teams. Combine your passion with purpose and join a culture that is thriving in the face of change.
Make an impact with our Data and Analytics team as a Data Engineer. This diverse team of tech-savvy problem solvers embraces digital transformation and the possibilities analytics brings to the future of our industry. As a trusted advisor, you’ll design, develop and maintain innovative, high-quality solutions that are redefining the way MNP does business.
MNP is proudly Canadian. Providing business strategies and solutions, we are a leading national accounting, tax and business advisory firm in Canada. Entrepreneurial to our core, our talented team members transcend obstacles into opportunities and are successfully transforming mid-market business practices.
Responsibilities
- Collaborate closely with the Power Platform, Data Science, Technology Development, and various business teams to enhance and evolve MNP’s Enterprise Analytics program
- Design, develop, and maintain scalable data pipelines, leveraging Azure Databricks, Azure Data Factory (ADF), and associated Azure data platform components
- Support the development and operation of a Data Lakehouse platform, incorporating Databricks, Delta Lake, Azure Data Lake Storage, Azure SQL, and Power Platform tools
- Monitor platform performance and optimize costs to ensure efficiency and scalability
- Assist in designing and implementing robust ETL (Extract, Transform, Load) and ELT (Extract, Load, Transform) processes
- Support data modelling initiatives to ensure data quality and accessibility
- Implement data security best practices, including defining and managing user access controls at scale
- Contribute to automation and continuous integration / continuous deployment (CI / CD) practices using Azure DevOps
- Develop a comprehensive understanding of MNP’s services, business models, and industry context to align data solutions effectively
Skills and Experience
2+ years in Data Engineering, ETL development, or Business Intelligence development rolesHands-on experience with Azure Data Factory, Azure Databricks (Spark), Databricks Asset Bundles, Azure SQL, Azure Data Lake Storage, and Azure DevOpsStrong expertise in working with both structured and semi-structured data formats (CSV, JSON, Parquet)Experience working with OAuth 2.0 APIs as data sourcesProficiency in scripting languages, notably SQL and PythonFamiliarity with operational OLTP and analytical OLAP databasesUnderstanding of Data Lakehouse architecture and Medallion architecture best practicesExperience with Databricks; Unity Catalog, Lakebase, Apps and workflow orchestration is highly desirableExperience in the following would be considered an asset :MLOps and LLMOps within the DatabricksExposure to Power BI and Power BI EmbeddedFamiliarity with development frameworks or languages such as .Net Core, C#.NET, JavaScript, or CSS