Data Analytics Developer

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

The Data Analytics Developer will be a member of a global team with a key emphasis on providing development and maintenance for SAP Data Services, ETL process, and PBI Reporting. This individual will work with the Data Analytics Analyst and business units to document field mapping, business rules, and business logic required to transform master and transactional data from various ERP systems into the analytical databases and Power BI Reports.

 

This individual will design and deliver the end-to-end ETL process and Data Analytics technology infrastructure that will feed data to dashboards, scorecards, standard reports, and ad hoc reports. The Data Analytics Developer has proven experience providing technology solutions, in both SAP Business Object Data Services (BODS) and Power BI (PBI), to support key business processes and providing troubleshooting support within a global manufacturing environment. This individual will report to the Manager of the Data and Analytics Team.

 

 

Principle Duties and Responsibilities

• Develop and maintain ETL process in SAP Business Objects Data Services (BODS) for source SAP and non-SAP systems and target OLAP systems (SQL, etc.).
• Design, estimate and create project plan for development, testing, and implementation of ETL, PBI reports process and related tasks.
• Document mapping and transformation rules from source system fields in SAP (S3) and non-SAP ERP systems to database.
• Proficiency in database systems and SQL for data extraction, transformation, and loading.
• Design, implement, and support Power BI data models, data flows, dashboards, and visualizations ensuring optimal performance and ease of use.
• Use DAX (Data Analysis Expressions) to create custom calculations, measures, and KPIs.
• Monitor BODS/PBI jobs and dataflows, perform fast troubleshooting and root cause analysis, and provide fast turnaround with a resolution of job failure and any other issues in the BODS/PBI production system.
• Create documentation to assist business users and IT members effectively using the solutions developed.
• Troubleshoot and resolve issues with BODS and Power BI systems in a global manufacturing environment.
• Work closely with cross-functional teams including data analysts, IT, and business users to gather, analyze, and test data requirements.

 

 

Knowledge, Skills and Abilities

• Ability to handle multiple demands with a sense of urgency, drive and energy
• Ability to learn quickly in a challenging environment and work as part of a team or independently to achieve objectives
• Strong problem solving skills and technical aptitude
• Strong verbal and written communication skills
• Experience working in an Agile project environment
• 5+ years of hands-on experience in Power BI development and data visualization.
• 5+ years of demonstrated technical mastery of Design, Development, Deployment, Administration of SAP Business Objects Data Services and MSFT ETL applications.
• 5+ years of experience developing ETL process with SAP and non-SAP source systems.
• 5+ years of experience working with SAP (ECC6), SQL, and other data warehouse & OLAP
• applications
• Experience in designing SAP Data Services job flows to extract from and load to SAP systems and SQL Servers, including delta loads to improve ETL performance.
• Sound knowledge of SAP FICO, SD, MM/Pur, PP data and tables.
• Sound knowledge of BODS scheduling and Management Console.
• Strong knowledge of SQL, star schema, data modelling and data warehouse concepts.
• Solid Experience with Data Integration transforms such as Query, Validation, Case transforms and Data Quality transforms such as Match, Associate, and Data Cleanse.
• Experience with creating and maintaining SQL servers and databases.
• Solid experience in building Power BI data models, reports, and dashboards
• Experience Architecting Data model in PowerBI with complex joins, and developing Power automate workflows.
• Proficient in building DAX queries in Power BI desktop.
• Experience in creating the technical design, architecture, and data flow diagrams for BI and analytics applications.
• Experience with Azure services like Azure Data Factory, Azure SQL Database, or Azure Synapse Analytics.

 

 

Mandatory Education and Experience

• B. Tech/B. E/MCA/Masters in Business Systems Analysis in a relevant stream through the regular course from recognized university and institute in India
• 5+ years of relevant experience in SAP BODS and ETL applications and working in a global organization
• 5+ years of relevant experience in Power BI and SQL Server
• One or more business intelligence certifications (PBI, SAP, Microsoft SQL/Azure, GCP, etc.)

 

 

YOU MUST HAVE VALID RIGHT TO WORK IN THE UK TO APPLY FOR THIS ROLE.

 

 

BENEFITS

• Competitive salary
• Opportunities to develop
• Bonus
• 33 days holiday (inclusive of bank holidays)
• Holiday buy and sell
• Pension
• Life Cover
• Employee Assistance Program
• Digital Benefits; Health, Wealth & Lifestyle

 

 

PHYSICAL DEMANDS

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)

 

 

WORKING 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.

• 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.