Data Engineer III

Established nearly two centuries ago, 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 Fortune 500 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.

Are you passionate about building robust data ecosystems that power advanced analytics and business insights? Join our dynamic team as a Data Engineer III, where you’ll design and implement cutting-edge data pipelines, integrate diverse data sources, and ensure the highest standards of data quality, security, and compliance. This is your opportunity to work on impactful projects that shape the future of data-driven decision-making.

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, SQL Server, SSIS, Power BI 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, 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.

FM is an Equal Opportunity Employer and is committed to attracting, developing, and retaining a diverse workforce.

#LI-TA1