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.Technical SupportRole name and descriptionFinance role within the Reporting & Analytics (R&A) team to join our technical development team. The successful candidate will be part of a cross functional team developing, operating and managing our systems that support planning, accounting and reporting for our Global Functions and the Executive.The opportunityThe incumbent is responsible to support heavy ad hoc reporting needs as well as assist in the creation of recurring reports intended for multiple users supporting a team of analysts, & supervisors; possess complete knowledge of SAP - including navigation of the system, using T codes, Finance Controlling (FICO) expert.Working with cross-functional teams, you will participate in the translation of business requirements to 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

• Strong 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) (a must)
• Strong knowledge and experience with Microsoft Fabric including Power BI reporting/modelling, setting up dataflows and gateways, moving data with Azure Data Factory
• Strong knowledge of SSIS - ability to design, deploy, and maintain SSIS packages with Visual Studio. Experience building SSIS package with multiple source types (Azure, SQL Server, Excel, data cubes). Setting up and scheduling jobs to automate packages
• Good 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 etc
• Experience building and publishing reports with SSRS
• Knowledge of MDX including knowledge of cube formulas (nice to have)
• 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/analysis in various tools
• Implement enhancements to existing Reports/Analysis
• Provide support as required to ensure the availability and performance of developed
• Perform sufficient data validation to ensure accuracy

Skills and attributes for success

• MSBI (SSIS, SSAS, SSRS) - SSIS being most important
• Visual Studio
• MS Fabric/Power BI
• Strong SQL skills (SSMS, Azure Data Studio)
• Strong knowledge of SAP - FICO
• Knowledge of excel macros (VBA)
• Strong 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 look forWe are looking for someone who is passionate about what they do. Someone who is willing to push the boundaries and offer innovative and creative solutions to current challenges. We are looking for a team player who recognizes that the role they play is an important part of the success for the team as a whole. We want someone who is willing to learn, grow and develop and who is able to mentor those who are less capable than they are. We are looking for someone who is actively growing their career and who realizes that by being part of this team there are no boundaries to what we can achieve together.What we offerReporting & 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 | Building a better working worldEY 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.

EY