BI Engineer(POWER BI)

Role: Senior Associate

Tower: Data Analytics & Insights Managed Service

Experience: 6 - 10 years

Key Skills: BI Engineering

Educational Qualification: Bachelor's degree in computer science/IT or relevant field

Work Locations: Bangalore, Hyderabad

Job Description

As a Senior Associate, you'll work as part of a team of problem solvers, helping to solve complex business issues from strategy to execution by using Data, Analytics & Insights Skills. PwC Professional skills and responsibilities for this management level include but are not limited to:

• Use feedback and reflection to develop self-awareness, personal strengths, and address development areas.
• Proven track record as an SME in chosen domain.
• Mentor Junior resources within the team, conduct KSS and lessons learnt.
• Flexible to work in stretch opportunities/assignments.
• Demonstrate critical thinking and the ability to bring order to unstructured problems.
• Ticket Quality and deliverables review.
• Status Reporting for the project.
• Adherence to SLAs, experience in incident management, change management and problem management.
• Review your work and that of others for quality, accuracy, and relevance.
• Know how and when to use tools available for a given situation and can explain the reasons for this choice.
• Seek and embrace opportunities which give exposure to different situations, environments, and perspectives.
• Use straightforward communication, in a structured way, when influencing and connecting with others.
• Able to read situations and modify behavior to build quality relationships.
• Uphold the firm's code of ethics and business conduct.
• Demonstrate leadership capabilities by working with clients directly and leading the engagement.
• Work in a team environment that includes client interactions, workstream management, and cross-team collaboration.
• Good Team player. Take up cross competency work and contribute to COE activities.
• Escalation/Risk management.

Position Requirements:

Required Skills:

Primary Skill:

Secondary Skill:

BI Engineer:

Should have a Minimum of 6 years of hands-on experience in migrating dashboards from Oracle Analytics Cloud (OAC) and Spotfire to Power BI, with proven ability to replicate and enhance existing reports.

Assess and analyze current Spotfire and OAC reports to understand requirements, data sources, and functionalities.

Assist in troubleshooting and resolving issues related to report migration and post-migration support

Should be capable of converting the current logical SQL used in OAC reports to physical SQL for accessing data from Databricks

Should have experience in Converting Oracle Analytics Cloud (OAC) RPD models to Power BI data models to support effective data modeling and reporting

Expertise in formulas / DAX, Measures, Establishing hierarchies, Data refresh, Row/column/report level security, Report governance, complex visualizations.

Extensive experience in developing, maintaining, and managing Power BI driven dashboards & analytics and working knowledge of Power BI administration/architecture.

Ability to create and replicate functionalities like parameters (for top fields, sheet switching), interactive buttons to switch between dashboards, burger menus etc.

Participate in requirement gathering with business and evaluate the data as per the requirement. Coordinate and manage data analytics & Reporting activities with stakeholders.

Expertise in writing and analyzing complex SQL queries. Excellent problem solving, design, debugging, and testing skills, Competency in Excel (macros, pivot tables, etc.)

Should have minimum 5 years hands on Experience of delivering Managed Data and Analytics programs (Managed services and Managed assets)

Should have Strong communication, problem solving, quantitative and analytical abilities.

Effectively communicate with project team members and sponsors throughout the project lifecycle (status updates, gaps/risks, roadblocks, testing outcomes)

Nice to have:

Certifications in Power BI and other visualization tools is an added advantage.

Certification in Data Bricks is Preferred

Experience in Data ingestion technology by using any of the industry tools like Teradata, DataStage, etc.