Share this Job

Go Back

Senior Data Warehouse Engineer LOC: Detroit, MI


2016-12-06 14:15:40
Job Type: Full Time only
Budget $: 100,000 - 200,000

Responsibilities

  • Design and support the database and table schemas for new and evolving sources of data brought into the data warehouse Create and support
  • The ETL to facilitate bringing data into the data warehouse using SSIS or other technologies
  • Create and support analysis services cubes to help with query performance
  • Monitor and troubleshoot performance issues on the data warehouse servers
  • Define and promote the teams design principles and best practices for data warehousing architecture and techniques
  • Research and promote new tools and techniques to shape the future of the data warehouse environment

Requirements

  • Bachelors Degree in computer science or equivalent experience
  • Five years of experience with SQL Server T-SQL coding Three years of experience with SQL Server Database Administration, Integration Services (or similar ETL tool)
  • Analysis Services and MDX Query Language
  • Three years of programming experience (i.e. VBScript, .Net)
  • Strong understanding of dimensional modeling and other data warehousing techniques
  • Strong performance tuning skills
  • Strong analytical and research skills
  • Demonstrated ability to work independently as well as with a team
  • Ability to troubleshoot problems and quickly resolve issues
  • Strong communication skills
  • Passion to research new tools and technologies


Key Skills: