Address- This role is with the PFNA Data Analytics and Automation Solutions team within PFNA IT.
- The data modeler designs, implements, and documents data architecture and data modeling solutions, which include the use of relational, dimensional, and NoSQL databases. These solutions support enterprise information management, business intelligence, machine learning, data science, and other business interests.
- Role will focus on PepsiCo data modeling, metadata management, data governance support of all Pepsico business & subject Areas. Role will support data design activities to ensure alignment of key attributes across local, sector, and globally defined attributes.
- You will work with PFNA IT and business professionals across multiple functions to drive and support the PFNA transformation. You will identify opportunities for more streamlined and automated approaches to solve business problems with data/digital solutions and advocate for their adoption.
- You will help manage and mentor other PFNA IT associates working in the data & digital space in support of the above goals.
Responsibilities
Governs data design/modeling - documentation of metadata (business definitions of entities and attributes) and constructions database objects, for baseline and investment funded projects,as assigned; supports NAB/PBC Applications, Global MDM, EDW & Datalake /Lakehouse Modeling (Accountable)
-Provides and/or supports data analysis, requirements gathering, solution development, and
design reviews for enhancements to, or new, applications/reporting (Accountable/Consultation)
-Independently complete designs and database object constructs on any supported platform,
including Microsoft Azure, Synapse, Teradata, Sybase, Salesforce, Oracle, and/or DB2 (Accountable)
-Supports assigned project contractors (both on- & off-shore), orienting new contractors to
standards, best practices, and tools (Accountable)
-Advocates existing Enterprise Data Design standards; assists in establishing and documenting
new standards (Accountable/Consultation)
- Contributes to project cost estimates, working with BRM s to evaluate the size and complexity of
the changes or new development (Consultant)
- 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, analytics, and machine learning).
- Work with business and application/solution teams to implement data strategies, build data flows, and develop conceptual/logical/physical data models
- Define and govern data modeling and design standards, tools, best practices, and related development for enterprise data models.
- Identify the architecture, infrastructure, and interfaces to data sources, tools supporting automated data loads, security concerns, analytic models, and data visualization.
- Hands-on modeling, design, configuration, installation, performance tuning, and sandbox POC.
- Work proactively and independently to address project requirements and articulate issues/challenges to reduce project delivery risks.
-Knowledge on any cloud platforms , specifically Synapse and Azure is added advantage.
Qualifications
- 5 + years experience in Information Technology or Business Relationship Management
- 5 + years experience in performing data modeling/data design, hands-on relational, dimensional, and/or analytic experience (using RDBMS, dimensional, NoSQL data platform technologies, and ETL and data ingestion protocols).
- Experience with data warehouse, data lake, and enterprise big data platforms in multi-data-center contexts required.
- Bachelor s degree in Computer Science, MIS, Business Management, or related field
- Excellent remote collaboration skills
- Experience working in a matrix organization with diverse priorities
Solutions Delivery experience - expertise in system development lifecycle, integration, and
sustainability - Advanced data modeling or database experience; experience with Data Lake/Lakehouse, Synapse, IDM, ER/Studio and/or Erwin modeling tools
- Good knowledge of metadata management, data modeling, and related tools
- Knowledge on Datalake/Cloud Platforms(Azure (synapse)/GCP(Bigquery) etc), ADF,Databricks, Pipeline Creations is a plus
Good understanding of CPG/PepsiCo business processes, data, and EDW/MDM environments - Exceptional written and verbal communication skills along with collaboration and listening skills
- Ability to work with agile delivery methodologies
- Ability to ideate requirements & design iteratively with business partners without formal requirements documentation
Ability to lead teams with effective collaboration - Primary focus would be to partner with Enterprise Architecture to create Data Models, establish data standards and govern across all development; advocate and assist in governing Enterprise Architecture standards and strategy via data solutions.
- This would include independently analyzing project data needs, identifying and resolving data storage and integration
- Ability to work with virtual teams (remote work locations); lead team of technical resources (employees and contractors) based in multiple US locations and off-shore
- Actively participate in technical discussions, driving clarity of complex issues/requirements to build robust solutionsStrong communication skills to meet with business, understand sometimes ambiguous, needs, and translate to clear, aligned requirements
Skills: Data Modeling, virtual teams, Sybase, data models, Db2, Business Management, Computer Science, Mdm, Business Intelligence, Edw, Microsoft Azure, Machine Learning, Big Data, Teradata, technical discussions , Nosql, Data Science, Integration, Adf, er/studio, Data Warehouse, Enterprise Architecture, Synapse, Data Governance, Salesforce, Mis, Cpg, Data Lake, Erwin, data standards, Databricks, Communication, Data Design, Metadata Management, Oracle, Sustainability
Experience: 5.00-7.00 Years
