About the role
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