Data Engineer: SQL Server and Azure Fabric Data Pipelines

Manatt, Phelps & Phillips, LLP; Washington (District of Columbia); Hybrid; USD 160,000 - 190,000; Full time

Job summary

Manatt, Phelps & Phillips, LLP seeks a Mid-Level Data Engineer with SQL Server Administration (DBA) experience to own ELT processes across CRM, ERP, Billing, and Legal systems. You will design, build, test, and maintain scalable data pipelines while upholding data governance and security standards.

Report to the Data Architect and collaborate with Applications, Infrastructure, and Security teams. The role emphasizes health, performance, and high availability of Microsoft SQL Server environments,

Qualifications

• Five years of hands-on experience in data engineering, data warehousing, and SQL Server database administration.
• Data Analysis: Experience interpreting and working with business application data across Customer, Finance, Billing, and Legal systems.
• Data Security: Strong architectural mindset that treats security and compliance as foundational design requirements.
• DBA Expertise: Strong hands-on experience with SQL Server administration, including query profiling, indexing strategies, execution plan analysis, and database maintenance.
• Database Maintenance & Operations: Experience installing, configuring, patching, upgrading, and maintaining Microsoft SQL Server environments.
• Data Integration: Direct experience building ETL/ELT pipelines using Azure Data Factory (ADF) or comparable data integration platforms.
• Cloud Platforms: Hands-on experience developing Lakehouse and Data Warehouse solutions within the Microsoft Fabric ecosystem.
• SQL Programming: Advanced proficiency in developing and troubleshooting complex T-SQL scripts, stored procedures, functions, and triggers.
• DevOps & Deployment: Experience with Git, Azure DevOps, and pipeline deployment processes.
• Python & PySpark: Proficiency in Python or PySpark for cloud-based data transformation and processing.

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 adhere to client ethical walls, encryption standards, and 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 replication, backup and recovery.
• Design and manage high availability and disaster recovery architectures including Always-On, Failover Clustering, Log Shipping, and Replication.
• Monitor system performance and optimize queries using execution plans, indexing, statistics, and bottleneck analysis.
• Manage user access, audit permissions, enforce security, and implement data encryption standards.
• Schedule, test, and maintain backups to support business continuity and data protection.
• Implement automated data validation, error handling, alerting, and performance monitoring across SQL Server and Fabric.

Skills

Data engineering

Data warehousing

SQL Server administration

ETL/ELT pipelines

Azure Data Factory (ADF)

Microsoft Fabric

Python

PySpark

T-SQL

Git

Azure DevOps

Fabric CI/CD

Tools

Microsoft Fabric

Azure Data Factory

Git

Azure DevOps

Job description

Manatt, Phelps & Phillips, LLP seeks a Mid-Level Data Engineer with SQL Server Administration (DBA) experience to own ELT processes across CRM, ERP, Billing, and Legal systems. You will design, build, test, and maintain scalable data pipelines while upholding data governance and security standards.

Report to the Data Architect and collaborate with Applications, Infrastructure, and Security teams. The role emphasizes health, performance, and high availability of Microsoft SQL Server environments,