Job Description :
Solution Architecture Consultant/Expert
DEARBORN,MI
Position Description:
Work on the Global Order to Delivery (GOTD) program with the Order Analytics Repository (OAR) and/or New Vehicle Inventory System (NVIS) applications. The Analytics Database Developer will provide Application Development and Support for database and service capabilities that permit the retention of key vehicle order management and order generation data. This data will be used to analyze order generation capabilities, permit the visualization of key measures, provide inventory information for unique marketing and sales customer experiences, and to identify opportunities for business and technical improvements.
Skills Preferred:
Ability to effectively collaborate across it and business teams in a global team environment to design, develop and implement solutions to meet business needs -Strong verbal and written communication skills -A passion to learn new technologies and skills
Experience Required:
3+ years of Microsoft SQL Server 2012 or later and SSIS development/support experience -Familiarity with Star Schema design and implementation -Experience using SQL Server Integration Services (SSIS), including o Package automation across environments o Package configuration encryption o Logging and error handling o Scripting in .NET -For OAR position o Microsoft SQL Server Analytics development experience o Implementation of relational data warehouses o Troubleshooting in an analytics environment -For NVIS position: o 1+ years in Microsoft Azure Cloud development and deployment o Strong knowledge/hands-on experience with Azure SQL Data Warehouse, Azure SQL Databases, Blob Storage, App Service o Troubleshooting in Azure cloud environment
Education Required:
Equivalent work experience in the requested areas