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.
The opportunity
As a Senior BI Consultant, you will be responsible for supporting and enhancing Business Intelligence and Data Analytics platforms with a primary focus on Power BI and Databricks. You will work across global engagements, helping clients translate complex data into actionable insights. This role involves day-to-day application management, dashboard development, troubleshooting, and stakeholder collaboration to ensure high data quality, performance, and availability.
Your key responsibilities
- BI Support & Monitoring: Provide daily application support for Power BI dashboards and Databricks pipelines, resolving incidents, fulfilling service requests, and implementing enhancements.
- Dashboard Development: Design, develop, and maintain Power BI reports and data models tailored to evolving business requirements.
- Root Cause Analysis: Investigate and resolve data/reporting issues, bugs, and performance bottlenecks through detailed root cause analysis.
- Requirement Gathering: Collaborate with business users and technical stakeholders to define BI requirements and translate them into scalable solutions.
- Documentation: Maintain technical documentation, including data flows, dashboard usage guides, and QA test scripts.
- On-Call & Shift Support: Participate in shift rotations and be available for on-call support for critical business scenarios.
- Integration & Data Modeling: Ensure effective data integration from diverse systems and maintain clean, performant data models within Power BI and Databricks.
Skills and attributes for success
- Hands-on expertise in Power BI, including DAX, data modeling, and report optimization
- Working experience in Databricks, especially with Delta Lake, SQL, and PySpark for data transformation
- Familiarity with ETL/ELT design, especially within Azure data ecosystems
- Ability to troubleshoot BI performance issues and manage service tickets efficiently
- Strong communication skills to interact with global stakeholders and cross-functional teams
- Ability to manage and prioritize multiple support tasks in a fast-paced environment
To qualify for the role, you must have
- 3–7 years of experience in Business Intelligence and Application Support
- Strong hands-on skills in Power BI and Databricks, preferably in a global delivery model
- Working knowledge of ETL processes, data validation, and performance tuning
- Familiarity with ITSM practices for service request, incident, and change management
- Willingness to work in rotational shifts and support on-call requirements
- Bachelor’s degree in Computer Science, Engineering, or equivalent work experience
- Willingness to work in a 24×7 rotational shift-based support environment.
- No location constraints
Technologies and Tools
Must haves
- Power BI: Expertise in report design, data modelling, and DAX
- Databricks: Experience with notebooks, Delta Lake, SQL, and PySpark
- Azure Ecosystem: Familiarity with Azure Data Lake and Azure Synapse (consumer layer)
- ETL & Data Modelling: Good understanding of data integration and modelling best practices
- ITSM Tools: Experience with ServiceNow or equivalent for ticketing and change management
Good to have
- Data Integration: Experience integrating with ERP, CRM, or POS systems
- Python: For data transformation and automation scripting
- Monitoring: Awareness of Azure Monitor or Log Analytics for pipeline health
- Certifications: Microsoft Certified Data Analyst Associate or Databricks Certified Data Engineer Associate
- Industry Exposure: Experience in retail or consumer goods industries
What we look for