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.