Conexess – Conexess Design Skip to main content

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

 

Option 1: Create a New Profile