Remote Fabric Data Lake Engineer: Lakehouse & Pipelines

Blue Ocean Systems Infotech Pvt. Ltd.; United States; Remote; USD 120,000 - 160,000; Full time

Job summary

Blue Ocean Systems Infotech Pvt. Ltd. is seeking a Microsoft Fabric Data Lake Developer for a remote role.

The candidate will design and implement lakehouse solutions, build data ingestion pipelines, and integrate data from diverse sources while ensuring data quality, security, and governance. The role requires 5+ years of relevant experience, strong SQL and Python/PySpark, and familiarity with Fabric components, Delta Lake, and medallion architecture.

Qualifications

• Hands-on experience with Microsoft Fabric including Lakehouse, OneLake, Data Factory pipelines and notebooks.
• Strong SQL skills and practical experience with Python or PySpark.
• Experience developing ETL/ELT pipelines and working with structured and semi-structured data.
• Understanding of Delta Lake, Parquet, dimensional modelling, and medallion architecture.
• Experience implementing data quality checks, error handling, logging, and monitoring.
• Knowledge of data security, workspace permissions, and access management.
• Familiarity with Git and CI/CD practices for data solutions.
• Strong analytical, troubleshooting, and communication skills.

Responsibilities

• Design and develop lakehouse solutions using Microsoft Fabric, OneLake, and Delta tables.
• Build and maintain data ingestion and transformation pipelines using Fabric Data Factory, Dataflows Gen2, and notebooks.
• Integrate data from databases, APIs, enterprise applications, and file-based sources.
• Implement Bronze, Silver, and Gold data layers using a medallion architecture.
• Develop transformations using SQL, Python, PySpark, and Spark SQL.
• Implement incremental loading, change data capture, and data validation processes.
• Monitor pipelines, troubleshoot failures, and optimize performance and resource usage.
• Apply data security, access controls, governance, and data quality standards.
• Prepare curated datasets for Power BI reporting and downstream analytics.
• Collaborate with architects, business analysts, and reporting teams to translate requirements into technical solutions.
• Maintain technical documentation, source-to-target mappings, and operational support procedures.
• Support version control, testing, and deployment across development, test, and production environments.

Skills

Microsoft Fabric

SQL

Python

PySpark

ETL/ELT pipelines

Delta Lake

Parquet

Data security

CI/CD for data

Git

Tools

Azure Data Factory

Azure Data Lake Storage

Azure Databricks

Azure Synapse Analytics

Job description

Blue Ocean Systems Infotech Pvt. Ltd. is seeking a Microsoft Fabric Data Lake Developer for a remote role.

The candidate will design and implement lakehouse solutions, build data ingestion pipelines, and integrate data from diverse sources while ensuring data quality, security, and governance. The role requires 5+ years of relevant experience, strong SQL and Python/PySpark, and familiarity with Fabric components, Delta Lake, and medallion architecture.