Senior Data Engineer

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. 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: OneLake Data Factory Lakehouse Warehouse Semantic Models 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. Required Knowledge/Skills/Abilities (KSA) 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 #J-18808-Ljbffr Loyal Source Government Services