Senior Data Engineer

Loyal Source Government Services; Orlando (FL); On-site; USD 113,000 - 138,000; Full time

Job summary

Loyal Source Government Services is seeking a Senior Data Engineer to design, build, and operate scalable data platforms in Orlando, FL on site. You will develop ETL/ELT pipelines using Microsoft Fabric, Azure Data Factory, and related Azure services, connecting APIs, SaaS, and databases to enable analytics and self-service BI.

You will optimize SQL transformations, implement Medallion Architecture, govern metadata, and drive CI/CD deployments with Azure DevOps and Git.

Qualifications

• Bachelor's degree in a relevant field is required.
• 5+ years hands-on data engineering experience with large-scale platforms.
• Strong SQL performance tuning and data modeling skills.
• Proficient in Python for data processing and automation.

Responsibilities

• Design, develop, and maintain scalable ETL/ELT pipelines.
• Build enterprise data warehouses and analytics platforms.
• Implement Medallion Architecture in Fabric and Lakehouse patterns.
• Collaborate with data architects on enterprise data models for analytics.

Skills

SQL

Python

ETL/ELT

REST APIs

Git

CI/CD

Data Lakes

Dimensional Modeling

Power BI

Education

Bachelor's Degree

Tools

Microsoft Fabric

Azure Data Factory

Azure Synapse Analytics

SSIS

OneLake

Dataflows

Job description

Loyal Source Government Services is hiring a Senior Data Engineer to build and operate scalable enterprise data platforms in Orlando, FL (onsite).

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 using best practices
• Develop and optimize SQL-based transformations including stored procedures, views, and performance-tuned datasets
• Create reusable, scalable ingestion frameworks for batch and near real-time processing
• Monitor and troubleshoot data pipelines to ensure reliability, performance, and operational stability
• Collaborate with Data Architects on enterprise data models supporting analytics, operational reporting, and self-service BI
• Implement and support Medallion Architecture (Bronze, Silver, Gold) 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 using: Microsoft Fabric, OneLake, Lakehouse, Warehouse, Data Factory, Pipelines, Semantic Models, and Power BI
• Use Azure services to support secure data movement, storage, integration, and processing
• Participate in environment configuration, deployment planning, and operational support
• Implement automated data quality validation, reconciliation, and exception handling
• Support data governance activities including metadata management, data lineage, data stewardship, data cataloging, and data classification
• Establish monitoring and alerting 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 including pull requests, branching strategies, release management, and deployment automation
• Develop Infrastructure-as-Code and configuration management patterns where appropriate
• Implement data security controls including 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
• 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 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
• Experience with Data Factory
• Experience with Lakehouse
• Experience with Warehouse
• Experience with Semantic Models
• Experience with 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, OneLake, Lakehouse, Warehouse, Medallion Architecture (Bronze, Silver, Gold)
• Azure Data Services, Azure Data Factory, Dataflows, ETL, ELT, Pipelines
• SQL, stored procedures, views, performance-tuned datasets
• Semantic Models, Power BI, data warehousing, data modeling, dimensional models, star schemas
• Azure DevOps, Git, CI/CD, Infrastructure-as-Code, configuration management
• Python, Azure Cloud Services, Azure Synapse Analytics, SSIS
• Data Lakes, Delta Lake, REST APIs, Azure Functions, Synapse Analytics, Data lineage
• Salesforce, Workday
• Data cataloging, data classification, data stewardship, metadata management

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