← Back to jobsJob ID col-cmwf60nr2077389hqk48mjj0x

First Soft Solutions LLCPosted 8 days ago

Microsoft Fabric Data Integration Engineer

Contract
On-site
5+ years
Competitive
Posted 8 days ago

First Soft Solutions LLC is seeking a Microsoft Fabric Data Integration Engineer to design, develop, and implement enterprise-scale data integration solutions. The role focuses on automated ETL/ELT pipelines, integrating SAP and Workday, and delivering reliable, secure datasets for financial, HR, and operational analytics.

Posted
8 days ago
Source
linkedin.com
Sector
Information Technology & AI

Opens the employer's application page in a new tab

Responsibilities

  • Design, develop, deploy, and maintain scalable ETL/ELT pipelines using Microsoft Fabric
  • Leverage Fabric Data Factory, Data Pipelines, Dataflows Gen2, OneLake, Lakehouse, and Fabric Data Warehouse
  • Implement automated data ingestion, transformation, scheduling, monitoring, and error-handling processes
  • Optimize data pipelines for performance, scalability, reliability, and maintainability
  • Develop and maintain secure data integrations between SAP, Workday, and Microsoft Fabric
  • Extract and transform SAP financial and operational data and Workday HR and payroll data
  • Implement API-based integrations using REST APIs, web services, and supported enterprise connectors
  • Configure initial data loads, incremental processing, and scheduled refresh mechanisms
  • Ensure data consistency and integrity across enterprise source systems
  • Develop advanced SQL queries, complex joins, transformation logic, and data mapping procedures
  • Implement cross-system record matching using common identifiers and business-defined matching rules
  • Identify and resolve duplicate records, missing identifiers, inconsistent formats, and unmatched datasets
  • Build automated reconciliation frameworks to validate data completeness and accuracy
  • Establish automated data validation, quality monitoring, and exception-reporting processes
  • Implement secure data access, role-based permissions, and appropriate audit controls
  • Support data lineage, metadata management, and enterprise data governance practices
  • Troubleshoot data integration failures and resolve pipeline performance issues
  • Perform unit testing, integration testing, data validation, and user acceptance testing support
  • Develop source-to-target mappings, technical design documentation, and operational procedures
  • Collaborate with data architects, business analysts, functional teams, and reporting stakeholders
  • Provide production support, troubleshooting, and knowledge transfer

Qualifications

  • Work Authorization: U.S. Citizens, Green Card Holders, and H-1B Visa Holders
  • Bachelor's degree in Computer Science, Information Technology, Engineering, or a related discipline, or equivalent professional experience
  • Minimum 5 years of experience in data engineering, data integration, ETL/ELT development, database development, or related disciplines
  • Demonstrated hands-on experience designing and implementing Microsoft Fabric data engineering solutions
  • Strong experience with Fabric Data Factory, Data Pipelines, Dataflows Gen2, Lakehouse, OneLake, and Fabric Warehouse
  • Proven experience integrating data from both SAP and Workday enterprise platforms
  • Advanced SQL skills, including complex joins, transformations, record matching, and data reconciliation
  • Experience developing and consuming REST APIs, JSON-based integrations, and enterprise web services
  • Strong understanding of data warehousing, dimensional modeling, data integration patterns, and data quality principles
  • Experience implementing automated data pipelines, monitoring, error handling, and scheduled data refreshes
  • Strong analytical, troubleshooting, communication, and technical documentation skills
  • Must possess valid U.S. work authorization under one of the specified categories
  • Must demonstrate hands-on technical expertise in Microsoft Fabric, SQL, SAP, and Workday integrations

Preferred

  • Experience working with SAP ECC 6.0 EHP 6 or comparable SAP ERP environments
  • Knowledge of Workday Reports-as-a-Service (RaaS) and Workday Web Services
  • Hands-on experience with Python, PySpark, or Power Query
  • Experience with Azure Data Factory and related Azure data services
  • Familiarity with Microsoft Power BI and enterprise reporting solutions
  • Knowledge of Microsoft Fabric security, governance, and performance optimization
  • Experience supporting financial, payroll, HR, and operational reporting environments
  • SAP ECC 6.0 EHP 6

Required skills

Azure Data FactoryData WarehousingDimensional ModelingJSONMicrosoft Fabric Data FactoryMicrosoft Fabric Data PipelinesMicrosoft Fabric Dataflows Gen2Microsoft Fabric Fabric WarehouseMicrosoft Fabric LakehouseMicrosoft Fabric OneLakePower QueryPySparkPythonREST APIs

Full job description

First Soft Solutions LLC is seeking a Microsoft Fabric Data Integration Engineer to design, develop, and implement enterprise-scale data integration solutions. The role focuses on automated ETL/ELT pipelines, integrating SAP and Workday, and delivering reliable, secure datasets for financial, HR, and operational analytics.

Responsibilities

  • Design, develop, deploy, and maintain scalable ETL/ELT pipelines using Microsoft Fabric
  • Leverage Fabric Data Factory, Data Pipelines, Dataflows Gen2, OneLake, Lakehouse, and Fabric Data Warehouse
  • Implement automated data ingestion, transformation, scheduling, monitoring, and error-handling processes
  • Optimize data pipelines for performance, scalability, reliability, and maintainability
  • Develop and maintain secure data integrations between SAP, Workday, and Microsoft Fabric
  • Extract and transform SAP financial and operational data and Workday HR and payroll data
  • Implement API-based integrations using REST APIs, web services, and supported enterprise connectors
  • Configure initial data loads, incremental processing, and scheduled refresh mechanisms
  • Ensure data consistency and integrity across enterprise source systems
  • Develop advanced SQL queries, complex joins, transformation logic, and data mapping procedures
  • Implement cross-system record matching using common identifiers and business-defined matching rules
  • Identify and resolve duplicate records, missing identifiers, inconsistent formats, and unmatched datasets
  • Build automated reconciliation frameworks to validate data completeness and accuracy
  • Establish automated data validation, quality monitoring, and exception-reporting processes
  • Implement secure data access, role-based permissions, and appropriate audit controls
  • Support data lineage, metadata management, and enterprise data governance practices
  • Troubleshoot data integration failures and resolve pipeline performance issues
  • Perform unit testing, integration testing, data validation, and user acceptance testing support
  • Develop source-to-target mappings, technical design documentation, and operational procedures
  • Collaborate with data architects, business analysts, functional teams, and reporting stakeholders
  • Provide production support, troubleshooting, and knowledge transfer

Preferred

  • Experience working with SAP ECC 6.0 EHP 6 or comparable SAP ERP environments
  • Knowledge of Workday Reports-as-a-Service (RaaS) and Workday Web Services
  • Hands-on experience with Python, PySpark, or Power Query
  • Experience with Azure Data Factory and related Azure data services
  • Familiarity with Microsoft Power BI and enterprise reporting solutions
  • Knowledge of Microsoft Fabric security, governance, and performance optimization
  • Experience supporting financial, payroll, HR, and operational reporting environments
  • SAP ECC 6.0 EHP 6
  • SAP ERP
  • Workday RaaS
  • Workday Web Services
  • Python
  • PySpark
  • Power Query
  • Azure Data Factory
  • Azure data services
  • Microsoft Power BI
  • Enterprise reporting
  • Microsoft Fabric security
  • Data governance
  • Performance optimization
  • Financial reporting
  • Payroll reporting
  • HR reporting
  • Operational reporting

Company

  • Microsoft enterprise technology consulting and solutions
  • Monmouth Junction, NJ, US
  • http://www.firstsoftsolutions.net/
  • Founded in 2006
  • 51-200 employees

Qualifications

  • Work Authorization: U.S. Citizens, Green Card Holders, and H-1B Visa Holders
  • Bachelor's degree in Computer Science, Information Technology, Engineering, or a related discipline, or equivalent professional experience
  • Minimum 5 years of experience in data engineering, data integration, ETL/ELT development, database development, or related disciplines
  • Demonstrated hands-on experience designing and implementing Microsoft Fabric data engineering solutions
  • Strong experience with Fabric Data Factory, Data Pipelines, Dataflows Gen2, Lakehouse, OneLake, and Fabric Warehouse
  • Proven experience integrating data from both SAP and Workday enterprise platforms
  • Advanced SQL skills, including complex joins, transformations, record matching, and data reconciliation
  • Experience developing and consuming REST APIs, JSON-based integrations, and enterprise web services
  • Strong understanding of data warehousing, dimensional modeling, data integration patterns, and data quality principles
  • Experience implementing automated data pipelines, monitoring, error handling, and scheduled data refreshes
  • Strong analytical, troubleshooting, communication, and technical documentation skills
  • Must possess valid U.S. work authorization under one of the specified categories
  • Must demonstrate hands-on technical expertise in Microsoft Fabric, SQL, SAP, and Workday integrations
  • Experience working with SAP ECC 6.0 EHP 6 or comparable SAP ERP environments
  • Knowledge of Workday Reports-as-a-Service (RaaS) and Workday Web Services
  • Hands-on experience with Python, PySpark, or Power Query
  • Experience with Azure Data Factory and related Azure data services
  • Familiarity with Microsoft Power BI and enterprise reporting solutions
  • Knowledge of Microsoft Fabric security, governance, and performance optimization
  • Experience supporting financial, payroll, HR, and operational reporting environments
  • Minimum 5 years of experience in data engineering, data integration, ETL/ELT development, database development, or related disciplines.

Required skills

  • Azure Data Factory, Data Warehousing, Dimensional Modeling, JSON, Microsoft Fabric Data Factory, Microsoft Fabric Data Pipelines, Microsoft Fabric Dataflows Gen2, Microsoft Fabric Fabric Warehouse, Microsoft Fabric Lakehouse, Microsoft Fabric OneLake, Power Query, PySpark, Python, REST APIs, SAP, SQL, Workday

Preferred skills

  • Hands-on experience with Python, PySpark, or Power Query

Experience

  • 5+ years

Job details

Employment type

Contract

Seniority level

5+ years

Date posted

Nov 13, 2026

Work mode

On-site

Job source

linkedin.com

Company

First Soft Solutions LLC

Information Technology & AI

Microsoft enterprise technology consulting and solutions

See all 3 jobs from First Soft Solutions LLC →

Similar jobs

Matched on role, skills and location · live jobs only

See more Data Engineer jobs in Annapolis

GTECH LLC

1d ago

New

Microsoft Fabric Data Engineer (Mid-Level):::Hybrid in Golden Valley, MN

Full-timeHybridGolden Valley, MNCompetitive

GTECH LLC is adding mid-level Microsoft Fabric data engineers to its Process, Data, and Technology team.

Why similarSame roleDimensional ModelingPySpark

Curana Health

1d ago

New

Data Engineer

Full-timeRemoteUnited StatesCompetitive

Curana Health is hiring a Data Engineer to build, optimize, and maintain data pipelines supporting clinical, operational, and analytical reporting.

Why similarSame roleAzure Data FactoryRemote

EXL

1d ago

New

Senior Data Engineer

Full-timeRemoteUnited StatesCompetitive

EXL is seeking a seasoned Data Engineer to join their Sports Analytics & Engineering Practice. This role is pivotal in shaping and implementing a cloud-native data ecosystem, where you will architect and build scalable data infrastructure that transforms raw…

Why similarSame roleData warehousingRemote

Get new Data Engineer jobs in Annapolis by email

Create job alert

Microsoft Fabric Data Integration Engineer

First Soft Solutions LLC · Competitive

Apply on company site