Job description Data Warehouse Engineer for Detroit, MI - multiple positions open - to design and develop data models and table structures for hosting data from various sources into centralized Data Warehouse and Big Data platform; develop ETL processes to populate relational databases and Big Data clusters and integrate with operational systems; work collaboratively to facilitate analysis of large data sets and support statistical analysis, machine learning algorithms & predictive models; develop processes to ensure data quality and system availability; monitor processes and system performance and ensure processes are optimized; develop and implement best practices and guidelines for consistency and stability. Requires Master\'s degree in Computer Science, Software Engineering, Electrical Engineering or closely-related field and 3 yrs experience working with a relational DB system, which includes writing complex SQL queries, database design and addressing performance issues; using a data warehouse or business intelligence ecosystem; implementing a development life cycle for data mining that includes data gathering, cleaning, modeling, validation, deployment and monitoring processes; developing and maintaining the ETL logic for the data required for predictive modeling using SQL and .Net; and building a framework for a centralized scoring engine using SSIS and providing visibility around predictive models using SSRS and Tableau.
Key Skills: