Data/BI Architect

Project overview

We're hiring a hands-on Data/BI Architect to support the evolution of a cloud-based data platform, with a strong focus on data warehousing, analytics, and reporting. You'll work closely with BI Developers to design, build, and optimise end-to-end data solutions across the Azure stack.

Client Details

A well-established UK-based international investment organisation with a global footprint, delivering impactful programmes across multiple regions.

Description

As a Data Architect, you will bring your experience in Microsoft Fabric and Azure data technologies to the organisation, and your core responsibilities include:

Profile

Background and skills

Competencies and aptitude

Job Offer

• Actively delivering work for key business programs advising and supporting the further adoption of the data platform.
• Designing, building and providing guidance for the use and management of data specifically around our data hub, Enterprise Data Warehouse and Power BI and Fabric Analytics and Reporting tools.
• Defining the data technology architecture, model/schema, including metadata, integration and Business Intelligence or data warehouse architecture.
• Coordinating changes across business change, technology change management process, incident management and problem management process.
• Ensuring traceability of requirements on data through design, build, testing and scope changes.
• Providing input into data dictionaries and the evolution of these and other related data assets such as the organisations Common/Logical Data Model.
• Several years of experience in a senior BI data architecture role.
• Expert in dimensional modelling (logical and physical) using Kimball methodology and an excellent understanding of all data concepts, metadata management, data quality management and data governance.
• Experience in end-to-end BI architecture design in an Azure environment: ingestion
• storage
• transformation
• consumption.
• Proven record working with SQL relational databases, data warehouses, query authoring (SQL) as well as working familiarity with a variety of other databases.
• Highly experienced in building and optimizing data queries.
• Good with manipulating, processing and preparing datasets/semantic models.
• Experienced in working with data engineering technologies including ADLS, ADF, Azure SQL, and Azure Synapse, Power BI/Fabric and DAX.
• Good working knowledge of languages such as Python/PySpark.
• Previously created or enhanced CI/CD build and release pipelines using Azure DevOps and GI T.
• Knowledge of other Scripting languages such as YAML, PowerShell, Terraform etc.
• Ability to quickly learn, implement, and utilise new technologies.
• Analytical and problem-solving. Combines and organises information into meaningful patterns; identifies underlying relationships, causes and effects; and combines pieces of information to form conclusions or general rules.
• Communications. Excellent oral and written communication skills.
• Detail-oriented. Consistently takes a thorough, accurate, organised and quality-centred approach.
• Organisation and prioritising. Can effectively address projects, requests and competing priorities. Owning deliverables through to implementation.
• Self-learning mindset. Desires to learn new skills and is willing to share knowledge with the team.
• Provide problem diagnosis and technical assistance.
• £750-£850 per day (Inside IR35)
• Hybrid working (2-3 days in London)
• Initial 6-month contract with extension potential

Project details

• Start: flexible
• Location: City of London, UK, GB
• Rate: 94-106 EUR/h