Skip to content
Search jobs inside your AI agent. Claude, ChatGPT, Claude Code, Codex, Gemini, Cursor and Grok
Connect

Saltu Staffing

NewBe an early applicant

Data Lake Engineer (Microsoft Fabric / Azure)

Posted

Description

About the Job:

A national law firm serving public companies, Fortune 500 businesses, and middle-market clients is hiring a Data Lake Engineer to build the data platform behind its new AI and Knowledge Management function. You'll work closely with firm leadership, Finance, Pricing, Business Development, and IT. This is a remote role for candidates based in Illinois.


Responsibilities:

  • Design and build a medallion lakehouse on Azure Data Lake Storage Gen2 and/or Microsoft Fabric OneLake
  • Develop batch and incremental pipelines from Aderant Expert, Intapp, InterAction, and Microsoft 365
  • Migrate existing SQL Server reporting databases and jobs onto the new platform
  • Set up data quality checks, change data capture, alerting, and error handling
  • Create conformed models for clients, matters, timekeepers, rates, invoices, and collections
  • Publish Power BI semantic models for finance, pricing, and profitability dashboards
  • Prepare structured and unstructured data for AI use cases such as Azure AI Search and Azure OpenAI
  • Enforce role-based access and ethical walls, and maintain governance with tools such as Microsoft Purview


Requirements:

  • Bachelor's degree in Computer Science, Information Systems, Engineering, or a related field, or equivalent experience (required)
  • 5+ years of data engineering experience, including 2+ years building a cloud data lake or lakehouse (required)
  • Hands-on experience with ADLS Gen2, Azure Data Factory and/or Synapse, and Microsoft Fabric (required)
  • Strong SQL Server skills, plus Python and PySpark/Spark SQL (required)
  • Experience with Delta Lake/Parquet, medallion architecture, and dimensional modeling (required)
  • Experience building Power BI semantic models and CI/CD for data pipelines (required)
  • Experience with confidential or regulated data and role-based security (required)
  • Law firm or professional services experience with Aderant, Intapp, or InterAction (preferred)
  • DP-700, DP-600, or DP-203 certification (preferred)


Top Skills:

  • Lakehouse Architecture
  • Data Pipeline Development
  • Data Modeling
  • Data Governance and Security
  • Explaining Data to Non-Technical Stakeholders


First-Year Goals:

  • 90 days: Map source systems and data owners, get the target architecture approved, and load Aderant financial data that reconciles to month-end reports
  • 6 months: Integrate Intapp and InterAction, move the client/matter/timekeeper model into production, and run core finance and pricing dashboards from the lakehouse
  • 12 months: Retire or migrate legacy reporting jobs, put governance in place, and launch the first AI or knowledge use case on platform data


Skills

Apply

See also