Senior Data Engineer

MNP; Calgary; On-site; CAD 80,000 - 110,000; Full time

Job summary

A leading business advisory firm in Calgary is seeking a Senior Data Engineer to join their Data and Analytics team. This role involves designing and maintaining scalable data pipelines using Azure technologies, supporting data modeling initiatives, and implementing best practices for data security. Ideal candidates will have 3-4 years of experience in Data Engineering and proficiency in SQL and Python. The firm offers flexible benefits and a supportive culture with a focus on diversity.

Benefits

Generous base pay

Vacation time

Flexible benefits

Professional development assistance

Qualifications

• 3-4 years in Data Engineering, ETL development, or Business Intelligence development roles.
• Hands-on experience with Azure data platform components.
• Proficiency in scripting languages, notably SQL and Python.

Responsibilities

• Collaborate with various teams to enhance MNP’s Enterprise Analytics program.
• Design and maintain scalable data pipelines using Azure components.
• Implement data security best practices and optimize platform performance.

Skills

Azure Data Factory

Azure Databricks (Spark)

SQL

Python

Data Lakehouse architecture

Tools

Azure SQL

Azure Data Lake Storage

Azure DevOps

Job description

Overview

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!