Lansing, MI, US
1 day ago
Data Warehouse Architect 5
DescriptionGlobal 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.ResponsibilitiesDesign and support the database and table schemas for new and evolving sources of data brought into the data warehouseCreate and support the ETL to facilitate bringing data into the data warehouse using SQL Server Integration ServicesCreate and support the SQL Server Analysis Services cubes to help with query performanceMonitor and troubleshoot performance issues on the data warehouse serversFollow the design principles and best practices defined by the team for data warehousing techniques and architectureParticipate in an on-call rotationParticipate in production code pushes after regular business hoursRequirementsBachelor's degree in computer scienceTwo years of experience with SQL Server 2005/2008/2012 T-SQL CodingTwo years of experience with SQL Server 2005/2008/2012 Database AdministrationTwo years of experience with SQL Server Integration Services (or similar ETL tool)Two years of experience with SQL Server Analysis ServicesTwo years of programming experience (i.e. VBScript, .Net)Ability to complete responsibilities effectively and efficiently with minimal directionReliable and works independently to get the job doneDisplays a positive attitude and is open to changeSeeks feedback and is willing to act on feedbackRegularly shares their best practices to help develop othersSeeks out new challenges and growth opportunitiesLives the ISMs and demonstrates them in our culture

Confirm your E-mail: Send Email