We are seeking an exceptional Data Engineer - Data 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 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.
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.
Skills & Experience
- 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
- Bachelor's degree in computer science, mathematics,,,, statistics, engineering, finance or related fields