Senior Data Engineer

BuildingBlocks Software Services Pvt Ltd; Chennai District; On-site; INR 1,400,000 - 2,400,000; Full time

Job summary

BuildingBlocks Software Services Pvt Ltd is seeking a hands-on Data Engineer to ensure data accuracy, reliability, and performance during customer go-lives. You will validate datamigrations, build optimized SQL data models, and implement automated data quality checks using Python to support analytics and reporting.

You will validate end-to-end migrations, write complex SQL, and create scalable data models. The role also involves data quality automation, dbt-based modeling, and workflow

Qualifications

• 4–7 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.
• Strong understanding of query optimization and performance tuning.

Responsibilities

• Validate end-to-end data migrations to ensure accuracy and completeness.
• Write and optimize complex SQL queries (CTEs, joins, window functions).
• Develop automated data validation checks using Python and data quality frameworks.
• Build and maintain data models using dbt and document lineage and tests.
• Schedule and manage pipelines using Airflow and monitor workflows for SLA adherence.

Skills

SQL

Python

PostgreSQL

Query optimization

Tools

dbt

Airflow

Great Expectations

Deequ

Job description

Regardless of whether accomplishing astounding customer work or aiding assemble our organization from the inside, our different gifted organization shares a solitary mission: to fabricate lovely encounters that decidedly affect individuals’ lives and the organizations we serve.
Our way of life is more reason than work, mixing the quest for certified human association with a fastidious way to deal with the things we make. All with an idealistic soul. We’re an organization that is adequately youthful to be fun and defiant – yet intense and driven enough to immensely affect the business.

About the Role

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 datamigrations, 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 – 7 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
• 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)

Why Join Us

• Work on high-impact, data-critical projects
• Opportunity to build robust and scalable data systems
• Collaborative and fast-paced environment

Transcend your experience!

Please select the services you are looking for