Enterprise Data Engineer

Jenner & Block; Chicago (IL); On-site; USD 130,000 - 180,000; Full time

Benefits offered by this job

Health benefits

401k profit sharing

Competitive compensation

Job summary

Jenner & Block LLP is seeking an experienced Enterprise Data Engineer to design, build, and maintain data pipelines and the firm-wide Enterprise Data Repository (EDR). The role emphasizes working within the Microsoft Fabric ecosystem, collaborating with IT leadership and governance stakeholders to deliver reliable, scalable data solutions for firm-wide reporting and analytics.

You will design pipelines from Elite 3E Cloud, Chrome River, Intapp, SharePoint, and other sources, while ensuring data

Qualifications

• Bachelor's degree or equivalent professional experience in a related field.
• 5+ years of professional data engineering or data architecture experience.
• Strong SQL proficiency and ETL/ELT design skills.
• Experience with Microsoft Fabric in a production environment is required.

Responsibilities

• Design, build, and maintain end-to-end data pipelines across multiple source systems.
• Develop and manage batch and incremental ingestion workflows using Microsoft Fabric Data Factory pipelines.
• Monitor performance, optimize throughput and resource utilization, and establish data contracts with owners and vendors.
• Collaborate on the Enterprise Data Repository architecture and governance to enable firm-wide reporting and analytics.
• Ensure data modeling standards and metadata documentation are maintained across the data ecosystem.

Skills

SQL

Python

PySpark

C#

Power BI

Data Modeling

ETL/ELT

Git/Azure DevOps

Education

Bachelor's degree in Computer Science / Information Systems / Data Engineering

5+ years data engineering / data architecture

Tools

Microsoft Fabric

Azure Data Factory

SQL Server

Purview

OneLake

Job description

Position Summary

Jenner & Block is seeking an experienced Enterprise Data Engineer to join our Information Technology team. In this role, you will design, build, and maintain the data pipelines and infrastructure that power firm-wide reporting and analytics. Working primarily within the Microsoft Fabric ecosystem, you will serve as a key contributor to the architecture and evolution of the firm's Enterprise Data Repository, partnering closely with data engineers, IT leadership, and governance stakeholders to deliver reliable, scalable data solutions across the firm.

Essential Job Functions

• Design, build, and maintain end-to-end data pipelines that ingest structured and semi-structured data from source systems including Elite 3E Cloud, Chrome River, Intapp suite, SharePoint, and other firm applications
• Develop and manage batch and incremental data ingestion workflows using Microsoft Fabric Data Factory pipelines and related orchestration tools; implement robust error handling, retry logic, alerting, and logging frameworks across all pipeline components
• Monitor pipeline performance, identify bottlenecks, and optimize throughput, latency, and resource utilization; collaborate with application owners and vendors to define and maintain data contracts, API integrations, and file-based data feeds
• Collaborate with peer data engineers on the architecture, design, and evolution of the firm's Enterprise Data Repository “EDR”, serving as the authoritative data store for firm-wide reporting and analytics.
• Develop and enforce data modeling standards including dimensional modeling, star schema design, and normalized transactional schemas as appropriate to use case; manage EDR schema lifecycle including versioning, migration scripts, and backward compatibility considerations
• Partner with the Database Administrator and Data Engineers to optimize query performance, indexing strategies, and resource governance within the EDR environment; maintain comprehensive data dictionaries and metadata documentation to support data literacy across the organization
• Serve as a Microsoft Fabric platform engineer, assisting with workspace configuration, capacity management, and governance settings
• Build and manage Lakehouses, Warehouses, Dataflows Gen2, and Notebooks within Microsoft Fabric to support unified analytics and BI workloads; implement OneLake architecture patterns to support hybrid cloud-to-on-premises integration scenarios
• Manage integration between Microsoft Fabric and Power BI semantic layers, enabling self-service analytics capabilities across the firm; stay current with Microsoft Fabric release cadence and evaluate new features for adoption that advance firm data strategies
• Collaborate with the Data Governance team to establish and enforce data quality rules, validation frameworks, and automated anomaly detection within the data pipeline ecosystem
• Implement and maintain data lineage tracking tools (e.g., Purview or equivalent) and support data privacy and security controls including column-level and row-level security, data masking, and access auditing
• Partner with IT Managers, peer Software / Data Engineers and the Database Administrator to align data infrastructure with broader application and reporting goals; participate in the team's change process, contributing technical proposals and peer reviews
• Create and maintain thorough technical documentation including architecture diagrams, pipeline runbooks, data flow maps, and operational procedures; provide technical guidance and knowledge transfer to team members, and communicate project status, risks, and outcomes clearly to IT leadership and stakeholders

Qualifications and Requirements

• Bachelor's degree in Computer Science, Information Systems, Data Engineering, or a related discipline; or equivalent professional experience; minimum 5 years of professional experience in a data engineering, data architecture, or closely related role
• Demonstrable hands‑on experience with Microsoft Fabric in a production environment; experience designing and maintaining enterprise‑grade data pipelines with clearly defined SLAs, monitoring, and operational runbooks
• Strong proficiency in SQL for complex querying, ETL/ELT development, and performance tuning across relational database platforms including Microsoft SQL Server; proficiency in Python or similar scripting languages for data transformation, automation, and tooling
• Solid understanding of data modeling concepts including dimensional modeling, normalization, and schema design for analytics workloads; experience with data quality frameworks, lineage tools, and metadata management practices
• Microsoft Fabric (Lakehouse, Warehouse, Data Factory, Dataflows Gen2, Notebooks, OneLake, Real‑Time Intelligence); Azure (Data Factory, Blob Storage, Data Lake Storage, Key Vault); Microsoft SQL Server (on‑premises and cloud)
• T‑SQL (advanced), Python (intermediate to advanced), PySpark (working knowledge), C# (intermediate); Microsoft Purview familiarity preferred
• Git/Azure DevOps, documentation standards, change management workflows; Power BI semantic model integration and dataset management

Preferred Qualifications

• Experience in a legal, professional services, or highly regulated industry environment; familiarity with legal technology platforms such as Elite 3E, Chrome River, or the Intapp suite; Microsoft certifications such as DP‑700 or DP‑203 preferred
• Working knowledge of the Microsoft Power Platform (Power BI, Power Apps, Power Automate) and SharePoint integration patterns; experience with .NET development, hybrid on‑premises and cloud data architectures, and familiarity with ISO 27001 controls or similar security and compliance frameworks

Disclaimer

This job description is intended to provide a general overview of the primary duties and responsibilities for the position. It is not an exhaustive list of all tasks or responsibilities that may be assigned. The role may include additional duties, specialized projects, and other tasks as required. The firm reserves the right to modify or adjust the responsibilities to meet business needs.

Physical Requirements

Candidates must be able to meet the physical demands of the position, including the ability to commute to the office as required on designated in‑office days based on the position. The firm is committed to providing reasonable accommodations in accordance with the Americans with Disabilities Act (ADA) for qualified individuals with disabilities.

EEO Statement

Jenner & Block LLP is an equal opportunity employer. Recruitment and employment decisions are not made on the basis of an individual’s race, color, creed, religion, national origin, ancestry, citizenship status, age, non‑disqualifying physical or mental disability or medical condition, genetic information, sexual orientation, sex, gender identity and/or expression, pregnancy, childbirth, breastfeeding or related medical conditions, arrest record, matriculation, personal appearance, political affiliation, marital, parental, veteran, military, or order of protection status, or any other protected status or that of their relatives, friends, or associates.

Jenner & Block is proud to offer a competitive total rewards package, including comprehensive health & well‑being benefits and 401k profit sharing. The anticipated pay range for this role is $130,000 to $180,000 in Chicago. The actual offered rate for this position will be determined based on several factors, including qualifications and experience, geographic location, education, external market data, and consideration of internal equity.