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