Senior Associate - Power BI - Data and Analytics - Advisory

Job Description & Summary:  

A career within Data and Analytics services will provide you with the opportunity to help organisations uncover enterprise insights and drive business results using smarter data analytics. We focus on a collection of organisational technology capabilities, including business intelligence, data management, and data assurance that help our clients drive innovation, growth, and change within their organisations in order to keep up with the changing nature of customers and technology. We make impactful decisions by mixing mind and machine to leverage data, understand and navigate risk, and help our clients gain a competitive edge. 

Responsibilities: 

Proficiency with Microsoft Excel, Access, PowerPoint, PowerBI and SQL required. 

What you will deliver 

• Design and build Power BI reports and dashboards using DAX, Power Query (M), bookmarks, and drill-through features. 

• Should have strong experience in implementing semantic models using best practices. 

• Strong experience in Power BI Report Builder, Develop Paginated (RDL) reports. 

• Tune and optimize reports connected to On-prem / Cloud databases via DirectQuery, ensuring performance. 

• Manage and monitor Power BI Premium P1 capacity, including auto-scaling, memory usage, CPU load, and report cache strategies. 

• Monitoring / Troubleshooting on-premises data gateways and optimize connector settings. 

• Collaborate on report classification, and governance, including report lifecycle, naming conventions, RLS/OLS, and sensitivity labels. 

• Integrate Power BI with multiple systems and design unified models across sources. 

Presentation of Data & Analysis 
Format data in a clear and concise presentation that communicates and documents analysis findings. 
Present findings and recommendations to functional areas impacted by analysis. 

Experience and Qualifications 

• Proficiency in Microsoft Excel, Access, PowerPoint required; PowerBI and SQL preferred. 

• Experience Level: 3-6 years 

General Responsibilities 

• Analyzing Data or Information — Identifying the underlying principles, reasons, or facts of information by breaking down information or data into separate parts. 

• Contributing analyses to departmental groups and committees (including procurement) for presentation. 

• Organizing, Planning, and Prioritizing Work — Developing specific goals and plans to prioritize, organize, and accomplish your work. 

• Self-starting projects while generating workable and realistic timeframes to improve the productivity of projects to produce tangible results. 

• Establishing and Maintaining Interpersonal Relationships — Developing constructive and collaborative working relationships and maintaining them over time. 

• Spending time to align personal and professional development with experts in all areas of the business. Collectively supplying and recognizing the achievements and successes of others. 

Physical and Mental Skills and/or Abilities 

• Statistical & Spreadsheet Proficiency — Using computers and computer systems to evaluate and process information, enter data and set up functions/queries. 

• Critical Thinking — Using logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions or approaches to problems. 

• Deductive Reasoning — The ability to apply general rules to specific problems to produce answers that make sense. 

• Inductive Reasoning — The ability to combine pieces of information to form general rules or conclusions (includes finding a relationship among seemingly unrelated events). 

Mandatory skill sets: 

‘Must have’ knowledge, skills and experiences  

MS Excel, Power BI, DAX, Data Modelling, SQL 

Preferred skill sets: 

‘Good to have’ knowledge, skills and experiences  

 Statistical analysis, SAP Analytics 

Years of experience required: 

• 3-6 years of experience 

Education qualification: 

• BE, B.Tech, ME, M,Tech, MBA, MCA (60% above)