Implementation Engineer

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 We are looking for an Implementation Engineer with data engineering skills to be an important part of building our latest innovative multi-tenant, micro-services solutions. We use some of the latest technologies along with some core foundational technologies such as .NET, SQL Server and Angular. Successful candidates will possess a passion for technology, seeking out and learning the best options for solving problems. 

This role has current Hybrid Workplace flexibility local to our Detroit, MI office.  Candidate must be available and willing to work in-person two days 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

ESSENTIAL DUTIES AND RESPONSIBILITIES

• Maintain our goal: Our highest priority is to satisfy the customer through early and continuous delivery of valuable software. 
• Use Agile methodologies to deliver solutions that will support our customers, mainly using the Scrum framework to support solution development, implementation, and support.   
• Work in a team environment to build our solutions, and with regular retrospection, improve our team culture and processes through continuous inspection.   
• Develop, implement and maintain data pipelines and processes to translate complex, business rules into efficient, scalable SQL logic, handling edge cases, and ensuring accurate, deterministic outcomes across large datasets.
• Determines best methodology and approach to implement and configure new requirements into existing and new client solutions 
• Works closely with software development teams to test new application features, including identification of possible user actions and potential problems with current design/functionality 
• Actively participate in team technical discussions where design ideas are presented and reviewed resulting in a team decision on the best approach. 
• Participate in systems design, design reviews, software development, code reviews, quality engineering, and continuous integration and continuous delivery. 
• Develop and maintain databases in support of application development, modification and creation of queries and integration. 
• Provide support to internal and external clients currently utilizing software applications, including assisting with the delivery of solutions.  
• Assist with training as needed, including developing training materials and delivering training to staff. 
• May mentor other Implementation Engineers. 

Qualifications - Education and Experience

KNOWLEDGE, SKILLS, ABILITIES, AND COMPETENCIES 

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, skills, abilities, and competencies required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. 

• Preferred familiarity with, or desire and ability to learn: 

• Data integration and ETL/ELT patterns

• Utilization of technologies such as C#, .Net, WCF, and MS SQL Server 

• Relational and dimensional database design methodologies and/or unstructured data solutions 

• Tools such as Visual Studio (VS), Team Foundation Server (TFS), GIT, etc. 

• Automation testing for quality engineering disciplines such as unit testing, smoke testing, and integration test. 

• Continuous integration and continuous delivery tools (Azure DevOps).  

• Understanding of potential performance, security, scalability and maintainability issues.  
• Architecting and optimizing complex SQL solutions using advanced relational database concepts (normalization strategies, indexing, execution planning, CTEs, and aggregations) to ensure accuracy, scalability, and high performance across large datasets.

• Requires ability to: 

• Function on an Agile (Scrum) team utilizing ADO for task management and source control. 

• Independently analyze requirements to determine how applications function in order to build effective designs and tests. 

• Use industry standard design patterns. 

• Understand and utilize testing methodologies (test driven development, unit testing, performance/load testing). 

• Learn and follow Urban Science’s Software Development Life Cycle (SDLC). 

• Develop business awareness and understanding of the business requirements of IT. 

• Monitor and check work deliverables ensuring high quality, accuracy and having a strong attention to detail.  

• Prioritize competing demands, manage multiple concurrent tasks and adapt to changing priorities. 

• Find improvements in processes, projects, and software. 

• Independently engineer a feature or epic from ideation with product owner to delivery of those specified items, while understanding the impact in relation to the rest of the software platform and associated business.   

• Oral 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 including the ability to create technical documents. 

• Analytical Thinking/Reasoning: 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 Orientation: 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. 

• Concern for Order, Quality & Accuracy: Requires the ability to monitor and check work related information and deliverables ensuring high quality and accuracy. 

• Customer Service Orientation: 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/Critical 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 set-backs 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. 

EDUCATION AND EXPERIENCE 

• Must have Baccalaureate degree in an appropriate IT field such as Computer Science or Computer Engineering from an accredited U.S. college or university, equivalent foreign institution, or equivalent experience. 

• Must have minimum of two years relevant work experience.  

• MS SQL Server and MS .NET Certifications preferred.  

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.