Data Management 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 

A Data Management Analyst operates within a larger Data Management function to provide technical integration and processing support relevant to data to address the business needs of the organization, with a high degree of accuracy and in a timely manner.  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. 

 

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 has current Hybrid Workplace flexibility local to our Detroit office.  Candidate must be available and willing to work in-person one day per week. 

 

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

Essential Duties and Responsibilities

Curation of data

• Guidance: With manager guidance and while working in a supportive team setting, import, transfer, monitor, process, and analyze data in order to improve accuracy and quality.
• Participate in Agile Processes: Actively engage as a member of a SCRUM team, attending daily stand-ups, sprint planning, and retrospectives to deliver on our commitments.
• Data Integrations: Interface with other technology teams both within and outside of ChannelVantage to integrate data from a variety of sources. This includes client data source teams, DBAs, and application teams.
• ETL Development: Plan and implement Extract, Transform, Load (ETL) processes to move and prepare data for analysis or reporting using SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and other automation tools.
• Data Stewardship: Perform regular database maintenance tasks, including query optimization, data clean-up, data quality, accuracy checks, and resolving technical issues.
• Support: Effectively responds to internal inquiries/requests in a timely manner to maintain high satisfaction.
• Cross-Team Support: Collaborate across several teams to process, audit and integrate data from various sources into downstream systems for data modeling, reporting & production software applications.
• Commitment to Automation: Assess and implement enhancements to optimize and expand the suite of automated processes.
• Documentation: Maintain comprehensive documentation for database structures, processes, and maintenance activities.
• 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.

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 wi