Azure Data Engineer

Frontline Data Solutions provides web-based environmental, health, and safety software to some of the world's leading chemical, oil & gas, and manufacturing companies. Frontline is a fully distributed organization, and all roles, including this one, can be performed from any location within the United States. Frontline is unique in that it combines the fast-paced, entrepreneurial environment of a start-up software company with the stability and reputation that reflects its 27-year history of serving blue-chip industrial customers.
As a Data Engineer at Frontline Data Solutions, you will focus on the implementation of our Analytics platform using Fabric to create high-performance report and dashboard APIs.
What You'll Do
Data Architecture: Design and evolve data schemas, transforms and pipelines for scalability, and long‐term performance.
Performance Optimization: Tune queries, indexing, and database configurations and transforms.
Reliability & Recovery: Maintain high data availability and ensure data integrity.
Operations Management: Monitor data system health, troubleshoot incidents, and manage upgrades, patches, and migrations across environments.
Cross‐Team Collaboration: Work closely with Product, Engineering, and Technical Services to align data solutions with platform and customer needs.
Skills You'll Need
Experience with MS Fabric:2+ years of experience with Fabric, One Lake, Pipelines, Notebooks and Event streams
Experience with Spark: 2+ years of experience with Spark, PySpark, understanding of distributed processing and data frames.
Advanced SQL Expertise: 3+ years of experience with SQL Server and similar RDBMS, specializing in expert-level SQL, query tuning, indexing strategies, and execution plan analysis.
Strong background in performance engineering (database optimizers, schema design) and high-availability architectures, including replication, read replicas, and Availability Groups.
What You'll Get
Impact: Play a critical role in ensuring fast, reliable, and scalable data systems that empower product performance, support platform growth, and enhance customer experience.
Leadership & Growth: Work directly with senior leadership, reporting to the CTO, in an autonomous and entrepreneurial culture with zero bureaucracy.
Remote Work & Flexibility: Frontline is a fully distributed organization.
Competitive Compensation