IN Senior Associate Power BI MS Dynamics Advisory Hyderabad

Line of Service

Advisory

Industry/Sector

Not Applicable

Specialism

Microsoft

Management Level

Senior Associate

Job Description & Summary

At PwC, our people in business application consulting specialise in consulting services for a variety of business applications, helping clients optimise operational efficiency. These individuals analyse client needs, implement software solutions, and provide training and support for seamless integration and utilisation of business applications, enabling clients to achieve their strategic objectives.

Those in Microsoft Dynamics CRM at PwC will specialise in analysing client requirements, implementing CRM software solutions, and providing training and support for seamless integration and utilisation of Microsoft CRM applications. Working in this area, you will enable clients to optimise operational efficiency and achieve their strategic objectives.

Why PWC

At PwC, you will be part of a vibrant community of solvers that leads with trust and creates distinctive outcomes for our clients and communities. This purpose-led and values-driven work, powered by technology in an environment that drives innovation, will enable you to make a tangible impact in the real world. We reward your contributions, support your wellbeing, and offer inclusive benefits, flexibility programmes and mentorship that will help you thrive in work and life. Together, we grow, learn, care, collaborate, and create a future of infinite experiences for each other. Learn more about us.

At PwC, we believe in providing equal employment opportunities, without any discrimination on the grounds of gender, ethnic background, age, disability, marital status, sexual orientation, pregnancy, gender identity or expression, religion or other beliefs, perceived differences and status protected by law. We strive to create an environment where each one of our people can bring their true selves and contribute to their personal growth and the firm’s growth. To enable this, we have zero tolerance for any discrimination and harassment based on the above considerations.

Responsibilities

· Experience in Power Bi, Power Bi Mobile reports, Power Bi Services, Power Bi Report Builder, SQL Server.

· Experience on Power Bi data modelling concepts like Star Schema, Snow Flake, Dimension and

· Fact Tables.

· Having experience in building relationships between the tables by using the cardinality relationships.

· Good knowledge on Date transformation, modifications, data analysis and Calculations in PBI.

· Developing UI and UX designs for the reports and M language is used for complex real-world challenges of data transformations.

· Having good knowledge on writing DAX functions to create Measure and Calculated Columns.

Required Skills

· Having experience in creating new measure for Time intelligent functions like YTD, MTD, QTD growth analysis in power desktop.

· Having experience on extracting data from different data sources like SQL Database, EXCEL workbooks, CSV files, Share Point, and cloud services ( data sets ), Data flows, Dataverse by using the connection modes.

· Having experience in creating different charts like Line chart, bar chart, table, matrix table, area chart, KPI chart, gauge chart, scattered chart, tree map, shape map, Donut chart, waterfall chart and filled map.

· Having experience in generating the reports by using Power BI report builder software.

· Extracting the data from different sources like power bi datasets, SQL server, etc.

· Having experience in building data modelling and preparing datasets in Power Bi.

· Good knowledge in building the reports, query designing, Dax modifications, data formats, table building, performance tuning.

· Understanding the business requirements to build the reports and dashboards.

· Well knowledge on gathering and translating End User requirements into Reports & Dashboards. Including Analysis, Design, Development of Reports and Dashboards.

· Good knowledge in building reports by using report builder software, formatting tables, building

· calculations in the report.

· Worked on Power BI Gateways to keep the dashboards and reports up to date by scheduling the Refresh.

· Implemented RLS (Row Level Security) for the Reports to manage the user access.

· Good knowledge in creating new reports and visuals by using Power Bi.

· Publishing the reports, refresh based on time in Power Bi services.

Mandatory skill sets:

Power BI

*Preferred skill sets:

Power BI

*Years of experience required

4 to 6 Years

*Education Qualification

BE/B.Tech

Education (if blank, degree and/or field of study not specified)

Degrees/Field of Study required: Bachelor of Technology, Bachelor of Engineering

Degrees/Field of Study preferred:

Certifications (if blank, certifications not specified)

Required Skills

Power BI

Optional Skills

Accepting Feedback, Accepting Feedback, Active Listening, Analytical Thinking, Business Process Analysis, Communication, Creativity, CRM Analytics, CRM Implementations, CRM Project Management, Customer Journey Analysis, Data Management, Embracing Change, Emotional Regulation, Empathy, Inclusion, Intellectual Curiosity, Learning Agility, Microsoft Dynamics 365, Microsoft Dynamics CRM, Microsoft Dynamics Customer Relationship Management (CRM) Architecture, Microsoft Dynamics Customer Relationship Management (CRM) Configuration, Microsoft Dynamics Customer Relationship Management (CRM) Integration, Microsoft Power Apps, Operational Efficiency {+ 4 more}

Desired Languages (If blank, desired languages not specified)

Travel Requirements

Not Specified

Available for Work Visa Sponsorship?

No

Government Clearance Required?

No

Job Posting End Date