Sr. Business Intelligence Engineer; SQL, Finance & HR Reporting
Listed on 2026-10-18
-
IT/Tech
Data Analyst
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
- 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
- Law firm or professional services experience
- Elite 3E or Workday data experience
- Crystal Reports, SSIS, or Databricks exposure
- SQL performance tuning (reading execution plans)
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.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).