Lead Data Modeler

Primary :

• 10+ years of overall technology experience that includes at least 8+ years of data modeling and systems architecture.
• 5+ years of experience with Data Lake Infrastructure, Data Warehousing, and Data Analytics tools.
• 6+ years of experience developing enterprise data models.
• 4+ years in cloud data engineering experience in at least one cloud (Azure, AWS, Google Cloud Platform).
• 4+ years of experience with building solutions in the retail or in the supply chain space.

Required Skills & Qualifications:

• Expertise in data modelling tools (ER/Studio, Erwin, IDM/ARDM models, CPG / Manufacturing/Sales/Finance/Supplier/Customer domains )
• Experience with at least one MPP database technology such as Databricks Lakehouse, Redshift, Synapse, Teradata, or Snowflake.
• Experience with version control systems like GitHub and deployment & CI tools.
• Experience of metadata management, data lineage, and data glossaries is a plus.
• Working knowledge of agile development, including DevOps and DataOps concepts.
• Working knowledge of SAP data models, particularly in the context of HANA and S/4HANA, Retails Data like IRI, Nielsen Retail.

• Independently complete conceptual, logical and physical data models for any supported platform, including SQL Data Warehouse, Spark, Data Bricks Delta Lakehouse or other Cloud data warehousing technologies.
• Governs data design/modelling documentation of metadata (business definitions of entities and attributes) and constructions database objects, for baseline and investment funded projects, as assigned.
• Develop a deep understanding of the business domains like Customer, Sales, Finance, Supplier, and enterprise technology inventory to craft a solution roadmap that achieves business objectives, maximizes reuse.
• Drive collaborative reviews of data model design, code, data, security features to drive data product development.
• Show expertise for data at all levels: low-latency, relational, and unstructured data stores; analytical and data lakes; SAP Data Model.
• Develop reusable data models based on cloud-centric, code-first approaches to data management and data mapping.
• Partner with the data stewards team for data discovery and action by business customers and stakeholders.
• Provides and/or supports data analysis, requirements gathering, solution development, and design reviews for enhancements to, or new, applications/reporting.
• Assist with data planning, sourcing, collection, profiling, and transformation.
• Support data lineage and mapping of source system data to canonical data stores.
• Create Source to Target Mappings (STTM) for ETL and BI developers.