Senior Database Engineer - BI & Data Warehousing (Hybrid)

Field Sales Solutions; Thame; Hybrid; GBP 50,000 - 58,000; Full time

Benefits offered by this job

Health & Wellbeing programme

25 Days Holiday + Bank Holidays

Incentive Programme

Career development support

Job summary

Field Sales Solutions is seeking a Senior Database Engineer for its Business Intelligence team in Thame. Hybrid role, with at least one day weekly at Head Office.

Salary around £50K plus benefits, with opportunities to work on data pipelines, ETL, and Azure Data Factory integrations for internal and partner reporting. The role focuses on designing, optimizing, and maintaining SQL-based data structures, collaborating with BI, reporting, and QA teams to deliver reliable data for dashboards and

Qualifications

• Strong experience developing in SQL from creating database models from scratch.
• Solid understanding of Data Warehousing (star schema, fact/dimension design).
• Expert in writing efficient T-SQL code.
• Proficient in query optimization, partitioning and index design.
• Good data cleansing and preparation skills.
• Strong analytical and problem‑solving skills.
• Ability to collaborate across the BI team.
• Experience designing Azure Data Factory data pipelines.
• Confident communicator with non-technical stakeholders.
• Highly organized, able to manage workload independently.
• Understanding how SQL feeds Power BI
• Experience with Dev-ops and Source control
• Translating business questions into SQL
• Data engineering for machine learning modelling
• Able to build solutions from ingestion to presentation
• Good practice with exception handling
• Understanding of vectoring data

Responsibilities

• Build and Refine queries, CTE’s, stored procedures, views and functions
• Create and Maintain tables, indexes, constraints, schemas and triggers
• Diagnose slow queries using execution plans, cardinality estimates, IO and wait stats
• Design optimized queries for CPU, IO and memory usage, reducing locking.
• Checking job schedules, ETL Pipelines and data freshness
• Build and Maintain ingestion pipelines
• Enforce constraints, referential integrity and validation rules
• Support compliance requirements
• Document data pipelines, schemas, stored procedures, data flows and standards
• Promote best practices
• Plan for Scalability

Skills

SQL development

Data warehousing

T-SQL

Query optimization

Azure Data Factory

Data pipelines

ETL

Data modeling

Stakeholder communication

DevOps / Source control

Power BI

SQL Server

Tools

Power BI

SQL Server

Git

Job description

Field Sales Solutions is seeking a Senior Database Engineer for its Business Intelligence team in Thame. Hybrid role, with at least one day weekly at Head Office.

Salary around £50K plus benefits, with opportunities to work on data pipelines, ETL, and Azure Data Factory integrations for internal and partner reporting. The role focuses on designing, optimizing, and maintaining SQL-based data structures, collaborating with BI, reporting, and QA teams to deliver reliable data for dashboards and