Data Engineer at Manatt, Phelps & Phillips, LLP | Boston, MA, US | Rezi

Data Engineer at Manatt, Phelps & Phillips, LLP

Data Engineer

Manatt, Phelps & Phillips, LLP · Boston, MA, US

2 days ago

Data Engineer

Manatt, Phelps & Phillips, LLP · Boston, MA, US

2 days ago
Resume preview

Impress employers and recruiters.
Choose from hundreds of resume examples.

Target Resume Now
Resume preview

Tailor your resume to this Data Engineer role.

Rezi rewrites your resume against Manatt, Phelps & Phillips, LLP's job description. Free.

Resume score gauge reading 58 out of 100

Don't guess if your resume is good enough.

See how it scores against the Data Engineer posting at Manatt, Phelps & Phillips, LLP — free, in seconds.

About the Role

We are seeking a Mid-Level Data Engineer with SQL Server Administration (DBA) experience to join our team. In this role, you will be responsible for ELT processes that move critical data across our Customer (CRM), Finance (ERP), Billing, and Legal ecosystems. Reporting to the Data Architect, you will design, build, test, and maintain scalable data pipelines and solutions while adhering to established frameworks, architectural standards, and data governance practices. The Data Engineer will ensure the health, security, and performance of our enterprise Microsoft SQL Server environments. The Data Engineer will work closely with business applications, Infrastructure and Security teams to maintain SQL database high availability, performance and robust disaster recovery.

Responsibilities

  • Design, develop, and implement data integration pipelines using standard and custom connectors.
  • Design, build, and deploy end-to-end data solutions on Microsoft Fabric, including Lakehouse, Data Warehouse, and semantic layer architectures.
  • Ensure that all data movement, storage, and processing strictly adhere to client ethical walls, encryption standards, and row/column-level access controls.
  • Develop production-grade transformation logic using T-SQL, Python, and PySpark within cloud notebooks and stored procedures.
  • Monitor database health, optimize indexing, tune slow-running queries, and manage transactional replication, backup and recovery strategies, and user permissions.
  • Design and manage failover architectures, including Always-On Availability Groups, Failover Clustering, Log Shipping, and Replication.
  • Monitor system performance and optimize queries using execution plans, indexing strategies, statistics, and bottleneck analysis.
  • Manage user access, audit permissions, enforce role-based security, and implement data encryption standards.
  • Schedule, test, and maintain full, differential, and transaction log backups to support business continuity and data protection.
  • Implement automated data validation, error handling, alerting, and performance monitoring across SQL Server and Microsoft Fabric environments.

Requirements

  • Five years of hands-on experience in data engineering, data warehousing, and SQL Server database administration.
  • Experience working with regulated data in Legal, Tax, Finance, or Healthcare environments is highly desirable.
  • Experience interpreting and working with business application data across Customer, Finance, Billing, and Legal systems.
  • Strong architectural mindset that treats security and compliance as foundational design requirements.
  • Strong hands-on experience with SQL Server administration, including query profiling, indexing strategies, execution plan analysis, and database maintenance.
  • Experience installing, configuring, patching, upgrading, and maintaining Microsoft SQL Server environments.
  • Direct experience building ETL/ELT pipelines using Azure Data Factory (ADF) or comparable data integration platforms.
  • Hands-on experience developing Lakehouse and Data Warehouse solutions within the Microsoft Fabric ecosystem.
  • Advanced proficiency in developing and troubleshooting complex T-SQL scripts, stored procedures, functions, and triggers.
  • Experience with Git, Azure DevOps, and pipeline deployment processes.
  • Familiarity with Fabric CI/CD, deployment pipelines, GitHub integration, data modeling, Power BI semantic models, and Fabric capacity and cost monitoring.
  • Proficiency in Python or PySpark for cloud-based data transformation and processing.

Skills

  • SQL Server Administration
  • ELT
  • Microsoft Fabric
  • Lakehouse
  • Data Warehouse
  • T-SQL
  • Python
  • PySpark
  • SQL Server High Availability & Disaster Recovery (HA/DR)
  • Always-On Availability Groups
  • Failover Clustering
  • Log Shipping
  • Replication
  • Performance Tuning
  • Security & Compliance
  • Backup & Recovery Administration
  • Data Validation
  • Error Handling
  • Alerting
  • Performance Monitoring
  • Data Integration
  • Azure Data Factory (ADF)
  • Git
  • Azure DevOps
  • CI/CD
  • Power BI semantic models

Location

  • United States

Work Type

  • Hybrid
  • On-Call Support

Experience Level

  • Mid-Level
  • Five years of hands-on experience

Education Level

  • Microsoft Certified: Fabric Data Engineer Associate (DP-700)
  • Microsoft Certified: Azure Data Engineer Associate (DP-203)
  • Microsoft Certified: Administering Relational Databases (DP-300)

Salary/Compensations

  • $160K-$190K

Benefits

  • A full range of medical, financial and/or other benefits dependent on the position will also be offered.

About the Company

  • With eleven offices across the United States, 500+ professionals and 350+ business professionals, Manatt, Phelps & Phillips, LLP (www.manatt.com), is a multidisciplinary, integrated national professional services firm known for quality and an extraordinary commitment to clients.
  • The Firm’s groundbreaking approach—bringing together legal services, advocacy and business strategy—differentiates Manatt from its competitors and positions the Firm to provide a distinct and compelling value proposition.

Equal Opportunity

  • Manatt is an equal opportunity employer, dedicated to a policy of non-discrimination in employment on any basis including race, color, physical or mental disability, religion, creed, national origin, citizenship status, ancestry, sex or gender (including gender identity, gender expression, status as a transgender or transsexual individual, pregnancy, childbirth, or related medical conditions), age (over 40), genetic information, past, current, or prospective service in the uniformed services, sexual orientation, political activity or affiliation, genetic or and any other protected classes or characteristic protected under applicable federal, state, or local law.
  • Consistent with the American Disabilities Act, applicants may request accommodations needed to participate in the application process.
  • This employer will provide the Social Security Administration (SSA) and, if necessary, the Department of Homeland Security (DHS), with information from each new employee’s Form I-9 to confirm work authorization.
  • If the Government cannot confirm that you are authorized to work, this employer is required to provide you written instructions and an opportunity to contact SSA and/or DHS before taking adverse action against you, including terminating your employment.
  • Employers may not use E-Verify to pre-screen job applicants or to re-verify current employees and may not limit or influence the choice of documents presented for use on the Form I-9.
  • In order to determine whether Form I-9 documentation is valid, this employer uses E-Verify’s photo screening tool to match the photograph appearing on some permanent resident and employment authorization cards with the official U.S. Citizenship and Immigration Services’ (USCIS) photograph.
  • If you believe that your employer has violated its responsibilities under this program or has discriminated against you during the verification process based upon your national origin or citizenship status, please call the Office of Special Counsel at 1-800-255-7688 (TDD: 1-800-237-2515).