Data Engineer - Financial Analytics Specialist

Job Purpose -

We are seeking a Data Engineer Financial Analytics Specialist to join our Data and Analytics team at RWS. This role combines advanced technical skills in SQL and ETL with analytical thinking and financial business acumen. You will be instrumental in designing and implementing data transformations and pipelines to support complex business requirements, particularly in financial data systems. This is a hands-on technical role with a significant focus on problem-solving, mathematical reasoning, and creating solutions for intricate business processes.

This position is ideal for someone with a quantitative background in computer science, mathematics, or a related field, who thrives on developing innovative solutions, optimizing data workflows, and ensuring data accuracy. We are looking for a candidate who is self-motivated, detail-oriented, and possesses exceptional technical skills, alongside a strong sense of ownership and accountability. The primary focus of this role will be financial data projects within a collaborative and dynamic team environment.

About Group Technology-

Group Technology enables the organization to achieve its strategic direction whilst driving shareholder value. The division establishes common standards and IT governance across the business. It further develops and manages core applications enabling smooth operational running of the organization across all functions. We drive and deliver future roadmaps aligned to the overall strategic direction of the business. Group Technology support services to over 7500 end users across the globe, manage the information security operation and safeguard all our assets. Our core Group Technology functions include Technical Architecture, Network & Voice, IT Security, Service Delivery, Solutions Delivery and Asset Management. Group Technology has a global presence across all regions with over 400 staff.

Our Data Engineering team is responsible for developing, building, maintaining, and managing data pipelines. This requires working with large datasets, databases, and the software used to analyse them including cloud systems like AWS or Azure.

Job Overview

Key Responsibilities

We are seeking a Data Engineer Financial Analytics Specialist to join our Data and Analytics team at RWS. This role combines advanced technical skills in SQL and ETL with analytical thinking and financial business acumen. You will be instrumental in designing and implementing data transformations and pipelines to support complex business requirements, particularly in financial data systems. This is a hands-on technical role with a significant focus on problem-solving, mathematical reasoning, and creating solutions for intricate business processes.

This position is ideal for someone with a quantitative background in computer science, mathematics, or a related field, who thrives on developing innovative solutions, optimizing data workflows, and ensuring data accuracy. We are looking for a candidate who is self-motivated, detail-oriented, and possesses exceptional technical skills, alongside a strong sense of ownership and accountability. The primary focus of this role will be financial data projects within a collaborative and dynamic team environment.

Key Responsibilities

• Write advanced T-SQL queries, stored procedures, and functions to handle complex data transformations, ensuring optimal performance and scalability.
• Perform query performance optimization, including indexing strategies and tuning for large datasets.
• Design, develop, and maintain ETL/ELT pipelines using tools like SSIS, ADF, or equivalent, ensuring seamless data integration and transformation.
• Build and automate data workflows to support accurate and efficient data operations.
• Collaborate with stakeholders to understand financial business processes and requirements.
• Develop tailored data solutions to address challenges such as cost allocation, weighted distributions, and revenue recognition using mathematical and logical reasoning.
• Conduct root cause analysis for data issues, resolving them swiftly to ensure data accuracy and reliability.
• Apply critical thinking and problem-solving to transform business logic into actionable data workflows.
• Partner with cross-functional teams to ensure data solutions align with business objectives.
• Document data workflows, pipelines, and processes to support ongoing maintenance and scalability.

Required Skills and Experiences

• Minimum 5+ years of experience require in the similar role or same skillset
• Advanced proficiency in T-SQL and SQL Server, including tools like SSMS, SQL Profiler, and SQL Agent.
• Proven experience developing and optimizing complex queries, stored procedures, and ETL pipelines.
• Proficiency with SSIS for data integration and transformation.
• Strong critical thinking and mathematical reasoning skills to design efficient solutions for business problems.
• Demonstrated ability to handle complex financial data challenges, including proportional distributions and other mathematical transformations.
• Solid understanding of financial concepts and processes, enabling seamless translation of business needs into data solutions.
• Ability to work effectively with business stakeholders, translating requirements into technical solutions.
• Excellent interpersonal and communication skills, fostering collaboration across teams.
• Familiarity with Python, C#, or similar scripting languages for backend integration.
• Experience with cloud ETL tools such as Azure Data Factory (ADF), Fivetran, or Airbyte.
• Knowledge of data governance and compliance principles.

Shift Timings-

There will be UK shift timings - 1:30 PM 9:30 PM (IST)

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.