Data Engineer – SAP Data sphere & ETL Developer

HTC Global Services logo

HTC Global Services

View Salaries, Reviews, and more  

Job Summary


Job Type
-

Seniority

Years of Experience
Information not provided

Tech Stacks
Python SQL Spark Databricks Backbone pySpark SAP Flow OData Analytics API Snowflake ETL Delta Lake

Job Description

Exciting Opportunity Alert! 🌟 HTC Global Services is hiring Data Engineer – SAP Data sphere & ETL Developer for an Airline Project.


HTC Global Services - a leading CMM level 5 global provider of innovative IT and Business Process Services and Solutions since 1990 with headquarters in Troy, Michigan, USA.


Role Overview:

As a Data Engineer, you will be the technical backbone of our SAC Workforce Planning implementation. You will work in a high-synergy partnership with the Lead SAC Planning Consultant, taking full ownership of the data supply chain. Your mission is to architect a seamless flow of employee, position, and cost data from SuccessFactors and Databricks into SAC Analytics Cloud (SAC), ensuring the planning models are accurate, automated, and performant.

Key Activities (Technical Support & Integration)

  • SAC Planning Support: Partner directly with the SAC Consultant to design and optimize the Data Layer in Datasphere that feeds the SAC Planning Model. Ensure all dimensions (Org Units, Cost Centers, Employee IDs) and measures (FTE, Salary, Benefits) are perfectly aligned.
  • SuccessFactors Extraction (Snapshotting): Develop and manage complex extraction logic from SuccessFactors (via OData/Compound Employee API) to create "point-in-time" snapshots—essential for attrition analysis and budget-vs-actual variance.
  • Advanced Data Transformation (Databricks): Use Databricks (Spark/Python) to perform heavy-lifting transformations that exceed standard SAP capabilities, such as complex payroll allocations, localized benefit calculations, or blending external market benchmark data.
  • Datasphere Model Building: Build and maintain the Business Layer and Data Layer in SAP Datasphere. Create Graphical/SQL Views and Analytic Models specifically optimized for SAC consumption.
  • Automated Data Orchestration: Design and monitor end-to-end schedules. Ensure that when a planner opens an SAC story, the data has been refreshed from source systems without manual intervention.
  • Quality Assurance & Reconciliation: Implement automated reconciliation scripts to verify that headcount and total labor costs in Datasphere match the source systems (SuccessFactors/Finance) before data is pushed to the SAC Planning model.

Technical Skills & Experience

  • SAP Datasphere Mastery: Expert knowledge of Spaces, Data Flows, and Transformation Flows. Experience with Remote Tables and Data Federation vs. Replication strategies.
  • Databricks / Spark: Proficiency in PySpark or SQL within Databricks to clean and enrich HR data. Ability to manage Delta Lake tables for versioned workforce data.
  • Integration Specialist: Hands-on experience with SAP BTP (Business Technology Platform) and Cloud Connector. Knowledge of how to handle SuccessFactors API pagination and delta loads.
  • Data Modeling for Planning: Understanding of Star Schema and Snowflake Schema designs specifically for OLAP (Online Analytical Processing) and SAC Planning requirements.
  • Security & PII Governance: Expert-level implementation of Data Access Controls (DAC) in Datasphere to ensure sensitive salary data is only visible to authorized planners based on their Org Unit.

Professional Experience

  • Workforce Planning Background: Previous experience working on at least one SAC Workforce Planning or SAP BPC project is highly preferred.
  • Collaborative Mindset: Proven track record of working as the "Technical Lead" supporting a "Functional Lead" (Consultant) to deliver business-critical analytics.
  • Problem Solver: Ability to troubleshoot data discrepancies between HRIS (SuccessFactors) and the Planning environment (SAC) independently.


Interested candidates please do share your updated CV to [email protected] mentioning your Current CTC, expected CTC and notice period details.


#HTCGlobalServices #ITJobs #hiring #lookingforjob #careers #jobs #immediatejoiner #recruitment #technology #jobseekers #interview #lookingforjobchange #newjob #SAPSAC #WorkforcePlanning #SAPDataSphere


Interview Questions of Data Engineer – SAP Data sphere & ETL Developer at HTC Global Services

Currently, there aren't any interview questions for this role at HTC Global Services shared by other job seekers.
View more interview questions of similar roles from other companies →
banner icon
Prepare For Your Interview in 1 Week?
Equip yourself with possible questions that interviewers might ask you, based on your work experience and job description.
Get Started!

Salary Insights of Data Engineer – SAP Data sphere & ETL Developer at HTC Global Services

Currently, there aren't any salaries for this role at HTC Global Services shared by other job seekers.

View more salaries from HTC Global Services →

Achieve your dream job with our top-notch tools!

Resume Checker Illustration

Resume Checker

Our free resume checker analyzes the job description and identifies important keywords and skills missing from your resume in just a minute!

Check Now
Interview Preparation Illustration

AI InterviewPrep

Utilizing advanced AI, our tool generates tailored interview questions based on your industry, role, and experience. Practice and receive feedback on your answers in real time!

Check Now
Resume Builder Illustration

Resume Builder

Let us show you the differences between a bad, good, and great resume, and guide you in building a resume that helps you stand out to employers, ensuring you land your next position faster!

Check Now