EY AI Data - Architect 

Canada, Ontario, Toronto 

925719873

We are seeking an experienced Data Architect that can translate business strategies and requirements into world-class technical solutions, applications, and process designs. The role assumes the responsibility for all technical aspects of solution delivery, from inception through design to implementation. They will conduct regular detailed solution analysis and provide expert judgment pertaining to highly complex technical issues including all aspects related to development, infrastructure, data, and configuration management perspectives. This role requires a rare blend of skills normally found in the specialized roles of Cloud Architect, Data Analyst, Data Engineer and Reporting Specialist. The Data Architect will also assist in the establishment and enforcement of architectural standards and best practices to ensure consistency in data solutions delivery across development teams.

Your key responsibilities:

• Lead and provide oversight into the design of end-to-end data solutions including data architecture, data integration, data modelling, security, privacy, regulatory, performance, data governance, business intelligence, etc. and to ensure alignment to the overall business needs
• Provide technical oversight and recommendations on data infrastructure (on-prem and Cloud)
• Lead discovery sessions with primary business stakeholders to obtain knowledge of business objectives, challenges, and requirements
• Present and socialize proposed solutions to technical boards during review sessions as well as articulate and communicate designs to stakeholder groups
• Support solution delivery by providing insights to the application development teams and project managers that plan and execute delivery activities
• Support implementation processes in association with internal and external development teams. Participate in project-related activities.
• Assume responsibility for the quality of the implemented solution and its adherence to technology strategies, standards, and best practices
• Create solution architecture documents that describe and explain solution attributes and associated benefits
• Stay current on emergent technologies relevant to supporting the data solutions delivered for customers
• Support the identification of opportunities for continuous improvement of solution management methodologies, including obtaining feedback after the solution has been implemented
• Assist in the identification and recommendation of appropriate solutions, upgrades, replacements, or decommissioning options incorporating business and technology productivity, usability, and total cost of ownership

To qualify for the role you must have:

• Bachelor’s degree in Information Technology, Software Engineering, Computer Science, or related field. Related professional certifications and/or training is considered an asset.
• 10+ years demonstrated experience in the design and implementation of modern data architectures to support large scale data solutions
• Expert knowledge of data patterns to support architectures and data management concepts/processes including ETL/ELT, Data Mesh, date lake, data lakehouse, data warehouse, data streaming, data virtualization, etc.
• Strong understanding of data modeling (dimensional, data vault, etc.) principles and techniques based on established methodologies (e.g., Kimball).
• Strong knowledge of ETL tools such as Informatica, SSIS, Talend, DataStage, etc. as well as standards and best practices for ETL development
• Strong knowledge of data governance framework principles and vendor platforms (e.g., Collibra, Informatica EDC/Axon)
• Experience with data manipulation and visualization tools such as Tableau, Power BI, etc.
• Strong knowledge of SQL and demonstrated ability to apply SQL to a wide variety of business requirements.
• Strong Knowledge of ETL frameworks using Azure Data Factory and Databricks Notebooks.
• Strong knowledge in data warehousing concepts and data platforms (e.g., Snowflake, Databricks)
• Strong knowledge of Azure-based architecture and services such as RBAC, AAD, VM, ADLS, Azure DevOps, and Events hub.
• Proficient in building secure architecture using: Encryption, Azure key vault, Access control, Network security, and Advanced data security.
• Knowledge of MDM concepts and solutions
• Demonstrated experience deploying data solutions in Big Data platforms (e.g., AWS, Azure, GCP, etc.).
• Strong analytical and decision-making skills.
• Experience working within multidisciplinary, distributed, and collaborative environments.

What we offer

We offer a competitive compensation package where you’ll be rewarded based on your performance and recognized for the value you bring to our business. In addition, our Total Rewards package allows you decide which benefits are right for you and which ones help you create a solid foundation for your future. Our Total Rewards package includes a comprehensive medical, prescription drug and dental coverage, a defined contribution pension plan, a great vacation policy plus firm paid days that allow you to enjoy longer long weekends throughout the year, statutory holidays and paid personal days (based on province of residence), and a range of exciting programs and benefits designed to support your physical, financial and social well-being. Plus, we offer:

• Support and coaching from some of the most engaging colleagues in the industry
• Learning opportunities to develop new skills and progress your career
• The freedom and flexibility to handle your role in a way that’s right for you

If you can demonstrate that you meet the criteria above, please contact us as soon as possible.

EY exists to build a better working world, helping to create long-term value for clients, people and society and build trust in the capital markets.