Sr. Manager Data Modeling

Job Description

A career in our Advisory Acceleration Centre is the natural extension of PwC s leading class global delivery capabilities. provide premium, cost effective, high quality services that support process quality and delivery capability in support for clie engagements.Years of Experience: Candidates with 12-16 years of hands on experience Position Requirements:Must Have: Experience in Data Modeling and responsible for the development of the conceptual, logical, and physical data mode the implementation of RDBMS, operational data store (ODS), data marts, and data lakes on target platform (SQL/NoSQL). Implement business and IT data requirements through new data strategies and designs across all data platform(relational, dimensional, and NoSQL) and data tools (reporting, visualization). 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, securi concerns, analytic models, and data visualization. Work with business and solution teams to implement data strategies, build data flows, and develo conceptual/logical/physical data models Work proactively and independently to address project requirements and articulate issues/challenges to reduce projeWdelivery 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 brick MPP databases, Redshift/Snowflake right from Ingestion to Transformation to Consumption using various metho 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 Ability to adapt quickly to an existing, complex environment and learn new concepts and software Self-motivated, independent, detail oriented, responsible team player and exhibit exceptional relationship managemeskills Business / domain knowledge in one of the domains -Financial Services/ Healthcare/ Consumer Market/Industrial Products/ Telecommunication,Media and Technology /Deal advisory along with technical expertise Experience in leading technical teams, guiding and mentoring team members Good analytical & problem-solving skills Strong Data modeling skills utilizing one of the industry leading tools like ER/Studio, Erwin Data Modeler, Oracle Developer etc. Strong knowledge and experience in SQL and SQL procedures for data analysis, extraction and manipulation Strong experience in Database SQL tuning and performance improvement Experience with multiple relational databases platforms like Oracle, Exadata, MS SQL ServerDesired Knowledge / Skills: 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 brick MPP databases, Redshift/Snowflake right from Ingestion to Transformation to Consumption using various metho including API delivery or similar knowledge in alternate cloud services Experience in Pre-sales and RFP responsesProfessional and Educational Background: BE / B.Tech / MCA / M.Sc / M.E / M.Tech / MBAAdditional Information: Line of Service: Advisory Horizontal: Technology Consulting Designation: Senior Manager Location: Bangalore, India Key Skills: A career in our Advisory Acceleration Centre is the natural extension of PwC s leading class global delivery capabilities. provide premium, cost effective, high quality services that support process quality and delivery capability in support for clie engagements.Years of Experience: Candidates with 12-16 years of hands on experience Position Requirements:Must Have: Experience in Data Modeling and responsible for the development of the conceptual, logical, and physical data mode the implementation of RDBMS, operational data store (ODS), data marts, and data lakes on target platform (SQL/NoSQL). Implement business and IT data requirements through new data strategies and designs across all data platform(relational, dimensional, and NoSQL) and data tools (reporting, visualization). 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, securi concerns, analytic models, and data visualization. Work with business and solution teams to implement data strategies, build data flows, and develo conceptual/logical/physical data models Work proactively and independently to address project requirements and articulate issues/challenges to reduce projeWdelivery 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 brick MPP databases, Redshift/Snowflake right from Ingestion to Transformation to Consumption using various metho 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 Ability to adapt quickly to an existing, complex environment and learn new concepts and software Self-motivated, independent, detail oriented, responsible team player and exhibit exceptional relationship managemeskills Business / domain knowledge in one of the domains -Financial Services/ Healthcare/ Consumer Market/Industrial Products/ Telecommunication,Media and Technology /Deal advisory along with technical expertise Experience in leading technical teams, guiding and mentoring team members Good analytical & problem-solving skills Strong Data modeling skills utilizing one of the industry leading tools like ER/Studio, Erwin Data Modeler, Oracle Developer etc. Strong knowledge and experience in SQL and SQL procedures for data analysis, extraction and manipulation Strong experience in Database SQL tuning and performance improvement Experience with multiple relational databases platforms like Oracle, Exadata, MS SQL ServerDesired Knowledge / Skills: 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 brick MPP databases, Redshift/Snowflake right from Ingestion to Transformation to Consumption using various metho including API delivery or similar knowledge in alternate cloud services Experience in Pre-sales and RFP responsesProfessional and Educational Background: BE / B.Tech / MCA / M.Sc / M.E / M.Tech / MBAAdditional Information: Line of Service: Advisory Horizontal: Technology Consulting Designation: Senior Manager Location: Bangalore, India,

Keyskills :
ms sqlsql tuningdata martsdata vaultdata modelsdata qualitydata analysisdata modeling