Data Engineer

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.

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.

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

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

• Infrastructure as Code:
  Experience using Terraform to provision cloud resources.
• Dev Ops Mindset:
  Familiarity with CI/CD pipelines (Git Hub 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.

In accordance with applicable pay transparency legislation, candidates will be informed of the salary range for this position prior to interview. Pay is…