Senior Data Engineer

Job Description

Summary


Loyal Source is seeking a highly skilled Senior Data Engineer to design, build, and support scalable enterprise data platforms using Microsoft Fabric, Azure Data Services, and modern data engineering practices .


This role will be responsible for developing robust data pipelines, designing data models, implementing governance and data quality controls, and enabling analytics and reporting solutions across the organization. The ideal candidate combines strong technical engineering skills with the ability to collaborate with business stakeholders, architects, analysts, and application teams to deliver trusted and governed data products.


The Senior Data Engineer will play a key role in advancing Loyal Source's enterprise analytics strategy through Microsoft Fabric, Azure DevOps, Power BI, Salesforce, Workday, and other enterprise platforms.

Job Classification


Salary Exempt

Duties and Functions


Data Engineering & Platform Development

• Design, develop, and maintain scalable ETL/ELT pipelines utilizing Microsoft Fabric, Azure Data Factory, Dataflows, and other Azure services.
• Build and support enterprise data integration solutions connecting internal and external systems, APIs, SaaS platforms, databases, and third-party applications.
• Design and implement Microsoft Fabric Lakehouse, Warehouse, and OneLake solutions following best practices.
• Develop and optimize SQL-based data transformations, stored procedures, views, and performance-tuned datasets.
• Create reusable and scalable ingestion frameworks supporting batch and near real-time data processing.
• Monitor and troubleshoot data pipelines to ensure high reliability, performance, and operational stability.

Data Architecture & Modeling

• Collaborate with Data Architects to design enterprise data models supporting analytics, operational reporting, and self-service BI.
• Implement and support Medallion Architecture (Bronze, Silver, Gold layers) within Microsoft Fabric.
• Define dimensional models, star schemas, fact tables, dimension tables, and semantic modeling structures for analytics consumption.
• Recommend architectural improvements that increase scalability, maintainability, and performance.

Microsoft Fabric & Azure Platform

• Develop solutions utilizing:
  • Microsoft Fabric
  • OneLake
  • Lakehouse
  • Warehouse
  • Data Factory
  • Pipelines
  • Semantic Models
  • Power BI
• Work with Azure services to support secure data movement, storage, integration, and processing workloads.
• Participate in environment configuration, deployment planning, and operational support activities.

Data Governance & Quality

• Implement automated data quality validation, reconciliation, and exception handling processes.
• Support data governance initiatives including:
  • Metadata management
  • Data lineage
  • Data stewardship
  • Data cataloging
  • Data classification
• Establish monitoring and alerting processes for pipeline failures, schema drift, and data anomalies.
• Promote data standards and governance best practices across engineering initiatives.

DevOps & Automation

• Implement CI/CD deployment processes using Azure DevOps and Git repositories.
• Create automated deployment pipelines for Fabric artifacts and data engineering solutions.
• Support source control, pull request workflows, branching strategies, release management, and deployment automation.
• Develop Infrastructure-as-Code and configuration management patterns where appropriate.

Security & Compliance

• Implement data security controls, access management, encryption, and auditing capabilities.
• Ensure compliance with internal governance policies and industry best practices.
• Support regulatory and privacy requirements related to sensitive business and employee data.

Collaboration & Leadership

• Partner with business stakeholders, analysts, architects, and application teams to understand data requirements.
• Mentor junior engineers and promote engineering best practices.
• Participate in technology evaluations and recommend new tools, frameworks, and architectural improvements.

Contribute to enterprise standards for Microsoft Fabric, data engineering, and analytics delivery.

Education and Experience (Required)


• Bachelor's Degree in Computer Science, Data Engineering, Information Systems, Mathematics, Software Engineering, or related discipline.


• 5+ years of hands-on experience in Data Engineering, Data Platform Engineering, Data Warehousing, or Analytics Engineering.


• Advanced SQL development skills, including query optimization and performance tuning.


• Strong Python development experience for data processing, integrations, automation, and orchestration.


• Experience designing and implementing enterprise data warehouses and analytical data platforms.


• Experience building enterprise ETL/ELT solutions using:


• Microsoft Fabric


• Azure Data Factory


• Azure Synapse Analytics


• SSIS or comparable technologies


• Hands-on experience with:


• Data Lakes


• Lakehouses


• Data Warehouses


• Dimensional Modeling


• Star Schema Design


• Experience integrating data from APIs, SaaS platforms, databases, and external systems.


• Experience with source control and Git-based development practices.

Preferred Requirements


• Microsoft Fabric implementation experience in production environments.


• Experience with:


o OneLake


o Data Factory


o Lakehouse


o Warehouse


o Semantic Models


o Power BI


• Experience with Azure DevOps and CI/CD deployment pipelines.


• Experience with Delta Lake and modern lakehouse architectures.


• Experience developing REST APIs, microservices, and backend integrations.


• Experience supporting enterprise reporting and analytics initiatives.


• Experience with Salesforce and Workday data models and integrations.


• Familiarity with healthcare, workforce management, staffing, government contracting, or enterprise operational reporting.


• Microsoft Azure and/or Microsoft Fabric certifications.

Knowledge/Skills/Abilities (KSA)


Required

• Microsoft Fabric
• Azure Data Factory
• SQL
• Python
• Azure Cloud Services
• Data Warehousing
• Data Modeling
• ETL / ELT
• Git
• Azure DevOps

Preferred

• Power BI
• Delta Lake
• OneLake
• Lakehouse Architecture
• REST APIs
• Azure Functions
• Salesforce
• Workday
• Synapse Analytics

Work Environment/Condition


Describe the indoor/outdoor elements, lighting, temperature, etc.

Physical Demands


Describe the physical attributes an employee must have to perform the job duties with or without reasonable accommodation. This is a required section.

Pay: $125,000

About Loyal Source


Loyal Source provides healthcare and technology solutions designed to improve outcomes and support mission-critical operations. Guided by innovation and purpose, we help organizations achieve success across complex challenges worldwide. Loyal Source is a military friendly employer and proud partner of the Military Spouse Employment Partnership program.


Loyal Source uses AI-powered voice screening as part of our application process. After you apply, you will receive a brief qualification survey via text or email. Candidates who meet the position requirements will then be invited to complete a quick AI-powered voice assessment. This easy, no-scheduling-required process helps us and the candidate move the hiring process forward faster.


We are committed to providing equal employment opportunities to all applicants. If you have a disability or medical condition and need a reasonable accommodation to participate in this step of the hiring process, you may request an alternative method or accommodation at any time by contacting Human Resources at View email address on click.appcast.io


If you are a qualified individual with a disability or a disabled veteran, you may request a reasonable accommodation by contacting HR at View email address on click.appcast.io . If you are unable or limited in your ability to access job openings or apply for a job on this site as a result of your disability, please select the accessibility menu to the (right or left) for more assistance. You can also request reasonable accommodations by contacting a telecommunications relay service by dialing 711 for direct access and assistance (tty).


This contractor and subcontractor abides by the requirements of 41 CFR 60-300.5(a) and 41 CFR 60-741.5(a) .
These regulations prohibit discrimination against qualified individuals on the basis of protected veteran status or disability, and require affirmative action by covered prime contractors.

Date Posted: 08/07/2026

Job ID: a1WPe00000Cd3vBMAR