Senior Associate EW

ES- Finance and Accounting: Reporting and Analytics Centre of Excellence

Senior Finance Analyst (Technical)

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

We provide reporting solutions or requirements through finance markets and operations reporting along with cyclical and critical controlling processes such as Forecasting Financial Planning Revenue Planning Markets Leadership Planning and Cash Reporting to help you take better business decisions. With projects like Mercury we also support business transformation and we are continuing to expand our services to support all Regions with their reporting and analytics needs.

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

We provide reporting solutions or requirements through finance markets and operations reporting along with cyclical and critical controlling processes such as Forecasting Financial Planning Revenue Planning Markets Leadership Planning and Cash Reporting to help you take better business decisions. With projects like Mercury we also support business transformation and we are continuing to expand our services to support all Regions with their reporting and analytics needs.

The opportunity

The Senior Associate Finance R&DA (Technical) will support the development maintenance and modernization of Finance reporting and data engineering solutions. The role requires strong technical expertise across SSIS SQL Server Power BI and Azure data services (Azure SQL Azure Data Factory Azure Databricks) with responsibility for business critical reporting processes periodic rollovers and cloud migration initiatives. The individual will work closely with global stakeholders and provide technical support and guidance within the team

Your key responsibilities

• Data Engineering & Integration:
  • Develop maintain and enhance SSIS packages including source changes logic updates and performance improvements.
  • Execute monitor and troubleshoot ad hoc and scheduled SSIS jobs to ensure data accuracy and availability.
  • Resolve Visual Studio and SSIS related issues including deployment failures and environment specific errors.

• Reporting & Analytics (Power BI)
  • Perform ongoing enhancements and maintenance of Power BI dashboards.
  • Implement advanced Power BI capabilities such as:
    • Data validation and reconciliation checks
    • Automation features to reduce manual effort and improve efficiency
  • Support Power BI dataset and dashboard rollovers aligned to financial reporting cycles.

• Periodic Rollover & Run the Business Activities
  • Lead and support rollover activities for EW and other Finance datasets including:
    • SSIS package rollovers
    • Power BI report and dataset rollovers
    • SQL query updates aligned to new reporting periods
  • Ensure continuity data integrity and timely delivery across rollover cycles.

• Azure & Cloud Enablement
  • Support Azure migration initiatives including migration of on premises SQL Server workloads to Azure SQL Database.
  • Refactor and optimize SQL queries for Azure SQL compatibility scalability and performance.
  • Redesign data access using Elastic Queries and cross database querying where applicable.

• Azure Data Factory & Advanced Pipelines
  • Contribute to Azure Data Factory (ADF) development including:
    • Supporting production ADF pipelines
    • Building pipelines for datasets such as engineering lists and charged hours
  • Use Azure Databricks for data processing transformations and pipeline integration.

• Collaboration & Team Support
  • Provide hands on support to team members across SSIS ADF Azure SQL Databricks and Power BI.
  • Assist with pipeline troubleshooting defect resolution and knowledge sharing.
  • Collaborate with onshore stakeholders to translate business requirements into technical solutions.

Skills and attributes for success

• Strong experience with SQL Server (T SQL query optimization performance tuning)
• Hands on expertise in SSIS (development deployment monitoring troubleshooting)
• Strong experience with Power BI including DAX Power Query and data modelling
• Experience working with Azure suite (Azure SQL Azure Data Factory (ADF) Azure Databricks)
• Experience in on prem to Azure migration projects
• Strong analytical and problem solving skills
• Ability to manage multiple priorities in a reporting driven environment
• Proactive ownership driven mindset
• Effective communication skills for technical and non technical stakeholders
• Team oriented approach with willingness to support and mentor peers

To qualify for the role you must have

• More than 5 years of experience possessing advanced knowledge as a Data Engineer - Microsoft BI & Azure
• More than 3 years of working knowledge in Power BI Visualization tool.
• Bachelors/Masters degree in a related field

What we look for

• A Team of people with technical experience business acumen and enthusiasm to learn new things in this fast-moving environment
• Opportunities to work with EY F&A practices globally with leading businesses across a range of industries

What we offer

EY Global Delivery Services (GDS) is a dynamic and truly global delivery network. We work across eight locations Argentina China India Philippines Poland Mexico Sri Lanka and Spain and with teams from all EY service lines geographies and sectors playing a vital role in the delivery of the EY growth strategy. From accountants to coders to advisory consultants we offer a wide variety of fulfilling career opportunities that span all business GDS you will collaborate with EY teams on exciting projects and work with well-known brands from across the globe. Well introduce you to an ever-expanding ecosystem of people learning skills and insights that will stay with you throughout your career.

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