This site uses cookies. To find out more, see our Cookies Policy

Excel Tool Developer in Chicago, IL at CRS Group

Date Posted: 10/13/2018

Job Snapshot

  • Employee Type:
  • Location:
    Chicago, IL
  • Job Type:
  • Experience:
    2 to 5 years
  • Date Posted:

Job Description

Excel Tool Developer
Duration: 6-month contract
Location: Oak Brook, IL
Overview: The CRS Group is currently looking for a Excel Tool Developer for one of our clients in the Oak Brook area. The CRS Group is a nationwide Staffing Firm who works primarily with Fortune 500 and Fortune 1000 corporations.
Job Description:
  • Support the Finance team by rapidly developing business-specific reporting and tools
  • Partner with the business to make enhancements to existing tools and reports
  • Interact with the customers to understand business requirements
  • Candidate is expected to understand projects from both the business and technical perspectives
  • Should be able to work well independently to rapidly build reporting solutions for business customers
  • Also, be a go getter and exhibit strong communication skills

Duties and Responsibilities:
  • Rapid development of business-based tools and reports as requested by users
  • Develop new Excel-based reports using SQL and VBA automation
  • Develop and support limited number of MS Access-based tools
  • Write new SQL queries to gather/summarize data
  • Create SQLServer stored procedures to stage data for Excel tools
  • Modify existing Excel tools/reports
  • Other systems support and projects as needed
  • Ability to express ideas effectively, verbally and in writing

  • Bachelor's Degree in Computer Science, Accounting, or Finance required
  • 2-5 years of hands-on Excel and VBA experience
  • Experience working with business areas and other non-technical groups, translating requests into requirements
  • Strong analytical, problem solving, and organizational skills
  • Excellent communication skills
  • Strong analytical, problem solving, and organizational skills
  • Experience with Oracle BI tools/Hyperion a plus

A Typical Day:
  • Meet with business users to gather and understand user requirements, and translate into new tools/reports
  • Develop new Excel-based reports and tools based on user requests
  • Understand data sources and how to create calculations for new tools
  • Modify existing reports and tools as required by users
  • Write ad-hoc queries and reports as needed to support user departments
  • Utilize the functionality delivered with SQLServer, including stored procedures and job scheduling
  • Additional Skills: Excel, VBA, MS Access, SQLServer

Top Skills:
  • Individual that can deliver results quickly, and work effectively with business users
  • Excellent communication skills, both verbal and written
  • Ability to learn quickly
  • Strong analytical and problem-solving skills
  • Customer-focus

ss #82377
Qualified applicants will receive consideration for employment without regard to race, color, age, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, or genetic information.