Data Engineer

Who we are:

At MCAN, we are most proud of the team we have built and our team member experience. Our people are our best assets and are made up of respected industry innovators, influencers, and big thinkers. We do things differently than other lenders. Our business isn’t selling mortgages, it’s building relationships. 

The #MCANLIFE is shaped around a culture of customer-centricity for both internal and external clients and powered by genuine collaboration. We are a home for talented professionals seeking a more connected career and one that allows them to use more of their skills.

#MCANLIFE means you can connect, discover, and grow.

We are certified from Great Place to Work® Canada 2021-2023 and recognized as one of Canada’s Best Workplaces™ 2022-2023. We are also thrilled to be recognized on the 2024 list of Best Workplaces for Women!

We’re looking for Data Engineer to join MCAN’s IT team.

Job Summary:

The Data Engineer will be responsible for expanding and optimizing our data and data pipeline architecture, as well as enhancing data flow and collection for cross-functional teams. The ideal candidate is a seasoned data pipeline builder and data wrangler who thrives on optimizing and constructing data systems from the ground up. Data Engineer will collaborate with our software developers and business on various data initiatives, ensuring a consistent and optimal data delivery architecture across ongoing projects. They must be self-directed and adept at supporting the data needs of multiple teams, systems, and products. The right candidate will be enthusiastic about the opportunity to optimize or even redesign our company’s data architecture to support the next generation of products and data initiatives. They are responsible for outlining the detailed data architecture and design for review to be approval by the Enterprise Architect team.

What you will be responsible for:  

• Develop and maintain an optimal data pipeline architecture.


• Assemble large, complex data sets that meet both functional and non-functional business requirements.


• Identify, design, and implement internal process improvements, such as automating manual processes, optimizing data delivery, and redesigning infrastructure for greater scalability.


• Build the necessary infrastructure for optimal extraction, transformation, and loading (ETL) of data from a wide variety of sources using SQL and Azure big data technologies.


• Create analytics tools that leverage the data pipeline to provide actionable insights into customer acquisition, operational efficiency, and other key business performance metrics.


• Collaborate with stakeholders, including Business, Development, and Design teams, to address data-related technical issues and support their data infrastructure needs.


• Work with data and analytics experts to enhance the functionality of our data systems.

The work experience, skills, education that you bring:  

Education:  

• A BSc/BA in Computer Science, Engineering or Equivalent work experience

Skills/Experience:  

• Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.


• Experience building and optimizing ‘big data’ data pipelines, architectures and data sets.


• Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.


• Strong analytic skills related to working with unstructured datasets.


• Build processes supporting data transformation, data structures, metadata, dependency and workload management.


• A successful history of manipulating, processing and extracting value from large disconnected datasets.


• Working knowledge of message queuing, stream processing, and highly scalable ‘big data’ data stores.


• Strong project management and organizational skills.


• Experience supporting and working with cross-functional teams in a dynamic environment.


• We are looking for a candidate with 5+ years of experience in a Data Engineer role. They should also have experience using the following software/tools:
  
  
  
  • Experience in creating and managing Data Lake: Azure Data Lake
  
  
  • Experience with big data tools: Azure Databricks, Spark, Kafka, etc.
  
  
  • Experience with relational SQL and NoSQL databases, including SQL Server, Azure SQL Database, Azure Data Lake Storage, Azure Cosmos DB, Azure Blob Storage
  
  
  • Experience with data pipeline and workflow management tools: Azure Data Factory, Airflow, etc.
  
  
  • Experience with Salesforce and Azure Cloud Services
  
  
  • Experience with stream-processing systems: Azure Stream Analytics etc.
  
  
  • Experience creating aggregated data: Data Marts from Data Lake
  
  
  • Experience with Microsoft Power BI integration, Modelling and Reporting
  
  
  
  

We believe great work and collaboration can happen anywhere, which is why we are a permanent hybrid work environment! We equip our team with great technology and empower them to deliver their best results.

We are dedicated to building an organization that reflects the diversity of our clients and the communities we serve across Canada. Do you possess and value the same attributes? Are you interested in your own development? Then come join our team!

Requests for accommodation can be made at any stage in the recruitment process. 

We thank all applicants for their interest but only those selected for further consideration will be contacted. 

MCAN is committed to providing accommodation to applicants throughout the job application and interview process to the point of undue hardship. If you require any accommodations, please contact our Human Resources team at 416 644 5257.