Job Title: Data Analytics role – Senior Level Profile
Senior (4+ years)
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 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.