Job
Description
In this role as a Data Analytics professional at EY, you will play a crucial part in designing and implementing enterprise-grade Power BI solutions. Your responsibilities will include: - Designing and implementing complex dashboards, reports, and data models using Power BI. - Leading data modeling efforts using star/snowflake schemas and best practices in Power BI and SQL-based environments. - Writing optimized and complex SQL queries for data extraction, transformation, and loading from various sources. - Collaborating with data engineers, architects, and business stakeholders to design efficient and scalable BI architectures. - Defining and implementing data governance, data quality, and security measures such as Row-Level Security in Power BI. - Working closely with business users to gather and refine requirements to ensure dashboards meet user expectations and business objectives. - Optimizing Power BI performance through data modeling, query optimization, and incremental data refresh. - Staying updated on emerging trends in data analytics and visualization tools, especially within the Microsoft ecosystem. Required Skills: - 3 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 such as SQL Server, Azure SQL, Oracle. - Deep understanding of data modeling techniques like normalized, denormalized, star schema, snowflake schema, etc. - Strong experience handling 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) and Power Platform tools (Power Apps, Power Automate) is beneficial. - 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 other data analytics or visualization tools like Tableau, Qlik is advantageous. - 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. Please note that this position may require you to log in from the nearest office for at least 2 days a week as part of the latest Return to Office mandate, with the possibility of logging in from the base office (Kochi/Trivandrum) once a quarter if requested by management. Additionally, short-term business travel to the MENA region for project-related work may be required, with durations ranging from 1 to 3 months as needed. At EY, we are committed to building a better working world by creating new value for clients, people, society, and the planet. Our teams work across a full spectrum of services in assurance, consulting, tax, strategy, and transactions, providing services in more than 150 countries and territories.,
