Data Engineer

Role Overview: As a Data Solutions Developer, you will collaborate closely with the Head of Data to create and implement scalable data solutions that facilitate the consolidation of company-wide data into a controlled data warehouse environment. Your primary focus will be on constructing efficient ELT pipelines, APIs, and database architectures to facilitate high-speed ingestion and storage of data from various sources into a unified repository. This repository will act as the foundation for business reporting and operational decision-making processes. Key Responsibilities: - Design and implement scalable database and data warehouse solutions - Establish and manage data ingestion pipelines for both batch and real-time integration - Define and maintain relational schema and metadata frameworks - Support the development of a centralized data repository for unified reporting and analysis - Optimize database structures and queries for performance and scalability - Document and version control all data pipeline and architecture components - Develop and maintain robust APIs for internal and external data exchange - Facilitate efficient data flow between operational systems and reporting platforms - Support system integrations with various tools such as CRM, finance, operations, and marketing - Enforce access control, encryption, and PII protection across all data solutions - Ensure compliance with data protection regulations such as GDPR - Promote and uphold data quality, governance, and security standards - Provide guidance on best practices in data engineering and cloud architecture - Offer ongoing support to internal teams on performance optimization and scalable solution design - Take on DBA responsibilities for the SBR database Qualifications Required: - Possess at least 5 years of experience as a SQL Developer or in a similar role - Demonstrate a strong understanding of system design and software architecture - Be capable of designing and building performant and scalable data infrastructure solutions - Proficiency in SQL and its variations among popular databases - Expertise in optimizing complex SQL statements - Solid grasp of API knowledge and data ingestion pipeline creation,