Job Description

Job OverviewKey ResponsibilitiesThe primary focus of a data engineer is to ensure that data flows smoothly from its source to its destination efficiently and securely. The data engineer is the first line of data cleaning and wrangling. They are responsible for: * Ensuring the accuracy of data

• Promoting data quality
• Transforming data into more useful formats. This can involve writing code to automate processes, leveraging machine learning algorithms to detect patterns or anomalies in data, or utilizing algorithms to identify correlations.

Skills & ExperienceMicrosoft SQL Server:

• Proficient in Microsoft SQL Server, including database design, optimization, and maintenance.
• Skilled in T-SQL (Transact-SQL): Strong command over T-SQL for writing stored procedures, functions, views, triggers, and complex queries.
• Management, configuration, and monitoring of SQL Jobs, along with expertise in SQL Agent service.
• Experience in performance tuning and query optimization for large datasets.

SSIS (SQL Server Integration Services):

• Expertise in designing and implementing ETL (Extract, Transform, Load) packages/processes using SSIS.
• Knowledgeable in creating and overseeing data ingestion for efficient integration from diverse sources (MySQL, PostgreSQL, MSSQL, CSV/Excel, etc.).
• Experience with data cleansing, transformation, and loading strategies.

Monitoring and Troubleshooting:

• Experience in implementing monitoring solutions to track the performance of ETL processes and databases.
• Strong troubleshooting skills to identify and resolve issues in data pipelines and databases.

C#:

• Proficient in C# programming language, with a focus on data manipulation and processing.
• Ability to develop custom components and scripts within the SSIS framework using C#. Along with that experience in developing standalone class libraries using C#.
• Knowledge of the .NET framework and its integration with SQL Server.

Additional SkillsAzure:

• Experience with Azure Cloud and its associated services in the realm of data engineering.
• Proficient in using Azure Data Factory for building, orchestrating, and automating data workflows.
• Knowledge of integrating data engineering solutions with other Azure services, such as Azure SQL Database, Azure Blob Storage, Azure Data Lake Storage, and other Azure data services.
• Experience using Databricks and Python (or Azure Synapse/ MS Fabric)

General

• Familiarity with version control systems like Git/Azure DevOps repos for managing codebase.
• Strong problem-solving skills and the ability to troubleshoot issues in data pipelines.
• Understanding of data security and compliance standards.
• Effective communication skills for collaborating with cross-functional teams.
• Bachelor\xe2\x80\x99s degree in computer science, Computer Engineering, or a closely related field.
• Required minimum of 4-5 years development experience.

Life at RWSAt RWS, we\xe2\x80\x99re 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\xe2\x80\x99s top 100 brands, more than three-quarters of Fortune\xe2\x80\x99s 20 \xe2\x80\x98Most Admired Companies\xe2\x80\x99 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.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\xe2\x80\x99ll 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 ValuesGet the 3Ps right \xe2\x80\x93 Partner, Pioneer, Progress \xe2\x80\x93 and we\xc2\xb4ll Deliver together as One RWS.For further information, please visit: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 characteristicsRecruitment 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.

RWS