Senior Consultant – Cloud Data Warehouse Architect / Developer

Cloud Data Warehouse ConsultantWe are looking for an enthusiastic Cloud Data Warehouse Consultant to join our Financial Services team working at one of our multinational banking clients with the data management, technology, and analytics teams. The Cloud Data Warehouse Architect / Developer designs and implements agile, scalable, and cost-efficient solution on Cloud data services. As a Consultant, you will work on-site at our client as part of a cohesive consulting team and have interactions with senior stakeholders in addition to opportunities to own deliverables.The resource will support the migration of an Enterprise Data Warehouse to an Azure Cloud platform and will help design and implement a proof of concept as well as the strategic solution. The candidate will work closely with various development teams and Business units to further enhance the data warehouse and reporting elements of the platform. A strong understanding of data warehousing design principles is essential. The consultant will trouble shoot issues during the daily process of loading the files and transforming them to the new Azure Data Warehouse.Propose architectures that consider cost/spend and develop recommendations and plans to right-size solutionsDefine solutions paying particular attention to ensuring technical requirements have been factored inProvide subject matter expertise on a range of Cloud service implementation, migration, delivery, and performance management activitiesDevelop efficient ETL routinesWork with wider Technology teams to ensure development and testing is coordinated and best practices are followedHelp define test cases and work closely with users assisting them with testing bug fixes or new features and functionsEnsure due diligence has been carried out on all software changes, paying particular attention to detail on unit, component, and systems integration testingWork with BAU teams to ensure project changes are released to live in a coordinated mannerDesign and develop warehouse enhancementsLoad and validate dimensions and measures stored proceduresPerform all application unit and system testingSupport the loading and integrity of the data warehouseCreate data dictionary's and proper documentation on the data warehouseAssist with creation of a robust, sustainable, and scalable architecture that supports requirements and provides for expansionWork with end users, business analysts, technical architects, and developers to define the data requirements and data structure for BI and analytics solutionsCollaborate with Engineers, Business Analysts, Data Modelers, SMEs, and Data Governance to build a sustainable warehouse in the CloudYearly Gross Salary: $120k – $180k