Job Description

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.

 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.

 Provides and/or supports data analysis, requirements gathering, solution development, and design reviews for enhancements to, or new, applications/reporting

 Independently complete designs and database object constructs on any supported platform, including Microsoft Azure, Synapse, Teradata, Sybase, Salesforce, Oracle, and/or DB2 (Accountable)

 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.

 Be responsible for the development of the conceptual, logical, and physical data models, the implementation of RDBMS, operational data store (ODS), data marts, and data lakes on target platforms (SQL/NoSQL).

 Oversee and govern the expansion of existing data architecture and the optimization of data query performance via best practices. The candidate must be able to work independently and collaboratively.

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com .

To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/ .

Skills and Requirements

6-9 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.

 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

 Knowledge on Data lake/Cloud Platforms(Azure - Synapse), ADF, Databricks

 Good understanding of CPG/PepsiCo business processes, Industry data models and EDW/MDM environments null

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal employment opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment without regard to race, color, ethnicity, religion,sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military oruniformed service member status, or any other status or characteristic protected by applicable laws, regulations, andordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request to HR@insightglobal.com.