The Role

BNP Paribas Real Estate is a one-of-a-kind real estate specialist business, with multiple business lines providing residential and commercial property sales; facilities and property management; and rural estate advice and management.

The use of data-driven insights and technology is key in the real estate sector.  To continue our competitive approach in this market, we have embarked on an exciting programme of activity which involves identifying and enhancing the possibilities with our data – transforming and evolving BNP Paribas Real Estate as a data-enabled organisation.

To facilitate this, we are looking for an experienced and motivated SQL Developer to work in the Solutions Engineering team within our IT department.  The role will work alongside the existing development and change management teams to continue to develop and enhance our operational database integrations, and data warehouse capabilities.

Working with the Head of Development, this exciting role will consult with key stakeholders and the Head of Data Transformation on their business intelligence requirements – together developing appropriate data structures to feed our visualisation platforms and drive innovative corporate strategy.

Our current data ecosystem is almost entirely based on Microsoft SQL Server, and spans applications that manage detailed property and client data, sales pipeline, and strategic financial planning.  The central data warehouse is in its initial stages, and its maintenance and development will form a core part of this role’s responsibilities.

Increasingly, we are seeking to enrich and enhance our data capabilities by consuming external data feeds.  Experience of harnessing public or commercially available datasets and APIs to augment corporate data, would be beneficial.

As a SQL expert, you will assist in the development and maintenance of data integrations between operational data platforms.  In addition, supporting our Application Support and Application Production teams to troubleshoot production issues where required.

Typical Role Responsibilities

•    Design, develop and enhance operational database integrations and data warehouse capabilities, using best practice approaches.

•    Consult with key stakeholders and the Head of Data Transformation to develop appropriate data structures for business intelligence requirements.

•    Prepare high-level designs and help to produce technical and ETL mapping specification.

•    Recognise where the performance and server load of existing procedures and ETL processes can be enhanced.

•    Troubleshoot data issues and anomalies to determine the best resolution.

•    Support and maintain existing SQL integrations and developments.

•    Regularly liaise with project managers, business analysts and developers.

•    Designing databases with both front-end and back-end users in mind.

Necessary Skills/Experience

•    Expert in Microsoft SQL Server.

•    Proficient in writing complex SQL queries to retrieve and manipulate data.

•    Experience in creating and maintaining stored procedures and functions to optimize database performance.

•    Experience with SSIS for data integration and ETL (Extract, Transform, Load) processes.

•    Background in reporting and business intelligence tools, including SSRS.

•    Experience of working within a development environment.

•    Understanding of relational and dimensional data modelling.

•    Familiarity with consuming external data feeds and APIs.

•    Strong mathematical and statistical knowledge.

•    Excellent written and verbal communication skills.

•    Impeccable attention to detail.

•    Strong troubleshooting skills for production issues.

•    Adept at working with all types of stakeholders.

Further Desirable Skills

•    Other database technologies (Oracle, MySQL, PostgreSQL, MongoDB)

•    REST APIs, Web Services

•    Simego / Ouvvi – data automation

•    .Net

•    Data visualisation tools (e.g. Tableau, Power BI)

•    Python

•    Dataiku

Desirable Experience

•    Working with similar data types; Property/Real Estate, HR & Financial Transaction data, Sales.

•    Experience within a financial service, real estate, or commercial markets industry.

•    Experience of supporting software tools such as Jira, and Service Now.

Desirable Qualifications

•    Formal IT qualification (A Level, HND/HNC/BTEC or degree).

•    Bachelor’s degree in computer science or a related field.

•    5+ years of experience in database architecture, or a related field.

•    MCSE/MCSA certifications preferred.

We are proud to offer award-winning benefits to support and reward our employees:

•    Health & Leisure: Private medical cover, 25 days annual leave + public holidays (the option of purchasing up to 5 additional days via flex benefits), health screening, gym discounts, wellbeing support, volunteering opportunities, cycle to work scheme, eye care voucher, travel & retail discounts, travel insurance, concierge service, kids pass, open fairways golf card, great company culture and social events (including sports teams, charity events, art pass), perks at work 

•    Financial:  Pension, life assurance at 8 x basic salary, group income protection (long term disability insurance), interest free season ticket loan, bonus scheme - you will be eligible to participate in the Company’s Bonus Scheme, share incentive plan, financial and mortgage advice 

BNP Paribas Real Estate is committed to providing a work environment that fosters diversity, inclusion, and equal employment opportunity without regard to race, colour, gender, age, creed, sex, religion, national origin, disability (physical or mental), marital status, ancestry, sexual orientation, gender identity and gender expression, or any other legally protected status.