Senior Consultant - Datahub

Job Title

Position Overview: This position is responsible for supporting the delivery of DataHub Daily Reporting, End of Month Forecast and RetailPer4mance. 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.

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 Detroit, MI Office location. Candidates must be available and willing to work in-person two times per week. Initial training may require additional in-person training for hands-on learning experience.

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

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