EY GDS Consulting AI And DATA Snowflake Data engineer Senior- E
Share
Job Location:
Monthly Salary:
Posted on:
30+ days ago
Vacancies:
1 Vacancy
Job Summary
At EY youll 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 were 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.
Job Description Snowflake Data Engineer
Objectives and Purpose
- The Senior Data Engineer ingests builds and supports large-scale data architectures that serve multiple downstream systems and business users. This individual supports the Data Engineer Leads and partners with Visualization on data quality and troubleshooting needs.
- The Senior Data Engineer will:
- Clean aggregate and organize data from disparate sources and transfer it to data warehouses.
- Support development testing and maintenance of data pipelines and platforms to enable data quality to be utilized within business dashboards and tools.
- Create maintain and support the data platform and infrastructure that enables the analytics front-end; this includes the testing maintenance construction and development of architectures such as high-volume large-scale data processing and databases with proper verification and validation processes.
Your key responsibilities
- Design build and optimize scalable data pipelines and ETL/ELT processes to ingest transform and load data into Snowflake.
- Develop and maintain Snowflake data warehouse solutions including schema design performance tuning and security implementation.
- Integrate data from diverse sources (structured semi-structured unstructured) such as databases APIs CSV XML JSON etc.
- Implement best practices for Snowflake features such as virtual warehouses clustering time travel zero-copy cloning and data sharing.
- LeverageSnowflakes advanced features(e.g. materialized views result caching query acceleration services) to improve query performance and reduce costs.
- Collaborate with business users to understand requirements and deliver high-quality reliable datasets for reporting and analytics.
- Work with AWS services such as Glue S3 Redshift Lambda IAM and CloudWatch to support data workflows.
- Ensure data governance quality and compliance across all pipelines.
- Implement and manageSnowflake security featuressuch as RBAC (Role-Based Access Control) data masking and row-level security to ensure compliance with organizational and regulatory requirements.
- Automate monitoring logging and alerting for data processes.
- Participate in code reviews architecture discussions and continuous process improvements.
Required Skills & Qualifications
- Bachelors degree in engineering Computer Science Data Science or related field.
- 5 years of experience in data engineering with strong focus on cloud data warehouses.
- Proven track record of designing and implementing complex data solutions.
- Hands-on expertise in Snowflake (SQL SnowSQL tasks streams stored procedures performance tuning).
- Strong knowledge of SQL Python and ETL/ELT frameworks.
- Experience with AWS services (S3 Glue Lambda Redshift etc.).
- Familiarity with data modeling (3NF Star Schema Data Vault).
- Experience with orchestration tools such as Airflow DBT or Rundeck.
- Experience with CI/CD pipelines for data workflows.
- Solid understanding of data governance security and compliance best practices using Snowflake.
- Ability to troubleshoot and optimize SQL queries and Snowflake workloads.
Desired skillsets
- Exposure to BI/Visualization tools (Power BI Tableau Looker QuickSight).
- Knowledge of API integration and real-time data streaming (Kafka Kinesis).
- Understanding of DevOps concepts in data engineering.
- Pharmaceutical healthcare or financial industry domain knowledge is a plus.
- Snowflake Certification
- Any cloud certification (AWS/Azure)
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.
Required Experience:
Senior IC
Key Skills
- Apache Hive
- S3
- Hadoop
- Redshift
- Spark
- AWS
- Apache Pig
- NoSQL
- Big Data
- Data Warehouse
- Kafka
- Scala
About Company
Bij EY Studio+ creëren we transformatieve ervaringen die mensen in beweging brengen en markten vormgeven. We combineren design, technologie en commercieel inzicht, aangevuld met EY.ai, een verenigend platform en aangedreven door ons volledige spectrum van diensten.
