Senior Data Engineer

Franklin Fitch; United States; Remote; USD 150,000 - 190,000; Full time

Job summary

Franklin Fitch is partnering with a large US law firm to migrate its legacy SQL Server data warehouse to Microsoft Fabric. We seek a Senior Data Engineer to own the modernisation, build safe pipelines, and enable secure data access for AI and back‑office automation.

This hands‑on role offers direct access to the hiring manager, with potential to grow into a technical lead and flexible remote work with occasional office visits to US locations.

Qualifications

• Strong hands‑on Microsoft Fabric data engineering experience, including lakehouse or medallion architecture.
• Strong SQL skills, including experience with existing SQL Server environments.
• Practical experience with PySpark and Spark SQL.
• Sound data‑security practices for confidential business data.
• The ability to understand an inherited environment, make changes safely and work with limited day‑to‑day direction.
• Clear communication and a willingness to use modern tools, including AI‑assisted development, thoughtfully.

Responsibilities

• Platform ownership: take ownership of the data warehouse as it moves from SQL Server to Microsoft Fabric, while supporting the legacy environment during the transition.
• Pipelines and reporting: Build and adapt data pipelines and models across accounting, HR, CRM and other business systems.
• AI and data security: Work with AI engineers to deliver data for new applications and protect sensitive information.
• Ownership and communication: Raise risks early and communicate clearly with stakeholders; take ownership of outcomes.
• Preferred: experience with legal accounting systems such as Elite or 3E, and supporting a data‑warehouse migration.

Skills

Microsoft Fabric data engineering

SQL

PySpark

Spark SQL

Data security

Communication

Inherited environment understanding

Job description

This role is only open in the following states: Alabama, Arizona, California, Colorado, Delaware, District of Columbia, Florida, Georgia, Maryland, Massachusetts, Nevada, New York, North Carolina, Ohio, South Carolina, Tennessee, Texas, Virginia

Want to take ownership of a data platform at a pivotal point in its modernisation?

We’re partnering with a large US law firm that is moving its legacy SQL Server data warehouse to Microsoft Fabric. The firm now needs a Senior Data Engineer who can understand what has been built, take ownership of it and develop it safely over the long term.

This is a hands‑on role with direct access to the hiring manager. You’ll support business‑critical financial reporting, prepare for a major accounting‑system change and help make data available securely for AI and back‑office automation. There is potential for the role to develop into a technical lead position.

Key Responsibilities

Platform ownership

• Take ownership of the data warehouse as it moves from SQL Server to Microsoft Fabric, while supporting the legacy environment during the transition
• Learn the consultants’ Fabric implementation (notebooks, SQL and Python scripts), then maintain, test and improve it

Pipelines and reporting

• Build and adapt data pipelines and models across accounting, HR, CRM and other business systems
• Support the planned replacement of the firm’s accounting system, including mapping data into the rebuilt warehouse
• Make changes to financial and profitability reporting while keeping outputs accurate

AI and data security

• Work with AI engineers to deliver the data needed for new applications and automation
• Protect sensitive information, including personal, HR and compensation data

Ownership and communication

• Raise risks early and communicate clearly with stakeholders
• Take ownership of outcomes, not just code

Key Skills & Qualifications

Required

• Strong hands‑on Microsoft Fabric data engineering experience, including lakehouse or medallion architecture
• Strong SQL skills, including experience with existing SQL Server environments
• Practical experience with PySpark and Spark SQL
• Sound data‑security practices for confidential business data
• The ability to understand an inherited environment, make changes safely and work with limited day‑to‑day direction
• Clear communication and a willingness to use modern tools, including AI‑assisted development, thoughtfully

Preferred

• Experience with accounting data: billing subledgers, general‑ledger reconciliation, financial data modelling or profitability reporting
• A background in a law firm or professional‑services organisation
• Experience with legal accounting systems such as Elite or 3E, particularly their data structures
• Experience supporting a major source‑system or data‑warehouse migration
• Technical‑lead experience, or an interest in growing into that responsibility

Roughly five to seven years of relevant experience is the target, but directly comparable experience matters more than a strict year count.

The preference is for someone able to visit one of the firm’s US offices when needed. Fully remote working may be considered for the right person.

If you’ve worked on business‑critical data platforms and would enjoy owning the next stage of a Fabric migration, we’d like to hear from you, even if you don’t meet every preferred criterion.