IN_Manager_USA Paid Media Data Ingestion, Modeling and Visualization_GCC_Advisory_Bangalore

Line of Service

Industry/Sector

Specialism

Management Level

Job Description & Summary

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.

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: 

Experience – 7+ Years 

Responsibilities 

• Support Paid Media data enablement initiatives by working with Marketing, IT teams, and Paid Media data vendors. 

• Conduct requirements gathering sessions with business and technical stakeholders. 

• Review and understand BRDs, KBQs, FIAs, vendor documentation, source files, and data dictionaries. 

• Create and maintain FRS/FRDs, business rules, KPIs, source-to-target mappings, user stories, and test scenarios. 

• Perform data discovery, profiling, validation, reconciliation, and impact analysis. 

• Use SQL, Excel, Microsoft Fabric, and self-service analytics tools for data exploration and validation. 

• Analyze paid media data sources, transformations, and reporting requirements. 

• Support reporting mockups and dashboard requirements for Power BI. 

• Translate business requirements and data logic to data engineering teams and participate in solution design discussions. 

• Support SIT/UAT, defect triage, and requirement validation. 

• Track dependencies, risks, assumptions, and action items, and provide regular project status updates to stakeholders. 

Mandatory skill sets: 

‘Must have’ knowledge, skills and experiences  

• 7+ years of Business Analysis experience supporting Data & Analytics projects. 

• 2+ years of experience working with Paid Media digital marketing datasets in an analytics context. 

• Strong expertise in BRD, FIA, FRS/FRD, business rules, data mapping, and test scenarios. 

• Advanced SQL skills for data analysis, profiling, and validation. 

• Understanding of dimensional data modeling concepts including Facts, Dimensions, Primary Keys, and Star Schema design. 

• Working knowledge of Microsoft Fabric, Power BI, Excel, and self-service analytics tools. 

• Understanding of API-based data exchanges, SFTP-based file exchanges, and analytics data ingestion concepts. 

• Strong communication skills with technical and non-technical stakeholders. 

Preferred skill sets: 

• Pharmaceutical commercial data experience. 

• Hands-on experience with USA paid media platforms such as CM360, DV360, SA360, Google Ads, Meta Ads, Microsoft Ads, LinkedIn, TikTok, PulsePoint, IAS, Doximity, and Phreesia. 

• Ability to work closely with Marketing, IT, data engineering teams, and external vendors. 

• Strong stakeholder management, project tracking, and status reporting skills. 

Years of experience required: 

7+ years of relevant Business Analysis experience, including 2+ years with Paid Media digital marketing datasets. 

Education qualification: 

Bachelor’s or Master’s degree in Business, Marketing, Computer Science, Data Analytics, Engineering, or a related field. 

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

Certifications(if blank, certifications not specified)

Required Skills

Optional Skills

Desired Languages(If blank, desired languages not specified)

Travel Requirements

Available for Work Visa Sponsorship?

Government Clearance Required?

Job Posting End Date