Data Engineer - senior

Job Purpose As a Data Engineer at RWS, you will be a key architect of our data's journey. We are currently in an exciting phase of technical evolution, bridging the gap between established on-premises systems and cutting-edge cloud environments. You will play a vital role in managing this hybrid landscape, ensuring that our data flows seamlessly across an extensive on-premise SQL Server estate and a target Google Cloud Platform (GCP) architecture. You’ll have end-to-end ownership of data pipelines—from the initial ingestion of raw source data to the monitoring of production environments. Your work will directly enable our Analytics and AI teams to build the future of global language services. If you enjoy solving complex "plumbing" problems and building scalable, high-performance data systems, you'll find a home here. About Product & Technology Product & Technology plays a pivotal role in aligning the organization with its strategic objectives and enhancing shareholder value. Product & 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, Product & 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, Product & Technology ensures a strong presence across all regions, enabling efficient and effective support to our global operations. Job Overview Key Responsibilities Architect Hybrid Pipelines: You'll build and manage robust data pipelines that bridge on-premise SQL Server environments and GCP in the cloud. Modernize Data Ingestion: You will implement Change Data Capture (CDC) and streaming updates to ensure our cloud data stays synchronized and fresh. Optimize for Performance: You’ll design and refine BigQuery architectures, focusing on partitioning and clustering to ensure high-speed, cost-effective querying. Orchestrate Workflows: You will use tools like Cloud Composer (Airflow) and Dataform, SSRS and Databricks to schedule and monitor complex, multi-stage data workflows. Maintain Data Integrity: You’ll own the health of your pipelines, troubleshooting failures and ensuring data quality across Star and Snowflake schemas. Collaborate Across Teams: You’ll act as a technical partner to analysts and business leads, translating their needs into efficient technical requirements. Skills & Experience Proven Data Background: Experience in data engineering or warehousing, specifically owning the full lifecycle of a data pipeline. SQL Server Expertise: Mastery of T-SQL (stored procedures, CTEs, tuning) and experience moving data via SSIS or similar tools. Cloud Proficiency: Hands-on experience with GCP, particularly BigQuery and Cloud Storage (GCS). Python Programming: Strong skills in Python for scripting, API interactions, and data manipulation (Pandas or PySpark). Modern Data Modelling: Deep understanding of dimensional modelling and designing scalable schemas. Experience with Orchestration & Integration: Familiarity with tools like Cloud Dataflow, Dataproc, or Cloud Composer. Beneficial Skills Infrastructure as Code: Experience using Terraform to provision cloud resources. DevOps Mindset: Familiarity with CI/CD pipelines (GitHub Actions/Jenkins) and Git version control. Real-time Data: Experience using Pub/Sub for messaging and streaming ingestion. Data Mesh: Knowledge or experience of implementing a Mesh and Data Products. Life at RWS Life at RWS - If you like the idea of working with smart people who are passionate about growing the value of ideas, data and content by making sure organizations are understood, then you’ll love life at RWS. Our purpose is to unlock global understanding. This means 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 , putting clients fist and winning together , to pioneer , innovating fearlessly and leading with vision and courage, to progress , aiming high and growing through actions and to deliver , owning the outcome and building trust with our colleagues and clients. 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. RWS Values Get the 3Ps right – Partner, Pioneer, Progress – and we´ll Deliver together as RWS. 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.