Back to Results

Data Warehouse Architect 5 - Lansing, MI

Quick Facts
Company Name:Global Information Technology
Location:Lansing, MI
Employment Type:Contract
Take Action

Description

Global Information Technology is looking for a Data Warehouse Engineer  who will be  responsible for the full life cycle of back-end development of the data warehouse. Responsibilities include the development of ETL processes, dimensional design of the table structure, cube development for performance and database administration. The DWE will work closely with the Business Analyst to work through business requirements and develop processes necessary to provide visibility into the data via the centralized data warehouse and reporting platform. The DWE will also work closely with the front-end developers to ensure data that is brought in and managed is clean, accurate, available and complete. The DWE will help to ensure the data warehouse processes are running optimally.

 

If you're the type of person who keeps your skills sharp, is constantly reading about new technology and participates in online communities for database administrators, then you're the type of person we're looking for.

 

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 SQL Server Integration Services

•Create and support the SQL Server Analysis Services cubes to help with query performance

•Monitor and troubleshoot performance issues on the data warehouse servers

•Follow the design principles and best practices defined by the team for data warehousing techniques and architecture

•Participate in an on-call rotation

•Participate in production code pushes after regular business hours

 

Requirements

•Bachelor's degree in computer science

•Two years of experience with SQL Server 2005/2008/2012 T-SQL Coding

•Two years of experience with SQL Server 2005/2008/2012 Database Administration

•Two years of experience with SQL Server Integration Services (or similar ETL tool)

•Two years of experience with SQL Server Analysis Services

•Two years of programming experience (i.e. VBScript, .Net)

•Ability to complete responsibilities effectively and efficiently with minimal direction

•Reliable and works independently to get the job done

•Displays a positive attitude and is open to change

•Seeks feedback and is willing to act on feedback

•Regularly shares their best practices to help develop others

•Seeks out new challenges and growth opportunities

•Lives the ISMs and demonstrates them in our culture

 



Automation Alley Logo