Sidley Austin LLP
Sidley Austin LLPVerified Source

Senior Business Intelligence Engineer

98K–145K
Onsite · Chicago, Illinois
Posted August 12, 2026
payroll

Overview

Lead recurring reporting and data processes for administrative functions. Own processes with hard monthly and annual deadlines. Ensure data accuracy and produce firm leadership reporting. Strong SQL analysis is the single most important qualification.

What You'll Do11

  • 1Own recurring operational reporting and data processes across firm financial and HR data domains from daily validation through month-end and year-end close
  • 2Read, analyze, and understand complex SQL views stored procedures to explain how reported numbers are produced and diagnose discrepancies
  • 3Monitor daily data validation reporting and investigate conflicts such as HR records from upstream system changes applying corrections before month-end close
  • 4Execute month-end and year-end close activities including reconciliations and year-end reporting deliverables
  • 5Prepare and distribute highly confidential deliverables with complete accuracy and discretion
  • 6Develop and maintain reports in Power BI and Cognos while supporting legacy Crystal reports
  • 7Work with product management team to translate HRIS changes into data and report updates
  • 8Trace data issues back to source systems and coordinate corrections with data engineering and system owners
  • 9Maintain clear documentation and step-by-step procedures for all recurring processes
  • 10Contribute subject-matter knowledge to report modernization efforts and validate converted outputs
  • 11Respond to ad hoc analysis requests with fast accurate turnaround

Requirements11

  • 1Bachelor's degree in Data Analytics Information Systems Computer Science Accounting Finance or related field
  • 2Minimum 5 years experience as data analyst reporting analyst or similar role owning recurring operational data processes
  • 3Expert-level SQL analysis ability to read and unravel complex multi-table logic nested views and stored procedures
  • 4Proven experience running recurring financial or operational close cycles against hard deadlines
  • 5Exceptional attention to detail with track record in data validation reconciliation and correction
  • 6Proven ability to handle highly sensitive financial and personnel data with discretion
  • 7Report development experience with Power BI Tableau or Cognos
  • 8Excellent communication skills comfortable working with product managers business analysts and senior administrative stakeholders
  • 9Ability to own long-running processes independently with minimal supervision
  • 10Strong diagnostic ability to trace incorrect numbers through interconnected systems
  • 11Habit of documenting processes decisions and fixes in writing

Salary Insight

$98 - $145k per year

Location

Typeonsite
LocationChicago, Illinois

Required Skills

sqlpower bitableaucognosaws
Share:

Similar open positions

Explore active roles that match your skills and interests.

Robert Half

Robert Half

10h agoMinneapolis, Minnesotapayroll

Senior Business Analyst, Power BI

Transform complex data into meaningful reporting and business insights using Power BI and Microsoft data environment. Lead stakeholders across technical and business teams to deliver scalable analytics solutions.

130K–150K
power bisqletl pipelines+2 more

Sigma Systems, Inc.

13h agoDallas, Texaspayroll

Senior Business Intelligence Developer, ETL & Power BI

Own the design and delivery of BI solutions that drive decisions across the enterprise. You will lead complex projects from data modeling to dashboard deployment, working with SQL, Power BI, and OBIEE in an Azure environment. Your team includes junior developers you will mentor daily, plus cross-functional business partners. This role demands deep technical skill in ETL and a proven track record of turning raw data into actionable insights.

Competitive salary
ETL design and developmentSQLPL/SQL+7 more
1805 KBR Wyle Services, LLC

1805 KBR Wyle Services, LLC

18h agoWashington, District of Columbiapayroll

Senior Power BI Developer

Senior Power BI Developer leads design development administration governance and support of enterprise business intelligence solutions. This role drives innovation through collaboration with stakeholders and partners delivering mission critical capabilities.

Competitive salary
power bissasssrs+2 more
SoftPath Technologies LLC

SoftPath Technologies LLC

19h agoPhiladelphia, Pennsylvaniapayroll

Senior Power BI Developer with Tableau Experience

You will own reporting and dashboard development for operational and executive audiences across the enterprise. You will build with Power BI and Tableau, writing and tuning complex SQL against large datasets. You will work with a data team that supports multiple business units, integrating diverse data sources. This role stands out because it requires deep expertise in both platforms and a track record of performance optimization.

Competitive salary
Power BITableauSQL

Child Care Group

13h agoDallas, Texaspayroll

Senior BI Developer & Data Analyst

Lead business intelligence initiatives at ChildCareGroup to transform data into strategic insights. Own reporting and analytics solutions while collaborating with cross-functional teams to drive data-informed decisions.

Competitive salary
Microsoft Power BIMicrosoft FabricSQL+8 more

Apex Systems

18h agoWashington, District of Columbiapayroll

Senior Business Intelligence Analyst Apex Systems

Lead digital BI initiatives measuring digital enhancements supporting mobile online and employee-facing products. Provide quantitative and qualitative insights to drive business decisions. Own end-to-end analytics solutions across hybrid locations.

114K–146K
Data AnalysisReportingBusiness Intelligence+1 more