Data Engineer

Data EngineerWe are hiring a Data Engineer to own the operational backbone of our data platform: SQL Servers, the pipelines that move data out of it, and the Microsoft Fabric data warehouse that feeds reporting, regulatory work, and internal applications. The data is high-frequency time-series and operational data from more than 100 projects, so reliability, completeness, and monitoring matter as much as building new things. This is a hands-on role on a small team that is actively modernizing its platform. We want someone who learns new tools on their own initiative, takes ownership of production systems, and wants to grow with the platform.Essential ResponsibilitiesAdminister the SQL Server environment in Azure: backups and restore testing, SQL Agent jobs, index and statistics maintenance, security and access, storage growth, and performance tuning.Monitor continuous data ingestion from 100+ projects and resolve gaps, delays, duplicates, and out-of-range values before they reach downstream reporting.Build, maintain, and troubleshoot pipelines that move data from staging and external REST APIs into the Fabric data warehouse.Maintain and extend the warehouse's dimensional models, data quality rules, and load performance.Build alerting for pipeline failures, data freshness, and completeness, and own the response when they fire.Contribute to the migration of remaining workloads from Azure Synapse to Microsoft Fabric.Support analysts and application developers who consume warehouse data through Power BI semantic models and internal applications.Write and maintain runbooks and technical documentation, and work in Git with code review and CI/CD deployment.Required Qualifications3+ years of professional experience with SQL Server and T-SQL, including set-based query design, stored procedures, execution-plan tuning, and indexing.Hands-on database administration in production: backup and recovery, SQL Agent, maintenance jobs, logins and role-based security, and capacity monitoring.Experience building and operating production ETL/ELT pipelines (Azure Data Factory, Synapse pipelines, Fabric Data Factory, or SSIS), including incremental loads, failure handling, and reruns.Working knowledge of dimensional modeling: facts, dimensions, grain, and slowly changing dimensions.Hands-on Microsoft Fabric experience: Warehouse and Lakehouse, Data Factory pipelines, Dataflow Gen2, notebooks, and capacity monitoring.Familiarity with Azure fundamentals: resource organization, networking basics, managed identities, and Key Vault.Experience implementing data quality checks, monitoring, or alerting production data.Proficiency with Git.A track record of learning new tools and platforms independently and applying them to real work.Python, and C# programming languagesSpark frameworkPreferred QualificationsExperience with Power BI semantic modelsExperience with high-volume time-series, IoT, or industrial operations data.Microsoft certification DP-600 (Fabric Analytics Engineer) or DP-700 (Fabric Data Engineer).Other DutiesPlease note this job description is not designed to cover or contain a comprehensive list of activities, duties, or responsibilities required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.Physical Demand RequirementsWork Environment - Office Staff This role operates primarily in a professional office environment and uses computers, cloud platforms, databases, development tools, and communication systems. Limited travel to company offices or project locations may be required.Physical Demands - Office Staff This is largely a sedentary role requiring extended computer work, regular communication, and the ability to manage multiple technical priorities. The position may occasionally require travel in vehicles or airplanes and access to company operating locations.