Senior data engineer

job summary:
Are you a senior data architect looking to lead a massive data modernization effort at a premier legal services provider? We are seeking a heavyweight backend engineering professional to champion the transition from legacy on-premises databases to a unified Microsoft Fabric Lakehouse architecture. In this remote role, you will be the cornerstone of a newly launched enterprise ecosystem, rescuing a massive data backlog, mentoring junior developers, and setting the rigorous data governance foundation needed for cutting-edge AI integrations. Our client offers a highly competitive compensation package including comprehensive medical, dental, and vision coverage.

location: Telecommute
job type: Permanent
salary: $150,000 - 180,000 per year
work hours: 9am to 6pm
education: Bachelors


responsibilities:

• Start your morning collaborating with the Knowledge Management leadership team to architect and stabilize the backend data foundation using Microsoft Fabric.
• Take full ownership of replacing fragmented, legacy ETL pipelines with a modern, unified lakehouse ecosystem.
• Write and execute Python and SQL notebooks to transform, validate, and securely move vast amounts of critical firm data across platforms.
• Design and maintain robust semantic models that power enterprise-level analytics and Power BI dashboards.
• Develop custom SharePoint Online solutions, including libraries, workflows, and frontend web parts, to support daily practice operations.
• Mentor junior and mid-level developers, alleviating their backend architectural load and streamlining incoming data requests.
• Partner with cross-functional stakeholders and database administrators to ensure data integrity, governance, and readiness for future AI deployments

qualifications:
Must-Haves:

Previous experience working directly within a law firm, court system, or legal technology environment.

Extensive background in backend data engineering, specifically migrating legacy on-premises SQL Server databases to modern cloud architectures.

Deep architectural expertise in Microsoft Fabric, including OneLake, Lakehouse, and semantic modeling.

Advanced proficiency in building scalable ETL and ELT pipelines using Python, PySpark, and complex SQL queries.

Ability to work strict EST core hours (9:00 AM to 6:00 PM) and willingness to travel to the Southeast US for strategic planning sessions 2 to 3 times per year.

Reside in an approved remote location (Candidates located in New York and California are explicitly excluded from consideration).

Nice-to-Haves:

Familiarity with frontend development technologies such as React JS, JavaScript, HTML5, and CSS3.

Experience with SharePoint Online administration, Power Automate flows, and custom scripting.

Prior exposure to complex legal CRM, billing, financial, or matter management software systems.

A Bachelor's degree in Computer Science, Software Engineering, or a closely related discipline.

skills:
CSS3,analytics,dataset,dataflow,ensuring data integrity,pipeline development,complex queries,Enterprise Search,ETL,Front-end development,GitHub,HTML5,Computer Science,jQuery,JavaScript,Knowledge Management,Microsoft Fabric,Power Automate,Microsoft SQL,SharePoint Online,SharePoint,monitor performance,Power BI reports,Power Query,Python,React.js,SQL,stored procedures,scripting,software development,cmdlets,adaptability,Ability to analyze,communicate,Strong verbal and written communication,creative problem-solving,decisive,energetic,proactive,customer-focused,Team player,business operations,business needs,dashboard design,semantic models,DBAs,governance,Legal experience,maintenance,modeling,strong collaboration skills,maintain data,self-organization,semantic,warehouses,technical documentation,workflows

Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact View email address on click.appcast.io.


Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including: medical, prescription, dental, vision, AD&D, and life insurance offerings, short-term disability, and a 401K plan (all benefits are based on eligibility).


This posting is open for thirty (30) days.

It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.