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