Data Engineer III

FM; Johnston (RI); On-site; USD 105,000 - 145,000; Full time

Benefits offered by this job

Comprehensive health and well-being programs

401(k) and pension plan

Tuition reimbursement

Flexible work schedule

Paid time off allowances

Job summary

A leading mutual insurance company in Rhode Island is seeking a Data Engineer III to design and maintain scalable data pipelines. As a critical member of the Information Technology team, you will deliver reliable datasets, enable advanced analytics, and optimize data performance using tools like Microsoft Fabric and Apache Spark. Ideal candidates will have 5+ years of experience and a strong education in computer science or related fields. This full-time position offers comprehensive benefits and career development opportunities.

Qualifications

• 5+ years of relevant work experience.
• Strong proficiency in T-SQL for cloud data warehouses.
• Familiarity with CI/CD practices for data solutions.
• Experience with data orchestration and ETL tools (Azure Data Factory or SSIS) and interest in Fabric Data Factory.

Responsibilities

• Design scalable data pipelines and infrastructure.
• Deliver reliable datasets for analytics and data science.
• Automate processes and optimize data delivery.

Skills

Data pipeline architecture

SQL query optimization

ETL tools expertise

Data orchestration

Big data frameworks

ETL

DevOps for analytics

Spark (PySpark/Scala)

Data modeling

Education

Bachelor's or Master's in Computer Science or equivalent

Master's degree in CS/IT

Tools

Microsoft Fabric

Azure Data Factory

SQL Server

Apache Spark

Job description

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 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.

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 & 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