Source description
About the role
EY is hiring for the position of EDS Associate - BI! Responsibilities of the Candidate: 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 Requirements: 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.) Experience as Azure developer on platforms like Azure data factory, Azure SQL database
More at EY