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.

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.