SAP Data Integration & Technical Architect

Celeros Flow Technology LLC; Glasgow; On-site; GBP 70,000 - 110,000; Full time

Job summary

Celeros Flow Technology is seeking an experienced SAP Technical Expert to lead the design, development, and optimisation of SAP data extraction and integration into a Microsoft SQL Server Data Warehouse environment.

You will work on SAP database structures, data models, ETL design, data governance, and reliable SAP data delivery for enterprise reporting and analytics. Strong knowledge of SAP data architecture and SQL Server is essential.

Qualifications

• 5+ years of SAP technical experience.
• Strong SQL Server development and administration experience.
• Experience designing enterprise Data Warehouse solutions.
• Advanced SQL development skills.

Responsibilities

• Analyse SAP database structures and data models for analytics.
• Design scalable SAP data extraction and integration strategies.
• Develop ETL/ELT pipelines to load SAP data into SQL Server DW.
• Collaborate with BI developers and business stakeholders.
• Provide technical guidance on SAP data structures and source systems.
• Produce technical documentation and architecture diagrams.

Skills

SAP Expertise

SQL Server

ETL Design

Data Modeling

SSIS

Azure Data Factory

SAP Data Services

Power BI

Education

Degree in Computer Science/Information Systems

SAP Certification desirable

Microsoft SQL Server or Azure Data certs desirable

Tools

SSIS

Azure Data Factory

SAP Data Services (BODS)

Power BI

Job description

Celeros Flow Technology, LLC For over 140 years our products have helped ensure the safe, reliable operations of key industries. With a passion for precision and partnership, Celeros Flow Technology continues this heritage of high performance and dependability, providing mission critical, sustainable flow control solutions for our customers around the globe.

Celeros Flow Technology is looking for individuals with a voice and a vision. We embrace change, diversity and promote new ways of looking at old ideas. We seek talented professionals to join our world-class team of innovators in a global, collaborative & multi-cultural environment, where you will be challenged, supported, and inspired to be extraordinary.

General Summary

We require an experienced SAP Technical Expert to lead the design, development, and optimisation of SAP data extraction and integration solutions into a Microsoft SQL Server Data Warehouse environment.

The role will focus on SAP database structures, SAP data models, ETL design, data governance, and the reliable delivery of SAP data for enterprise reporting, analytics, and BI platforms.

The successful candidate will possess deep technical knowledge of SAP data architecture and database infrastructure, with hands‑on experience extracting SAP data from SAP environments and integrating it into SQL Server-based data warehouses.

Principal Duties & Responsibilities

• SAP Data Architecture
• Analyse and document SAP database structures, data models, and business processes.
• Identify and map SAP master, transactional, and reference data required for analytics and reporting.
• Design scalable SAP data extraction and integration strategies.
• Define and maintain SAP-to-Data Warehouse data models.
• Data Warehouse Integration
• Design, build, and support processes to extract SAP tables into Microsoft SQL Server Data Warehouse platforms.
• Create and maintain ETL/ELT pipelines for loading SAP data into staging, operational, and dimensional warehouse layers.
• Develop data transformation logic and business rules to ensure data consistency and quality.
• Optimise data loads for performance and scalability.
• Technical Development
• Develop and maintain SAP extraction
• Design SQL Server database schemas, stored procedures, and integration processes.
• Support data modelling activities including star schemas, dimensions, and fact tables.
• Stakeholder Engagement
• Collaborate with Business Analysts, BI Developers, and business stakeholders.
• Provide technical guidance on SAP data structures and source system capabilities.
• Support reporting and analytics initiatives across the organisation.
• Operational Support
• Troubleshoot SAP extraction and integration issues.
• Monitor and optimise existing data pipelines.
• Support upgrades, migrations, and SAP environment changes.
• Produce technical documentation and architecture diagrams.

Knowledge, Skills & Abilities

• SAP Expertise
• 5+ years of SAP technical experience.
• Strong understanding of SAP database architecture and data structures.
• Knowledge of core SAP modules Database & Data Warehouse Skills
• Strong SQL Server development and administration experience.
• Experience designing enterprise Data Warehouse solutions.
• Advanced SQL development skills.
• Strong understanding of relational and dimensional data modelling.
• Data Integration Skills
• Experience with one or more of:
• SQL Server Integration Services (SSIS)
• Azure Data Factory
• SAP Data Services (BODS)
• Other enterprise ETL tools
• Technical Skills
• SAP extractors and data provisioning techniques.
• Performance tuning and optimisation.
• Data quality and reconciliation methodologies.
• Source-to-target mapping design.
• Desirable Skills
• Microsoft Fabric.
• Power BI.
• SAP Datasphere.
• Data Vault modelling.
• Experience supporting cloud-based data platforms.
• Deliverables
• SAP data extraction framework.
• Source-to-target data mappings.
• SQL Server Data Warehouse design.
• Automated SAP data ingestion processes.
• Data quality and reconciliation controls.
• Technical architecture and operational documentation.

Education & Experience

• Degree in Computer Science, Information Systems, Data Engineering, or related discipline.
• SAP Technical Certification desirable.
• Microsoft SQL Server or Azure Data certifications desirable.

Applicants must have the legal right to work in the UK for this role.

PHYSICAL DEMANDS

• Required daily to stand, sit, walk, talk, hear, and see (specific close vision abilities are required to perform computer work)
• Required occasionally to stoop, kneel, crouch and crawl
• Required daily to use hands and fingers and arms to reach (to operate a computer and telephone)
• Required occasionally to lift and/or move objects that are light to moderate
• Required occasionally to travel (usually by air or road so may be required to sit for extended periods)

WORKING CONDITIONS

• Ability to work with moderate noise (i.e. business office with computers, phone, and printers, etc.)
• Ability to work in an open planned office / individual office
• Ability to sit at a computer terminal for extended periods
• Ability to sit in a car or on a plane for extended periods

DISCLAIMER

The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not intended to be construed as an exhaustive list of all responsibilities, duties and skills required of personnel so classified.

Reasonable accommodations may be made to enable qualified individuals with disabilities to perform the essential functions.

CELEROS FLOW TECHNOLOGY VALUES

All Celeros divisions are committed to the effective use of the Celeros Values. It is important that all employees understand and utilize these values when performing the duties of his/her position.

INTEGRITY: We work safely and respect our employees, business partners & environment. We always lead by example.

SPEED: In our mission to bring mission‑critical flow control equipment to the world, energy in our actions & urgency.

ACCOUNTABILITY: We stand behind our actions and deliver on our promises.

PARTNERSHIP: We collaborate across our teams & our customers to win together. We rely on each other to deliver the best outcome & celebrate successes.

EXCELLENCE: We are passionate about being the best at engineering, manufacturing & maintaining mission‑critical equipment. We seek quality & community improvement in every interaction.

QUALITY: Quality encompasses all aspects of Celeros’ business, and every employee shares the responsibility to prevent the occurrence of any nonconformity relating to product, process and the quality system. All employees have an obligation to identify and record any such nonconformity, and through designed channels, initiate and recommend solutions.

CELEROS Flow Technology is an equal opportunity employer.