Architect / Data Modeler- Senior Manager

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

Work arrangement
No