Azure Data Engineer
Frontline Data Solutions · Romblon, Philippines ·
- Category
- Data engineering
- Experience
- 2+ years
Data engineer building Frontline's analytics platform on Microsoft Fabric — designing scalable data schemas, pipelines, and report/dashboard APIs, tuning SQL Server performance, and keeping data highly available. Requires Fabric, Spark/PySpark, and expert SQL Server skills; fully remote within the US.
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