BI & Data Product Analyst

Job Purpose

We are seeking an exceptional Data Engineer – Data Product Analyst to join our dynamic Data and Analytics team at RWS. In this role, you will be heavily involved in working with ETL processes, SSIS packages, and data transformations, utilizing your expertise in advanced MS SQL/T-SQL code. Approximately 70% of your responsibilities will revolve around writing complex SQL code, developing jobs, procedures, functions, CTE data flows, data pipelines and solutions. Your ability to conduct rapid root cause analysis (RCA) for data issues will be crucial, demanding an acute attention to detail and a proactive approach to identifying potential risks resulting from script or process changes. This role requires a quantitative background (computer science or mathematics or similar) and the ability to optimise data processes. The ideal candidate should be self-reliant, accountable, possess exceptional technical skills, have a strong sense of ownership, and thrive in a collaborative team environment.  The main area of focus will be financial data.

About Group Technology

Group Technology plays a pivotal role in aligning the organization with its strategic objectives and enhancing shareholder value. Group Technology is responsible for establishing unified standards and governance practices throughout the company. Additionally, we oversee the development and maintenance of core applications essential for the seamless operation of various functions across the organization. We are committed to driving and executing future roadmaps that are in line with the overall strategic direction of RWS. 

With a global reach, Group Technology provides support services to over 7500 end users worldwide. We take pride in managing the information security operation and safeguarding all our assets. Our core functions encompass Enterprise & Technical Architecture, Network & Voice, Infrastructure, Service Delivery, Service Operations, Data & Analytics, Security & Quality Compliance, Transformation, Application Development, Enterprise Platforms, With a dedicated team of over 500 staff, Group Technology ensures a strong presence across all regions, enabling efficient and effective support to our global operations.

Job Overview

Key Responsibilities:

• Demonstrate a high level of proficiency in advanced T-SQL code, handling complex queries, data wrangling, transformation, optimisation, and performance tuning.
• Utilize your extensive experience with SSIS packages and ETL to design, develop, and maintain efficient data pipelines and workflows.
• Conduct rapid and thorough root cause analysis (RCA) for data issues, resolving them promptly to ensure data integrity and accuracy.
• Collaborate closely with business stakeholders to understand their requirements and use your deep understanding of different data structures and processes of the company to make relevant links between business needs and data solutions.
• Work with multiple systems and a diverse range of tables with varying logic, architecture, and keys, creatively finding effective and efficient methods to combine data and generate valuable insights and outputs.
• Engage in continuous learning and research to stay updated with the latest industry trends and best practices in data engineering and analytics.
• Proactively identify opportunities for process improvements and optimisations, streamlining data workflows to enhance overall productivity.
• Ensure comprehensive documentation of data pipelines, processes, and data mappings for ease of maintenance and knowledge sharing.
• Collaborate with the team to develop and maintain a robust data governance framework, adhering to data quality standards, privacy regulations, and best practices.
• Serve as a technical expert and a reliable resource for the team, offering guidance and mentorship to less experienced data engineers.

Required Skills and Qualifications:

• Bachelor's degree in computer science, mathematics,,,, statistics, engineering, finance or related fields.
• Proven experience (at least 5 years) in a similar role as a Data Engineer - Data Analyst,, predominantly focused on developing and optimising MS SQL/T-SQL code and SSIS packages. Preferably in financial data projects, preferably in financial data projects.
• SQL Server: Advanced proficiency in SQL Server (T-SQL) with hands-on experience using tools like SQL Server Management Studio (SSMS), SQL Profiler, and SQL Agent
• Advanced SQL Development: Expertise in writing complex SQL queries, joins, subqueries, and nested queries.
• Stored Procedures & Functions: Proficient in developing efficient stored procedures, functions, SQL Agent service to automate business logic/process.
• Query Performance Optimization: Experience in query optimization and resolving slow query performance, familiar with index and optimization strategies for indexes
• Data Integration/ETL Development: Experience in developing and maintaining ETL processes, ensuring seamless data flow across systems by using SSIS. Implement and maintain ETL processes to ingest, transform, and load data into SQL databases.
• Debugging, Error Handling & troubleshooting: Strong understanding of error handling, transactions, and rollback mechanisms within stored procedures, debugging and troubleshooting.
• Experience with Azure DevOps tools and version control (e.g., Git) for efficient project management.
• Understanding of financial data and processes, enabling seamless translation of business requirements into efficient data solutions.
• Strong interpersonal and communication skills, with experience in relationship building and stakeholder management. Ability to work independently and collaboratively in a team environment.
• Advanced excel knowledge (advanced functions, pivots, etc.)
• Utilize GIT, Teams, and the MS Office suite for effective collaboration and version control.

Good to Have:

• Some hand-on experience in project management would be advantageous.
• Scripting knowledge in Python, C#, or other languages for backend integration.
• Familiarity with other cloud ETL tools like ADF/Fivetran/Celigo/Airbyte etc.
• Understanding of NoSQL databases for handling unstructured or semi-structured data.
• Experience with cloud computing platforms (e.g.Azure, AWS, GCP) is a plus.
• Experience with data warehousing concepts is advantageous.
• Knowledge of data governance principles is welcome.
• Proficiency in using automation and orchestration tools like Apache Airflow or Kubernetes for managing data workflows.
• Cloud Databases: Familiarity with cloud-based SQL databases and cloud infrastructure.
• Experience with other databases like MySQL, PostgreSQL, and Azure SQL Database.
• Familiarity with BI tools (e.g., Power BI, SSRS) for reporting and data visualization.
• Data Warehousing: Knowledge of data warehousing concepts and ability to design data models for reporting and analytics.
• REST API, JSON experience

Life at RWS

At RWS, we’re here for one purpose: unlocking global understanding.

As a unique, world-leading provider of technology-enabled language, content, and intellectual property services, we remove the barriers to communication to make global connection possible. Our unrivalled experience and deep understanding of language have been developed over more than 60 years. As we look to shape the future, our ambition is to create a world where understanding is universal for everyone.

We work with over 80% of the world’s top 100 brands, more than three-quarters of Fortune’s 20 ‘Most Admired Companies’ and almost all the top pharmaceutical companies, investment banks, law firms and patent filers. Our client base spans Europe, Asia Pacific and North and South America. Our 65+ global locations across five continents service clients in the automotive, chemical, financial, legal, medical, pharmaceutical, technology and telecommunications sectors.   

Over the past 20 years we’ve been evolving our own AI solutions as well as helping clients to explore, build and use multilingual AI applications. With 45+ AI-related patents and more than 100 peer-reviewed papers, we have the experience and expertise to support clients on their AI journey.

If you like the idea of working with smart people who are passionate about breaking down language barriers and giving back to their communities, then you’ll love life at RWS. Our work fundamentally recognizes the value of every language and culture. So, we celebrate difference, we are inclusive and believe that diversity makes us strong.

We want every employee to grow as an individual and excel in their career. In return, we expect all our people to live by the values that unite us: to partner with colleagues and clients, to adopt a pioneering spirit, to be positive in progressing the work we do, and always to deliver what we promise. 

RWS Values 

                  Get the 3Ps right – Partner, Pioneer, Progress – and we´ll Deliver together as One RWS.

For further information, please visit: RWS   

RWS embraces DEI and promotes equal opportunity, we are an Equal Opportunity Employer and prohibit discrimination and harassment of any kind. RWS is committed to the principle of equal employment opportunity for all employees and to providing employees with a work environment free of discrimination and harassment. All employment decisions at RWS are based on business needs, job requirements and individual qualifications, without regard to race, religion, nationality, ethnicity, sex, age, disability, or sexual orientation. RWS will not tolerate discrimination based on any of these characteristics

Recruitment Agencies: RWS Holdings PLC does not accept agency resumes.  Please do not forward any unsolicited resumes to any RWS employees.  Any unsolicited resume received will be treated as the property of RWS and Terms & Conditions associated with the use of such resume will be considered null and void.