Data Engineer - Senior

EY; Bengaluru Urban; On-site; INR 1,400,000 - 2,100,000; Full time

Job summary

EY is seeking a Data Engineer to join the Technology Assurance team in Bengaluru. You will design and implement data solutions using SSIS/SSAS/SSRS, build ETL/ELT pipelines, and leverage Power BI for analytics.

You’ll work with cross-functional teams, contribute to data warehousing efforts, and help improve data platforms and reporting capabilities. The role requires 4+ years of experience, strong SQL/Python skills, and familiarity with Azure Data Factory/Synapse.

Qualifications

• 4+ years in designing and implementing end-to-end data solutions using big data tech.
• Proven expertise in SSIS/SSAS/SSRS and Power BI with business requirements-based architectures.
• Proficiency in Python, SQL, or similar languages for data engineering tasks.
• Experience with data extraction, transformation, and pipelines using Azure tools.
• Familiarity with CI/CD and version control (Git) and project management (JIRA).
• Knowledge of data warehousing concepts and both SQL and NoSQL storage design.

Responsibilities

• Design and implement data solutions using SSIS/SSAS/SSRS and Power BI.
• Develop and maintain ETL/ELT pipelines ensuring data quality and performance.
• Collaborate with audits, IT security, and stakeholders to assess control effectiveness.
• Build dashboards and reports, and optimize SQL queries for speed.
• Evaluate and integrate new data platforms, internal and external sources.
• Contribute to data warehouse design and modeling for SQL and NoSQL stores.

Skills

SSIS

SSAS

SSRS

Power BI

SQL

ETL/ELT pipelines

Data warehousing

Azure Data Factory

Synapse Analytics

Python

Git

JIRA

Azure DevOps

CI/CD

Tableau/Spotfire

Big Data concepts

Education

Bachelor's degree in mathematics, information systems, statistics, computer science

Tools

Azure Data Factory

Azure Synapse Analytics

SQL Server

SSIS

SSAS

SSRS

Power BI

Python

Git

JIRA

Azure DevOps

CI/CD

Job description

Job Description:

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.

Job Description of Data Engineer

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.

Data Engineer – Technology Assurance

As Risk Assurance Senior, you’ll contribute technically to Risk Assurance client engagements and internal projects. An important part of your role will be to assist fellow Seniors & Managers while actively participating within the client engagement Similarly, you’ll anticipate and identify risks within engagements and share any issues with senior members of the team. In line with EY commitment to quality, you’ll confirm that work is of high quality and is reviewed by the next-level reviewer. As a member of the team, you’ll help to create a positive learning culture and assist fellow team members while delivering an assignment.

The opportunity

We’re looking for professional having at least 4 years or more of experience. You’ll be part of a cross-functional team that’s responsible for the full software development life cycle, from conception to deployment. This is a fantastic opportunity to be part of a leading firm whilst being instrumental in the growth of a new service offering.

Skills and Summary of Accountabilities:

• Designing, architecting, and implementing data solutions using Microsoft SQL Server Integration Services (SSIS) to efficiently process and analyze large, complex data sets, meeting, and exceeding business requirements.
• Proficiency in developing and maintaining SQL Server Analysis Services (SSAS) models, including tabular and multidimensional, to support advanced analytics and reporting.
• Expertise in creating, deploying, and managing ETL/ELT pipelines with SSIS and SSAS, ensuring data accuracy and integrity for data warehousing solutions.
• Experience with SQL Server Reporting Services (SSRS) for the development of interactive, tabular, graphical, or free-form reports from relational, multidimensional, or XML-based data sources.
• Proficient in leveraging Power BI for data visualization and business intelligence, creating dashboards and reports that provide actionable insights to stakeholders.
• Strong understanding of data warehousing and modelling concepts, with the ability to design and optimize data storage for both SQL and NoSQL database technologies.
• Evaluating and implementing distributed storage, parallel processing, and advanced query techniques to enhance data retrieval and analysis performance.
• Recommending and building new data platforms and solutions as required, utilizing in-house data platforms, and integrating with external data sources to fulfil business needs.
• Excellent communication skills to convey findings, recommendations, and opportunities to improve data systems and solutions to both technical and non-technical audiences.
• Exposure working in client facing roles, collaborate with cross functional teams including internal audits, IT security and business stakeholders to assess control effectiveness and facilitate remediation activities.
• Good to have experience in IT Controls, Risk and Compliance.
  • Testing of internal controls such as IT general controls, IT application controls, IPE related controls, interface controls etc.
  • Design IT Risk Controls framework such as IT SOX.

To qualify for the role, you must have.

• A minimum of 4 years of experience in designing and implementing end-to-end business solutions using Big Data technologies and data engineering practices.
• Demonstrated expertise in Microsoft SQL Server Integration Services (SSIS), Analysis Services (SSAS), Reporting Services (SSRS), and Power BI, with a proven track record of planning and architecting solutions based on business requirements using optimized techniques.
• Proficiency with Logic Apps, complex stored procedures, and triggers, as well as experience in managing event handlers in SSIS, and implementing audit and configuration logs to monitor package status.
• Competency in at least one programming language relevant to data engineering, such as Python, SQL, R, or Scala, with a preference for candidates proficient in multiple languages.
• Strong knowledge of SQL for data manipulation and reporting, with the ability to create insightful reports in Power BI and SSRS.
• Expertise in optimizing SQL queries for improved execution speed and efficiency.
• A preferred knowledge in data extraction, transformation, and the development of data pipelines using Azure Data Factory/Synapse Analytics.
• Familiarity with additional BI tools such as Spotfire or Tableau is advantageous.
• A solid understanding of version control systems like Git, as well as experience with JIRA for issue tracking, change/release management, and familiarity with CI/CD practices using Azure DevOps.

Ideally, youll also have

• Bachelors Degree or above in mathematics, information systems, statistics, computer science, or related disciplines.
• Relevant certifications are considered a plus.
• Experience with AI/ML is a plus.
• Provide high quality client services by directing daily progress of engagement work, informing engagement manager of engagement status, and managing staff performance.
• Ability to communicate clearly and concisely and use strong writing and verbal skills to communicate facts, figures, and ideas to others.

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.