Sr. Business Intelligence Engineer (SQL, Finance & HR Reporting)

Location: Downtown Chicago, hybrid (minimum 3 days onsite)

Compensation: $100K-$145K

Type: Full-time, permanent (direct hire)

Schedule: Monday to Friday, with occasional extra hours during heavy periods like month-end and year-end close

We're hiring a hands-on Senior Business Intelligence Engineer for an established international law firm. You'll own the recurring finance and HR reporting that firm leadership relies on. You'll work inside a large legacy SQL Server environment, tracing why a number is wrong and fixing it at the root. This is a SQL-first individual contributor role.

What You'll Do

Own recurring finance and HR reporting processes, from daily data validation through month-end and year-end close

Read and unravel complex existing SQL (nested views, stored procedures, multi-table logic) to explain how reported numbers are produced

Trace discrepancies back to source systems, find the root cause, and make targeted, safe corrections

Run close activities, including reconciliations and confidential deliverables for firm leadership

Build and maintain reports in Power BI and Cognos, and support the remaining legacy Crystal reports

Partner with product managers, business analysts, and data engineering on system changes and report modernization

Document recurring processes so anyone on the team can run them

What You Need

5+ years as a data analyst, reporting analyst, or in a similar role owning recurring operational data processes

Expert-level SQL Server skills: reading, troubleshooting, and safely modifying SQL you didn't write

Experience running month-end or year-end close cycles against hard deadlines

Report development in at least one enterprise BI platform (Power BI, Tableau, or Cognos)

Exceptional attention to detail and discretion with sensitive financial and personnel data

Bachelor's degree in Data Analytics, Information Systems, Computer Science, Accounting, Finance, or a related field

Nice to Have

Law firm or professional services experience

Elite 3E or Workday data experience

Crystal Reports, SSIS, or Databricks exposure

SQL performance tuning (reading execution plans)

Not a Fit If

Your SQL experience is mostly SELECT queries against clean tables, or your background is primarily dashboard and visualization work. The interview process includes a live, hands-on technical panel.

Why This Role

Close-knit, collaborative team that genuinely supports one another

Modern stack including Databricks, on a growing Data & AI team

Clear growth path with two structured career tracks

Work Authorization: Must be authorized to work in the US without sponsorship, now or in the future.

Seniority level: Mid-Senior level

Employment type: Full-time

Industries: Law Practice and Professional Services