R042419: Senior Report Writer with Data Analysis Skills

Job Location:

St. Louis, MO

As a salaried fulltime employee of Ferguson Consulting, you will function as a contract IT resource in the role of Senior Data Analyst/Information Analyst at the enterprise level for our reinsurance client, a Fortune 100 company and leader in Business Intelligence and Big Data in Chesterfield, MO..

As a Ferguson Consulting employee, and a consultant to our end client, you are able to focus on your technical skills development and career versus becoming a client SME - which is always in your best interest.

Under limited supervision, you will develop, modify and support existing reports and create new reports for the Investment Division. In this role, you will be part of a cross-functional team that supports reporting, cubes, feeding to Tableau. The client has spent considerable resources to build a modern reporting platform. In this role, you will need a strong understanding of SQL to triage data to the source.

The system uses a cloud-based solution and manages the investments for the private debt equity team: it completes wires, does the accounting, and funding for our client. The ideal candidate will have accounting, investment or financial services experience. In this role, you will need strong Report writing, SQL & Excel skills for supporting existing reports and creating new reports.

What You'll Do:

  • Develops, validates, documents, and maintains business and functional requirements and conducts structured walkthroughs of requirements with business and IT technical team members
  • Transforms business requirements into SQL statements
  • Develop, modify and support existing reports to meet business needs
  • Create new reports
  • Analyzes source system data in support of improving data quality
  • Works with the business to identify data issues and identify potential solutions
  • Proactively works to identify ways to improve data quality through business rules automation
  • Assists in evaluation of business requests to determine feasibility; researches and identifies options
  • Responds to questions from business and IT technical teams
  • Assists in evaluation of and tracking of new or enhanced solutions to determine potential issues, communicates how problems may affect business and recommends solutions
  • Assists in performing task automation and implements process improvements; recommends enhancements that result in increased quality and service
  • Respond to escalated calls from users and the help desk

Who You Are:

  • 3-5 years IT-related experience, such as Business Analysis, Data Analysis, etc.
  • Advanced SQL skills, Excel skills
  • Ability to be flexible when needed, take initiative, and demonstrate accountability
  • Strong interpersonal skills
  • Ability to quickly adapt to new methods, work under tight deadlines
  • Strong investigative, analytical and problem-solving skills
  • Good data analysis skills
  • Ability to set goals and handle multiple tasks, clients, and projects simultaneously
  • Ability to appropriately balance priorities, deadlines, and deliverables
  • Ability to work well within a team environment and participate in department/team projects
  • Ability to balance detail with departmental goals/objectives
  • Ability to foster customer service as needed
  • Ability to translate business needs and problems into viable/accepted solutions
  • Bachelor’s degree or equivalent experience


    • 8+ years IT-related experience, such as Business Analysis, Data Analysis, Report Writing etc.
    • 2+ years Financial or Investment industry knowledge
    • LOMA Certification
    • Financial or Investment knowledge

The benefits:

We hire IT professionals who like to work with smart people and can hold their own in a demanding environment. Our employees build a career at Ferguson. Here IT isn’t a support function for our business – it IS our business. We strive to develop a professional relationship with each employee – and that is what you are, our direct employee. Our pay and benefit levels recognize the advanced skills of our talented staff members. In addition, we are unique in our market in the emphasis that we place on continuing education, including an annual training allowance that is an integral part of our compensation package. This kind of investment in our employees’ professional development is an important contributor to making Ferguson a desirable place to build an IT career. As a W-2 employee, your first assignment will be just that – the first of many. Our goal is to establish a long-term employee relationship with you.

The compensation:

Highly competitive base salary.

Paid overtime

$.60/$1 401K match

160 hours of Paid Time Off (PTO) Benefits

Bonus System

Health, vision, dental, and life insurance

Short-term and long-term disability

Training allowance for Leading Industry Professional Training with SLU/Wash U.

How to Apply:

If you are looking for a change and/or are interested in building or continuing your career as an IT professional and have the ability to thrive in challenging, fast-paced environments, we want to hear from you.

Please send your resume to Katie McElhone at kmcelhone@fergcons.com

Please review our website fergusonconsultinginc.com and find out more about who we are and what we can do for you.


Katie McElhone
Ferguson Consulting
1350 Timberlake Manor Parkway, Suite 500
Chesterfield,MO 63017
(636) 728-4406
Back to the list of open positions

Subscribe to Ferguson Consulting Career Opportunities RSS Feed. Subscribe to Ferguson Consulting Career Opportunities RSS Feed.


I have confidence in Ferguson’s management and their values. I have always felt treated as a person, not a number.

— Ferguson employee since 2005

Ferguson has always been proactive about lining up my next assignment and getting me the best rate possible.

— Ferguson employee since 2000

Ferguson's management and staff take a sincere interest in the careers of their consultants. They understand the industry like no other firm I have worked for.

— Ferguson employee since 2008

Ferguson works hard laying the groundwork so that it’s easy for the consultant to succeed on the assignment.

— A Ferguson employee since 1994