Job Title: Data Architect

Rate: £500/day inside IR35

Location: London

Job Type: Contract

We seek a highly experienced Data Architect with 8-10 years of expertise in data marts, data warehouses, Oracle ODS, MS SQL ODS, and ETL platforms. If you excel at designing robust data architecture and ETL pipelines, with a keen eye for data quality and operational reporting, we want to hear from you! Key Responsibilities:

• Data Warehouse & ETL Development: Design and develop data warehousing solutions and ETL pipelines to support organizational needs.

• Data Modelling: Design logical and physical data models to solve specific problems and meet new reporting requirements from ODS (Operational Data Store).

• ODS Architecture: Create and maintain ODS structures for efficient data integration and real-time processing.

• Data Integration: Consolidate data from multiple sources, including CRM systems, log files, and external data feeds, into the ODS.

• Data Transformation & Cleansing: Ensure high data quality by transforming and cleansing raw data for accurate reporting and analysis.

• Operational Reporting: Enable real-time or near real-time decision-making by providing up-to-date data using PLSQL, SQL, and Power BI.

• Collaboration: Work closely with Chapter Leads to design the organization's Data and Business Intelligence (BI) Strategy.

• Data Analysis & Modelling: Provide strong analytical skills to support data-driven decisions. Skills & Qualifications:

• 8-10 years of experience in data architecture.

• Strong understanding of data marts, data warehouses, and ETL platforms.

• Expertise in Oracle ODS, MS SQL ODS, and PLSQL.

• Proficiency in data modelling and ETL pipeline design.

• Experience with real-time operational reporting and data integration from diverse sources.

• Solid knowledge of SQL, Power BI, and related tools for reporting and analysis.

• Excellent problem-solving skills and the ability to design solutions to support business needs.