Data Engineer

Manatt, Phelps & Phillips, LLP

. Design, develop, and implement data integration pipelines using standard and custom connectors .

Posted 11/5/2026full-timeUnited StatesMid-LevelSenior💰 $160,000 - $190,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in designing and implementing data integration pipelines and end-to-end data solutions on Microsoft Fabric, with a strong focus on security, compliance, and performance optimization. Proficient in SQL Server administration, data transformation using T-SQL and Python, and managing high-availability architectures.

Highest-signal resume keywords

Data EngineeringSQL Server AdministrationETL/ELT Pipeline DevelopmentMicrosoft Fabric SolutionsData Security and Compliance

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

T-SQLPythonPySparkSQL Server AdministrationData Integration PipelinesDatabase OptimizationData WarehousingETL/ELT DevelopmentData ModelingPerformance Monitoring

Soft Skills

Architectural MindsetCollaborationProblem-Solving

Tools & Technologies

Microsoft FabricAzure Data FactoryGitAzure DevOpsPower BI

Certifications & Qualifications

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

Industry Keywords

Data WarehousingRegulated DataLegalFinanceHealthcare

Tech Stack

Tools & technologies

AzureCloudETLMS SQL ServerPySparkPythonSQL

About the role

Key responsibilities & impact

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 data movement, storage, and processing 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 SQL Server high-availability and disaster-recovery 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
Implement automated data validation, error handling, alerting, and performance monitoring across SQL Server and Microsoft Fabric environments
Work closely with business applications, Infrastructure, and Security teams
Report to the Data Architect

Requirements

What you’ll need

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 focused on security and compliance
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 or comparable data integration platforms
Hands-on experience developing Lakehouse and Data Warehouse solutions within Microsoft Fabric
Advanced proficiency in 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
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)
Willingness to be available outside standard business hours to troubleshoot and resolve critical technical issues as needed

Benefits

Comp & perks

A full range of medical, financial and/or other benefits dependent on the position
Hybrid workplace: work remotely two days per week
On-call support outside standard business hours as needed