Senior Data Engineer

Foundation-Partners-Group; Orlando (FL); On-site; USD 120,000 - 160,000; Full time

Job summary

Foundation-Partners-Group is seeking a Senior Data Engineer to design, build, and operate modern data platforms at scale across Azure, Fabric, Azure SQL, and AWS. You will architect reliable pipelines and self-service analytics to drive business decisions.

This hands-on role emphasizes containerized workloads with Azure Container Apps Jobs, governed data delivery, and collaboration with analytics and engineering teams.

Qualifications

• Proficient in Python for production-grade data pipelines and automation.
• Advanced SQL skills with SQL Server, Azure SQL DB, and cloud data warehouses.
• Experience with MS Fabric including Warehouses, Lakehouses, and OneLake.
• Extensive experience containerizing workloads with Docker and deploying as Container Apps Jobs.
• Experience with AWS data services (S3, Redshift) and cloud data architectures.
• Knowledge of data modeling (dimensional), star/snowflake schemas, OLTP/OLAP.
• Version control with Git/GitHub and CI/CD pipelines.
• Strong analytical problem‑solving and clear communication.
• Self-directed with attention to detail; end-to-end ownership.

Responsibilities

• Design and build scalable data pipelines using Python and cloud-native tools.
• Architect data solutions across Fabric Warehouses, Azure SQL, and AWS.
• Implement Bronze-Silver-Gold data delivery with governance.
• Manage large-scale data warehouses focusing on performance and cost.
• Develop ETL/ELT pipelines from APIs, files, and SaaS data sources.
• Deploy containerized pipeline jobs via Azure Container Apps Jobs with scheduling.
• Move data between on-prem SQL Server and cloud targets.
• Design fault-tolerant patterns with logging, alerts, retries.
• Collaborate with analytics/BI teams to deliver clean models.
• Mentor engineers and contribute to standards.

Skills

Python

SQL

MS Fabric

Docker

Azure Container Apps

Cloud data architecture

Git/GitHub

Analytical problem solving

Communication

Self-directed

Education

Bachelor's degree

Tools

Azure Data Factory

Azure Container Apps

Terraform/Bicep

GitHub Actions

Azure DevOps

Docker

SQL Server/Azure SQL

Job description

We are looking for a Senior Data Engineer to design, build, and operate modern data platforms at scale. You will work across cloud-native Azure infrastructure, Microsoft Fabric, Azure SQL, and AWS, building reliable pipelines, performant data models, and self-service analytics that drive real business decisions. A meaningful part of this role involves containerized workload execution -- designing and deploying pipeline jobs using Azure Container Apps Jobs for scheduled and event-driven data processing. This is a hands‑on role suited for an engineer who thrives in ambiguity, values clean architecture, and moves comfortably between strategy and implementation.

RESPONSIBILITIES

Data Platform and Architecture

• Design and build scalable data pipelines using Python and cloud-native orchestration tools, including Azure Data Factory, Azure Container Apps Jobs, and Fabric Data Pipelines.
• Architect data solutions across Microsoft Fabric Warehouses, Azure SQL Database, and AWS (S3, Redshift), selecting the right tool for the workload.
• Implement Medallion/layered architecture patterns (Bronze to Silver to Gold) for structured, governed data delivery.
• Manage and optimize large-scale data warehouse environments with a focus on performance, cost, and maintainability.

Pipeline Development and Integration

• Develop Python-based ETL/ELT pipelines to ingest and transform data from APIs, flat files, databases, and SaaS platforms.
• Build and deploy containerized pipeline jobs using Azure Container Apps Jobs, including scheduling, scaling rules, secrets management via Azure Key Vault, and integration with Azure Container Registry.
• Build and maintain data movement between on-premises SQL Server environments and cloud targets.
• Design idempotent, fault-tolerant pipeline patterns with robust logging, alerting, and retry logic.
• Collaborate with analytics and reporting teams to deliver clean, well-documented data models for Power BI or similar BI tools.

Cloud Infrastructure and Operations

• Containerize data workloads using Docker; deploy and operate them as Azure Container Apps Jobs for scheduled batch processing and event-triggered pipeline execution.
• Implement infrastructure-as-code principles and version‑controlled deployment practices using GitHub, Bicep or Terraform, and CI/CD tooling (Azure DevOps or GitHub Actions).
• Monitor platform health, optimize compute and storage costs, and enforce data security and access governance.

Collaboration and Engineering Excellence

• Partner with data analysts, BI developers, software engineers, and business stakeholders to translate requirements into technical solutions.
• Maintain thorough technical documentation: pipeline specs, data dictionaries, runbooks, and architecture diagrams.
• Mentor junior engineers and contribute to team standards and knowledge sharing.

REQUIREMENTS

• Python: fluent in writing production-grade pipelines, data transformations, and automation scripts.
• RDBMS: Advanced T‑SQL and/or ANSI SQL; experience with SQL Server, Azure SQL DB, and cloud warehouse query engines (Redshift, Fabric).
• MS Fabric: Warehouses, Lakehouses, Data Pipelines, OneLake, and Fabric's unified analytics model.
• Containerization: Docker image development, container registry management, and deploying workloads as Container Apps Jobs with schedule and event triggers, scaling rules, and environment variable/secret injection.
• AWS data services: S3 for data lake storage, Redshift for cloud data warehousing.
• Data modeling: dimensional modeling, star/snowflake schema design, and entity‑relationship modeling for both OLTP and OLAP workloads.
• Version control and DevOps: Git, GitHub, pull request workflows, and CI/CD pipelines.
• Strong analytical problem‑solving -- able to decompose ambiguous business problems into clean technical solutions.
• Clear written and verbal communication with both technical peers and non‑technical stakeholders.
• Self‑directed with strong attention to detail; comfortable owning work end‑to‑end.

Experience

• 5 to 8 years of hands‑on data engineering experience in production environments.
• Proven track record designing and delivering data platforms on Azure and/or AWS.
• Demonstrated experience migrating or modernizing legacy on‑premises data infrastructure to cloud‑native solutions.
• Hands‑on experience running workloads with Azure Container Apps Jobs or a comparable containerized job execution platform.

PREFERRED QUALIFICATIONS

• Experience with MS Fabric in a production capacity, including Fabric Warehouses and OneLake integration.
• Familiarity with dbt (data build tool) or similar transformation frameworks.
• Exposure to streaming or near‑real‑time data ingestion patterns (Event Hub, Kafka, Kinesis).
• Experience with Workday, Adaptive Planning, or other ERP/FP&A source systems.
• Power BI experience including semantic model development, dataset optimization, or DirectQuery/Import mode tradeoffs.
• Agile/Scrum team experience; comfort working in iterative delivery cycles.
• Relevant cloud certifications: Microsoft Azure Data Engineer (DP-203), AWS Certified Data Analytics, or equivalent.
• Bachelor's degree in Computer Science, Information Systems, Data Science or a related field. In lieu of formal education, equivalent professional experience demonstrating the same depth of knowledge is accepted.