Staff Architect, Data Engineer

Location:
22 St. Clair Avenue East, Toronto, Ontario, M4T 2S5

Reporting to the Director, Information Management, the Staff Data Engineer will play a pivotal role in expanding the Choice's use of data as a strategic enabler of organizational goals and objectives while ensuring high levels of data quality. The Staff Data Engineer is responsible for the design, development and implementation of database structure, system level data architecture, governance and processes, and tools across multiple data types. This individual will act as the primary advocate of data modeling methodologies and enterprise-level best practices.

Responsibilities

• Develop and maintain a comprehensive data architecture that includes conceptual, logical, and physical data models for various data domains, ensuring alignment with business requirements and data governance principles.

• Oversee the design and implementation of data integration pipelines to ingest, transform, and load data from various sources into the data lake/warehouse, and ensure pipelines are optimized for performance, scalability, and reliability.

• Collaborate with the Staff Architect, Information Management to assess, identify and prioritize areas of data quality improvement and opportunities for data quality monitoring to improve data accuracy, completeness, and consistency.

• Support the development and maintenance of data dictionaries, glossaries, and other data documentation to promote data understanding and accessibility.

• Collaborate with external data engineers to implement and maintain data governance tools and processes within the data architecture.

• Work closely with business stakeholders to understand their data needs for reports, forms, queries and data extraction, and translate them into technical requirements.

• Collaborate with technical teams (e.g., developers, DBAs) to ensure seamless integration of data solutions with existing systems.

• Ensure the stability and reliability of data access and data quality across the organization via ongoing database monitoring, support and maintenance.

• Develop and deploy end-user practices and tools for data extraction, queries, and data manipulation in accordance with business processes.

Qualifications

• Bachelor's degree in computer science, data engineering, information technology, or a related field together with 8 years related work experience.

• Proven technical experience in building, installing, configuring, supporting, assessing and enhancing data lakes and systems.

• Hands on experience with data architecting, large-scale data modeling, and business requirements gathering/analysis.

• Experience working with cloud-based data warehousing platforms such as Synapse, Snowflake, Databricks or similar.

• Proficiency in SQL and other query languages; familiarity with Python or R is a plus.

• Ability to act as a primary resource on major technical data modeling projects.

• Strong understanding of data engineering theories, principles, and best practices, and strategies for improving data quality.

• Experience in creating comprehensive technical documentation and documenting processes, including proficiency with data processing flowcharting techniques.

• Hands-on experience with data migration, integration, and optimization projects.

• Proficiency in performing meticulous peer code reviews to ensure high-quality code and adherence to best practices.

• Exceptional ability to ensure that technical solutions meet scalability, performance, and security requirements.

• Familiarity with project management concepts.

• Strong collaboration skills, especially with third-party resources for technical architecture design and development.

• Strong analytical, conceptual and troubleshooting skills to efficiently resolve technical issues.

• Ability to communicate complex technical concepts in user-friendly language.

• Willingness to support team members, fostering internal expertise and reducing reliance on external resources.

• Ability to communicate effectively with technical and non-technical audiences, explaining complex data concepts in clear and concise business terms.

About Choice Properties

Choice Properties Real Estate Investment Trust is an owner, manager and developer of well-located retail and commercial real estate across Canada. Choice Properties' portfolio spans approximately 65 million square feet of gross leasable area and consists of over 700 properties primarily focused on supermarket-anchored shopping centers.

Choice Properties' strategy is to create value by enhancing and optimizing its portfolio through high quality transactions, strategic development and active property management. We mainly focus on necessity-based retail, and high-quality industrial and mixed-use assets. In particular, we have a strategic relationship with Loblaw, our largest tenant, that provides us with access to high quality investment opportunities.

Our established operating platform with a proven track record of success also provides us with access to a transformational development pipeline that we believe supports superior long-term value creation and growth. A commitment to continuous learning and development is a strong part of our culture.

Choice Properties REIT recognizes Canada's diversity as a source of national pride and strength. We have made it a priority to reflect our nation's evolving diversity in the people we hire, and the culture we create in our organization. Accommodation is available upon request for applicants and employees with disabilities.

In addition, we believe that compliance with laws is about doing the right thing. Upholding the law is part of our Code of Conduct - it reinforces what our customers and stakeholders expect of us.

Number of Openings:
1

Please Note: If you have Employee Self Service (ESS) on Workday, apply to this job via the Workday application.