← Back to jobsJob ID col-cmvgy9r2w0076s3ct95kqmm1f

Lowenstein Sandler LLPPosted 30+ days ago

Data Engineer

Full-time
Hybrid
3+ years
$125K – $140K/yr
Posted 30+ days ago

Responsibilities Design, build, test, and maintain ETL/ELT pipelines that ingest data from the firm's enterprise systems into the Microsoft Fabric Data Lakehouse, using Data Factory pipelines, and Spark notebooks Implement and maintain the bronze, silver, and gold layers of the firm's medallion architecture, covering raw ingestion, cleansing and conformance, and curated analytics-ready models Partner with the Data Ar

Posted
30+ Days Ago
Source
jobs.jobvite.com
Sector
Information Technology & AI

Opens the employer's application page in a new tab

Responsibilities

  • Design, build, test, and maintain ETL/ELT pipelines that ingest data from the firm's enterprise systems into the Microsoft Fabric Data Lakehouse, using Data Factory pipelines, and Spark notebooks
  • Implement and maintain the bronze, silver, and gold layers of the firm's medallion architecture, covering raw ingestion, cleansing and conformance, and curated analytics-ready models
  • Partner with the Data Architect to translate logical data models into physical implementations, including star schemas, slowly changing dimensions, and Power BI semantic models in the gold layer
  • Build and maintain source-system integrations across Aderant Expert, Intapp, iManage, InterAction, Dayforce, SharePoint Online, and third-party APIs, applying incremental load and change data capture patterns and normalizing key entities to the SALI/LMSS taxonomy
  • Develop transformation logic in T-SQL, Spark SQL, and PySpark, with built-in data quality validation, reconciliation to source, exception handling, and alerting
  • Diagnose and trace data discrepancies end-to-end — from source system through bronze, silver, and gold layers to the final DAX measure or report — identifying and resolving root causes
  • Monitor, tune, and optimize pipeline performance, refresh windows, and Fabric capacity consumption to control cost and meet business service levels
  • Implement data governance and security controls with the Data Architect and Information Security, including workspace permissions, row-level security, sensitivity labeling, and law firm confidentiality and ethical wall requirements
  • Partner with Finance, Marketing, Human Resources, practice groups, and IT stakeholders to gather requirements, and support business intelligence developers and self-service users with reliable, well-modeled, documented datasets
  • Manage data artifacts through source control and deployment pipelines, using Fabric Git integration and Azure DevOps to promote changes across development, test, and production workspaces
  • Leverage Claude Code and other AI-powered development tools to accelerate pipeline development, testing, and documentation, and build the curated datasets that power the firm's AI and agentic applications
  • Maintain data dictionaries, lineage, and operational runbooks, and provide production support and escalation-level troubleshooting for failed or degraded data loads

Qualifications

  • 3-5+ years of hands-on ETL/ELT or data engineering experience building and supporting production data pipelines
  • Microsoft Fabric experience is preferred but not required; equivalent experience with Azure Data Factory, Synapse Analytics, Databricks, SSIS, dbt, or other modern ETL frameworks will be considered
  • Working knowledge of medallion architecture (bronze/silver/gold), lakehouse and data warehouse concepts, and dimensional modeling
  • Strong T-SQL skills, with proven hands-on experience in MS SQL Server including query optimization and performance tuning
  • Proficiency in Python and PySpark, or a demonstrated ability to ramp up quickly on Spark-based transformation
  • Experience with incremental load, change data capture, and slowly changing dimension patterns
  • Experience ingesting data from REST APIs, JSON and XML payloads, flat files, SFTP sources, and direct database connections
  • Rigorous approach to data quality, including validation, reconciliation, and alerting
  • Familiarity with source control (Git) and CI/CD practices for data artifacts
  • Experience building, maintaining, and supporting analytics models for reporting
  • Ability to deliver high-quality work quickly in a fast-paced, deadline-driven environment, with a track record of managing competing priorities effectively
  • Willingness to adopt AI-assisted development tooling as part of a regular engineering workflow
  • Bachelor's degree in Computer Science, Information Systems, Data Analytics, or a related field, or equivalent practical experience of 5+ years in data engineering
  • Data Platform: Microsoft Fabric (Lakehouse, Warehouse, OneLake, Data Factory pipelines, Dataflows Gen2, Notebooks, Direct Lake), Azure Data Factory, Synapse, Databricks
  • Languages: T-SQL, Python, PySpark, Spark SQL
  • Architecture: medallion architecture, dimensional modeling and star schemas, slowly changing dimensions, Delta Lake and Parquet formats, partitioning
  • Integration: REST APIs, JSON, XML, flat file and SFTP ingestion, ODBC/JDBC, OAuth 2.0, change data capture
  • BI and Semantic Layer: Power BI, semantic models, DAX, row-level security
  • Cloud and Security: Microsoft Azure, Entra ID, Key Vault, Microsoft Purview, data sensitivity labeling and classification
  • Tools and DevOps: Git, Fabric Git integration and deployment pipelines, Azure DevOps, VS Code, SQL Server Management Studio
  • Strong analytical and problem-solving skills with excellent attention to detail
  • Exceptional communication skills, with the ability to translate technical concepts for non-technical stakeholders
  • Proven ability to work both independently and collaboratively in a team-oriented environment
  • A continuous learner who actively tracks and experiments with emerging tools, especially in the data and AI space

Preferred

  • Power BI development experience a plus, including semantic models, DAX, and report delivery
  • KQL a plus
  • AI Development: Claude Code, GitHub Copilot, or equivalent AI-assisted tooling a plus
  • Legal data standards: SALI/LMSS taxonomy experience a plus
  • Law firm data experience (Aderant, Intapp, iManage, InterAction, Dayforce) a plus

Required skills

Azure Data FactoryCI/CDChange Data CaptureData QualityDimensional ModelingETL/ELT Data PipelinesGitMedallion ArchitectureMicrosoft FabricMicrosoft SQL ServerPower BIPySparkPythonREST APIs

Nice to have

KQL a plus

Full job description

Responsibilities

  • Design, build, test, and maintain ETL/ELT pipelines that ingest data from the firm's enterprise systems into the Microsoft Fabric Data Lakehouse, using Data Factory pipelines, and Spark notebooks
  • Implement and maintain the bronze, silver, and gold layers of the firm's medallion architecture, covering raw ingestion, cleansing and conformance, and curated analytics-ready models
  • Partner with the Data Architect to translate logical data models into physical implementations, including star schemas, slowly changing dimensions, and Power BI semantic models in the gold layer
  • Build and maintain source-system integrations across Aderant Expert, Intapp, iManage, InterAction, Dayforce, SharePoint Online, and third-party APIs, applying incremental load and change data capture patterns and normalizing key entities to the SALI/LMSS taxonomy
  • Develop transformation logic in T-SQL, Spark SQL, and PySpark, with built-in data quality validation, reconciliation to source, exception handling, and alerting
  • Diagnose and trace data discrepancies end-to-end — from source system through bronze, silver, and gold layers to the final DAX measure or report — identifying and resolving root causes
  • Monitor, tune, and optimize pipeline performance, refresh windows, and Fabric capacity consumption to control cost and meet business service levels
  • Implement data governance and security controls with the Data Architect and Information Security, including workspace permissions, row-level security, sensitivity labeling, and law firm confidentiality and ethical wall requirements
  • Partner with Finance, Marketing, Human Resources, practice groups, and IT stakeholders to gather requirements, and support business intelligence developers and self-service users with reliable, well-modeled, documented datasets
  • Manage data artifacts through source control and deployment pipelines, using Fabric Git integration and Azure DevOps to promote changes across development, test, and production workspaces
  • Leverage Claude Code and other AI-powered development tools to accelerate pipeline development, testing, and documentation, and build the curated datasets that power the firm's AI and agentic applications
  • Maintain data dictionaries, lineage, and operational runbooks, and provide production support and escalation-level troubleshooting for failed or degraded data loads

Preferred

  • Power BI development experience a plus, including semantic models, DAX, and report delivery
  • KQL a plus
  • AI Development: Claude Code, GitHub Copilot, or equivalent AI-assisted tooling a plus
  • Legal data standards: SALI/LMSS taxonomy experience a plus
  • Law firm data experience (Aderant, Intapp, iManage, InterAction, Dayforce) a plus

Benefits

  • Coverage options for medical, dental, vision, prescription drug, life insurance, disability, FSAs, 401K, and paid time off

Qualifications

  • 3-5+ years of hands-on ETL/ELT or data engineering experience building and supporting production data pipelines
  • Microsoft Fabric experience is preferred but not required; equivalent experience with Azure Data Factory, Synapse Analytics, Databricks, SSIS, dbt, or other modern ETL frameworks will be considered
  • Working knowledge of medallion architecture (bronze/silver/gold), lakehouse and data warehouse concepts, and dimensional modeling
  • Strong T-SQL skills, with proven hands-on experience in MS SQL Server including query optimization and performance tuning
  • Proficiency in Python and PySpark, or a demonstrated ability to ramp up quickly on Spark-based transformation
  • Experience with incremental load, change data capture, and slowly changing dimension patterns
  • Experience ingesting data from REST APIs, JSON and XML payloads, flat files, SFTP sources, and direct database connections
  • Rigorous approach to data quality, including validation, reconciliation, and alerting
  • Familiarity with source control (Git) and CI/CD practices for data artifacts
  • Experience building, maintaining, and supporting analytics models for reporting
  • Ability to deliver high-quality work quickly in a fast-paced, deadline-driven environment, with a track record of managing competing priorities effectively
  • Willingness to adopt AI-assisted development tooling as part of a regular engineering workflow
  • Bachelor's degree in Computer Science, Information Systems, Data Analytics, or a related field, or equivalent practical experience of 5+ years in data engineering
  • Data Platform: Microsoft Fabric (Lakehouse, Warehouse, OneLake, Data Factory pipelines, Dataflows Gen2, Notebooks, Direct Lake), Azure Data Factory, Synapse, Databricks
  • Languages: T-SQL, Python, PySpark, Spark SQL
  • Architecture: medallion architecture, dimensional modeling and star schemas, slowly changing dimensions, Delta Lake and Parquet formats, partitioning
  • Integration: REST APIs, JSON, XML, flat file and SFTP ingestion, ODBC/JDBC, OAuth 2.0, change data capture
  • BI and Semantic Layer: Power BI, semantic models, DAX, row-level security
  • Cloud and Security: Microsoft Azure, Entra ID, Key Vault, Microsoft Purview, data sensitivity labeling and classification
  • Tools and DevOps: Git, Fabric Git integration and deployment pipelines, Azure DevOps, VS Code, SQL Server Management Studio
  • Strong analytical and problem-solving skills with excellent attention to detail
  • Exceptional communication skills, with the ability to translate technical concepts for non-technical stakeholders
  • Proven ability to work both independently and collaboratively in a team-oriented environment
  • A continuous learner who actively tracks and experiments with emerging tools, especially in the data and AI space
  • Power BI development experience a plus, including semantic models, DAX, and report delivery
  • KQL a plus
  • AI Development: Claude Code, GitHub Copilot, or equivalent AI-assisted tooling a plus
  • Legal data standards: SALI/LMSS taxonomy experience a plus
  • Law firm data experience (Aderant, Intapp, iManage, InterAction, Dayforce) a plus
  • 3-5+ years of hands-on ETL/ELT or data engineering experience building and supporting production data pipelines.
  • Bachelor's degree in Computer Science, Information Systems, Data Analytics, or a related field, or equivalent practical experience of 5+ years in data engineering.

Required skills

  • Azure Data Factory, CI/CD, Change Data Capture, Data Quality, Dimensional Modeling, ETL/ELT Data Pipelines, Git, Medallion Architecture, Microsoft Fabric, Microsoft SQL Server, Power BI, PySpark, Python, REST APIs, Spark SQL, T-SQL

Preferred skills

  • KQL a plus, Legal data standards: SALI/LMSS taxonomy experience a plus

Experience

  • 3+ years

Company

  • Lowenstein Sandler LLP is a national law firm with over 400 lawyers based in New York, Palo Alto, Roseland, Salt Lake City, San Francisco, Washington, D.C., and Wilmington.
  • New York, New York, USA
  • http://www.lowenstein.com/

Job details

Employment type

Full-time

Seniority level

3+ years

Date posted

Oct 16, 2026

Work mode

Hybrid

Job source

jobs.jobvite.com

Company

Lowenstein Sandler LLP

Information Technology & AI

Lowenstein Sandler LLP is a national law firm with over 400 lawyers based in New York, Palo Alto, Roseland, Salt Lake City, San Francisco, Washington, D.C., and Wilmington.

Similar jobs

Matched on role, skills and location · live jobs only

See more Data Engineer jobs in Roseland

Axtria - Ingenious Insights

Today

New

Data Engineer II – Databricks

Full-timeOn-siteChapel Hill, NCCompetitive

Axtria is seeking a Data Engineer II to build and optimize scalable data pipelines for pharmaceutical marketing and customer engagement initiatives.

Why similarSame roleDimensional ModelingPySpark

Woven by Toyota

Today

New

Software Engineer II, Data Labeling

Full-timeHybridAnn Arbor, MICompetitive

Woven by Toyota is enabling Toyota’s transformation into a mobility company through autonomous driving, software-defined vehicles, mobility infrastructure, and cloud and AI technologies.

Why similarSame roleGitPython

Flow Traders

Today

New

Core Data Engineer

Full-timeOn-siteNew York, NY$165K – $210K/yr

Flow Traders is hiring a Core Data Engineer to own the lifecycle and quality of foundational data products, including market, trading, and reference data.

Why similarSame roleData QualityPython

Get new Data Engineer jobs in Roseland by email

Create job alert

Data Engineer

Lowenstein Sandler LLP · $125K – $140K/yr

Apply on company site