Design, develop, and maintain scalable data integrations between internal and external systems.
Build and optimise ETL/ELT pipelines to support operational and analytical workloads.
Implement batch, event-driven, and near real-time data ingestion approaches where required to support evolving business needs.
Proactively monitor pipelines and data workflows, resolving issues relating to data integrity, performance, reliability, and scalability to ensure data quality, consistency, and reliability across all integration points.
Work with manufacturers, suppliers, customers, and internal teams to integrate, process, and validate pricing data, identifying opportunities to automate repetitive price list updates.
Design and implement API-based integrations and reusable ingestion frameworks, including handling authentication, rate limits, pagination, schema evolution, and error handling.
Implement best practices for API performance, versioning, and documentation.
Develop and maintain data models and optimised datasets for business intelligence tools such as Power BI and Bold BI, supporting operational and strategic reporting requirements.
Work cross-functionally with Product Managers, development teams, account managers, professional services, and other stakeholders while contributing to improvements in data architecture, automation practices, and data governance standards, and supporting ad-hoc tasks as required.
Implement data validation, monitoring, and error handling processes.
Champion best practices for data security, privacy, and compliance.
Requirements
Strong experience with ETL/ELT tools and data pipeline development.
Hands-on experience with data integration platforms or messaging technologies.
Knowledge of Apache Nifi workflows and maintaining them.
Knowledge of databases including the use of SQL to query and manage data.
Proven working experience as a data analyst or business data analyst.
Technical expertise regarding data models, database design development, data mining and segmentation techniques.
Strong analytical skills with the ability to collect, organize, analyse, and disseminate significant amounts of information with attention to detail and accuracy.
Experience designing and supporting APIs (REST, GraphQL, or similar).
Knowledge of statistics and experience using statistical packages for analysing datasets (Excel, Power BI, Bold BI etc.).
Advance Microsoft Office skills.
Strong problem solving skills and the ability to work with complex datasets.
BSc or equivalent qualification in either Mathematics, Economics, or Statistics, or a related discipline, or equivalent experience.