Data Analyst

QuadReal - Toronto, ON (30+ days ago)

Apply Now

About QuadReal

Headquartered in Vancouver, Canada, QuadReal Property Group is a global real estate investment, operating and development company. QuadReal manages the real estate and mortgage programs of British Columbia Investment Management Corporation (BCI), one of Canada’s largest asset managers with a $153.4 billion portfolio.

QuadReal manages a $37.6 billion portfolio spanning 23 Global Cities across 17 countries. The company seeks to deliver strong investment returns while creating sustainable environments that bring value to the people and communities it serves. Now and for generations to come.

QuadReal: Excellence lives here.

www.quadreal.com

Role Description:
The Data Management Office at QuadReal is a global function dedicated to producing, promoting, and supporting the availability of the quality information required to create data as a competitive advantage.

Reporting to the Enterprise Content Manager, the Data Analyst role is responsible for supporting the Data Management program by analyzing data and content across the enterprise, business functions, and within IT projects; and streamlining migration activities by providing technical capabilities to profile and automate enrichment of data, and report to the business, IT and Data Management teams. The Data Management Office is in a building phase and is seeking talent committed to innovation and change.

Key responsibilities of this role include collaborating with Data Management and IT to deliver timely analysis, reports and migration plans for content and data; supporting the business and technical teams throughout configurations, loads, and tests; liaising with vendors, training and supporting business and IT staff; supporting data management initiatives; participating as data representative in IT projects; and drafting and coaching on appropriate policies and standards.

Responsibilities:
Data and Content Analysis and Migration Preparation:
Working with data from multiple enterprise applications, including SharePoint, JD Edwards, MS Dynamics, and Yardi
Ability to extract business data rules from business people, through relationship and credibility building and explaining data to non-technical stakeholders
Providing data in consumable formats and automating data cleanup to the extent possible
Using analysis reporting tools to visualize project data
Building and testing the scripts to automate enrichment / remediation on data and metadata (using Python, Visual Basic, SQL, Excel, or similar)
May manage contract technical data analyst roles to augment for project work

Load Testing and Remediation:
Planning and executing QA activities throughout the load activities
Working with Business SMEs to build the migration mapping file / load sheets, including filling in the correct metadata, identifying gaps, and resolving data issues
Working with SharePoint Technical Specialist and Business Analysts to configure testing environments
Working with project teams to configure production environments

Production Migration and Maintenance:
Training and leading contractors/interns on analysis and migration activities to scale for large projects versions of themselves to scale for big projects
Ability to support multiple projects, prioritize and manage deliverables to stakeholders
Creating and designing documentation for solution configurations and migration automation
Supporting and monitoring migration to production
Supporting creation and delivery of end-user training
Processing and solving operational issues and requests in a ticketing system

Experience and Qualifications:
Bachelor’s degree in Computer Science, Engineering, or equivalent
1-3 years in technical or data analyst role
Proficient in building data wrangling and automation scripts using Python, Visual Basic, SQL, Excel, or similar
Experience with Data Visualisation, such as Power BI
Experience with defining and supporting data-cleansing initiatives
Ability to identify and remediate data issues through root cause analysis
Experience with enterprise content management platforms, such as SharePoint, M-Files, Content Server, or similar
Well-rounded skill set comprised of a blend of business and technical acumen
Must be able to effectively communicate with internal and external stakeholders
Demonstrated ability in technical and business writing, particularly process documentation
Collaboratively defining, documenting, and monitoring data quality rules, metrics and scorecards
Knowledge of Enterprise Content Management, Data Governance, Data Quality Management and Information Security principles
Customer-focused, team player with a desire to continuously improve current business practices/processes
Ability to see the big picture while defining and resolving details
Enthusiastic, self-starter that requires minimal direction and delivers with integrity

QuadReal Property Group will provide reasonable accommodation at any time throughout the hiring process for applicants with disabilities or for those needing job postings in an alternate format. If you require accommodation, please advise the Talent Acquisition team member you are working with and include the following: Job posting #, your name and your preferred method of contact.

Want to learn about our end-to-end recruitment process? Click this link for a short video that will take you through each step, so you’ll know exactly what to expect.