Data Engineer

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, potentially utilizing Azure Data Lake and SQL Server. Your primary focus will be on constructing efficient ELT pipelines, APIs, and database architectures to facilitate the 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. Your responsibilities will include designing and implementing scalable database and data warehouse solutions, establishing and managing data ingestion pipelines for both batch and real-time integration, defining and maintaining relational schema and metadata frameworks, and supporting the development of a centralized data repository for unified reporting and analysis. Furthermore, you will optimize database structures and queries for performance and scalability, while also documenting and version controlling all data pipeline and architecture components. In addition to your focus on centralizing data infrastructure, you will address ad hoc data solution requirements to ensure the continuity of business operations. You will develop and maintain robust APIs for internal and external data exchange, facilitate efficient data flow between operational systems and reporting platforms, and support system integrations with various tools such as CRM, finance, operations, and marketing. You will collaborate with IT and compliance personnel to enforce access control, encryption, and PII protection across all data solutions, as well as ensure compliance with data protection regulations such as GDPR. Promoting and upholding data quality, governance, and security standards will be an integral part of your role. Acting as a subject matter expert, you will provide guidance on best practices in data engineering and cloud architecture, offer ongoing support to internal teams on performance optimization and scalable solution design, and take on DBA responsibilities for the SBR database. To be successful in this role, you should 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, and 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, and a solid grasp of API knowledge and data ingestion pipeline creation are essential skills for this position.,