AI and Data - Data Architect (Snowflake)

Ottawa 13 hours agoFull-time External
Negotiable
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. 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 Snowflake Data Architects for our AI & Data practice team. We are looking for a candidate with strong technical leadership and experience to translate and deliver business needs into secure scalable solutions and architectures for the Snowflake data platform. Your Key Responsibilities Snowflake: Lead solution architecture for Snowflake-based projectsDesign or review logical and physical data models to support analytics, AML, reporting, and AI use casesDefine ingestion patterns (e.g., batch, streaming, file-based)Design data storage layers (e.g., raw, curated, consumption)Define security architecture (e.g., roles, RBAC, masking, row access policies)Design data sharing (e.g., secure views, shares, inter-account patterns)Establish data quality controls (e.g., validation rules, control totals, reconciliation)Develop cost monitoring/telemetry/governance (e.g., warehouse sizing, auto suspend, usage monitoring)Produce architecture artifacts (e.g., diagrams, standards)Lead technical reviewsEnforce standards (e.g., reference architecture) across teams Core: Lead and facilitate data architecture assessments, workshops, and strategy sessions with clients to understand business goals, challenges, and opportunitiesDefine and develop enterprise data strategies, roadmaps, and architectures aligned with clients' business objectives, regulatory requirements, and industry best practicesDesign and architect scalable and extensible end-to-end data management solutions encompassing:data warehouses and data lakes, to support business analytics, reporting, and machine learning use casestarget state and reference architecturesconceptual, logical, and physical data models and graph data modeling to represent business entities, relationships, and processesdata integration patterns for batch/streaming pipelinesmaster data managementdata governanceDevelop and maintain data standards, guidelines, and best practices for data management and governanceCollaborate with business stakeholders, data scientists, and data engineers to define data requirements, source data integration strategies, and data quality standardsEvaluate and recommend data technologies, platforms, and tools, such as cloud data services and data management solutions to meet client needs and requirementsProvide technical leadership and guidance to project teams, including data architects, data engineers, and developers, to ensure alignment with architectural principles, design patterns, and best practicesConduct data architecture reviews, assessments, and audits to assess compliance with architectural standards, identify gaps, and recommend remediation actionsDevelop and deliver client presentations, executive briefings, and thought leadership content on data architecture trends, technologies, and best practicesMentor junior team members, provide coaching and support, and contribute to the professional development and growth of data architect capabilities within the practiceBuild valuable relationships both within EY and with clients To qualify for the role, you must have Bachelor’s degree in computer science, mathematics, data science, informatics, engineering, or a related field8+ years in data architecture or data engineering roles3+ years designing and developing on SnowflakeSnowflake SnowPro Core CertificationStrong SQL skillsBroad and deep demonstrated knowledge of Snowflake featuresDemonstrated experience with cloud platforms (AWS, Azure, GCP)Strong background in analytical data modeling including dimensional and Data Vault methodologiesProven experience delivering end-to-end enterprise data and solution architectures including data warehouses and data lakes to support analytics and machine learningDemonstrated experience architecting scalable data pipelines across batch and streaming patternsDemonstrated experience integrating data management capabilities including MDM, metadata, and data qualityDemonstrated experience embedding security, privacy, and governance controls into data platformsStrong communication (oral and written) Ideal Certifications Snowflake SnowPro Advanced ArchitectAWS Certified Solutions Architect (Associate or Professional)Azure Solutions Architect Expert 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. 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 industryLearning opportunities to develop new skills and progress your careerThe freedom and flexibility to handle your role in a way that’s right for you Toronto - $110000 to $160000 Are you ready to shape your future with confidence? Apply today. To help create the best experience during the recruitment process, please describe any accommodations you may need. Inclusiveness at EY Inclusiveness is 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. We embrace diversity and are committed to combating systemic racism, advancing gender equity and women in leadership, advocating for the 2SLGBTQIA+ community, promoting our neuroinclusion and accessibility initiatives, and are dedicated to amplifying the voices of Indigenous peoples (First Nations, Inuit, and Métis) nationally as we strive towards reconciliation. Our diverse experiences, abilities, backgrounds, and perspectives 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. Learn about our commitment to Inclusiveness at https://www.ey.com/en_ca/about-us/corporate-responsibility/equity EY | Building a better working world EY is building a better working world by creating new value for clients, people, society and the planet, while building trust in capital markets. Enabled by data, AI and advanced technology, EY teams help clients shape the future with confidence and develop answers for the most pressing issues of today and tomorrow. EY teams work across a full spectrum of services in assurance, consulting, tax, strategy and transactions. Fueled by sector insights, a globally connected, multi-disciplinary network and diverse ecosystem partners, EY teams can provide services in more than 150 countries and territories. At EY, we use artificial intelligence (AI) tools as one element of our recruitment process to enhance efficiency and improve the candidate experience. While AI supports us in our process, human judgment and decision-making remain integral in our candidate experience. We are committed to the responsible use of AI, and our practices are continuously reviewed and refined to ensure they align with the highest ethical principles and regulatory requirements. To all recruitment agencies: EY does not accept unsolicited resumes from recruitment agencies. Any resumes submitted without a prior agreement or request from our hiring team will not be considered. EY is not responsible for any fees related to unsolicited resumes. 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.