Analyst

Urban Science; Franklin (TN); Hybrid; USD 50,000 - 70,000; Full time

Job summary

Urban Science in Franklin, TN is seeking an analyst to provide operational support for an industry-leading sales analytics solution. You will enable quick and easy analysis of geography and segment KPIs against competitors for a major automotive manufacturer, delivering high-quality reports and data-driven insights.

This hybrid role requires a university degree in a technical field, 0–2 years of experience, and skills in SQL, Advanced Excel, and Python.

Qualifications

• University degree in a technical field (engineering, applied math, statistics, etc.)
• 0–2 years of related work experience preferred for Analyst level
• Familiarity with SQL, Excel, and Python is preferred
• Strong analytical thinking and problem-solving abilities
• Ability to work in a hybrid office environment in Franklin, TN

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.
• Accurately performs application coding and testing functions associated with the development of custom client software.
• Tracks, processes, analyzes and verifies data in order to improve accuracy and quality.
• Use technical skills to accurately monitor, 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.
• Effectively responds to client inquiries/requests in a timely manner to help improve client satisfaction.
• 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).
• 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.

Skills

Verbal communication

Written communication

Analytical thinking

Results orientation

Ethics & integrity

Teamwork

Self-control

Statistics

MS Office

SQL knowledge

Education

Bachelor's degree (engineering, applied math, statistics, information systems, computer science)

Technical degree preferred

Tools

SQL

Python

Advanced Excel

Job description

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,

POSITION OVERVIEW

This position will provide operational support for an industry-leading sales analysis solution that enables quick and easy analysis of geography and segment KPIs against competitors for a major automotive manufacturer. This role supports the delivery of client services and use of technical skills to maintain software and database systems and create regular reporting deliverables. Additionally, it requires providing analysis and reporting on key metrics for the platform's stakeholders. The position emphasizes technical and client-handling skills to carry out high-quality projects and tasks with precision and timeliness. The most commonly used technical tools in this position include SQL, Advanced Excel, Python, and proprietary software.

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

This role has current Hybrid Workplace flexibility local to our Franklin, TN office location. Candidates must be available and willing to work in-person two days per week (Wednesday and Thursday). Initial training may require additional in-person training for hands-on learning experiences.

• 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.
• Accurately performs application coding and testing functions associated with the development of custom client software.
• Tracks, processes, analyzes and verifies data in order to improve accuracy and quality.
• Use technical skills to accurately monitor, 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.
• Effectively responds to client inquiries/requests in a timely manner to help improve client satisfaction.
• 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).
• 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
• 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
• 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 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, utilizing functions, and filtering, sorting and formatting of data; intermediate knowledge of MS Word, PowerPoint, and Access is preferred
• Database Working knowledge of relational database concepts, which require gathering and manipulating data manually is preferred; knowledge and experience with SQL is preferred

EDUCATION and/or EXPERIENCE

• University degree required; technical degrees are required (i.e., engineering, applied math, statistics, applied science, information systems, operations research, computer science, etc.) from an accredited college or university, or equivalent foreign institution.
• Minimum of 0-2 years related work experience preferred for Analyst level

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.