Data Architect, Los Angeles

Join to apply for the
Data Architect
role at
EY
.
Be among the first 25 applicants.
At EY, we're all in to shape your future with confidence.
We'll help you succeed in a globally connected powerhouse of diverse teams and take your career wherever you want it to go.
Join EY and help to build a better working world.
The opportunity
EY is a global leader in assurance, tax, transaction and advisory services.
Technology is at the heart of what we do and deliver at EY.
Technology solutions are integrated in the client services we deliver and are key to our innovation as an organization.
Fueled by strategic investment in technology and innovation, Client Technology seeks to drive growth opportunities and solve complex business problems for our clients through building a robust platform for business and powerful product engine that are vital to innovation at scale.
As part of Client Technology, you'll work with technologists and business experts, blending EY's deep industry knowledge and innovative ideas with our platforms, capabilities, and technical expertise.
As a catalyst for change and growth, you'll be at the forefront of integrating emerging technologies from AI to Data Analytics into every corner of what we do at EY.
That means more growth for you, exciting learning opportunities, career choices, and the chance to make a real impact.
The selected candidate
Hands-on with design and implementation of scalable data pipelines, ETL processes, and data warehousing solutions aligned with Azure Well-Architected Framework pillars
Accountable for a suite of data models with relatively high complexity, leveraging strong understanding of data modelling standards to ensure high quality
Drive best practices for data security, data privacy, and data integrity
Ensure reliability and efficiency of data infrastructure in the Azure cloud
Understanding of AI-driven data engineering tools; build cutting-edge AI-driven use cases and ensure availability of AI-ready data
Work with other departments across the business to help define and deliver business value, and interface and communicate with program teams, management, and stakeholders to deliver large, complex projects
Your Key Responsibilities Include
Lead production of high-quality data engineering deliverables, ensuring project timelines are met, and provide informal mentoring/training to junior team members
Lead design, development and implementation of processes to extract, transform and load data from disparate sources into a consumable form for analytics
Develop and define future state data architectures aligned with industry best practices and organizational needs
Proficient in designing Data Architecture strategy, developing data architecture for modern data platforms, assessing enterprise existing data architecture and devising recommendations
Lead translation of requirements, design and solution architecture deliverables into detailed design specifications
Define and implement data management strategies aligned with business objectives
Lead delivery of data quality reviews, including cleansing to ensure integrity and quality
Evaluate and resolve issues regarding data quality reviews, cleansing, data integration and migration, leveraging advanced technical knowledge and showing technical leadership while driving continuous improvement
Provide leadership for the work group, ensuring appropriate expectations, principles, structures, tools, and responsibilities are in place to deliver the project
Analyze the latest industry trends such as cloud computing and distributed processing and infer potential impact on businesses (short and long-term)
Provide advanced technical expertise to maximize efficiency, reliability and value from current data engineering processes; research and monitor existing client base and industry developments to identify potential new product opportunities from emerging technologies
Develop strong working relationships with peers across engineering, collaborating to develop leading data engineering solutions
Drive adherence to relevant data engineering and data modeling processes, procedures, standards, and input into definition, maintenance and implementation of technology standards
Skills And Attributes For Success
Data Architecture: Ability to design and implement solutions leveraging Azure Well-Architected Framework pillars (Cost Optimization, Operational Excellence, Performance Efficiency, Reliability and Security)
Infrastructure Architecture Diagrams: Ability to create and deliver Azure Infrastructure Architecture Diagrams that visually represent data solution architecture and align with best practices
Data Extraction: Capability to design efficient extraction of high-volume structured and unstructured data with automated CDC capability
Data Ingestion: Capability to design efficient ingestion strategy for batch and stream processing of all data sources
Data Processing: Capability to design and implement models, capabilities and solutions for data validation, quality, profiling, etc.
Data Modeling: Capability to design, develop and produce complex data models with strong understanding of data modelling standards
Data Store: Capability to design data storage models, storage requirements and migration of data from one system to another
Data Consumption: Capability to design data consumption mechanisms with APIs, virtualization and visualization tools
Data Governance: Capability to design governance mechanisms including data catalog, lineage, classification, MDM, exploration
Data Security: Ability to design and implement authentication and authorization methods to ensure data security
Data Integration: Develop and manage data integration strategies, including ETL processes, to ensure seamless data flow and accessibility across systems
Required Technical Skills
Hands-on experience in building Data Architecture using patterns such as Data Mesh, Data Fabric, Data Lakehouse, Data Observability & Data as a Service (DaaS)
Proficiency in Azure services (e.g., Azure Data Lake, Azure SQL Database, Azure Synapse Analytics) to build scalable and efficient data solutions
Experience building data orchestration through Azure Data Factory, Function App, Logic App
Proficiency in SQL and familiarity with Python and Java
Extensive experience on Databricks performance optimization (data ingestion, transformation and consumption areas)
Experience designing and building Data Platforms integrating disparate data sources
Experience designing and developing authentication and authorization methods to ensure data security
Expertise in working with MPP designs to accelerate performance of large data warehouses
Expertise in Azure, Azure Data Bricks, Azure SQL, Spark
Expertise developing dataflows using NiFi/ADF, Databricks
Advanced hands-on design and implementation experience of large analytic warehouse
Advanced hands-on experience in Spark architecture and implementation using various methods
Experience with distributed message systems like Kafka
Hands-on experience in Python, PySpark or R
Expert in creating and analyzing complex SQL queries and procedures
Understanding of big data and distributed architecture
Experience creating ingestion workflows using Oozie or similar tools
Knowledge of security measures like HTTPS and Kerberos
Beneficial Technical Skills
Azure Data Lake Store, Databricks Delta Lakes
Experience using NoSQL databases
Advanced Analytics, ML and AI
Knowledge in Graph Databases, preferably Neo4J, Cypher and CosmosDB
Experience developing Microservices
Education
B.E./M.S. Computer Science, Data Analytics, Data Science, Engineering, IT, or related field preferred
Big Data Certification from Cloudera, Hortonworks or Databricks
What We Look For
Strong analytical skills and problem-solving ability
A self-starter, independent thinker, curious and creative person with ambition and passion
Excellent interpersonal, communication, collaboration, and presentation skills
Customer focused
Excellent time management skills
Positive and constructive minded
Takes responsibility for continuous self-learning
Takes the lead and makes decisions in critical times and tough circumstances
Attention to detail
High levels of integrity and honesty
What We Offer You
We offer a comprehensive compensation and benefits package where you'll be rewarded based on performance and recognized for the value you bring to the business.
The base salary range for this job in all geographic locations in the US is $145,500 to $280,000.
The base salary range for New York City Metro Area, Washington State and California (excluding Sacramento) is $174,500 to $318,200.
Individual salaries within those ranges are determined through a wide variety of factors including education, experience, knowledge, skills and geography.
In addition, our Total Rewards package includes medical and dental coverage, pension and 401(k) plans, and a wide range of paid time off options.
Join us in our team-led and leader-enabled hybrid model.
Our expectation is for most people in external, client serving roles to work together in person *****% of the time over the course of an engagement, project or year.
Under our flexible vacation policy, you'll decide how much vacation time you need based on your own personal circumstances.
You'll also be granted time off for designated EY Paid Holidays, Winter/Summer breaks, Personal/Family Care, and other leaves of absence when needed to support your physical, financial and emotional well-being.