Data Engineer (SQL, Azure Databricks, PySpark, Azure Data Factory, Python, Azure DevOps, Power BI, Delta Lake, ETL)

EXASOFT CONSULTING PTE. LTD.; Singapore; On-site; SGD 90,000 - 140,000; Full time

Job summary

EXASOFT CONSULTING PTE. LTD. is seeking a data engineering professional to design and maintain robust data pipelines.

You will work with Azure Data Factory, Azure Databricks, PySpark, Python, and Delta Lake to deliver scalable analytics workflows. You will implement REST API integrations, ensure data quality with observability practices, and develop compelling Power BI dashboards for business insights. Collaboration with cross-functional teams and performance testing with JMeter are key parts of

Qualifications

• Bachelor's or Master's degree in a technical field such as CS, Engineering or Data Science.
• 4+ years of professional experience in Data Engineering, Data Analytics, or related roles.
• Strong hands-on experience with SQL and Azure Databricks for data processing and analytics.
• Proficiency in PySpark, Python, and Azure Data Factory for workflows.
• Experience with Azure DevOps, Delta Lake, REST API, JSON and Google BigQuery.
• Experience building scalable data pipelines on cloud platforms.
• Knowledge of data observability, monitoring and reliability practices.
• Experience developing Power BI dashboards and reports.
• Hands-on with JMeter for API/load testing and ETL processes.
• Experience with anomaly detection and data quality practices.
• Strong analytical, troubleshooting and collaboration skills.

Responsibilities

• Develop reliable data pipelines for business and analytical use.
• Utilize Azure Data Factory and Azure Databricks for ingestion, transformation, and processing workflows.
• Write optimized SQL, Python, and PySpark for data prep.
• Work with Delta Lake and Google BigQuery for analytical data storage.
• Monitor data processes and apply observability practices.
• Build REST API integrations for data exchange between apps.
• Validate and process JSON data within data and API workflows.
• Support automated builds and deployments via Azure DevOps.
• Develop Power BI dashboards and reports for insights.
• Conduct API/load/performance testing with JMeter.
• Investigate issues and coordinate with teams to resolve data challenges.

Skills

SQL

Azure Databricks

PySpark

Python

Azure Data Factory

Delta Lake

REST API

JSON

Power BI

JMeter

ETL

Data Observability

Data Reliability

Education

Bachelor's or Master's degree in Computer Science/Engineering/Data Science

Tools

Azure DevOps

Google BigQuery

Power BI

Job description

Responsibilities:

• Develop and maintain reliable data pipelines for business and analytical applications.
• Use Azure Data Factory and Azure Databricks to manage data ingestion, transformation, and processing workflows.
• Write optimized SQL, Python, and PySpark code for data preparation and processing.
• Work with Delta Lake and Google BigQuery for storing and managing analytical data.
• Monitor data processes and identify data-related issues using data observability practices.
• Build and maintain REST API integrations for exchanging data between applications and services.
• Process and validate JSON data used within data and API workflows.
• Support automated build and deployment activities through Azure DevOps.
• Develop Power BI dashboards and reports to present data-driven insights.
• Perform API and application performance testing using JMeter to assess response time, reliability, and system performance.
• Investigate technical issues, improve processing efficiency, and coordinate with relevant teams to resolve data-related challenges.

Requirements:

• Qualification in Bachelor's or Master's degree in Computer Science, Engineering, Data Science, or a related technical discipline.
• 4+ years of professional experience in Data Engineering, Data Analytics, or a related technical role.
• Strong Hands - on experience with SQL and Azure Databricks for data processing and analytical workloads.
• Strong Experience in PySpark, Python, and Azure Data Factory for developing and managing data processing workflows.
• Experience in practical knowledge of Azure DevOps, Delta Lake, REST API, JSON, and Google BigQuery.
• Experience in working with cloud-based data platforms and developing scalable data pipelines.
• Strong Experience of Data Observability, data monitoring, and data reliability practices.
• Experience in developing Power BI dashboards and reports for business and analytical requirements.
• Hands - on experience in JMeter for API, load, or performance testing.
• Hands - on experience in ETL.
• Experience in Anomaly
• Strong analytical, troubleshooting, and problem-solving skills.
• Good communication and collaboration skills with the ability to work effectively with cross-functional teams.