Senior Manager - Data Architect - Toronto [Ernst & Young]

At EY, you'll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture and technology to become the best version of you. And we're counting on your unique voice and perspective to help EY become even better, too. Join us and build an exceptional experience for yourself, and a better working world for all.

The opportunity

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

• 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
• Support implementation processes in association with internal and external development teams. Participate in project-related activities.
• Lead discovery sessions with primary business stakeholders to obtain knowledge of business objectives, challenges, and requirements
• Stay current on emergent technologies relevant to supporting the data solutions delivered for customers
• Present and socialize proposed solutions to technical boards during review sessions as well as articulate and communicate designs to stakeholder groups
• 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)
• Assume responsibility for the quality of the implemented solution and its adherence to technology strategies, standards, and best practices
• Support the identification of opportunities for continuous improvement of solution management methodologies, including obtaining feedback after the solution has been implemented
• Support solution delivery by providing insights to the application development teams and project managers that plan and execute delivery activities
• Create solution architecture documents that describe and explain solution attributes and associated benefits

To Qualify For The Role You Must Have

• Strong analytical and decision-making skills.
• Demonstrated experience deploying data solutions in Big Data platforms (e.g., AWS, Azure, GCP, etc.).
• Strong Knowledge of ETL frameworks using Azure Data Factory and Databricks Notebooks.
• 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
• 10+ years demonstrated experience in the design and implementation of modern data architectures to support large scale data solutions
• Bachelor's degree in Information Technology, Software Engineering, Computer Science, or related field. Related professional certifications and/or training is considered an asset.
• 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.
• 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.
• Experience working within multidisciplinary, distributed, and collaborative environments.
• Strong knowledge of data governance framework principles and vendor platforms (e.g., Collibra, Informatica EDC/Axon)
• Knowledge of MDM concepts and solutions
• Proficient in building secure architecture using: Encryption, Azure key vault, Access control, Network security, and Advanced data security.
• Strong knowledge of SQL and demonstrated ability to apply SQL to a wide variety of business requirements.
• Experience with data manipulation and visualization tools such as Tableau, Power BI, etc.

What We Look For

We're interested in passionate leaders with a strong vision and a desire to stay on top of trends in the IT Advisory space. If you have a strong passion for helping businesses achieve their IT strategy, this role is for you.

What We Offer

At EY, our Total Rewards package supports our commitment to creating a leading people culture - built on high-performance teaming - where everyone can achieve their potential and contribute to building a better working world for our people, our clients and our communities. It's one of the many reasons we repeatedly win awards for being a great place to work.

Plus, 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.

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

Diversity and Inclusion at EY

Diversity and inclusiveness are at the heart of who we are and how we work. We're committed to fostering an environment where differences are valued, policies and practices are equitable, and our people feel a sense of belonging. From our actions to combat systemic racism and our advocacy for the LGBT+ community to our innovative Neurodiversity Centre of Excellence and Accessibility initiatives, we welcome and embrace the diverse experiences, abilities, backgrounds and perspectives that make our people unique and help guide us. Because when people feel free to be their authentic selves at work, they bring their best and are empowered to build a better working world.

EY | Building a better working world 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. Enabled by data and technology, diverse EY teams in over 150 countries provide trust through assurance and help clients grow, transform and operate. Working across assurance, consulting, law, strategy, tax and transactions, EY teams ask better questions to find new answers for the complex issues facing our world today.