Revalsys Technologies - Data Engineer - SQL/Python

Title : Data Engineer

About the Role :

We are seeking a highly skilled Data Engineer to join our team. The ideal candidate will have expertise in Databricks, Python, and SQL.

Key Responsibilities :

- Develop clean, reusable, and performant Python code for data ingestion, transformation, and quality checks.

- Write efficient and optimized SQL queries for querying structured and semi-structured data.

- Work with stakeholders to understand data requirements and implement end-to-end data workflows.

- Perform data profiling, validation, and ensure data quality and integrity.

- Optimize data pipelines for performance, reliability, and integrate data from various sources APIs, flat files, databases, cloud storage e.g., S3, ADLS.

- Build and maintain delta tables using Delta Lake format for ACID-compliant streaming and batch pipelines.

- Work with Databricks Workflows to orchestrate pipelines and scheduled jobs.

- Collaborate with DevOps and cloud teams to ensure secure, scalable, and compliant infrastructure.

Technical Skills Required :

Core Technologies :

- Python with strong knowledge of PySpark

- SQL Advanced level joins, window functions, CTEs, aggregation

ETL & Orchestration :

- Airflow, Azure Data Factory, or similar orchestration tools

- Auto Loader, Structured Streaming preferred

Cloud Platforms Any one or more :

- AWS Databricks on AWS, S3, Glue, Redshift

- GCP Dataproc, BigQuery, GCS

Data Modeling & Storage :

- Understanding of dimensional modeling, data lakes, and lakehouse architectures

Monitoring & Version Control :

- Logging, debugging, and monitoring with tools like Datadog, Prometheus, or Cloud-native tools

Optional/Preferred :

- Experience with REST APIs, JSON, and data ingestion from 3rd-party services

- Familiarity with DBT Data Build Tool or Great Expectations for data quality

Soft Skills :

- Clear communication and documentation skills

- Ability to work independently and within cross-functional teams

- Agile/Scrum working experience