Data Engineer III

Data Engineer III FM is a leading mutual insurance company whose capital, scientific research capability and engineering expertise are solely dedicated to property risk management and the resilience of its policyholder-owners. These owners, who share the belief that the majority of property loss is preventable, represent many of the world’s largest organizations, including one of every four Fortune500 companies. They work with FM to better understand the hazards that can impact their business continuity to make cost-effective risk management decisions, combining property loss prevention with insurance protection. What You’ll Do Architect & Innovate: Design and maintain scalable data pipelines and infrastructure for ingestion, integration, and storage of structured and unstructured data. Enable Analytics: Deliver clean, reliable datasets for Business Intelligence, Advanced Analytics, and Data Science teams. Optimize Performance: Implement modern practices using Microsoft Fabric, SQLServer, SSIS, PowerBI Premium, and big data frameworks like Spark. Ensure Quality: Validate solutions through rigorous testing and maintain data integrity across all systems. Collaborate & Lead: Partner with Product Owners, Architects, Analysts, and Data Scientists on medium-to-large projects, and lead small-to-medium initiatives independently. Drive Continuous Improvement: Automate processes, optimize data delivery, and redesign infrastructure for scalability. What We’re Looking For Prefer 4 year/bachelor’s degree or master’s degree in computer science, Information Technology, Computer Engineering, or equivalent experience. 5+ years relatable work experience. Ability to design and optimize SQL queries across cloud data warehouses, with strong proficiency in T‑SQL. Skilled in data orchestration and ETL tools such as Azure Data Factory or SSIS, and eager to adopt Fabric Data Factory (Pipelines & Dataflows Gen2). Background in CI/CD and version control for data solutions (e.g., Git, deployment pipelines), with interest in DevOps practices for analytics platforms. Familiarity with modern data lake architectures, including Delta Lake and medallion design patterns. Knowledge of columnar storage formats and lakehouse technologies such as Delta Lake and Parquet for scalable data processing. Hands‑on work with big data frameworks like Apache Spark (PySpark or Scala) for batch workloads is helpful. Understanding BI and semantic modeling concepts, including star schema design and performance tuning is helpful. Compensation & Benefits Compensation, Grade, and Job Title will be determined based on qualifications, experience, and technical skillset. Well qualified candidates may be considered for a data engineer IV. The position is eligible to participate in FM's comprehensive Total Rewards program that includes an incentive plan, generous health and well-being programs, a 401(k) and pension plan, career development opportunities, tuition reimbursement, flexible work, paid time off allowances and much more. Equal Opportunity Employer FM is an Equal Opportunity Employer and is committed to attracting, developing, and retaining a diverse workforce. Job Details Seniority level: Mid‑Senior level Employment type: Full‑time Job function: Information Technology Industries: Insurance #J-18808-Ljbffr