SAP Data Integration & Technical Architect

Celeros Flow Technology
UK
16 days ago
Apply on www.adzuna.co.uk
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
5 years minimum
Compensation
Β£50,887.0
Working hours
Regular working hours

Tech stack

Data Analysis Business Intelligence Development Information Systems Databases Computer Terminals Information Engineering Data Governance Data Infrastructure Data Integration Extract Transform Load (ETL) Data Mapping Data Transformation
+20 more
Data Structures Data Vault Modeling Data Warehousing Database Storage Structures Desktop Computing Microsoft SQL Server Performance Tuning Reference Data SAP (Applications) SAP NetWeaver Data Management SAP Materials Management SQL Stored Procedures SQL Server Integration Services Systems Integration Cloud Platform System Azure Data Factory Microsoft Fabric SAPBasis Information Technology Data Pipelines

Job description

  • 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., The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job.Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
  • 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), 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.

Requirements

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., * 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., * 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

Benefits & conditions

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

About the company

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.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.adzuna.co.uk
Prepare application

Good distractions

Loading talks and stories from around this role…