Location: Downtown Chicago, hybrid (minimum 3 days onsite)
Compensation: $100K-$145KType: 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 exposureSQL performance tuning (reading execution plans)
Not a Fit IfYour 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 RoleClose-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.
