The opportunity
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 Look For
What We Offer
Benefits
- 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
Diversity and Inclusion at EY
If you can demonstrate that you meet the criteria above, please contact us as soon as possible. The Exceptional EY Experience. It's Yours To Build. EY | Building a better working world
