Senior Data Engineer: Fabric & Data Lake

ADP; Houston (TX); On-site; USD 135,000 - 165,000; Full time

Job summary

World Emblem International seeks a hands-on Senior Data Engineer to build and own a centralized data platform on Microsoft Fabric. You will design ETL/ELT pipelines from Business Central and other sources, building solid foundations for AI initiatives.

You will work within the Applications team, collaborating with the AI director to plan and transition to in-house ownership, delivering scalable data models and governance across SQL Server, Azure SQL, and Fabric.

Qualifications

• 7+ years of professional experience in data engineering and SQL Server database development, including production pipeline ownership.
• Hands-on experience with Microsoft Fabric (OneLake, Lakehouse/Warehouse, Data Factory pipelines, or Dataflows Gen2) is mandatory.
• Expert T-SQL skills: Advanced database design, views, stored procedures, indexing, and query performance tuning.
• Strong experience with SQL Server and Azure SQL (Azure SQL Database or Managed Instance).
• Proven track record building ETL/ELT pipelines with Microsoft tooling (Fabric Data Factory, ADF, or SSIS) including incremental/CDC load strategies.
• Strong expertise in Data Warehousing & Dimensional Modeling (star schemas, facts/dimensions, SCDs).
• Experience integrating data from enterprise ERPs via APIs, OData, web services, or database connections.
• Hands-on experience with Git and Azure DevOps for version control and CI/CD workflows.
• Excellent technical communication skills with the ability to explain complex data topics to business stakeholders.
• Education: Bachelor’s degree in Computer Science, Information Systems, Engineering, or equivalent practical experience.

Responsibilities

• Data Platform Architecture & Build: Participate in architecture planning for the Microsoft Fabric platform (OneLake, Lakehouse/Warehouse, layered data zones, capacity structure, naming, and modeling standards).
• ETL / ELT Development & Integration: Design and maintain pipelines using Microsoft Fabric Data Factory (pipelines & Dataflows Gen2), Azure Data Factory, or SSIS. Extract data from Business Central, custom middleware, BigCommerce, HubSpot, and internal databases.
• Database Engineering: Build high-standard tables, views, functions, stored procedures, and indexes across SQL Server, Azure SQL, and Fabric Warehouse.
• Data Quality & Operations: Implement automated quality checks for completeness, accuracy, and freshness. Reconcile key business metrics between source systems and the data warehouse.
• Reporting & AI Enablement: Work with the Reporting Engineer to transition existing Power BI and SSRS reports to query the new platform. Deliver structured datasets for AI / RAG workflows.
• Governance, Security & CI/CD: Implement RBAC, row/column security, data protection standards. Maintain data dictionaries and lineage documentation. Manage code, objects, and deployment pipelines via Git and Azure DevOps.

Skills

Microsoft Fabric

T-SQL

SQL Server

Azure SQL

ETL / ELT

Data Warehousing

Dimensional Modeling

APIs / Data integration

Git / Azure DevOps

Technical communication

Education

Bachelor's degree in Computer Science / Information Systems / Engineering

Tools

Fabric Data Factory

SSIS

Git

Azure DevOps

Job description

World Emblem International seeks a hands-on Senior Data Engineer to build and own a centralized data platform on Microsoft Fabric. You will design ETL/ELT pipelines from Business Central and other sources, building solid foundations for AI initiatives.

You will work within the Applications team, collaborating with the AI director to plan and transition to in-house ownership, delivering scalable data models and governance across SQL Server, Azure SQL, and Fabric.