Data Warehouse Developer

POSITION DETAILS:

Position Title:

Reports to (POSITION):

Team:

Department:

BYTES:

Established in 1982, Bytes has grown rapidly and now employs over 600+ people across 5 locations in the UK and Ireland. Our turnover in Financial Year 2019 was in excess of £520M. We work with SME’s, corporates and public sector organisations to modernise and digitally transform their IT infrastructures.

We invest in our employees through on-going support, training and advice to help them achieve their career aspirations, rewarding success both financially and personally. There is opportunity to grow and move internally which can be seen through our long-standing employees who have developed existing and new skills to move into senior positions in the organisation leaving space for new team members to begin their journey.

Your Future Starts Here

Why Bytes?

• Over 600 staff (plans to double in size over the next 5 years)
• Operating from modern, hybrid working environments with offices in Leatherhead, Reading, London or Manchester
• Winners of an array of industry awards
• Sunday Times Top 100 Best Places to Work
• Excellent training and career prospects offered
• Fantastic office with gym, canteen, open plan, smart casual dress code, regular incentives and company events
• Supporters of 85+ charities with strong commitment to diversity and sustainability

PURPOSE OF JOB:

(OVERALL DESCRIPTION OF THE POST WITHIN THE TEAM AND ORGANISATION)

We are looking for an experienced Data Warehouse Developer with 2-5 years of experience to design, develop, and optimize data warehousing solutions. The ideal candidate will be proficient in building and maintaining data warehouses and ETL processes, with some exposure to modern data lake technologies. You will work closely with our internal development teams/Infra team to ensure data integrity, performance, and availability of Datawarehouse environment for reporting and analysis purposes.

KEY RESPONSIBILITIES:

• Design, Develop, and Maintain Data Warehouses:
• Design and implement data warehouse architectures that support enterprise reporting, analytics, and business intelligence.
• Develop, optimize, and manage ETL (Extract, Transform, Load) processes to integrate data from multiple sources into the data warehouse.
• Create and manage data models, schemas, and dimensional models (e.g., star, snowflake schemas) for efficient data storage and retrieval.

• Data Integration & Transformation:
• Work with relational databases such as SQL Server, Oracle, PostgreSQL, and integrate data from diverse sources such as flat files, APIs, or cloud services.
• Write complex SQL queries and stored procedures to transform raw data into structured formats for reporting and analysis.
• Implement and support ETL pipelines using tools such as SSIS, Informatica, or Azure Data Factory

• Data Governance & Quality:
• Ensure the accuracy, consistency, and reliability of data across the warehouse.
• Develop and implement data validation, cleansing, and transformation processes to ensure high data quality.
• Support data governance initiatives by documenting data structures, data flows, and maintaining metadata.

• Exposure to Data Lake Technologies:
• Exposure to Data Lake environments such as Azure Data Lake, AWS S3, or Google Cloud Storage to support semi-structured and unstructured data ingestion.
• Knowledge on how to manage data flows between data lakes and data warehouses, ensuring data is accessible for reporting and analysis when needed.

• Performance Monitoring & Optimization:
• Monitor and troubleshoot data warehouse performance, optimizing for query efficiency and storage.
• Ensure optimal database performance by implementing indexing, partitioning, and performance-tuning techniques.
• Collaborate with the Infra/Support team to ensure data systems are highly available, scalable, and secure.

QUALIFICATIONS, EXPERIENCE, & SKILLS:

(DELETE AS REQUIRED IF ESSENTIAL OR DESIRABLE, REMOVE UNNECESSARY REQUIRENENTs)

Educational Qualifications:

• Bachelor’s degree in computer science, Information Systems, or related field.

DESIRABLE

Years of Experience

• 3-5 years of experience in Data Warehouse development, design, and management.

ESSENTIAL

CORE Competencies & SKILLS – BASED ON POSITION AND GRADE (IF APPLICABLE)

(INCLUDE CORE COMPETENCIES & SKILLS REQUIRED FOR THIS POSITION BASED ON THE GRADE)

• Exposure to data lake technologies (e.g., Azure Data Lake, AWS S3) and an understanding of their use in data management and architecture (experience with them is a plus, but not required).

• Experience with cloud-based data platforms such as Azure Synapse Analytics, AWS Redshift, or Google BigQuery is a plus.

• Familiarity with data warehousing methodologies (e.g., Kimball, Inmon), dimensional modelling, and schema design.

• Strong SQL programming skills, including writing complex queries, stored procedures, and query performance tuning.

• Proficiency with SQL and relational databases such as SQL Server, Oracle, PostgreSQL, or MySQL

• Exposure to data lake technologies (e.g., Azure Data Lake, AWS S3) and an understanding of their use in data management (experience with them is a plus, but not required).

• Basic knowledge of data lake technologies, such as Azure Data Lake, AWS S3, or Google Cloud Storage.

• Familiarity with Big Data tools like Apache Spark, Hadoop, or Databricks is an added advantage.

• Experience working in an Agile environment with DevOps practices and CI/CD pipeline management for data integration.

• Experience in cloud migration or hybrid data architectures combining on-premise and cloud data solutions.