Senior Business Intelligence Analyst

  • Location
    Chicago, Illinois
  • Category:
    IT - IT
  • Job Type:
    Direct Hire
  • Job reference:

Job Summary:

This role will be instrumental in identifying and visualizing business trends and insights for the Commercial and Marketing teams. Additional responsibilities include: developing reports/queries, creating scorecards, performing statistical analysis, forecasting demand, and refining key performance indicators.


  • Develop and maintain SQL generating datasets to meet customer demand.
  • Utilize statistical data analysis tools (e.g. deviation, slope, capability, correlation) and translate data, trends, opportunities and other information into insights.
  • Manipulate data in BI software (e.g. Power BI) and Excel to create and share internally.
  • Maintain existing reports and data processes in SSIS / SSRS.
  • Perform data validation, root cause analysis, and ETL activities to ensure data accuracy.
  • Research, analyze and resolve issues surrounding data. Work with functional teams to resolve data discrepancies.
  • Reports gap analysis, verifies data validation & analysis, capable to be conversant with data warehousing.
  • Render KPIs through role specific dashboards and seamlessly integrate the data from multiple sources.
  • Create and evolve performance management tools and processes.
  • Develop user scorecards and metrics to provide high level visibility into performance and Commercial compliance to processes & SLAs 2.3 Develop user scorecards and metrics to provide high level visibility into performance and Commercial compliance to processes & SLAs.
  • Gather, analyze, document and validate the needs of stakeholders in accordance with PMO guidelines.
  • Interpret and translate needs of Commercial team for improved deliverables.
  • Manage departmental projects & programs as well as Commercial BI data, reporting or querying requests.
  • Coordinate and drive performance of project teams and develop and drive implementation of project plans within budgets and timelines.
  • Ensures the integrity of project data, including data extraction, storage, manipulation, processing and analysis.
  • Develop strong working relationships with Commercial leadership, cross-functional stakeholders, end users, Innovation & Technology team, and other analysts in the organization.



  • 3+ years of experience writing your own SQL and using SQL on the job.
  • 3+ years of experience providing reporting and datasets to internal / external customers.
  • 1+ year of experience working on a team using agile methods.
  • Experience with data models, keys, concatenations, lookups, joins, deduplications, transpositions, ranges, indexes, and other data presentation and manipulations.
  • Experience with database design, query language, and report writing.
  • Demonstrated experience with Business Intelligence software (Power BI, Sisense, Qlik, Tableau).
  • Knowledge and proven working experience of data management and data warehousing principles.
  • Experience building dashboards and automating manual processes.
  • Experience with statistical analysis tools as well as skills or ability to learn advanced analytics software (e.g. R, Knime, PowerBI, SAS).
  • Knowledge of lean, 5-S, six-sigma and other continuous improvement methodologies.
  • Strong analytical, conceptual and problem-solving abilities required.
  • Strong written, presentation and oral communication skills.

    Unique Perks/Benefits:

  • Profit Sharing and 401K match in addition to an annual target bonus of 10 percent.
  • Excellent Health/Dental/Vision Benefits.
  • Generous PTO plan.
  • Tuition and training reimbursement. 
  • Flexible work from home program.
  • Summer hours.

  • Equal Opportunity Employer/Veterans/Disabled

    To read our Candidate Privacy Information Statement, which explains how we will use your information, please

    The Company will consider qualified applicants with arrest and conviction records