Senior Data Engineer I

at  LexisNexis

Senior Data Engineer I
Are you an experienced Redshift developer with a ‘can do’ attitude and enthusiasm that inspires others?
Do you enjoy being part of a team that works with a diverse range of technologies?
About our Team
LexisNexis Legal & Professional, which serves customers in more than 150 countries with 11,800 employees worldwide, is part of RELX, a global provider of information-based analytics and decision tools for professional and business customers. Our company has been a long-time leader in deploying AI and advanced technologies to the legal market to improve productivity and transform the overall business and practice of law, deploying ethical and powerful generative AI solutions with a flexible, multi-model approach that prioritizes using the best model from today’s top model creators for each individual legal use case.
About the Role
As a Senior Data Engineer, you will be responsible for designing, developing, and maintaining analytical solutions. You will do so using Amazon Redshift and Tableau. You will apply your solid understanding of data modeling, SQL querying, data analysis and data presentation techniques.

Responsibilities

• Designing and developing scalable data models and analytical solutions using Amazon Redshift, ensuring efficient data storage, retrieval, and processing.
• Developing and optimizing complex SQL queries and analytical procedures to extract insights from large datasets stored in Redshift.
• Designing and developing Tableau dashboards to surface and present data analytics to the organisation.
• Implementing data quality checks, data transformations, and data cleansing processes to ensure the integrity and accuracy of analytical data.
• Developing and maintaining ETL (Extract, Transform, Load) processes to integrate data warehouse.
• Optimizing Redshift database performance by implementing partitioning strategies, indexing, query tuning, and workload management.
• Implementing data security and access controls within Redshift to ensure data privacy and compliance.
• Participating in code reviews, knowledge-sharing sessions, and continuous improvement initiatives to maintain best practices.

Requirements

• Have a BSC degree in computer science or equivalent.
• Have experience with Amazon Redshift and Microsoft BI systems, including data modelling, SQL querying, and performance tuning. Experience in PowerBI and Tableau.
• Be proficient in SQL and experience with analytical tools and techniques (e.g., data mining, statistical analysis, machine learning).
• Expertise in development languages including but not limited to: Java/J2EE, JavaScript, JSP, C/C++, HTML, XML, SQL, Windows, .NET, Unix, HPCC.
• Have knowledge of data warehousing concepts, dimensional modelling, and data integration best practices.
• Be able to write and review portions of detailed specifications for the development of complex system components.
• Have knowledge of test-driven development.
• Be able to troubleshoot and resolve process inefficiencies (i.e. bugs) in the repository.

Work in a way that works for you

We promote a healthy work/life balance across the organisation. We offer an appealing working prospect for our people. With numerous wellbeing initiatives, shared parental leave, study assistance and sabbaticals, we will help you meet your immediate responsibilities and your long-term goals.

• Working flexible hours - flexing the times when you work in the day to help you fit everything in and work when you are the most productive.

Working for you

We know that your well-being and happiness are key to a long and successful career. These are some of the benefits we are delighted to offer:

• Medical Aid
• Retirement Plan inclusive of Risk Benefits (Disability, Critical Illness, Life Cover & Funeral Cover)
• Modern family benefits, including adoption and surrogacy
• Study Leave

About the Business
LexisNexis Legal & Professional® provides legal, regulatory, and business information and analytics that help customers increase their productivity, improve decision-making, achieve better outcomes, and advance the rule of law around the world. As a digital pioneer, the company was the first to bring legal and business information online with its Lexis® and Nexis® services.
LexisNexis, a division of RELX, is an equal opportunity employer: qualified applicants are considered for and treated during employment without regard to race, color, creed, religion, sex, national origin, citizenship status, disability status, protected veteran status, age, marital status, sexual orientation, gender identity, genetic information, or any other characteristic protected by law. We are committed to providing a fair and accessible hiring process. If you have a disability or other need that requires accommodation or adjustment, please let us know by completing our Applicant Request Support Form:
https://forms.office.com/r/eVgFxjLmAK
, or please contact 1-855-833-5120.
Please read our
Candidate Privacy Policy

Responsibilities

• Designing and developing scalable data models and analytical solutions using Amazon Redshift, ensuring efficient data storage, retrieval, and processing.
• Developing and optimizing complex SQL queries and analytical procedures to extract insights from large datasets stored in Redshift.
• Designing and developing Tableau dashboards to surface and present data analytics to the organisation.
• Implementing data quality checks, data transformations, and data cleansing processes to ensure the integrity and accuracy of analytical data.
• Developing and maintaining ETL (Extract, Transform, Load) processes to integrate data warehouse.
• Optimizing Redshift database performance by implementing partitioning strategies, indexing, query tuning, and workload management.
• Implementing data security and access controls within Redshift to ensure data privacy and compliance.
• Participating in code reviews, knowledge-sharing sessions, and continuous improvement initiatives to maintain best practices

We promote a healthy work/life balance across the organisation. We offer an appealing working prospect for our people. With numerous wellbeing initiatives, shared parental leave, study assistance and sabbaticals, we will help you meet your immediate responsibilities and your long-term goals.

• Working flexible hours - flexing the times when you work in the day to help you fit everything in and work when you are the most productive