Sr Business and Reporting Analyst in Oak Brook, IL

  • Title: Sr Business and Reporting Analyst
  • Code: RCI-90773-1
  • RequirementID: 105337
  • Location: Oak Brook, IL 60523
  • Posted Date: 01/25/2023
  • Duration: 12 Months
  • Salary ($): 93.57 - 99.54 per Hourly
Talk to our Recruiter

  Job Description

Standard hybrid schedule: 2 weeks in office Mon-Tues, 3 days remote Wed-Fri

Business Support

  • Budgeting excel template maintenance that utilizes linking multiple excel files via sumif, vlookup, named ranges, absolute and relative references, linked tables to powerpoint.
  • Update the budget excel consolidator across multiple excel files utilizing lookups and sumifs
  • Following job aids accurately to run various business reporting on a daily, weekly, and monthly schedule

Real Time Systems support

  • Live database maintenance utilized for investment and budget reporting. Database is currently sourced in sharepoint list data sets and
  • Maintaining and updating links between sharepoint list and excel sources
  • Clean up of departmental sharepoint site

Reporting support

  • Power BI report and dashboard development
  • Updating sources of existing power bi reports

Top skills include:

  • Excel Expert – advanced skill sets. Pivots, lookups, large data sets, linked excel files, absolute and relative references, offset equations, sumif, sumproduct,
  • Microsoft Power BI and Power Apps – advanced skill set with experience creating reports and dashboarding.
  • DAX language with Power BI
  • Years of experience at least 7+

Other skills include:

  • Analysis, presentation skills, large data set experience, Finance/Accounting experience, Powerpoint and presentation experience


  • Bachelors+

Desired & aligned experience:

  • Financial and Business Analyst background is required.
  • Excel Proficiency is required
  • Power BI experience is required

About Rangam:

Rangam Consultants is a minority, women-owned, disability workforce solutions global organization. Specialized in attracting and retaining talents globally for a rewarding career in IT, Engineering, Scientific, Clinical, Healthcare, Administrative, Finance, Business Management, and many more, while integrating veterans and individuals with disabilities into the workforce. Indeed, we connect career aspirants to relevant job opportunities, be it jobs in USA, UK, India, or Ireland. Also remote jobs, work-from-home jobs, or contract jobs in different verticals and industries.
Rangam strives to put job seekers first, giving them free access to search for jobs, post resumes, and research companies.Every day, we connect millions of people to new opportunities.