IN-Senior Associate BI Consultant &Developer Data & Analytics Advisory Mumbai

Line of Service

Advisory

Industry/Sector

Not Applicable

Specialism

Data, Analytics & AI

Management Level

Senior Associate

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.

Creating business intelligence from data requires an understanding of the business, the data, and the technology used to store and analyse that data. Using our Rapid Business Intelligence Solutions, data visualisation and integrated reporting dashboards, we can deliver agile, highly interactive reporting and analytics that help our clients to more effectively run their business and understand what business questions can be answered and how to unlock the answers.

*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:

Key responsibilities

• Understand and document the reporting business requirements, processes and workflows developing both written and visual depictions of requirements and process flows.
• Work closely with BI product manager & lead dashboard design and information presentation ideation meetings with business stakeholders. 
• Works extensively in Tableau Desktop, MS Power BI designing and building highly customized dashboards to provide stunning visual analytics to key stakeholders.
• Builds Tableau/Power BI Data Models utilizing best practices, ensures data accuracy and ability to blend with other certified data sources.
• Understand Analytics & Business Intelligence framework and partner with Analytics Technology & Enterprise reporting Technology team to build & deploy reports and dashboards.
• Evaluate data sources and technology options, recommend appropriate solutions.
• Build and maintain a reporting data dictionary and data lineage.
• Perform data analysis, data mapping, and develop ad hoc queries.
• Write SQL queries, stored procedures, and scripts, ETL jobs.
• Perform QA testing of developed deliverables and assist with User Acceptance Testing
• Manage the prioritization, logging and tracking of user related issues, defects, enhancements, and work requests.

Experience and Skills

• Analytic and data driven mindset with a finesse to build dashboards that tell a story.
• Strong communication skills, interacting effectively with quantitative colleagues as well as less technical audiences.       
• Minimum of 5 years of proven experience creating Dashboards, Reports and Visualizations with interactive capabilities.
• Experience with data visualization tools (e.g., Tableau, Power BI) (8+ on a scale of 1-10).
• Minimum of 5 years’ experience in business/data analysis and data preparation (SQL is a must).
• Strong SQL query writing skills (8+ on a scale of 1-10)
• Minimum 2 years of experience in working with big data & building data apps using Python.
• Broad industry knowledge of investment management a plus
• Excellent verbal and writing skills in English.
• Excellent time management and ability to work under pressure to meet tight deadlines.
• Maintain a strong commitment to quality.

Technical Expertise

• Dashboard design certifications from Tableau or PowerBI
• Python programming skills and exposure to dashboarding libraries like Plotly, Dash, Streamlit etc. (7+ on a scale of 1-10)
• Experience working with Oracle, MSSQL, Snowflake and other cloud databases
• Strong Excel & PPT skills

Mandatory skill sets:

Financial Data, SQL, Power BI/ Tableau, Worked on big datasets, Python, Data analysis(along with data quality, data management)

Preferred skill sets:

ETL, QA

Years of experience required:

4 to 8 years

Education qualification:

Qualification / Technical Expertise

• Bachelor’s degree (Master’s degree would be a plus) in Finance, Economics, Computer Science, Mathematics, Statistics, Physics, Business Administration, or related fields

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

Degrees/Field of Study required: Master Degree, Bachelor Degree, Master of Engineering

Degrees/Field of Study preferred:

Certifications (if blank, certifications not specified)

Required Skills

Microsoft Power Business Intelligence (BI)

Optional Skills

Desired Languages (If blank, desired languages not specified)

Travel Requirements

Available for Work Visa Sponsorship?

Government Clearance Required?

Job Posting End Date