Data Warehouse Tech Lead - SQL 2016 - Kimball - ETL - London

Nexere Consulting Limited
United Kingdom
13 Nov 2017
15 Nov 2017
Contract Type
Full Time
Data Warehouse Tech Lead - SQL 2016 - Kimball - ETL - London Job Description: This is a role where you will be responsible for the development of innovative, maintainable and reliable new software solutions as well as enhancing existing applications to meet the dynamic business and regulatory requirements for this industry. You will be required to set and maintain standards and best of breed practices for this technology stack and mentor developers with less exposure to the technology. Candidate Profile Essential Experience/Skills: Advanced Data Warehouse development experience on SQL Server using the Kimball methodology Extensive ETL experience, with advanced T-SQL transformation abilities Experience in Dimensional Modelling (creating facts and dimensions) Experienced with SSAS/MDX and OLAP Cube design and implementation Good knowledge of implementing Slowly Changing Dimensions Experience with different system architectures, and have opinions about what works and what doesn't, including the implication of design choices on scalability and resilience A good understanding of the Application life cycle and a solid understanding of quality assurance, database engineering and build and deployment Development best practice including code reviews, unit testing, source control, and automated testing Can articulate to the business the impact of technology/design choices Familiarity with testing frameworks and processes Experience working in a highly regulated industry sector Preferred Experience/Skills: WhereScape RED Data Warehouse life cycle tool Experience of interfacing warehouse schemas to BI dashboards (QlikView, PowerBI, etc) Experience in SSIS development Understanding of Office 365 & associated technology Understanding of SharePoint with a broad range of real-world experiences. Must have hands on experience with SharePoint Online/Office 365 Integrating 3rd party products within an enterprise Understanding of cloud and on-premises infrastructure concerns An understanding of the benefits of loosely coupled applications/systems Oracle environments Unix/Linux environments A broad background in computer science fundamentals backed by experience in designing, developing, and debugging software Knowledge of how and when to identify and evaluate 3rd party systems and libraries Data Warehouse Tech Lead - SQL 2016 - Kimball - ETL - London - provided by Dice AUTOMATED TESTING, BI, CLOUD, COMPUTER SCIENCE, ETL, LINUX, MDX, OLAP, ORACLE, QLIKVIEW, SHAREPOINT, SQL, SQL SERVER, UNIX