Customer Data Engineer

Role ProfileThe Customer Data Engineer is an exciting role within the Data Services team at Lloyd’s List Intelligence, the global leaders in geospatial Big Data vessel tracking and analysis of more than 400,000 ships. This role will be part of a team that is responsible for delivering tailored data sets to customers as well as driving continual enhancements to our data quality to improve our customer experience and support revenue growth.This position presents an exciting opportunity for a results-driven individual with a strong understanding of complex data structures and database manipulation and willing to learn more about commercial decision-making and gain a deeper understanding of customer-led product development. Maritime knowledge would be a distinct advantage but much more important is a passion for large scale data management, data delivery and a desire to exceed customer expectations.This is a full-time permanent role reporting to the Data Services Manager.Key ResponsibilitiesEnsure incoming data requests are properly evaluated, prepared, and delivered in a timely and accurate fashion.Produce and validate data sets using complex SQL based on technical specifications using multiple databases and warehouses.Support pre-sales and sales colleagues by providing tailored data sets and technical support to fit customer needs.Providing post-sales support to customers.Explore ways to improve our data delivery processes, data cleaning and data quality.Maintain SLAs to ensure data sets for customers are generated, tested and delivered in a timely manner.What we are looking for:EssentialMinimum 2 years’ experience working with relational databases with demonstrable knowledge of but not limited to:Writing complex SQL queries which include the use of joins, CTEs & window functions.Query optimization and performance tuningDebugging slow queriesCreating ETL pipelines that interact with a relational database.Comfortable working with data sets in excess of 1 billion rows.Minimum 2 years’ experience working with at least one major RDBMS such as PostgreSQL, MySQL, Oracle etc.Minimum 1 years’ experience working with a data warehouse such as Snowflake, Databricks, Redshift etc.Demonstratable experience of working with REST APIs for both retrieving and delivering data.Confident and well-presented individual who would be comfortable speaking with customers in-person, via email and telephone.Key attention to detail and strong analytic and problem-solving skills.Strong written and verbal English communication skills.Ability to use own initiative to troubleshoot problems and find solutions.Comfortable collaborating with team members across US, EMEA, APAC.DesirableDomain knowledge or experience working within the maritime or an adjacent industry.Practical use of AWSExperience working in a startup or PE/Scale-UpA degree in any disciplineOur Promise to You – Benefits25 Days Holiday rising to 27 after 2 years’ service and a day off for your birthdayWork anywhere policy (up to 4 weeks per year, subject to approval)Life Assurance for 4 x SalaryCompany pension scheme: employee contribution of 5% basic salary, matched by an employer contribution of 5%Up to 4 Days Paid VolunteeringHealthy Lifestyle Subsidy up to £250Enhanced Family Leave (Maternity, Paternity, Shared Parental Leave)Flexible benefits including Private Healthcare Plan and Dental InsuranceWe know that sometimes the 'perfect candidate' doesn't exist, and that people can be put off applying for a job if they don't fit all the requirements. If you're excited about working for us and have most, but not all of the skills or experience we're looking for, please go ahead and apply. You could be just what we need!We believe strongly in the value of diversity and creating supportive, inclusive environments where our colleagues can succeed. As such, we are proud to be an Equal Opportunity Employer. We do not discriminate on the basis of race, colour, ancestry, national origin, religion, or religious creed, mental or physical disability, medical condition, genetic information, sex (including pregnancy, childbirth, and related medical conditions), sexual orientation, gender identity, gender expression, age, marital status, military or veteran status, citizenship, or other protected characteristics under federal, state or local law.Please let us know of any adjustments we need to make for you to show us your best self.About usWe are the industry experts delivering actionable maritime insight, data, technology, and analytics trusted by 60,000 professionals across the globe to drive commercial advantage, evaluate risk, and support the efficient and lawful movement of seaborne trade.Our data is collected only from the most reputable partners and accurate sources, many of which are exclusive to us and our customers.Our advanced analytics, artificial intelligence, and industry expertise transform our unparalleled data into powerful insight delivered through data and analytics platforms and services, news and commentary, and publications that help professionals in maritime operations, risk, and compliance stay well informed.Leading seaborne trade through change with data transparency, innovative technology, and human ingenuity.Our Vales and BehavioursBuild trust & TransparencyTransparency and trust needs to be at the heart, with commitment to honest communication aboutindividual progress, as well as company news, regular townhall meetings, clear messaging about thecompany's direction, and transparency in addressing internal challenges such as gender and raceinequality and recognition/reward.Embrace collective brillianceCollaboration and teamwork are the foundation of our collective success. Our data highlights the importance ofworking together cross-company and communicating with agility to solve problems. There is a strong emphasison friendly, authentic relationships and courageous collaboration.Work with respectRespect for one another's well-being, fairness in recognition of effort, inclusivity in approach, andcelebration of cultural differences is critical. There is emphasis placed on social awareness andpositive impact.Take responsibilityThe importance of being accountable to each other cannot be underestimated, recognizing eachother's work, and maintaining a challenge culture to ensure credibility, dependability, andtrustworthiness. There is focus on stepping up to take on more if it helps the collective organization.Simplify the complexThere is a focus in our data on delivering excellence, recognizing and learning from failures, anda commitment to delivering work that puts customers first and provides market-leadingexpertise.Move fast & be boldThe data sources emphasize the need to embrace change in an agile way, with a positive approach tochallenges and transformation. It includes a desire to evolve and remain industry leaders, embracingchallenges and promoting a culture of curiosity and continuous learning.