Sql jobs in United Kingdom

Senior Data Engineer - OnTheMarket Technology - London

CoStar Group (NASDAQ: CSGP) is a leading global provider of commercial and residential real estate information, analytics, and online marketplaces. Included in the S&P 500 Index and the NASDAQ 100, CoStar Group is on a mission to digitize the world’s real estate, empowering all people to discover properties, insights and connections that improve their businesses and lives.

We have been living and breathing the world of real estate information and online marketplaces for over 35 years, giving us the perspective to create truly unique and valuable offerings to our customers. We’ve continually refined, transformed and perfected our approach to our business, creating a language that has become standard in our industry, for our customers, and even our competitors. We continue that effort today and are always working to improve and drive innovation. This is how we deliver for our customers, our employees, and investors. By equipping the brightest minds with the best resources available, we provide an invaluable edge in real estate.

In December 2023 CoStar Group purchased OnTheMarket (OTM) with the intention of developing this established brand into the UK's number 1 Residential Property portal. Supported by the deep expertise of the CoStar Group and our Homes and Apartments teams, we will develop a world class user experience through offering the very best written content, imagery, design and functionality. The OnTheMarket product will support home buyers, sellers, and agents better than ever!

Learn more about OnTheMarket.

The role of Senior Data Engineer will be a key role within the OTM Data team, reporting to the Head of Data and working closely with the CTO. The Data team is responsible for data acquisition, data loading, data quality, data processing, data delivery, and data support for OnTheMarket. This role will provide focus on delivering value to our customers, by leveraging data to improve the OTM users and agents experience.

This role would be suited to an individual with a background in Python, SQL, AWS, Looker, PyTorch, Airflow and Redshift/Postgres. The candidate must be able to exhibit proficiency in working with large volumes of data, automating data loads, and the ability to understand end user requirements with the goal of building a solution to provide high quality data processing and analysis as well as building APIs.

• Develop data pipelines using Python, Airflow and Clojure

• Data warehousing (Redshift/Spectrum)

• Develop data solutions to address ad-hoc business needs

• Maintain existing reports and improve their performance

• Bachelor’s degree in Computer Science, Data Science, Mathematics, Engineering or equivalent experience

• Experience writing SQL queries and optimising query performance.

• Strong skills in Python

• Experience with AWS or GCP

• Demonstrated experience and responsibility with data, processes, and building ETL pipelines.

• Experience with cloud data warehouses such as Amazon Redshift, and Google BigQuery.

• Building visualizations using tools such as Looker studio or equivalent

• Experience in designing ETL/ELT solutions, preferably using tools like Airflow or AWS Glue

• Solid analytical and technical skills

• Good communications skills both verbally and written; this role will be working closely with business users.

• Clojure or other JVM language production experience

• Development & Deployment of machine learning models using PyTorch

• Experience with GIS systems (Postgis,QGIS, …)

Working at CoStar Group means you'll enjoy a culture of collaboration and innovation that attracts the best and brightest across a broad range of disciplines. As well as having an outstanding working environment based in London Blue Fin. Other perks include full private medical cover, dental cover, Life Assurance and member rewards, 28 days annual leave, a competitive pension, season ticket loans, enhanced maternity and paternity pay and much more!

At CoStar, we recognise the positive value of diversity and promote equality. We aim at all times to recruit the person who is most suited to the job and welcome applications from people of all backgrounds – men and women, people of all ages, sexual orientations, nationalities, religions and beliefs. However, we particularly encourage applications from women, disabled and Black, Asian and Minority Ethnic (BAME) candidates, as these groups are underrepresented throughout the commercial real estate industry.

CoStar Group is an Equal Employment Opportunity Employer; we maintain a drug-free workplace and perform pre-employment substance abuse testing.