EDS-Associate-BI

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.

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:

Specific Role requirements

• Create SSIS jobs to extract transfer and load data supporting and trouble-shooting existing ETL processes using SSIS/ Azure data factory
• Ability to 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 as needed 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 SQLETL/ 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 years of experience as a data analyst with exposure as a SSIS /ETL Developer
• More than 1 years of experience with SQL Server 2005/2008/2012 T-SQL coding
• More than 1 years of working knowledge in Visualization tools like Power BI
• Working knowledge in MS Excel Macros VB illustrations will be added advantage
• Bachelors 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 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.