BuildingBlocks Consulting - Senior Data Engineer
BUILDING BLOCKS SOFTWARE SERVICES PRIVATE
India
Full-Time
Posted 23 days ago
India
Full-Time
Posted 23 days ago
Job Description & Responsibilities
Senior Data Engineer
We are looking for a hands-on Data Engineer who will play a key role in ensuring the accuracy, reliability, and performance of data during customer go-lives.
This role focuses on validating data migrations, building optimized SQL-based data models, and implementing automated data quality checks using Python to support business analytics and reporting.
Key Responsibilities
Data Migration Validation
- Validate end-to-end data migrations to ensure accuracy and completeness.
- Perform checks such as data parity, nullability, duplicates, and referential integrity.
- Document validation results and support migration sign-off.
SQL Development & Optimization
- Write and optimize complex SQL queries (CTEs, joins, window functions).
- Analyze query performance using EXPLAIN plans and improve efficiency.
- Build scalable data models to support analytics use cases.
Data Quality & Automation (Python-Driven)
- Develop automated data validation checks using Python.
- Work with data quality frameworks like Great Expectations, Deequ, or similar tools.
- Build reusable validation scripts and ensure data reliability.
Data Modeling & Documentation
- Build and maintain data models using dbt (if applicable).
- Implement tests, documentation, and lineage tracking.
Workflow Orchestration
- Schedule and manage pipelines using Airflow.
- Monitor workflows, handle failures, and ensure SLA adherence.
(Optional) Cloud & Warehousing
- Work with PostgreSQL, Snowflake, or similar data warehouses.
- Optimize batch processing and data pipelines for performance.
Required Skills & Experience
- 4 - 10 years of experience in Data Engineering / Analytics Engineering.
- Strong expertise in SQL and Python (both are mandatory).
- Hands-on experience with PostgreSQL or similar relational databases.
- Experience in data migration validation / data quality checks.
- Strong understanding of query optimization and performance tuning.
- Experience with at least one of the following: dbt, Airflow, Great Expectations, or Deequ.
- Familiarity with Git and version control workflows.
Nice to Have
- Experience with Snowflake or cloud platforms (AWS preferred).
- Exposure to BI tools (Power BI, Tableau, Looker, Metabase).
- Experience building scalable data pipelines.
Why Join Us
- Work on high-impact, data-critical projects.
- Opportunity to build robust and scalable data systems.
- Collaborative and fast-paced environment.
(ref:hirist.tech)
About BUILDING BLOCKS SOFTWARE SERVICES PRIVATE
Required Skills
PythonAWSSQLGitPower BITableau
Job Details
Employment TypeFull-Time
Work ModeOn-Site
Experience4 – 10 years
Positions1
Posted by
N/A
Posted on:
26 Oct 2026
About BUILDING BLOCKS SOFTWARE SERVICES PRIVATE
More open roles
- Senior Software Engineer (Python/Node.JS , AWS)Autodesk · India
- IT Intern - Software Development, Python & AI/MLAI SAMRAT · India
- Ansible & Python Open-source Developer for GamingHartbridge Evergrove Placements · Farrukhabad, Uttar Pradesh, India
- Senior Full Stack Developer (Python, React.js & Azure, AI)Robert Bosch · India
- Specialist System Engineering (Devops Engineer, CICD, Kubernetes, containers, React, Python, API, Deployment + Development + Automation, GitHub PipelinesAT&T · Bengaluru, Karnataka, India
- Data Scientist (Python, ML, SQL) (Bhilai)Workers Town · Raipur, Chhattisgarh, India