SAP/BW Data Warehouse Analyst
Role details
Job location
Tech stack
Job description
Career Pathways: Progression Pathways for all People Leader and Technical roles with internal and external training courses available to support development. Raytheon UK has an opportunity for an experienced IT professional to support ERP BW development. The function sits within the Digital Technology team and is responsible for the delivery and support of application solutions to all UK based divisions to successfully enable operational business and operational delivery. This role is responsible for supporting and maintaining the full application life cycle and day-to-day operation along with servicing any new business requirements / configuration changes and new stand-ups, utilising industry standard best practice. It will also play a major part in understanding new business requirements, testing and integration other applications to integrate data between application. The successful candidate shall deliver support, maintain and develop BW data warehouse and reporting solutions within Raytheon UK. The role demands an in-depth knowledge of data warehousing and data management, database design and troubleshooting of performance issues. What you'll be doing: Work with other functional / business teams to deliver business systems to meet functional / business requirements. Works closely with other staff and functional users, ensuring systems or changes are delivered in a timely and effective manner. Works directly with the functional / business user community on bug fixes, request for service and approved changes to current systems and new applications Ensure the ongoing availability of Raytheon systems solutions working toward improved system productivity. Provide system support in response to business needs within published service levels - respond to and resolve break fixes and execute preventative maintenance solutions. Ensure integrity, availability & security of information and systems Activities include: Business analysis and requirements capture, using an understanding of the business domain and processes Systems analysis, programming and testing Data analysis & design System implementation including training, support, problem resolution Development of documentation for technologists and users Respond and resolve break fixes, and execute preventative maintenance solutions Analyse, design, code, test, implement, document and support development and enhancements to RSL applications and interfaces Monitor Helpdesk and Change Control systems for incoming work Update configuration / change management tools and ensure System Maps reflect any changes to application portfolio Working with vendors to deliver requirements & resolve issues Occasional visits to other RSL sites and customer/partner organisations may be required Your skills: Educated to degree level or equivalent, with strong SAP Business Warehouse and Abap programming experience SAP NetWeaver BW Dataflows (3.x & 7.x) SAP Business Explorer Toolset (including Query Designer and Web Analyser) General knowledge of wide range of IT technologies and activities, with specific knowledge of one or more technology fields. Use of formal systems delivery methodologies. Experience of delivering and supporting business critical application packages within a large organisation It would be great if you have : Knowledge and operational experience in a manufacturing and / or defence industry Add CPS job scheduler (SAP Business Process Automation by Redwood) Good understanding SAP BW - to include Dataflows (3.x & 7.x), InfoObjects, Datasources, DSOs, Cubes and Multiprovider Ability to administer Process Chains and resolve data loading issues Experience with BEx query designer, Analyzer and Web Application Designer. Support ad-hoc end-user requests, such as general BEx questions, and investigating perceived data anomalies or unexpected query results Perform regular monitoring of BW batch activity as part of wider service status & alerting framework Engage with cross-functional contacts as necessary in support of data insights needs of Raytheon Technologies, for existing services, and towards design, implementation, transition & support of future service needs. Personal Characteristics Works well in a team
Requirements
Effectively uses the specialist resources and knowledge of team mates to achieve working solutions Logical - analytical thinking Innovative Customer focus Flexibility Disciplined, organised and self motivated Able to manage multiple conflicting priorities and deadlines
Benefits & conditions
Appreciates the need and benefits for controlled process and standards What we offer: Competitive salaries. 25 days holiday + statutory public holidays, plus opportunity to buy and sell up to 5 days (37hr) Contributory Pension Scheme (up to 10.5% company contribution) Company bonus scheme (discretionary). 6 times salary 'Life Assurance' with pension. Flexible Benefits scheme with extensive salary sacrifice schemes, including Health Cashplan, Dental, and Cycle to Work amongst others. Enhanced sick pay. Enhanced family friendly policies including enhanced maternity, paternity & shared parental leave. Work Culture 37hr working week, although hours may vary depending on role, job requirement or site-specific arrangements. Remote, hybrid and site based working opportunities, dependant on your needs and the requirements of the role. A grownup flexible working culture that is output, not time spent at desk, focussed. More formal flexible working arrangements can also be requested and assessed subject to the role. Please enquire or highlight any request to our Talent Acquisition team to explore the flexible working possibilities. Up to 5 paid days volunteering each year.