Associate - EDS - BI And Azure

EY; Ernakulam; On-site; INR 500,000 - 800,000; Full time

Job summary

A global professional services firm is seeking an Associate to join their EDS team in Ernakulam, Kerala. This role involves collaboration with various teams to analyze data, develop ETL processes, and create visualizations using Power BI and SQL. Candidates should have a bachelor’s degree and over one year of relevant experience. The position offers opportunities for professional growth and the chance to contribute to innovative data solutions. Join us to make a significant impact within the organization.

Qualifications

• More than 1 year of experience as a data analyst with exposure as a SSIS/ETL developer.
• Ability to read and interpret complex reports and documents.
• Proficient working knowledge of database applications necessary for visualization.

Responsibilities

• Collaborate with teams to understand business requirements.
• Create SSIS jobs to extract, transfer and load data.
• Participate in production support and code deployment.

Skills

Proficient in SQL

ETL/SSIS

Power BI

Data Analysis

Presentation skills

Education

Bachelor’s degree in a related field

Tools

SQL Server 2005/2008/2012 T-SQL

Excel Macros

Azure Data Factory

Job description

Join to apply for the Associate - EDS - BI And Azure role at EY

Position Details

Job Title: Associate - EDS

Job Purpose

As an Associate, you will collaborate with business, reporting, and other teams to understand business requirements and perform data analysis. Get involved in project transition from different teams, do enhancements, modifications and support post transition as needed. This opportunity will allow you to be instrumental in leading, designing, mentoring, and implementing our next generation of reporting and data analytic business solutions. You will work with back end data teams to construct data objects necessary for supporting business requirements. Additionally, you will:

• Create SSIS jobs to extract, transfer and load data, supporting and trouble‑shooting existing ETL processes using SSIS/ Azure data factory
• Analyse large sets of data and determine patterns and rules for organizing and prepare visualization dashboards using Spotfire/Power BI
• Analyse and create complex SQL and SSIS packages to support new and evolving data integration projects
• Learn and support Decisions sciences team on extracted data analysis using different analytics tools
• Coordinate development of ETL best practices needed to support new and evolving sources of data used in reporting, transaction processing and analytics
• Perform extensive and detailed data analysis necessary to ensure strict adherence to data quality
• Participate in production support and code deployment outside of regular business hours
• Take on end‑to‑end ownership and perform different roles within analysis and development phases
• Adhere to general work requirements and perform other duties as assigned

Client Responsibilities

• Proficient in SQL, ETL/SSIS, Power BI
• Ability to understand existing SQL code to determine business logic and create source‑to‑target mapping documents
• Proficient working knowledge of spreadsheet, database, presentation software, email, and specialized business applications necessary for visualization and data representation
• Ability to read and interpret complex reports and documents
• Experience in utilizing database concepts and applying SQL knowledge (data modelling, data mapping, relational database concepts, writing complex SQL queries, etc)

Good to Have

• Experience as Azure developer on platforms like Azure data factory, Azure SQL database

Experience and Qualification

• More than 1 year of experience as a data analyst with exposure as a SSIS/ETL developer
• More than 1 year of experience with SQL Server 2005/2008/2012 T‑SQL coding
• More than 1 year of working knowledge in visualization tools like Power BI
• Working knowledge in MS Excel Macros, VB (illustrations will be added advantage)
• Bachelor’s degree in a related field

Additional Skills Requirements

• Presentation skills necessary to effectively communicate, update, persuade, and facilitate discussions within team
• Interpersonal skills necessary to establish and maintain effective working relationships with co‑workers, other business areas as required
• Planning skills necessary to coordinate workload around multiple assignments

EY is building a better working world by creating new value for clients, people, society and the planet, while building trust in capital markets. Enabled by data, AI and advanced technology, EY teams help clients shape the future with confidence and develop answers for the most pressing issues of today and tomorrow. EY teams work across a full spectrum of services in assurance, consulting, tax, strategy and transactions. Fueled by sector insights, a globally connected, multi‑disciplinary network and diverse ecosystem partners, EY teams can provide services in more than 150 countries and territories.

Seniority level

Associate

Employment type

Full‑time

Job function

Finance

Industries

Professional Services

Referrals increase your chances of interviewing at EY by 2x

Get notified about new Business Associate jobs in Kanayannur, Kerala, India.