Data Modeler – Senior Associate

Industry/Sector

Specialism

Management Level

Job Description & Summary

The Opportunity

Join our Acceleration Center India and help shape the future of business for our diverse client portfolio across geographies and jurisdictions. You’ll work at the heart of global teams across Advisory, Assurance, Tax and Business Services-solving real client challenges through connected collaboration. We’ll help you grow your skills so you can go further. With hands-on learning, cutting-edge tools and an inclusive culture, this is your opportunity to do inspiring work that makes a difference-every day.

As a Data Modeler you will help design and develop data solutions that transform raw information into usable insights for client decision-making, within our Data and Analytics Engineering practice. As a Senior Associate you will analyze complex data challenges, build meaningful client connections, guide junior team members, and navigate shifting priorities while developing your technical skills and professional presence. In this role at PwC, you will focus on data modeling, exploratory and descriptive analysis, statistical techniques, and data visualizations that support business questions and strategic decisions.

Responsibilities

- Modeling data structures that support exploratory analysis, descriptive analytics, and statistical modeling for client engagements

- Translating business requirements into data models that organize complex datasets for analysis and visualization

- Developing conceptual, logical, and physical data models that align with analytics goals and reporting needs

- Analyzing data sources, relationships, and quality issues to support reliable insights and recommendations

- Applying statistical techniques, machine learning concepts, and programming languages to solve business problems

- Building data model documentation that clarifies entities, attributes, relationships, and transformation rules

- Reviewing modeling deliverables for consistency, accuracy, and alignment with project objectives

- Interpreting feedback from clients and team members to refine solutions and improve deliverables

What You Must Have

- At least a Bachelor's degree

- At least 4 years of experience

- Oral and written proficiency in English required

What Sets You Apart

- Proven experience across conceptual → logical → physical modelling for warehouses, marts, and lakehouses (star / snowflake schemas, dimensional modelling; Data Vault 2.0 a strong plus).

• Hands-on with a modelling tool: erwin Data Modeler, ER/Studio, SqlDBM, or PowerDesigner - including forward-engineering DDL and reverse-engineering existing schemas.
• Expert ANSI SQL with real performance-tuning depth (execution plans, partitioning, clustering).

• Production experience on at least one modern cloud data platform: Snowflake and/or Databricks / Delta Lake (Redshift, BigQuery, Synapse also relevant).

• Comfort with the transformation layer - dbt for physical modelling / ELT and exposure to orchestration (Airflow, ADF).
• Demonstrated ownership of STTMs, data dictionaries, metadata, lineage and profiling as first-class deliverables.
• Experience with healthcare and/or pharma / life-sciences data. Strong signal: familiarity with IQVIA / IMS, Symphony/claims data, Veeva, EHR/EMR, RWD/RWE, Digital Marketing Channels and MDM for HCP/HCO.

• Working understanding of HIPAA and PHI/PII handling.

Travel Requirements

Job Posting End Date