Data Architect

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.