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.

EY GDS – Data and Analytics (D and A) – Data Modeller and Teradata Developer

As part of our EY-GDS D&A (Data and Analytics) team, we help our clients solve complex business challenges with the help of data and technology. We dive deep into data to extract the greatest value and discover opportunities in key business and functions like Banking, Insurance, Manufacturing, Healthcare, Retail, Manufacturing and Auto, Supply Chain, and Finance.

The o pportunity

• We’re looking for candidates with strong technology and data understanding in big data engineering space, having proven delivery capability. This is a fantastic opportunity to be part of a leading firm as well as a part of a growing Data and Analytics team.

Your key responsibilities

• Develop conceptual, logical, and physical data models, the implementation of RDBMS, operational data store (ODS), data marts, and data lakes on target platforms (SQL/NoSQL).
• Specify, demonstrate, and scope Teradata solutions that deliver business value to the client / prospect.
• Interact with senior leaders, understand their business goals, contribute to the delivery of the workstreams
• Design and optimize model codes for faster execution

To qualify for the role, you must have

• Hands on experience on any one of the data modelling tools.
• Oversee and govern the expansion of existing data architecture and the optimization of data query performance via best practices. The candidate must be able to work independently and collaboratively.
• Define and govern data modelling and design standards, tools, best practices, and related development for enterprise data models.
• Hands-on Experience as a Teradata Developer using BTEQ scripting and Teradata utilities such as multi load and fast load.
• Should have expertise working on queries and complex joins, tune the complex queries.
• Understand requirements and convert them to Teradata scripts using complex SQLs.
• Understanding of workload management on Teradata systems to minimize impact of mixed workloads, optimization of BTEQ/SQL Queries in a complex environment
• Help establish processes, procedures, and best practices for writing SQLs.
• Working knowledge of Unix and Shell scripting
• Strong analytical and problem-solving skills
• Agile Software Development.
• Conduct unit testing and troubleshooting
• Evaluate and improve existing Teradata systems
• Collaborate with teams to integrate systems
• Develop and execute database queries and conduct analyses
• In depth knowledge of data warehouse tools and technologies.
• Experience with Data Mapping and Modelling
• Experience with Data Analytics tools
• Strong verbal and written communications skills are a must

Ideally, you’ll also have

• Client management skills

What we look for

• People with technical experience and enthusiasm to learn new things in this fast-moving environment

What working at EY offers

At EY, we’re dedicated to helping our clients, from start–ups to Fortune 500 companies — and the work we do with them is as varied as they are.

You get to work with inspiring and meaningful projects. Our focus is education and coaching alongside practical experience to ensure your personal development. We value our employees and you will be able to control your own development with an individual progression plan. You will quickly grow into a responsible role with challenging and stimulating assignments. Moreover, you will be part of an interdisciplinary environment that emphasizes high quality and knowledge exchange. Plus, we offer:

• Support, coaching and feedback from some of the most engaging colleagues around
• 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

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.