Oracle Data Modeler - Senior Associate

PwC Acceleration Center India; Bengaluru; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

PwC Acceleration Center India is seeking an Oracle Data Modeler - Senior Associate to optimize client operations by analyzing needs and implementing Oracle's data tools. You will work with Oracle Database, Oracle Analytics Cloud, and Oracle Data Integrator to collect, cleanse, model, and visualize data.

You will mentor junior members, manage client relationships, and navigate complex data challenges, contributing to project success and your own professional growth in a dynamic, collaborative

Qualifications

• Bachelor's degree required.
• At least 5 years of experience.
• Proficiency in English (oral and written).
• Proficiency in data modeling tools.
• Strong knowledge of SQL for data analysis.
• Familiarity with ETL processes to map data flows.

Responsibilities

• Analyzing client needs to implement Oracle data solutions effectively.
• Using Oracle tools for data collection, cleansing, transformation, and modeling.
• Developing data visualization and analysis using Oracle Analytics Cloud and Oracle Data Visualization.
• Integrating data using Oracle Data Integrator and Oracle Golden Gate.
• Building and maintaining client relationships to support seamless integration of business applications.
• Providing training and support to clients for optimized use of Oracle data tools.
• Collaborating with teams to enhance data quality and security measures.
• Applying analytical thinking to derive insights and recommendations from complex data sets.
• Navigating complex situations to deliver quality solutions and support client objectives.
• Mentoring junior team members to foster growth and development in data analytics skills.

Skills

SQL

Data modeling

English

Education

Bachelor's degree

Tools

Erwin Data Modeler

ER/Studio

IBM Infosphere Data Architect

Job description

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 Oracle Data Modeler - Senior Associate, you will engage with clients to optimize their operational efficiency by analyzing their needs and implementing Oracle's suite of tools and technologies. This role involves data collection, cleansing, transformation, modeling, visualization, and analysis to derive actionable insights. As a Senior Associate, you will focus on building meaningful client connections and learning how to manage and inspire others. You will navigate increasingly complex situations, growing your personal brand and enhancing your technical skills. You are expected to anticipate the needs of your teams and clients, delivering quality solutions even when the path forward is not clear.

In this role at PwC Acceleration Center India, you will be part of our Business Application Consulting team within our Oracle practice. You will leverage Oracle tools like Oracle Database, Oracle Analytics Cloud, and Oracle Data Integrator to support clients in achieving their strategic objectives. This position offers the opportunity to deepen your understanding of business contexts and develop your skills in a dynamic and supportive environment. You will use a broad range of methodologies and techniques to generate new ideas and solve problems, contributing to the overall strategy and success of our clients.

Responsibilities

• Analyzing client needs to implement Oracle data solutions effectively
• Utilizing Oracle tools for data collection, cleansing, transformation, and modeling
• Developing data visualization and analysis using Oracle Analytics Cloud and Oracle Data Visualization
• Integrating data using Oracle Data Integrator and Oracle Golden Gate
• Building and maintaining client relationships to support seamless integration of business applications
• Providing training and support to clients for optimized use of Oracle data tools
• Collaborating with teams to enhance data quality and security measures
• Applying analytical thinking to derive insights and recommendations from complex data sets
• Navigating complex situations to deliver quality solutions and support client objectives
• Mentoring junior team members to foster growth and development in data analytics skills

What You Must Have

• At least a Bachelor's degree
• At least 5 years of experience
• Oral and written proficiency in English required
• Proficiency in any Data modeling tool like Erwin Data Modeler, ER/Studio, or IBM Infosphere Data Architect
• Strong knowledge of SQL, PostgreSQL, MySQL, MS SQL Server, or Oracle for Data analysis
• Familiarity with ETL processes to map data flows

What Sets You Apart

• Proficiency in data modeling tools preferred
• Familiarity with ETL processes for data flows
• Experience in normalization and denormalization techniques
• Preference for at least one of the following fields of study: Computer Science, Computer and Information Science, Information Technology, Data Science, Statistics, Mathematics, Engineering
• At least one of the following: Oracle Cloud Infrastructure (OCI) certifications; cloud architecture certifications (AWS, Azure, or Google Cloud); cloud data engineering certifications (AWS, Azure, GCP, or Databricks); Snowflake certifications
• Demonstrating proficiency in Oracle Business Intelligence Enterprise Edition (OBIEE)
• Utilizing advanced data modeling and data integration techniques
• Excelling in complex data analysis and data-driven consulting
• Developing innovative data quality improvement plans (DQIP)
• Navigating complex client relationships and delivering tailored solutions