Data Engineer - Workplace Analytics & Reporting
0 views3-5 years
Posted 1 day ago
- GCP
- Jenkins
- Python
Location: Pune / Bengaluru, India
IMMEDIATE JOINERS ONLY PLEASE
Must be able to join before 1st December 2026. If you are serving a notice period that ends later, please do not apply.
Salary: Up to 12 LPA (CTC)
Experience: 3 - 5 years
Location: Pune / Bengaluru
About the role
The project has already started, and we need a Data Engineer to join right away. You will build data pipelines for a workplace analytics initiative for a global banking client. The work involves pulling data from physical access systems and building/space systems, cleaning and transforming it, and producing safe, aggregated datasets without exposing sensitive raw data. It runs on the client's on-prem servers today, with a planned move to Google Cloud Platform (GCP). This is a production-facing role. You will follow proper escalation processes and lead root cause analysis when issues arise.
What you will do
- Build and maintain ETL/ELT pipelines pulling from multiple source systems
- Design clean, well-structured data models. This is judged heavily, because the design will carry into the future cloud migration.
- Work across logical and physical data modeling, from conceptual entity design to actual database implementation
- Write and tune SQL queries for large data volumes
- Automate pipeline runs
- Ensure data quality, validation and reconciliation
- Maintain data lineage: track and document how data moves and changes, from raw source to final output
- Build with a "cloud-ready" mindset, so code and design move cleanly to GCP later
- Work with synthetic/test data (production data is not available in lower environments)
- Follow SDLC practices across requirements, design, development, testing and deployment
- Handle production issues through proper escalation and structured Root Cause Analysis (RCA)
- Work closely with the internal team to stay up to date on product features, changes and issues
Must-have skills
- Strong SQL, including query tuning and performance optimization
- Python (or a similar scripting language) for pipeline logic
- Hands-on ETL/ELT development, not just conceptual knowledge
- Data modeling, both logical (LDM) and physical (PDM). This is a top priority for the role.
- Data quality and data lineage
- SDLC understanding
- Escalation handling and Root Cause Analysis (RCA) in production support
- Strong problem-solving; able to work independently without constant hand-holding
Good to have (not blocking)
- Power BI or Tableau (basic familiarity is enough)
- CI/CD exposure (e.g., Jenkins)
- Any cloud experience, ideally GCP
Who we are looking for
Someone with 3 - 5 years of data engineering experience, strong SQL and Python fundamentals, and real hands-on ETL and data modeling work, not just tool familiarity. Banking or financial services experience is a plus, not required.