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

Job Description

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

\n

Compensation: $100K-$145K

\n

Type: Full-time, permanent (direct hire)

\n

\n

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

\n

\n

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.

\n

\n

What You'll Do

\n

\n
• Own recurring finance and HR reporting processes, from daily data validation through month-end and year-end close
\n
• Read and unravel complex existing SQL (nested views, stored procedures, multi-table logic) to explain how reported numbers are produced
\n
• Trace discrepancies back to source systems, find the root cause, and make targeted, safe corrections
\n
• Run close activities, including reconciliations and confidential deliverables for firm leadership
\n
• Build and maintain reports in Power BI and Cognos, and support the remaining legacy Crystal reports
\n
• Partner with product managers, business analysts, and data engineering on system changes and report modernization
\n
• Document recurring processes so anyone on the team can run them
\n

\n

\n

What You Need

\n

\n
• 5+ years as a data analyst, reporting analyst, or in a similar role owning recurring operational data processes
\n
• Expert-level SQL Server skills: reading, troubleshooting, and safely modifying SQL you didn't write
\n
• Experience running month-end or year-end close cycles against hard deadlines
\n
• Report development in at least one enterprise BI platform (Power BI, Tableau, or Cognos)
\n
• Exceptional attention to detail and discretion with sensitive financial and personnel data
\n
• Bachelor's degree in Data Analytics, Information Systems, Computer Science, Accounting, Finance, or a related field
\n

\n

\n

Nice to Have

\n

\n
• Law firm or professional services experience
\n
• Elite 3E or Workday data experience
\n
• Crystal Reports, SSIS, or Databricks exposure
\n
• SQL performance tuning (reading execution plans)
\n

\n

\n

Not a Fit If

\n

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.

\n

\n

Why This Role

\n

\n
• Close-knit, collaborative team that genuinely supports one another
\n
• Modern stack including Databricks, on a growing Data & AI team
\n
• Clear growth path with two structured career tracks
\n

\n

\n

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