Technology Consulting - Power BI Developer - Senior

EY; Thiruvananthapuram; Hybrid; INR 1,500,000 - 3,000,000; Full time

Job summary

EY in Kerala is seeking a Senior Data Analytics professional to design and deliver enterprise Power BI solutions, data models, and reports, enabling insights across the business.

You will lead data modeling, write optimized SQL, and collaborate with data engineers and stakeholders to build scalable BI architectures while guiding junior developers and staying current with Microsoft BI trends.

Qualifications

• 4+ years hands-on Power BI development with M language and DAX.
• Expert SQL with relational databases (SQL Server, Azure SQL, Oracle).
• Deep data modeling knowledge – star and snowflake schemas.
• Experience with large datasets and performance tuning in Power BI.
• ETL and data integration experience; Azure Data Factory, SSIS or Talend is a plus.
• Exposure to cloud data platforms (Azure Synapse, Azure Data Lake) and Power Platform is a plus.
• Strong problem-solving, communication, and stakeholder management.
• Ability to present complex data to non-technical audiences.

Responsibilities

• Design and implement enterprise Power BI dashboards, reports, and data models.
• Lead data modeling activities using star/snowflake schemas.
• Write optimized SQL to extract, transform, and load data from multiple sources.
• Collaborate with data engineers, architects, and stakeholders on BI architecture.
• Define and implement data governance and data security, including Row-Level Security.
• Mentor junior BI developers and conduct code reviews.
• Stay updated on Microsoft BI ecosystem trends.

Skills

Power BI

Power Query

DAX

SQL

Star schema

Snowflake schema

Azure SQL

ETL

Azure Data Factory

Power Platform

Tools

SSIS

Talend

Azure Data Factory

Job description

Job Title: Data Analytics role – Senior Level Profile

Experience Level: Senior (4+ years)

Department: Data & Analytics / Business Intelligence

Key Responsibilities:

• Design and implement enterprise-grade Power BI solutions, including complex dashboards, reports, and data models.
• Lead data modeling efforts using star/snowflake schemas and best practices in Power BI and SQL-based environments.
• Write optimized and complex SQL queries to extract, transform, and load data from various data sources.
• Collaborate with data engineers, architects, and business stakeholders to design efficient and scalable BI architectures.
• Define and implement data governance, data quality, and security (e.g., Row-Level Security in Power BI).
• Work closely with business users to gather and refine requirements, ensuring dashboards meet user expectations and business objectives.
• Optimize Power BI performance through proper data modeling, query optimization, and incremental data refresh.
• Act as a mentor to junior BI developers, conducting code reviews and promoting best practices.
• Stay up to date on emerging trends in data analytics and visualization tools, particularly within the Microsoft ecosystem.

Required Skills:

• 4+ years of hands-on experience in Power BI development with advanced knowledge of Power Query (M language) and DAX.
• Expert-level experience in SQL and working with relational databases (e.g., SQL Server, Azure SQL, Oracle).
• Deep understanding of data modeling techniques – normalized, denormalized, star schema, snowflake schema, etc
• Strong experience working with large datasets, building reusable datasets, and optimizing Power BI performance.
• Knowledge of ETL processes, data integration, and data pipeline design (experience with tools like SSIS, Talend, or Azure Data Factory is a plus).
• Exposure to cloud data platforms (Azure Synapse, Azure Data Lake, etc) and Power Platform tools (Power Apps, Power Automate) is a plus.
• Excellent problem-solving, communication, and stakeholder management skills.
• Ability to present complex data in a clear and concise manner to non-technical audiences.
• Ability to work independently and as part of a team in a fast-paced environment.

Preferred Qualifications:

• Microsoft Certified: Power BI Data Analyst Associate (PL-300).
• Experience with additional data analytics or visualization tools (e.g., Tableau, Qlik) is a plus.
• Experience in Agile/Scrum environments.
• Familiarity with scripting languages (e.g., Python) or advanced analytics tools is a plus.
• Prior experience in domain-specific analytics (e.g., finance, healthcare, supply chain) is an advantage.

Work Environment

• This position requires the candidate to log in from the nearest office for at least 2 days a week as part of the latest Return to Office mandate, which may be amended as required.
• Log in from the base office (Kochi/Trivandrum) once a quarter if requested by management.
• The role may involve short-term business travel to the MENA region for project-related work, with durations ranging from 1 to 3 months as needed.

EY | Building a better working world

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.

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.