Data Engineer

MCAP Group of Companies; Southwestern Ontario; On-site; CAD 95,000 - 105,000; Full time

Job summary

MCAP is seeking a Data Engineer to analyze, design, implement and support data pipelines and reporting in a dynamic mortgage finance company. The role includes developing data solutions, maintaining documentation, and providing production support with strong SQL and BI skills.

The candidate will work on both Waterloo and Toronto sites with a focus on scalable data architectures and cloud-enabled data practices.

Qualifications

• 1-6 years relevant experience.
• Experience with BI and Data Warehousing environments.
• Experience with data modeling and database schema design.
• Strong analytical and troubleshooting skills.
• Mortgage/financial industry experience preferred.
• Knowledge of cloud native development practices using private or public clouds.

Responsibilities

• Design, develop and document data pipelines and reporting.
• Provide day-to-day production support and incident management.
• Develop software programs, code and unit tests for new and existing applications.
• Maintain supporting documentation.
• Write complex SQL queries for data analysis and reporting.
• Participate in installations, migrations and configuration.

Skills

T-SQL

C#

Python

SQL Server

Power BI

Education

Computer Science degree or related field

Tools

Microsoft SSIS

SSRS

Crystal Reports

Power BI

Azure DevOps

Job description

Data Engineer

MCAP at a Glance

JoiningMCAP means you will be a part of our diverse workforce of highly talented individuals who are recognized for their expertise and success! At MCAP, your professional expertise, commitment to teamwork and passion for service excellence are recognized and rewarded with competitive total rewards offering, a career with continuous learning and development (formal & informal training), and exciting opportunities in a dynamic, entrepreneurial environment.

The Role

This position is responsible for the analysis, design, execution, assessment, security, and troubleshooting of data, data pipelines, and reporting. This role is responsible for understanding the business unit functions and contributing to the evolutionary plans for the reporting environment. This includes defining, configuring, coding, developing, and documenting reporting, data, and data pipeline specifications throughout the project life cycle. In addition, the Data Engineer will provide day-to-day operations and production support, including off-hours problem resolution of supported applications.

Strategy and Planning

• Contributes to evaluation of design options and approach.
• Familiar with architectural patterns that contribute to the production of secure, reliable, manageable, and high-performance solutions.
• Contribute to architectural modelling to assist in determining solution efficacy.
• Performs estimating, prioritizing, planning of tasks to reliably and consistently deliver according to plan.
• Estimates feasibility of requests and negotiates on deliverables

Acquisition and Deployment

• Conduct research as directed on emerging application development software products, languages, automation tools, and standards in support of procurement and development efforts.
• Performs detailed technical design of proposed solutions for individual software components.
• Contributes to the determination of relevant risks and determines mitigation strategies.

Operational Management

• Develop and review software programs, code, and unit tests for new and existing applications and systems, ensuring functional and non-functional requirements are met.
• Develop, and maintain supporting documentation as required.
• Gather statistics and prepare and write reports on the status of the programming process for discussion with management and/or team members.
• Recommend, schedule, and perform software improvements and upgrades for optimal performance of software applications.
• Perform troubleshooting and root cause analysis in support of incident and problem management and recommend options to address identified issues.
• Participates in development, implementation, and maintenance of plans to ensure continuation of critical operations in the event of a disaster or interruption.
• Provides ongoing system maintenance and monitoring to ensure adherence to SLAs.

What You Bring To The Team

• 1-6 years relevant experience
• Experience with application analysis, design and development using a broad range of tools and techniques
• Experience with Business Intelligence and Data Warehousing environments
• Experience with data modeling and database schema design
• Strong analytical and troubleshooting skills
• Understanding of structured programming and object-oriented design and service-oriented architecture
• Experience in the mortgage or financial industry is preferred
• Minimum knowledge of cloud native development practices and design patterns using private or public cloud providers required
• Basic understanding of cloud patterns and infrastructure management using private or public cloud providers required
• Understands software development lifecycle and the practices and procedures of software development including Agile Development Methodology
• Ability to design, develop and maintain data pipelines for a variety of data sources
• Create and optimize complex SQL queries for data analysis and reporting.
• Participate in related technology installations, upgrades, migrations, and configuration.
• Ability to make recommendations to IT and business processes
• Knowledge of business procedures and applicable systems
• Excellent communication skills – both verbal and written
• Strong attention to detail and excellent organizational skills
• Strong analytical, designing, problem-solving, and decision-making skills with the ability to interpret client needs
• Demonstrated ability to work cooperatively in a team environment and ability to maintain a professional attitude
• Ability to develop strong working relationships with internal and external business partners and clients.
• Experience writing high-quality documentation, reports, and proposals, as well as documentation of system deliverables documentation
• Knowledge of business procedures and applicable systems
• Ability to mentor and coach others
• Self-starter, results-oriented with proven success in prioritizing and managing multiple tasks projects of varying complexity in the context of business operations
• Computer Science degree or related field, or equivalent experience
• Database technologies: Microsoft SQL Server, NoSQL (MongoDB), DB2
• Data ETL/ELT Tools: Microsoft SSIS, SSRS
• Reporting/Visualization tools: Crystal Reports, Power BI
• Azure Devops (automated CI/CD), build and release pipelines
• Languages: T-SQL, C#, Python, (COBOL is an asset)
• Experience with Data Catalog and Data Fabric technologies is an asset

If this sounds like you and you are looking to be a part of one of Canada’s largest independent mortgage finance companies, then we want to hear from you!

Be A Part Of Something Great

MCAPis Canada’s largest independent MortgageFinance company withover $150 billion in assets under management providing mortgage solutions forresidential and commercial properties. For over 35 years,MCAP originates, trades, securitizes and services mortgages in offices acrossCanada. MCAP originates residential mortgages exclusively through the mortgagebroker channel as we believe that a professional mortgage broker is aconsumer's best option and MCAP actively promotes the services of mortgagebrokers across the country. MCAP is also a leader in the Canadian residentialconstruction lending market with over 25 years in the business. Our teams ofdedicated professionals serve a variety of developer, construction and lenderclients across Canada.

Position #: req2272

Employment Status: Permanent Full Time

Location: Waterloo and Toronto

Number Of Openings:1

Department: Information Technology

Internal Job Title: Data Engineer

Salary Range: $95,000 - $105,000

The above information in this description has been designed to indicate the general nature and level of work performed by employees in the position. It is not designated to contain a comprehensive inventory of all duties, responsibilities, and qualifications required of employees assigned to this job.

MCAP provides equal opportunities for all applicants and is committed to fostering an inclusive, accessible environment, where all employees feel valued, respected and supported throughout the recruitment and employment process. If you require accommodation, we will work with you to meet your needs.