Senior Data Engineer

Loyal Source Government Services is seeking a Senior Data Engineer to design, build, and support scalable enterprise data platforms. The role is focused on modern data engineering practices across Microsoft Fabric and Azure Data Services, with an emphasis on data pipelines, governance, and analytics enablement.

Responsibilities

• Design, develop, and maintain scalable ETL/ELT pipelines using Microsoft Fabric, Azure Data Factory, Dataflows, and other Azure services.
• Build and support enterprise data integration solutions connecting internal and external systems, including APIs, SaaS platforms, databases, and third-party applications.
• Design and implement Microsoft Fabric Lakehouse, Warehouse, and OneLake solutions aligned to best practices.
• Develop and optimize SQL-based transformations, including stored procedures, views, and performance-tuned datasets.
• Create reusable and scalable ingestion frameworks for batch and near real-time processing.
• Monitor and troubleshoot data pipelines to support high reliability, performance, and operational stability.
• Collaborate with Data Architects to design enterprise data models for analytics, operational reporting, and self-service BI.
• Implement 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 to increase scalability, maintainability, and performance.
• Develop solutions utilizing Microsoft Fabric, OneLake, Lakehouse, Warehouse, Data Factory, Pipelines, Semantic Models, and 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.
• Implement automated data quality validation, reconciliation, and exception handling processes.
• Support data governance initiatives including metadata management, data lineage, data stewardship, data cataloging, and 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.
• 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 workflows, pull request practices, branching strategies, release management, and deployment automation.
• Develop Infrastructure-as-Code and configuration management patterns where appropriate.
• Implement data security controls, access management, encryption, and auditing capabilities.
• Ensure compliance with internal governance policies and industry best practices, including regulatory and privacy requirements related to sensitive business and employee data.
• 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.

Requirements

• 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, and 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, and Warehouse.
• Experience with Semantic Models and 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.

Technologies

Microsoft Fabric, Azure Data Services, Microsoft Fabric Lakehouse, Azure Data Factory, Dataflows, ETL, ELT, SQL, stored procedures, views, OneLake, Lakehouse, Warehouse, Medallion Architecture, Bronze, Silver, Gold, dimensional models, star schemas, semantic modeling structures, Power BI, Azure DevOps, Git, CI/CD, Infrastructure-as-Code, Python, Azure Cloud Services, Data Warehousing, Azure Synapse Analytics, SSIS, Data Lakes, Delta Lake, REST APIs, Salesforce, Workday, Azure Functions, Synapse Analytics, Data lineage, Metadata management, data cataloging, data classification, data stewardship.

Location and Role Details

• Location: Orlando, FL (onsite)
• Salary: USD 125,000 per year
• Job Classification: Salary Exempt

Education

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