Architect / Data Modeler- Senior Manager

Industry/SectorNot Applicable

SpecialismProduct Innovation

Management LevelSenior Manager

Job Description & SummaryAt PwC, our people in data and analytics engineering focus on leveraging advanced technologies and techniques to design and develop robust data solutions for clients. They play a crucial role in transforming raw data into actionable insights, enabling informed decision-making and driving business growth.

In data engineering at PwC, you will focus on designing and building data infrastructure and systems to enable efficient data processing and analysis. You will be responsible for developing and implementing data pipelines, data integration, and data transformation solutions.

Preferred Knowledge/Skills :

Demonstrates intimate abilities and/or a proven record of success as a team leader: - 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, 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 brick 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; - 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 management skills; - 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 SQ 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 Ora

The Opportunity When you join PwC Acceleration Centers (ACs), you step into a pivotal role focused on actively supporting various Acceleration Center services, from Advisory to Assurance, Tax and Business Services. In our innovative hubs, you’ll engage in challenging projects and provide distinctive services to support client engagements through enhanced quality and innovation. You’ll also participate in dynamic and digitally enabled training that is designed to grow your technical and professional skills.

As part of the Data Engineering team you are expected to lead the creation and implementation of impactful data solutions. As a Senior Manager you are expected to guide the execution of our Data Engineering Strategy, maintaining a customer-centric approach that supports PwC's goals and vision. You are expected to leverage your proficiency in Data Modeling and cloud technologies to drive project success and maintain operational excellence. Responsibilities

• Lead the development and execution of data engineering strategies
• Assure customer-centric data solutions align with PwC's vision
• Utilize proficiency in data modeling and cloud technologies to drive success
• Maintain operational excellence through innovative processes
• Guide and mentor team members to achieve project goals
• Foster client relationships through strategic interactions
• Identify opportunities for process improvements and implement changes
• Communicate complex technical concepts to diverse stakeholders What You Must Have
• Bachelor's Degree in Engineering, Technology
• 12 years of experience with 12-16 years of experience preferred
• Oral and written proficiency in English necessary What Sets You Apart
• Master's Degree preferred
• Experience in Data Modeling and development of data models
• Implementing business and IT data requirements
• Advanced skills in SQL and SQL Procedure builds
• Experience in Cloud technologies
• Advanced analytical and troubleshooting skills
• Exceptional communication skills
• Business/domain knowledge in various domains

  Travel RequirementsNot Specified

  Job Posting End Date