Senior Consultant - MarketView

Overview and Summary

We are Automotive Business Scientists. We empower our clients to turn overwhelming industry data into discovery, action and measured success. We are unique market leaders because we find and examine possibilities through the clarity of a scientific lens. To solve the toughest client challenges, we need curious, creative and dedicated people to join our team.

 

We search out individuals who align with our core values and who adhere to the highest standards of integrity and ethics in everything they do. Our company is filled with the brightest minds and the biggest hearts at every level. We recognize that personal success takes on many different forms of the course of our lives – both professional and personally – so we provide a myriad of benefits and programs focused on Wellbeing, Growth, Community and Recognition. One size does not fit all, so we encourage every Urban Scientist to discover their own formula for success. If this sounds like the kind of company you would like to work with, Apply Now!

 

Position Overview: This position is part of the Stellantis LAM team responsible for supporting the delivery of MarketView and MarketFlash Mobile data processing moved from monthly to daily, with the additional of several Dashboard for Stellantis corporate representatives and MFM has been just launched. 

 

Key responsibilities include processing and analyzing complex datasets, developing advanced SQL queries and stored procedures, and producing clear, visually compelling reports and presentations that translate data into actionable business insights while demonstrating strong workload management, technical expertise, the ability to effectively manage client relationships when required, and expectations in a fast-paced, collaborative environment. 

 This role offers Hybrid Workplace flexibility in accordance with Urban Science policy at our Detroit, MI office and our client locations as needed in Auburn Hills. Currently, employees are expected to work onsite approximately two days per week, ( Tuesdays and Fridays); however, this schedule may change based on evolving business needs. During the initial training and onboarding period, additional in-person days may be required to support hands-on learning and ensure a smooth transition into the role. 

 

URBAN SCIENCE DOES NOT AND WILL NOT PROVIDE IMMIGRATION RELATED SPONSORSHIP FOR THIS ROLE, NOW OR IN THE FUTURE.

 

At Urban Science, we are committed to creating an inclusive and welcoming workplace where diverse perspectives drive better outcomes for our employees, clients, and communities.  We are proud to be an equal opportunity employer and make all employment decisions based on qualifications, merit, and business needs. We are committed to equitable practices across hiring, development, career growth, and compensation.  In accordance with applicable federal and Texas law, we do not discriminate in any aspect of employment based on race, color, religion, sex, sexual orientation, gender identity or expression, national origin, age, disability, veteran status, or any other characteristic protected by law.

Essential Duties and Responsibilities

• 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 to better understand the proposal process.
• Serves as a contact for, and develops relationships with, the client 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 to properly create client deliverables.
• Tracks, processes, analyzes and verifies data to improve accuracy and quality.
• Assume 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 annual goal setting and performance review promptly.
• Works with manager to prioritize other duties as assigned.

Supervisory Responsibilities:  

• In preparation of possible future supervisory responsibilities, this person may be called upon to do the following for assigned staff: 
• Set objectives 
• Participate in performance appraisals 
• Assign and prioritize work 
• Approve timesheets 
• Establish and maintain quality, quantity and timeliness of work 
• Oversee training 
• Coach, mentor, manage, and motivate 

Qualifications - Education and Experience

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
• Ethics & Integrity:  Requires the ability to behave in a trustworthy & transparent manner
• Teamwork & Cooperation:  Requires the ability to work cooperatively with others and be part of a team
• Self-Control:  Requires the ability to keep emotions under control and to restrain from negative actions or behaviors
• 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 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
• Flexibility/Adaptability:   Requires the ability to adapt to and work effectively within a variety of situations, individuals or groups, as well as understand and appreciate different and opposing perspectives
• 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
• Self-Confidence:  Requires the ability to express confidence in dealing with challenging circumstances, in reaching decisions or forming opinions and in handling failures or setbacks constructively
• Organizational Commitment:  Requires the ability and willingness to align his/her own behavior with the needs, priorities and goals of the organization
• Relationship Building:  Requires the ability to effectively build and maintain friendly, warm relationships or networks of contacts with clients/customers
• Assertiveness:  Requires the ability and intent to appropriately display assertive behaviors to ensure others follow and comply with given directions
• 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 may 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)
• Time Management: Demonstrated ability to prioritize competing demands and manage multiple concurrent tasks is requiredSales & 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

 

EDUCATION and/or EXPERIENCE:

 

• 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)

 

CERTIFICATES, LICENSES, REGISTRATIONS:

 

• Certification of Apprentice in one practice areas required
• Certification of Consultant in one practice area OR certification of
• Apprentice in two practice areas preferred
• PM Ambassador required
• Intro to Operations Research required (or equivalent)
• Statistics I and Basic Statistics Assessment required (or equivalent)

 

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.