Enterprise Data Architect
Join a happy, growing team! 86% of employees recommend MCAN as a great place to
work! XMC leads competitors in growth year-over-year!
The Enterprise Data Architect is accountable for the development
and execution of Business Intelligence (BI)/data management strategy and contribute
to the plan to support the overall corporate strategy. This position is
directly responsible for the management of all the core data infrastructure,
data warehouse and all related systems by implementing best practices. He/she
is also responsible to developing Data Governance framework to manage
enterprise data. The framework includes policies, standards and guidelines to
utilize data in a controlled manner. The Enterprise Data Architect provides
leadership to application support and data management team of IT professionals
to manage day to day operations by following organizational policies and
governance frameworks. He/she will be working closely and supporting the VP, IT
to devise a system/technology roadmap to align with the corporate objectives.
What you will be responsible for:
Design, direct and implement business intelligence solutions for the
Lead Data Management/BI projects during all the phases of the project
life cycle, with emphasis on business requirements gathering, quality assurance
and user acceptance phases.
Driving process efficiencies and business value by providing data-based
solutions to internal stakeholders
Own relationship with the business report users to manage expectations
Be the voice of the business user to data/reporting management team
accelerating the adoption of new BI projects across the organization.
Identify risks with solution and communicate with business users to
proactively resolve or mitigate risks/delays to the BI projects.
Engage technical and non-technical business users in project
communications, using appropriate language and terminology for the intended
Support critical stakeholder business units such as Residential Lending,
AML/Compliance, Finance/Treasury with data solutions to meet the MCAN’s
regulatory, compliance and governance policies and frameworks
Transform business requirements into BI solutions.
Analyze different sources of data and document technical specifications
for analytics developers.
Support quality assurance and user acceptance tests.
Work with analytics developers to guide development, participate in code
reviews, to ensure technical and functional integrity of BI projects.
Training and Governance
Schedule and perform BI training sessions with the key business users.
Monitor progress and usage of the BI reporting tools across the
Work with business users to establish proper governance for creation,
publication and sharing of reports and dashboards.
Work with the VP, IT and BUs leads to design and implement the Data
Governance across the organization.
Provide leadership and direction to the Application Support and Data
Management team ensuring high level of engagement, motivation and innovation.
Identify opportunities to strengthen the capability of the BI practice
such as: mentoring employees, promoting technical developments, and building
Act as a positive role model and provide architectural expertise,
direction, and assistance to BI/analytics developers
Data Management Practices
Develop proficiency in the BI technologies, tools including but not
limited to BI (Power BI, Tableau etc.), ETL (SSIS) and RDBMS (MS SQL, Azure SQL
Stay current in BI industry and business trend through attending
networking events, individual learning and participation in BI webinar and
Identify and research relevant technologies, perform Proof of Concepts
(POC), prototypes, reviewing and recommending technology trends.
Develop, implement and maintain best practices and standard for delivery
of quality BI solutions.
Document business and technology roadmaps for the Data Management team.
The work experience, skills, education that you
Engineering or Computer Science undergrad degree, at a minimum
and verbal communication skills,
interpersonal and collaborative skills, with the ability to communicate
information security and risk-related concepts to technical and nontechnical
audiences at various hierarchical levels
understanding of relevant legal and regulatory requirements such as OSFI, OSC
years of experience in BI projects including 5+ years as a Solutions
Architect in BI/Analytics
building reports through a web-based environment
training uses in BI tools
years of experience building Functional and Technical specifications for
presentation skills, for all business user levels using technical and
SSIS, Visual Studio 2015 and above.
working knowledge of relational databases (MSSQL) and advanced SQL data
extraction and manipulation techniques.
knowledge of application testing phases and practices to align test data
strategy to testing phases and tools
Familiarity with Microsoft Azure technologies.
of converting business and technical risks into actionable tactical tasks
working with and managing policies, procedures, standards and guidelines
related to data management
knowledge of data privacy and data
An agile, boutique residential mortgage lender with the experience, the character and the commitment to excellence required in Canada’s evolving real estate market. XMC is proudly owned by MCAN Mortgage Corporation, a federally regulated mortgage investment corporation. Our team is 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. We’re all about team, how we can make contributions, and our own self development. If you’re excited about connecting - so are we!
MCAN is a niche-strategic investor in the Canadian real estate market focused on three key areas: single-family mortgages, residential construction loans, and other real estate investments. Our targeted approach to growth reflects our expertise and understanding of the needs of investors, clients, partners and the markets in which we invest.
Our people are our best asset - the kind of people you want on your team: smart, collaborative and helpful with a friendly, positive attitude. We are committed to building the company and building team member capabilities. Do you possess and value the same attributes? Are you interested in your own development? Then come join our team!
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.
MCAN is committed to providing accommodation to applicants throughout the job application and interview process. If you require any accommodations, please contact our Human Resources team at 416 847 2461
- Pay Type Salary
- Employment Indicator Perm FT
- Toronto, ON, Canada