Senior Consultant - Client Facing Role (SQL, Data Analysis)

SQL Excel Business Reporting Excellent Communications Skills
Full Time
Depends On Experience
Telecommuting not available Travel not required

Job Description

Urban Science is a business-solutions company focused on supporting the needs of the sales and marketing function of the automotive industry. We leverage a scientific methodology to help our client partners sell more vehicles, improve profitability and increase customer loyalty.  And we do that by helping solve their toughest challenges including planning an optimal dealership network, improving individual dealer performance and efficiently converting sales leads into sales. In short, we guide business through science—and we’ve been doing this since 1977.

This position supports the delivery of client services on an account team.  The Sr. Consultant is focused on both technical (mostly Light SQL and Excel) & client handling skills.


  • Plans, organizes, develops and delivers client-requested reports, deliverables and projects on time, adhering to client requested specifications.
  • Designs, creates and manages client databases, utilizing Urban Science proprietary software, ensuring accurate and high quality data.
  • Assists management in creating estimates and proposals for clients in order to have a better understanding of the proposal process.
  • Serves as a contact for, and develops relationships with, the client in order to effectively respond to client requests and inquiries in a timely manner and help improve client satisfaction.
  • Acquires and maintains a thorough understanding of client data for assigned projects in order to properly create client deliverables.
  • Tracks, processes, analyzes and verifies data in order to improve accuracy and quality.
  • Assumes responsibility for accurate and high quality data being utilized on assigned projects.
  • Accurately performs application coding and testing functions associated with the development of custom client software.
  • Use technical skills to accurately update and maintain Urban Science internal software systems.
  • Adheres to quality control standards for Urban Science and client organizations.
  • Coordinates with individuals or teams to complete analyses, tasks and projects on time and with high quality.
  • Attends project meetings and participates in presenting project status updates to client representatives or internal management to clearly communicate project status, conclusions and results.
  • Proactively communicates with management to provide updates and report issues in a timely manner.
  • Actively works with manager to understand and implement solutions to improve NPS (client satisfaction).
  • Partners with internal teams to ensure that software is properly installed, set up and functioning at established quality levels.
  • Actively supports and participates in required Urban Science training programs to achieve targeted development objectives.
  • Works with manager in completing own annual goal setting and performance review in a timely manner.
  • Works with manager to prioritize other duties as assigned.


To perform this job successfully, an individual must be able to perform each essential duty satisfactorily.  The requirements listed below are representative of the knowledge, skill, ability and/or competency needed for successful performance in the role.  Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

  • Verbal Communication:  Requires the ability to compose and verbally deliver information of varying levels, using appropriate grammar, tone, inflection and non-verbal cues, while also listening to and correctly deciphering verbal communication delivered by others
  • Written Communication:  Requires the ability and capacity to communicate ideas, facts and data in writing using appropriate grammar, syntax and sentence structure
  • Analytical Thinking:  Requires the ability to understand a situation by breaking it apart into smaller pieces, and/or tracing the implications of a situation in a step-by-step causal way
  • Results Oriented:  Requires the ability to strive for optimal results by taking responsibility for timeliness, commitment to task and adherence to performance standards
  • Teamwork & Cooperation:  Requires the ability to work cooperatively with others and be part of a team
  • Information Seeking:  Requires the drive to gain a deeper understanding of work related issues or events by making a concerted effort to gather information and seek out development opportunities
  • Initiative:  Requires the drive to go above and beyond in order to improve or enhance job results
  • Quality Control:  Requires the ability to monitor and check work related information and deliverables ensuring high quality and accuracy
  • Customer Service:  Requires the ability to understand and help/assist both internal and external customers and meet their needs.
  • Conceptual Thinking:  Requires the ability to understand a situation or problem by putting the different pieces together to see the bigger picture
  • Interpersonal Understanding:  Requires the ability to understand other’s feelings and concerns, and to value individual differences in people
  • Relationship Building:  Requires the ability to effectively build and maintain friendly, warm relationships or networks of contacts with clients/customers 
  • Developing & Coaching:  Requires the ability, desire and intent to teach and foster the development and long term capability of one or more employees by providing coaching, direction and feedback to enhance performance
  • Database: Requires demonstrated knowledge of relational database management, including, creating and executing queries, creating scripts, importing/exporting data and manipulating data; knowledge and experience with SQL is required
  • Math & Statistics: Requires knowledge of basic descriptive statistics and ability to execute simple statistical analyses, create scatter plots, bar charts and histograms; requires ability to select and apply the right mathematical methods or formulas to solve a problem
  • MS Office: Requires demonstrated knowledge of MS Excel for charting and graphing of data, writing formulas and utilizing functions, and filtering, sorting and formatting of data;  requires intermediate knowledge of MS Word, PowerPoint and Access; knowledge and experience with Visio preferred
  • Technical/Software: Must have demonstrated programming proficiency at the minimum requirement for the role (programming proficiency varies by role and my not be required in certain roles.  For those roles where programming proficiency is needed, typical programming languages used may  include .NET, VBA, C#, SQL, Java, HTML, SSIS and Open Source)
  • Sales & Business Development: Ability to identify potential new opportunities from the client and proactively communicate those opportunities to management is required
  • Project Management:  Knowledge and understanding of project management principles and fundamentals is strongly preferred, including the ability to estimate work efforts.


  • University degree required; technical degrees are strongly preferred (i.e., engineering, applied math, statistics, applied science, information systems, operations research, etc.) from an accredited college or university, or equivalent foreign institution.  Non-technical degrees will be considered if candidate possesses appropriate level of analytical and technical knowledge required for the role
  • Minimum of 4 years related work experience required (6 years experience preferred)


WORK ENVIRONMENT The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. This description is intended to describe the type and level of work being performed by a person assigned to this position. It is NOT an exhaustive list of all duties and responsibilities required by a person so classified. The job may require additional hours beyond the normal 40-hour workweek

Posted By

Laura Solter

Dice Id : 10125077
Position Id : 364996
Have a Job? Post it

Similar Positions

Sr. Data Analyst
  • CompuGain Corporation
  • Mclean, VA
Data Analyst
  • comScore
  • Reston, VA
Business Data Analyst III
  • IT-Strat, LLC
  • Mclean, VA
MIS Senior Data Analyst
  • JSI Research & Training Institute, Inc
  • Arlington, VA
Business Intelligence Analyst
  • Association of American Medical Colleges
  • Washington, DC
BI Reports Developer
  • ASM Research
  • Chantilly, VA
Data Developer
  • Acumen Solutions, Inc.
  • Mclean, VA
Data Analyst
  • Digital Intelligence Systems, LLC
  • Mclean, VA
MS Access Developer
  • ALTEK Information Technology, Inc
  • Washington, DC
Data Analyst
  • ALTA IT Services
  • Mclean, VA
Bus-Data Analyst with design pattern exp
  • Connect Resource Group
  • Rockville, MD
Data Analyst
  • Fairfield Technologies Inc
  • Mclean, VA