Data Analyst

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

The Data Analyst at Urban Science manages data used in products and services that Urban Science sells to its customers. That data comes from diverse sources, clients, venders and technologies, and requires considerable processing and integration to deliver the insights that are beneficial to our customers. The Data Analyst has a high level of responsibility to ensure the data integration and processing results in a quality level that meets the needs of the business functions.

Workplace flexibility has taken on a whole new meaning here at Urban Science. The requirements of each team, role and employee can look quite different. Leaders work with their teams to determine the right balance for working in-person and remotely, considering the needs of the business, our clients, cross-functional projects, individual work, and individual preference. This role is a hybrid role, with a requirement of 1 day per week in the Mexico office, with additional days as needed.

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

Essential Duties and Responsibilities

• Manage Urban Science client databases, extract and manipulate data utilizing Urban Science proprietary software and commercial tooling
• Interface with other technology and business teams to integrate data from a variety of sources (client teams, DBAs, consuming application teams and the analytics department)
• Help to document work instructions to interface with central GDS data systems
• Execute ongoing and ad hoc processing of data
• Apply data analysis methods and tools to enhance data cleansing and readiness for use
• Create and generate data reports and deliverables for clients
• Assist in data processing reporting and BI tooling for operational management of data systems
• Tier 2 and general system support functions
• Manage access control into data processing systems
• Ensure data confidentiality and regulatory compliance
• Proactively communicate with upper management to provide updates and report issues in a timely manner

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.

• Knowledge of relational database fundamentals, including creating and executing SQL queries, creating scripts, importing/exporting data, and manipulating data
• Familiarity with typical data integration patterns
• Experience with BI tools, such as PowerBI and Tableau
• 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, to turn facts and data in compelling stories using appropriate grammar, syntax and sentence structure.
• 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 in order to improve or enhance job results and the tenacity to withstand challenges and setbacks along the way.
• 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.
• 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.
• Relationship Building: Requires the ability to effectively build and maintain friendly, warm relationships or networks of contacts with clients/customers. 
• MS Office: Requires demonstrated knowledge of MS PowerPoint for the development of high impact presentations. Requires intermediate knowledge of MS Word and Excel.
• Time Management: Requires strong capability to prioritize competing demands, manage multiple concurrent tasks and run meetings on schedule. 

EDUCATION AND/OR EXPERIENCE

• Minimum Baccalaureate degree in Computer Science or related field from an accredited U.S. college or university, equivalent foreign institution is preferred. Non-technical degrees may be considered if candidate possesses appropriate level of analytical and technical knowledge and experience required for the role
• 3+ years related work experience required
• 1+ years with scripting and/or compiled languages
• GIS experience a plus: geoprocessing, spatial analysis and mapping

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.