SUPERVISOR, DATA MODELING Orange

Duties and responsibilities

• Develop Logical and Physical data models for OLAP and OLTP systems.
• Enforce modeling standards including normalization, denormalization, data transformation, data lineage, and data quality for the Enterprise Data Platform.
• Transform raw data from multiple sources into actionable insights.
• Conduct modeling sessions with project teams across business units to gather and define data requirements for the Enterprise Data Models.
• Collaborate with business and data teams to enhance data models quality and validity for decision support entities.
• Perform light data analysis and profiling using SQL queries on metadata as needed.
• Document data models for building reference that includes definitions for business terms and KPIs.
• Conceptualize complex data schemes while ensuring alignment with modern data architectures like Data Lakehouse.
• Collaborate with business stakeholders for requirements gathering and ensure alignment of data models with business needs.

Education

Bachelor's degree from a recognized university in Computer Science, Engineering, or any relevant field.

Experience

• 3 - 5 Years Experience In data modeling, statistical analysis, data manipulation, and ETL.

Skills and abilities

• Strong proficiency of English language spoken and written
• Advanced level in using SQL for analytics.
• Knowledgeable in Inmon and Kimball approaches for designing Data Warehouse and Data Mart architectures.
• Familiar with using Data Build Tool (DBT) and Python.
• Knowledge of big data ecosystems and trending data platform architectures.
• Strong analytical mindset with experience in turning business requirements into logical and physical models.
• Ability to grasp concepts quickly.