Senior Data Engineer

Zoho; Bengaluru; On-site; INR 1,500,000 - 2,100,000; Full time

Benefits offered by this job

Competitive salary

Insurance plans

Collaborative environment

Growth opportunities

Job summary

Prescience Decision Solutions in Bengaluru is seeking a Senior Data Engineer with 6+ years of experience to build scalable data pipelines and enterprise-grade data solutions. You will own end-to-end data engineering, from design to deployment, with strong emphasis on Python, SQL, data architecture, workflow orchestration like Airflow, and strict data governance.

The role requires hands-on work with highly governed finance, risk, or compliance data, ensuring data quality, lineage, and

Qualifications

• 6+ years in Data Engineering.
• Strong data architecture and system design skills.
• End-to-end ownership of production data pipelines.
• Expertise in Python and SQL.
• Experience with workflow orchestration like Airflow.
• Experience with finance/risk/compliance data domains.
• Designing and building transaction and fact tables.
• Advanced SQL skills (window functions, CTEs, CASE).
• Strong Python (pandas, SQLAlchemy, data classes, type hints).
• Experience with YAML configurations and Git workflows.

Responsibilities

• Own end-to-end data engineering processes from design to deployment and operations.
• Build scalable data pipelines, data models, and enterprise-grade data solutions.
• Ensure data quality, lineage, and governance across governed data domains.
• Collaborate with teams using Airflow or similar orchestration tools.
• Implement and optimize data models including fact/dimensions and medallion architecture.

Skills

Python

SQL

Data modeling

Data architecture

Airflow

Data quality

Data governance

Pandas

SQLAlchemy

Data classes

OO pipeline

Tools

Hive

Hadoop

Git

YAML

CI/CD

Job description

Prescience Decision Solutions | Full time

Prescience Decision Solutions, established in 2017, partners with Fortune 500 and mid-sized companies globally to unlock enterprise data and drive improved decision-making. We specialize in Data Science, Advanced Analytics, and Data Engineering, integrating AI and machine learning to deliver measurable business value and ROI.

Headquartered in Bangalore, our ‘Business Backward’ approach ensures a deep understanding of your challenges, enabling us to provide tailored, impactful solutions.

Founded by industry leaders from IIT and IIM, Prescience is a bootstrapped and profitable company with a strong project pipeline.

Our commitment to excellence has earned us recognition as one of the top three startups in the People Excellence category by xto10x, with a 97 percentile employee NPS, 100% mutual respect among employees, and a 98% employee pride rate.

As an equal opportunity employer, we are dedicated to fostering a diverse and inclusive workplace, free from discrimination based on caste, religion, gender, sexual orientation, nationality, or other protected characteristics.

To learn more, subscribe to our YouTube channel: YouTube Link .

Role Overview

Seeking a Senior Data Engineer with 6+ years of experience in building scalable data pipelines, data models, and enterprise-grade data solutions. The role requires strong expertise in Python, SQL, data architecture, workflow orchestration, and data quality frameworks, along with experience handling highly governed finance, risk, or compliance data. The ideal candidate will own end-to-end data engineering processes, from solution design and development to deployment, monitoring, and operational support.

Job Description

Job Description:

• 6+ years of experience in Data Engineering.
• Strong data architecture and system design skills with the ability to make sound trade-offs around data modeling, partitioning, and scalability.
• Demonstrated end-to-end ownership of production data pipelines, including design, deployment, monitoring, and operational support.
• Expertise in Python and SQL as primary tools; experience with Hive/Hadoop is a plus.
• Strong focus on data quality, validation, reconciliation, anomaly detection, and audit ability.
• Experience working with finance, risk, compliance, or other highly regulated data domains requiring strong data lineage and governance.
• Proven experience designing and building transaction and fact tables.
• Advanced SQL skills, including window functions, CTEs, CASE statements, and working across MySQL/PostgreSQL environments.
• Strong Python expertise, including pandas, SQLAlchemy, type hints, data classes, and object-oriented pipeline development.
• Experience with workflow orchestration platforms such as Airflow or similar tools.
• Strong understanding of data modeling concepts including fact/dimension modeling, normalization, and medallion architecture.
• Experience with YAML-based configurations, CI/CD practices, and Git-based development workflows.

Requirements

Strongly Preferred:

• Experience with enterprise data platforms, internal data tooling ecosystems, metadata/catalog solutions, secrets management tools, developer productivity platforms, and ETL orchestration frameworks.

Nice-to-Have:

• Experience with Hive, Hadoop, Spark, or related big data technologies.

• Competitive salary and performance-based bonuses.
• Comprehensive insurance plans.
• Collaborative and supportive work environment.
• Chance to learn and grow with a talented team.