Hybrid (Dearborn, MI)
Job Summary:This position is with the Dealer Integrations Inventory Solutions Technology team developing and maintaining key areas of the backend services and databases. The inventory services are at the center of it all and the developer in this position will be a critical contributor to high visibility solutions. This role will focus on data ETL, automated reporting and dashboarding, system performance and quick, nimble and reliable backend operations and development.
Essential Job Functions:
- Troubleshoot database performance (MS-SQL), data discrepancies, and web services/components
- Leading the development and implementation of advanced recurring automated report and dashboard solutions in support of business objectives.
- Serve as SME for backend data systems during requirements gathering and project scoping
- Develop information tools, algorithms, dashboards, and queries to monitor and improve business performance
- Analyzing data and communicating findings to stakeholders
- Identifying and recommending modifications to improve process efficiency for report and dashboard delivery methods and automation
- Creating new business intelligence services and support to address emerging needs
- Leading and participating in technical code reviews and best practices
Minimum Qualifications and Job Requirements:
• Expert skills in writing advanced SQL, creating packages, leveraging functions, building stored procedures, and optimizing SQL queries• Expert skills and knowledge in database management, MS SQL Server, and relational database concepts• Excellent programming and problem-solving skills with an aptitude to learn & apply new technology skills• Experience/understanding of data warehousing & data management concepts• Communication and thought leadership are essential for this role as the team will be eliciting requirements and prototyping early in the project and working directly with the business decision makers• 7+ years in all applicable technologies• Experience and/or knowledge of digital automotive, most specifically inventory and vehicle-related data
Other Responsibilities:
- Demonstrated ability to work autonomously and with a team while executing independent decision-making abilities in a fast-paced environment- Ability to work flexible hours to support application launch and production outages if necessary- Strong interpersonal skills, problem-solving skills, and the ability to handle multiple demands and competing priorities
