Senior Data Modelling Engineer

4 weeks ago

India The Institute of Clever Stuff Full time

Where: India (fully remote)

Business Hours: UK hours

Process:

1. ICS 1st Interview (30 minutes)

2. CV shared with client, followed by 1-2 further rounds

Context of work:

  • The client is a global energy company undergoing a significant transformation to support the energy transition. We work within their Customers & Products (C&P) division, serving both B2C and B2B customers across key markets such as the UK, US, Germany, Spain, and Poland.
  • This business unit includes mobility (fuel and EV), convenience retail, and loyalty.

Required Skills and Experience:

  • Proven experience in data modelling and data pipeline development.
  • Proficiency with tools like ER Studio, STTM, AWS Glue, Redshift & Athena, and Power BI.
  • Strong SQL and experience with generating DDL scripts.
  • Experience working in SAP data environments.
  • Experience in any of these domain areas is highly desirable: Logistics, Supply Planning, Exports and IFOT.
  • Familiarity with cloud platforms, particularly AWS.
  • Hands-on experience with DevOps and Agile methodologies (e.g., Azure ADO).
  • Strong communication and documentation skills.
  • Ability to work collaboratively with cross-functional teams.

Key Responsibilities

Data Modelling

  • Initiate and manage Gap Analysis and Source-to-Target Mapping Exercises.
  • Gain a comprehensive understanding of the EA extract.
  • Map the SAP source used in EA extracts to the AWS Transform Zone, AWS Conform Zone, and AWS Enrich Zone.
  • Develop a matrix view of all Excel/Tableau reports to identify any missing fields or tables from SAP in the Transform Zone.
  • Engage with SME's to finalise the Data Model (DM).
  • Obtain email confirmation and approval for the finalised DM.
  • Perform data modelling using ER Studio and STTM.
  • Generate DDL scripts for data engineers to facilitate implementation.

Data Engineering

  • Set up infrastructure for pipelines – this includes Glue Jobs, crawlers, scheduling, step functions, etc.
  • Build, deploy, test and run pipelines on demand in lower environments.
  • Verify data integrity: no duplicates, all columns in final table etc.
  • Write unit tests for methods used in the pipeline and use standard tools for testing.
  • Code formatting and linting.
  • Collaborate with other Modelling Engineers to align on the correct approach.
  • Update existing pipelines for CZ tables (e.g., Serverless Data Lake Framework (SDLF)) where necessary with new columns if they are required for EZ tables.
  • Raise DDP requests to register databases and tables, and to load data into the raw zone.

Other

  • Create comprehensive good documentation. Ensure each task is accompanied by detailed notes specific to its functional area for clear tracking and reference.
  • Analyse and manage bugs and change requests raised by business/SMEs.
  • Collaborate with Data Analysts and Virtual Engineers (VE) to refine and enhance semantic modelling in Power BI.
  • Plan out work using Microsoft Azure, ADO. Dependencies, status and effort are correctly reflected.

  • Senior Data Engineer

    3 weeks ago

    India Aptus Data Labs Full time

    Job Title: Senior Data EngineerLocation: RemoteExperience: 4+Employment Type: Full-TimeNotice- Looking for immediate joiners or who can join within 15-20 days.About the RoleAptus Data Labs is looking for a talented and proactive Senior Data Engineer to help build the backbone of our enterprise data and AI initiatives. You'll work on modern data lake...

  • Senior Data Modelling Engineer

    4 weeks ago

    India The Institute of Clever Stuff Full time

    Where: India (fully remote)Business Hours: UK hoursProcess:1. ICS 1st Interview (30 minutes)2. CV shared with client, followed by 1-2 further roundsContext of work:- The client is a global energy company undergoing a significant transformation to support the energy transition. We work within their Customers & Products (C&P) division, serving both B2C and B2B...

  • Senior Data Modelling Engineer With Gcp, Sql, Cognos, Etl

    4 weeks ago

    India Iitjobs, Inc. Full time

    GreetingsRole:- Senior Data Modelling Engineer with GCP, SQL, cognos, ETLExperience:- 4+ Years Location- Remote Duration: 4 Months Contract Required Skills & Experience:- Extensive experience with SQL, including writing complex queries and optimizing database performance (Must have)● Demonstrated expertise in data modeling techniques, including dimensional...

  • Senior Engineer, Data Engineering

    24 hours ago

    India Collabera Full time

    Senior Data Engineer Fully Remote Shift: US Time Zone (Night Shift)Financial Institution (FI) - Credit Union Collabera is seeking a seasoned Senior Data Engineer for its leading financial customer to design and optimize data solutions that power our analytics, reporting, and Member 360 initiatives. This role is ideal for someone with deep expertise in ETL...

  • Senior Data Engineer

    4 weeks ago

    India Black Piano Full time

    OverviewAs a Senior Data Engineer, you'll play a crucial role in storing, processing, modelling, and applying data science to make data and insights available for analytics and business intelligence (BI) systems. This position offers a unique opportunity to work with cutting-edge products and world-class clients in a remote-first environment.Key...

  • Senior Data Engineer

    4 weeks ago

    India Asenium Consulting Full time

    For one of my customers, we are looking for a Senior Data Engineer.Location: India (100% remote)Duration: 6+ months (renewable)Description: We are looking for a Senior Data Engineer with strong experience in SQL, Talend, and cloud platforms such as Google Cloud (Big Query) and Microsoft Azure.You will be responsible for designing and managing ETL pipelines,...

  • Erwin Data Modeler

    4 weeks ago

    India ADFAR Tech Full time

    ERwin Data Modeler - 5+ years of experience.Location: Onsite Riyadh (Saudi Arabia)JD as follows: Design and maintain conceptual, logical, and physical data models using ERwin Data Modeler Develop OLTP and OLAP data models for enterprise data warehouses and applications Reverse-engineer and forward-engineer models across Oracle, SQL Server, Snowflake Define...

  • ERwin Data Modeler

    4 weeks ago

    India ADFAR Tech Full time

    ERwin Data Modeler - 5+ years of experience.Location: Onsite Riyadh (Saudi Arabia)JD as follows:- Design and maintain conceptual, logical, and physical data models using ERwin Data Modeler- Develop OLTP and OLAP data models for enterprise data warehouses and applications- Reverse-engineer and forward-engineer models across Oracle, SQL Server, Snowflake-...

  • Senior Data Engineer

    10 hours ago

    India beBeeData Full time ₹ 1,80,00,000 - ₹ 2,40,00,000

    Job Title: Senior Data EngineerWe are seeking a highly skilled Senior Data Engineer to join our team. As a key member of our data engineering team, you will play a vital role in designing, building, and maintaining large-scale data systems.About the Role:The ideal candidate will have a strong background in software engineering, with experience in building...

  • Senior Data Engineering Expert

    10 hours ago

    India beBeeDataEngineer Full time

    We are seeking a highly skilled and experienced Senior Data Engineer to join our team. This is an exciting opportunity for someone with deep technical expertise in ETL pipeline design, data modeling, and data infrastructure who thrives in a fast-paced engineering-driven environment.The ideal candidate will have advanced proficiency in SQL and ETL/ELT design,...