5+ years of experience in data engineering and SQL Server administration, preferably in regulated environments.
Proficient in data analysis across Customer, Finance, Billing, and Legal systems.
Strong focus on security and compliance in data architecture.
Hands-on experience with SQL Server maintenance and operations.
Experience building ETL/ELT pipelines using Azure Data Factory or similar tools.
Familiarity with Microsoft Fabric for Lakehouse and Data Warehouse solutions.
Advanced skills in T-SQL, Python, or PySpark for data transformation.
Responsibilities
Design and implement data integration pipelines using standard and custom connectors.
Develop end-to-end data solutions on Microsoft Fabric, including Lakehouse and Data Warehouse architectures.
Ensure compliance with ethical walls and encryption standards for data movement and storage.
Create production-grade transformation logic using T-SQL, Python, and PySpark.
Monitor and optimize SQL Server performance, including indexing and query tuning.
Manage high availability and disaster recovery architectures for SQL Server.
Implement automated data validation and performance monitoring across environments.
Benefits
Hybrid work schedule with three days on-site and two days remote.
Opportunity for professional development and certifications.
Collaborative team environment with regular sprint planning and solution design sessions.
On-call support for critical technical issues outside standard hours.
Full Job Description
The Opportunity
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.
Key Responsibilities
Database & Pipeline Integration: Design, develop, and implement data integration pipelines using standard and custom connectors.
Microsoft Fabric Solution Development: Design, build, and deploy end-to-end data solutions on Microsoft Fabric, including Lakehouse, Data Warehouse, and semantic layer architectures.
Responsible for ensuring that all data movement, storage, and processing strictly adhere to client ethical walls, encryption standards, and row/column-level access controls required in a professional services environment.
Data Transformation: Develop production-grade transformation logic using T-SQL, Python, and PySpark within cloud notebooks and stored procedures.
SQL Administration & Tuning: Monitor database health, optimize indexing, tune slow-running queries, and manage transactional replication, backup and recovery strategies, and user permissions.
SQL Server High Availability & Disaster Recovery (HA/DR): Design and manage failover architectures, including Always-On Availability Groups, Failover Clustering, Log Shipping, and Replication.
Performance Tuning & Optimization: Monitor system performance and optimize queries using execution plans, indexing strategies, statistics, and bottleneck analysis.
Security & Compliance: Manage user access, audit permissions, enforce role-based security, and implement data encryption standards.
Backup & Recovery Administration: Schedule, test, and maintain full, differential, and transaction log backups to support business continuity and data protection.
Quality & Monitoring: Implement automated data validation, error handling, alerting, and performance monitoring across SQL Server and Microsoft Fabric environments.
Qualifications
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.
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, not an afterthought
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. Familiarity with Fabric CI/CD, deployment pipelines, GitHub integration, data modeling, Power BI semantic models, and Fabric capacity and cost monitoring.
Python & PySpark: Proficiency in Python or PySpark for cloud-based data transformation and processing.
Certifications - Highly Desired
Microsoft Certified: Fabric Data Engineer Associate (DP-700)
Microsoft Certified: Azure Data Engineer Associate (DP-203)
Microsoft Certified: Administering Relational Databases (DP-300)
Hybrid Workplace Expectations
On-Site Schedule: Work on-site three days per week for team collaboration, sprint planning, solution design, development, and support.
Remote Work Schedule: Work remotely two days per week while maintaining strong communication and meeting delivery commitments.
On-Call Support: Willingness to be available outside standard business hours to troubleshoot and resolve critical technical issues as needed.
The base annual pay range for this role is between $160K-$190K. The base pay to be offered will vary and depend on skills and qualifications, experience, location and will also take into account internal equity. A full range of medical, financial and/or other benefits dependent on the position will also be offered.
About Manatt, Phelps & Philips, LLP
Manatt, Phelps & Phillips, LLP is a law firm that provides legal services to clients in a variety of industries, including healthcare, entertainment, and financial services. The firm offers a range of services, including litigation, corporate law, and intellectual property law. Manatt, Phelps & Phillips was founded in 1965 and is headquartered in Los Angeles, California.
