Architect / Data Modeler- Senior Manager

Industry/Sector

Not Applicable

Specialism

Product Innovation

Management Level

Senior Manager

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 an Architect / Data Modeler- Senior Manager you will lead architecture and data modeling work within our Cloud Engineering, Data & Analytics practice, supporting Data Modernisation efforts that help shape how data is structured, governed, and used across client priorities. As a Senior Manager you will lead large projects, advise on complex technical decisions, and bring sound judgment to guide teams through ambiguity while building trusted relationships with stakeholders and driving operational excellence. In this role at PwC, you will shape data models, align architecture choices with business and technology needs, and translate complex requirements into clear direction for delivery teams.

Responsibilities

• Leading data architecture and data modeling efforts across cloud-based and modernized data environments
• Designing conceptual, logical, and physical data models that support analytics, reporting, and application use cases
• Translating business and technical requirements into scalable data structures, mappings, and transformation patterns
• Guiding data warehouse, data lake, and pipeline design across platforms such as Snowflake, Databricks, Azure Data Factory, and AWS
• Reviewing data quality, validation logic, and performance tuning approaches to improve reliability and query efficiency
• Advising client stakeholders on data strategy, modernization approaches, and architecture tradeoffs across complex initiatives
• Coordinating delivery across data engineering, platform, and product teams to move architecture decisions from design into implementation
• Applying database management, indexing, optimization, and security concepts to support resilient data platforms
• Identifying issues in source-to-target design, data integration, and transformation flow, and directing corrective actions
• Coaching team members on modeling standards, technical design decisions, and delivery practices across multiple workstreams

What You Must Have

• At least a Bachelor's degree
• At least 12+ years of experience
• Oral and written proficiency in English required

What Sets You Apart

• 12+ years of experience in Data Modeling and responsible for the development of the conceptual, logical, and physical data models, the implementation of RDBMS, operational data store (ODS), data marts, and data lakes on target platforms (SQL/NoSQL).

• Deep understanding of Insurance domain knowledge.

• Implement business and IT data requirements through new data strategies and designs across all data platforms (relational, dimensional, and NoSQL) and data tools (reporting, visualization).

• Lead the design, development, and implementation of insurance data models supporting interoperability and analytics

across Policy center, Billing Center and Claim Center.

• Advise and collaborate closely with engineering, product, and clinical teams to ensure technical solutions meet regulatory, operational, and user requirements.

• Understand and translate business needs into data models supporting long-term solutions.

• Create logical and physical data models using best practices to ensure high data quality and reduced redundancy.

• Develop best practices for standard naming conventions and coding practices to ensure consistency of data models.

• Perform reverse engineering of physical data models from databases and SQL scripts.

• Evaluate data models and physical databases for variances and discrepancies.

• Validate business data objects for accuracy and completeness.

• Analyze data-related system integration challenges and propose appropriate solutions.

• Identify the architecture, infrastructure, and interfaces to data sources, tools supporting automated data loads, security concerns, analytic models, and data visualization.

• Work with business and solution teams to implement data strategies, build data flows, and develop conceptual/logical/physical data models

• Work proactively and independently to address project requirements and articulate issues/challenges to reduce project delivery risks.

• Well versed in Data Modeling tools like ER/Studio, Erwin Data Modeler, Data Vault, Toad Data Modeler etc.,

• Hands on experience of working in the Cloud technologies – AWS/Azure/GCP

• End to end data and analytics solutions design experience using cloud technologies- AWS S3, Spark, EMR, Data bricks, MPP databases, Redshift/Snowflake right from Ingestion to Transformation to Consumption using various methods including API delivery or similar knowledge in alternate cloud services

• Strong skills in SQL, SQL Procedure builds

• Strong skills in analyzing Data Warehouse performance issues and resolutions using various methods/ techniques

• Strong analytical skills and troubleshooting skills

• Excellent communication skills

Travel Requirements

Not Specified

Job Posting End Date