EY Technical Support-SQL MSBI-Senior Associate-Supervising Associate 

India, Kerala, Kochi 

343724578

Role name and description

Working with cross-functional teams, you will participate in the translation of business requirements into technical reporting requirements to meet business needs. Using your skills and experience you will then use those requirements to design, develop, test and implement reports/analysis that utilize the underlying data within the firm data warehouse(s).

Your key responsibilities

• SQL skills including knowledge of relational databases (including INSERT, UPDATE, SELECT, LEFT JOIN, RIGHT JOIN, INNER JOIN, PIVOT, UNPIVOT, star schema, snowflake schema, nested/embedded queries, aggregated queries, stored procedures) and related tools (such as Access, SQL Management Studio, Azure Data Studio)
• Good knowledge and experience with Microsoft Fabric including Power BI reporting/modelling, setting up dataflows and gateways, moving data with Azure Data Factory
• Good knowledge of SSIS – ability to design, deploy, and maintain SSIS packages with Visual Studio
• Setting up and scheduling jobs to automate packages
• Experience in creating calculated measures and columns with DAX
• Good at creating different visualizations using Slicers, Lines, Pies, Maps, Waterfall, Heat Maps, and Tree maps
• Experience building and publishing reports with SSRS
• Strong knowledge of SAP – including navigation of the system, using T codes, Finance Controlling (FICO) expert, reconciling subledger detail to leading ledger
• Strong Excel formula/pivot knowledge including “Match”, “Index”, “Sumif”, “offset”, “conditionals” etc. (again a must)
• Basic accounting knowledge and experience in financial reporting and database skills
• Planning, budgeting and reporting experience would be an added advantage
• Translate business requirements into specifications that will be used to implement the required reports/analysis, created from potentially multiple data sources
• Develop new reports/ad hoc analysis in various tools
• Implement enhancements to existing Reports/Analysis
• Perform data validation to ensure accuracy

Skills and attributes for success

• MSBI (SSIS, SSAS, SSRS)
• Visual Studio
• MS Fabric/Power BI
• Strong SQL skills (SSMS, Azure Data Studio)
• Good knowledge of SAP - FICO
• Knowledge of excel macros (VBA)
• Power Apps Technology

To qualify for the role, you must have

• 2 years + of working in a relational database environment (SQL Server), involving writing queries and analyzing data
• Experience with reporting concepts and tasks (operational or functionally) as well as preparing and presenting information to end­ users in different formats
• Bachelor's degree in Finance, Information Systems or related discipline, or equivalent work experience

Ideally, you’ll also have

• Be a lifelong learner
• Possess strong communication skill
• Problem Solving skills
• Have logical and analytical skill
• Be decisive on real time basis
• Support heavy ad hoc reporting needs as well as assist in the creation of recurring reports intended for multiple users
• Open minded on how to approach solutions, people and work styles

What we offer

Reporting & Analytics team is a dynamic and truly global delivery network. We support customers in all EY locations and across many functions and Service Lines. R&A colleagues are located in various locations across the Globe with concentration in the US (New Jersey), UK, Germany, France, Poland and India. From accountants and programmers to people with consulting, change management or data scientist background, we offer a wide variety of fulfilling career opportunities that span various disciplines. In the R&A, you will collaborate with EY teams on exciting projects and work with well-known brands and technologies.

• Continuous learning: You’ll develop the mindset and skills to navigate whatever comes next
• Success as defined by you: We’ll provide the tools and flexibility, so you can make a meaningful impact, your way
• Transformative leadership : We’ll give you the insights, coaching and confidence to be the leader the world needs
• Diverse and inclusive culture: You’ll be embraced for who you are and empowered to use your voice to help others find theirs

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.