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 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 Outstanding 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
- 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

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.

📌 Sr Data Engineer (Chennai)
🏢 Buildingblocks Software Services
📍 Chennai