Data Warehouse Engineer
- Job Title
- Data Warehouse Engineer
- Job ID
- 27016694
- Location
- Detroit, MI
- Other Location
- Description
-
Job Description
What You'll Do/Need
Responsibilities
- Model application layer and metadata Design, develop and implement Business Intelligence (BI) report objects supporting end user business requirements
- Assist in creation of BI development standards and processes
- Design and create automated BI applications and reporting solutions
- Provide technical expertise to business areas in understanding the data architecture and give feedback on a structured approach to transitioning manual reports and applications to the Business Intelligence environment
- Guide business areas in identifying new data needs and delivery mechanisms for reporting information
- Establish documentation of reports and data definitions
- Support daily operations, including job monitoring and troubleshooting of the data warehouse environment
Requirements
- Bachelor’s degree in computer science, information technology or equivalent experience
- At least five years of experience working in a data warehousing position within a fast-paced and complex business environment, preferably working as a Data Warehouse Engineer; must also have experience developing schema data models in a data warehouse environment
- Demonstrated knowledge of database concepts of data mapping and modeling inclusive of normalization, referential integrity, dimensionality, keys, indexes, metadata and master data
- Proven and successful experience working with ETL concepts of data integration, consolidation, enrichment and aggregation
- Experience working with SQL server database administration, integration services, analysis services and MDX query language
- Strong demonstrated understanding of dimensional modeling and similar data warehousing techniques, as well as having experience working with relational or multidimensional databases and business intelligence architectures
- Excellent communicator both in written and verbal form