Azure Data Engineer

Frontline Data Solutions provides web-based environmental health and safety software to some of the worlds 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 Youll Do

• Data Architecture: Design and evolve data schemas transforms and pipelines for scalability and longterm 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.
• CrossTeam Collaboration: Work closely with Product Engineering and Technical Services to align data solutions with platform and customer needs.

Skills Youll 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 Youll 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