U061417: Data / Business Analyst

Job Location:

St. Louis, MO

The role:


As an IT professional with Ferguson Consulting, you will have the opportunity to develop state-of-the-art technical skills. You will need the maturity, motivation and some previous client experience to work productively in our client organizations. As a Ferguson employee, and a consultant to our end client, you will be able to focus on your technical skills development - which is what we do best.

Our rigorous screening for technical skills and client compatibility and our commitment to continuing education make our consultant’s valuable assets to the clients we serve. Our client’s know that Ferguson’s professionals will fit seamlessly with their operations and their staff.

We’ve learned over the years how to comply with our clients’ unique procurement procedures and to keep in step with their overall processes so we can be responsive to their requests and requirements.

Position Overview

As a fulltime employee of Ferguson Consulting, your first assignment will be working as a data analyst to complete a data-migration project currently underway. The ideal candidate will lead and execute all data-migration efforts under limited supervision.

The project is focused on migrating United Access' existing SQL-based ERP data into a Salesforce-based CRM / ERP managed package. An analysis will need to be conducted of existing ETL requirements, mappings, and the work completed thus far in Excel/Power Query. The ideal candidate will be capable of functioning as both a business and data analyst, interpreting the needs of the business through to technical execution. This project may potentially expand to include additional data sources.


    • Responsible for the management and execution of all ETL efforts between a legacy SQL ERP and a Salesforce-based ERP
    • Perform audit, reconciliation, and exception reporting
    • Capable of operating within migration constraints that require singular loads of data, as well as transitional scheduled data loads between systems to ensure synchronicity
    • Develops, validates, documents, and maintains business and functional requirements and conducts structured walkthroughs of requirements with business and project team members
    • May work with project teams to support requirements gathering
        • Defines data mapping specifications to support data transformation
        • Facilitates the identification of common data elements and their definition
        • Facilitates the identification of master data elements and their definition
        • Evaluates business requests to determine feasibility; researches and identifies options
        • May lead QA testing, user acceptance testing and troubleshooting to ensure client/user needs are met
        • Evaluates and tracks new or enhanced solutions to determine potential issues and communicates how problems may affect business
    • Responds to questions from business and IT teams and proactively maintains open line of communication
    • Participates in change management activities, Q&A testing, troubleshooting, and investigation
    • Performs task automation and implements process improvements; recommends enhancements that result in increased quality and service
    • Maintains regular and predictable attendance
    • Performs other duties as assigned


    • 5+ years IT-related experience, preferably in data analysis
    • Advanced oral and written communication skills demonstrating ability to share and impart knowledge with different levels of business users, especially ones with no technical background. Maintains open line of communication with the business using the business’ language not technical language
    • Ability to quickly adapt to new methods
    • Advanced investigative, analytical and problem solving skills.

      Must be detail oriented and organized

    • Ability to set goals and handle multiple tasks, clients, and projects simultaneously; Ability to appropriately balance priorities, deadlines, and deliverables
    • Ability to work effectively within a team environment and participate in department/team projects
    • Ability to translate business needs and problems into viable/accepted solutions
    • Ability to liaise with individuals across a wide variety of operational, functional, and technical disciplines
    • Bachelor's degree or equivalent experience

    • Proven success with ETL data migration efforts


    • 8+ years IT-related experience, such as Business Analysis, Data Analysis, etc.
    • Salesforce Data Loader, Object Data Model, and/or SOAP API experience strongly preferred
    • Strong SQL expertise
    • Familiarity with data migration tools, such as DBAmp

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

In the Solutions Group we operate from an ‘end product with certainty’ perspective. It can be challenging to guarantee total satisfaction to our client, but it’s immensely rewarding to deliver on that promise.

— Solutions Group employee