Job Description

Line of Service AdvisoryIndustry/Sector Not ApplicableSpecialism OperationsManagement Level Senior Manager & Summary At PwC, our people in business application consulting specialise in consulting services for a variety of business applications, helping clients optimise operational efficiency. These individuals analyse client needs, implement software solutions, and provide training and support for seamless integration and utilisation of business applications, enabling clients to achieve their strategic objectives.As a business application consulting generalist at PwC, you will provide consulting services for a wide range of business applications. You will leverage a broad understanding of various software solutions to assist clients in optimising operational efficiency through analysis, implementation, training, and support.*Why PWCAt PwC, you will be part of a vibrant community of solvers that leads with trust and creates distinctive outcomes for our clients and communities. This purpose-led and values-driven work, powered by technology in an environment that drives innovation, will enable you to make a tangible impact in the real world. We reward your contributions, support your wellbeing, and offer inclusive benefits, flexibility programmes and mentorship that will help you thrive in work and life. Together, we grow, learn, care, collaborate, and create a future of infinite experiences for each other. Learn more .At PwC, we believe in providing equal employment opportunities, without any discrimination on the grounds of gender, ethnic background, age, disability, marital status, sexual orientation, pregnancy, gender identity or expression, religion or other beliefs, perceived differences and status protected by law. We strive to create an environment where each one of our people can bring their true selves and contribute to their personal growth and the firms growth. To enable this, we have zero tolerance for any discrimination and harassment based on the above considerations. "Responsibilities:

• Data Modeling and Design:

• Develop and maintain conceptual, logical, and physical data models to support business needs.
• Create data models for OLTP (transactional) and OLAP (analytical) systems.
• Define and document data standards, guidelines, and best practices.
• Collaboration with Stakeholders:

• Work with business analysts, data architects, and subject matter experts to gather requirements.
• Collaborate with data engineering teams to implement data models.
• Data Architecture and Governance:

• Ensure adherence to data governance standards and data security policies.
• Participate in metadata management and ensure data lineage documentation.
• Performance Optimization:

• Analyze and optimize data models for performance and scalability.
• Implement indexing and partitioning strategies to enhance database performance.
• Good understanding of Normalization and Denormalization in Relational Databases
• Data Integration:

• Support ETL developers in data mapping and transformation processes.
• Ensure consistency and accuracy of data flows across systems.
• Technical Leadership:

• Mentor junior data modelers and provide technical guidance.
• Stay updated on industry trends, tools, and technologies in data modeling and analytics.

Mandatory skill sets:

• Extensive experience with data modeling tools such as Erwin, ER/Studio, or Power Designer.
• Strong understanding of relational, dimensional, and NoSQL data modeling techniques.
• Expertise in designing data solutions for both structured and unstructured data.
• Proficiency in SQL and database platforms (e.g., Oracle, SQL Server, Snowflake).
• Knowledge of data governance, data quality, and data security best practices.

Preferred skill sets:Experience with cloud-based data solutions (Azure preferred).Years of experience required:11 to 14 yearsEducation qualification:Bachelors or Masters degree in Computer Science, Information Technology, or a related field. 11+ years of experience in data modeling, data architecture, or a similar role. Strong analytical and problem-solving skills. Excellent communication and stakeholder management abilities.Education (if blank, degree and/or field of study not specified) Degrees/Field of Study required: Bachelor of EngineeringDegrees/Field of Study preferred:Certifications (if blank, certifications not specified)Required Skills Data Modeling, Structured Query Language (SQL)Optional Skills Accepting Feedback, Accepting Feedback, Active Listening, Analytical Reasoning, Analytical Thinking, Application Software, Business Data Analytics, Business Management, Business Technology, Business Transformation, Coaching and Feedback, Communication, Creativity, Documentation Development, Embracing Change, Emotional Regulation, Empathy, Implementation Research, Implementation Support, Implementing Technology, Inclusion, Influence, Intellectual Curiosity, Learning Agility, Optimism {+ 24 more}Desired Languages (If blank, desired languages not specified)Travel Requirements Not SpecifiedAvailable for Work Visa Sponsorship? NoGovernment Clearance Required? NoJob Posting End Date

PwC