Sr. Data Engineer
About The Position
World Emblem International is seeking a hands-on Senior Data Engineer to build, scale, and own the company's new centralized data platform on Microsoft Fabric. This role will be part of the Applications team and will work closely with the Director of AI. The Senior Data Engineer will be a key technical voice in the architecture and planning of the Data Lake/Data Warehouse project. Responsibilities include designing and building ETL/ELT pipelines from various systems such as Business Central, custom middleware, ecommerce, and marketing systems, ensuring a solid foundation for AI initiatives and enterprise reporting. This is a hands-on build role requiring T-SQL, table design, view creation, stored procedure development, and the construction of Fabric pipelines, with full ownership of running and extending the platform in-house.
Requirements
- 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.
- Bachelor’s degree in Computer Science, Information Systems, Engineering, or equivalent practical experience.
Nice To Haves
- Experience with Microsoft Dynamics 365 Business Central (or Dynamics NAV) data models and APIs.
- Familiarity with HubSpot, BigCommerce, Optimizely, or manufacturing/production data environments.
- Experience building Power BI semantic models (DAX) and migrating SSRS reports.
- Relevant Microsoft Certifications: DP-700 (Fabric Data Engineer), DP-600 (Fabric Analytics Engineer), or DP-300.
- Experience preparing enterprise data pipelines for AI / Machine Learning / RAG use cases.
Responsibilities
- Participate in architecture planning for the Microsoft Fabric platform (OneLake, Lakehouse/Warehouse, layered data zones, capacity structure, naming, and modeling standards).
- Partner with an external implementation partner during initial rollout and transition into full in-house ownership.
- 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.
- Build incremental/CDC loads, error handling, retries, and idempotent processing.
- Build high-standard tables, views, functions, stored procedures, and indexes across SQL Server, Azure SQL, and Fabric Warehouse.
- Design dimensional models (star schemas, fact/dimension tables, SCDs) and manage query performance, partitioning, and capacity planning.
- Implement automated quality checks for completeness, accuracy, and freshness.
- Reconcile key business metrics (orders, revenue, inventory) between source systems and the data warehouse.
- Monitor pipeline health, handle alerting, and resolve root-cause data issues.
- Work with the Reporting Engineer to transition existing Power BI and SSRS reports to query the new platform instead of production databases.
- Deliver structured, documented datasets to the AI department for RAG systems, agents, and predictive analytics.
- Implement RBAC, row/column-level security, and data protection standards.
- Maintain data dictionaries and lineage documentation.
- Manage code, database objects, and deployment pipelines via Git and Azure DevOps.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
