Senior

Job Requirements

Key responsibilities:

• Ensuring reporting and analytics packs and information are produced in a timely manner.
• Develop interactive dashboard to meet user needs.
• Build data models to integrate and optimize data flows.
• Drive data improvements, enhancements and efficiencies.
• Ability to identify issues and find solutions.
• Ability to challenge and question in a constructive way.
• Development of New reports based on onshore requirement.
• Consistently offer innovative problem-solving approaches to handle regular deliverables
• Independently and effectively manage difficult client situations
• Variance analysis, providing commentary and Insights on the reports to leadership team.
• Creation and maintenance of SOPs for operational activities
• Supporting on Ad-hoc requests

Technical Skills:

• Automation of reports using Advanced Excel, Alteryx, Power Automate, Power App, VBA etc.
• Proficient in Data visualization tool - Power BI & ETL tool - Power Query
• Experience on Data Governance aspects, Data Quality

Enabling Skills:

• Excellent communication skills
• Professional, service oriented, proactive and flexible
• Self-motivated and able to prioritize
• Ability to work well under pressure in a fast passed environment while demonstrating high level of maturity
• Strong inter-personal skills; the ability to handle conflict and manage expectations

Education & Experience

• The candidate must have relevant experience in a similar role, preferably with a Big 4 firm
• For Graduate - 4+ years of experience
• For Post-Graduate - 3+ years of experience
• 3-4+ years of experience in MI reporting and data management (Experience in a professional services firm would be an advantage)

Description

Senior/Consultant - Power BI

Role summary

• We are seeking a hands-on Senior/Consultant-level BI professional to design, build, and optimize internal analytics solutions using Power BI, DAX, robust data modeling, and Power Query, with supporting skills in T-SQL/Spark SQL (Databricks) and Azure Data Lake (ADLS). The role requires excellent communication, strong stakeholder management, advanced Excel, and good knowledge of AI prompting to accelerate analysis, documentation, and solution delivery.

Key responsibilities

• Lead end-to-end delivery of internal Power BI solutions: requirements gathering, solution design, development, testing, deployment, and support
• Build efficient semantic models and dimensional schemas; define relationships, hierarchies, and calculation logic; enforce data model governance
• Develop advanced DAX measures and calculations; optimize model performance and report responsiveness (VertiPaq, aggregation strategies)
• Perform data shaping and transformation using Power Query (M), parameters, and dataflows; implement incremental refresh
• Write and optimize intermediate T-SQL and Spark SQL (Databricks) for dataset preparation, joins, aggregations, and window functions
• Integrate and manage data from Azure Data Lake (ADLS Gen2), including folder/partition design, security, and access patterns for analytics
• Apply BI visualization, UX, and storytelling best practices to deliver clear, actionable dashboards and reports for internal stakeholders
• Implement and manage security and governance (workspace management, RLS/OLS, permissions, deployment pipelines)
• Collaborate with data engineers/architects on data models, data quality, and performance tuning across the stack
• Drive stakeholder engagement internally: translate business questions into analytical solutions, facilitate UAT, and communicate insights to technical and non-technical audiences
• Utilize AI prompting to accelerate development and documentation (e.g., crafting effective prompts for generating DAX scaffolding, Power Query patterns, test cases, release notes, user guides); maintain prompt libraries and guidelines
• Proficient with enterprise AI assistants (Microsoft Copilot family, Azure OpenAI, Claude, Gemini) to accelerate DAX/Power Query scaffolding, documentation, testing, and stakeholder communications.
• Hands-on experience designing AI agents/bots to automate BI workflows (e.g., requirements triage, data quality checks, semantic model documentation, KPI alerts) with secure tool/function-calling.
• Good exposure to agentic AI patterns (planning, tool-use, memory, reflection) and RAG over internal analytics assets (data dictionary, semantic models, wiki), with strong focus on Responsible AI, governance, and cost/latency optimization.
• Document solutions, standards, and operating procedures; contribute to reusable templates and accelerators
• Mentor junior team members and contribute to continuous improvement of delivery methods and quality

Required qualifications and experience

• Education and experience:
  • Bachelor's degree (or equivalent): 5+ years of relevant BI/analytics experience
  • Master's/Postgraduate degree: 4+ years of relevant BI/analytics experience
• Technical skills:
  • Advanced Power BI (data modeling, report design, dataset management, performance optimization)
  • Advanced DAX and dimensional data modeling (star schema design, calculation optimization)
  • Power Query (M) for data transformation and shaping
  • Intermediate T-SQL and Spark SQL for Databricks (joins, CTEs, window functions, query performance basics)
  • Azure Data Lake (ADLS Gen2): structure/partition design, permissions, integration with Databricks/Power BI
  • Advanced Excel (Power Query/Power Pivot, complex formulas, pivots, data analysis features)
  • Good knowledge of AI prompting and prompt patterns to enhance BI/analytics workflows
• Core competencies:
  • Excellent verbal and written communication; ability to simplify complex concepts
  • Strong internal stakeholder management and facilitation skills
  • Proven ability to work in Agile, fast-paced, cross-functional environments
  • Analytical mindset with attention to detail, quality, and governance

Nice to have (preferred)

• Azure ecosystem: Databricks Delta Lake, Azure Synapse, Azure Data Factory, Microsoft Fabric
• Power BI tooling: DAX Studio, Tabular Editor, ALM Toolkit, Power BI deployment pipelines
• Data governance and cataloging (e.g., Microsoft Purview)
• Performance tuning of VertiPaq models, large datasets, and complex DAX
• Visualization best practices, UX design, and accessibility
• Practical experience using Copilot/AI assistants for BI tasks and prompt-engineering frameworks
• Industry experience in finance, healthcare, manufacturing, or retail analytics
• Certifications: Microsoft PL-300/PL-600/PL-400, DP-203, Databricks

Job Requirements

Key responsibilities:

• Ensuring reporting and analytics packs and information are produced in a timely manner.
• Develop interactive dashboard to meet user needs.
• Build data models to integrate and optimize data flows.
• Drive data improvements, enhancements and efficiencies.
• Ability to identify issues and find solutions.
• Ability to challenge and question in a constructive way.
• Development of New reports based on onshore requirement.
• Consistently offer innovative problem-solving approaches to handle regular deliverables
• Independently and effectively manage difficult client situations
• Variance analysis, providing commentary and Insights on the reports to leadership team.
• Creation and maintenance of SOPs for operational activities
• Supporting on Ad-hoc requests

Technical Skills:

• Automation of reports using Advanced Excel, Alteryx, Power Automate, Power App, VBA etc.
• Proficient in Data visualization tool - Power BI & ETL tool - Power Query
• Experience on Data Governance aspects, Data Quality

Enabling Skills:

• Excellent communication skills
• Professional, service oriented, proactive and flexible
• Self-motivated and able to prioritize
• Ability to work well under pressure in a fast passed environment while demonstrating high level of maturity
• Strong inter-personal skills; the ability to handle conflict and manage expectations

Education & Experience

• The candidate must have relevant experience in a similar role, preferably with a Big 4 firm
• For Graduate - 4+ years of experience
• For Post-Graduate - 3+ years of experience
• 3-4+ years of experience in MI reporting and data management (Experience in a professional services firm would be an advantage)