Senior Data Engineer

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 Senior 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
• Manage and govern data platform access through Databricks Unity Catalog
• Develop a comprehensive understanding of MNP’s services, business models, and industry context to align data solutions effectively

Skills and Experience

• Three to four years in Data Engineering, ETL development, or Business Intelligence development roles
• Hands-on experience with Azure Data Factory, Azure Databricks (Spark), Databricks Asset Bundles, Azure SQL, Azure Data Lake Storage, and Azure DevOps
• Strong expertise in working with both structured and semi-structured data formats (CSV, JSON, Parquet)
• Experience working with OAuth 2.0 APIs as data sources
• Proficiency in scripting languages, notably SQL and Python
• Familiarity with operational OLTP and analytical OLAP databases
• Understanding of Data Lakehouse architecture and Medallion architecture best practices
• Experience with Databricks; Unity Catalog, Lakebase, Apps and workflow orchestration is highly desirable
• Experience in the following would be considered an asset:
  • MLOps and LLMOps within the Databricks
  • Exposure to Power BI and Power BI Embedded 
  • Familiarity with development frameworks or languages such as .Net Core, C#.NET, JavaScript, or CSS 

MyRewards@MNP

With a focus on high-potential earnings, MNP is proud to offer customized rewards that support our unique culture and a balanced lifestyle to thrive at work and outside of the office. You will be rewarded with generous base pay, vacation time, 4 paid personal days, a group pension plan with 4% matching, voluntary savings products, bonus programs, flexible benefits, mental health resources, exclusive access to perks and discounts, professional development assistance, MNP University, a flexible ‘Dress For Your Day’ environment, firm sponsored social events and more!

Diversity@MNP

We embrace diversity as a core value and celebrate our differences. We believe each team member contributes unique gifts and amplifying their potential makes our business stronger. We encourage people with disabilities to apply!