Senior Database Engineer

Field Sales Solutions have an exciting opportunity for you to join us as a Senior Database Engineer

This is your opportunity to work for a multi award winning Field Marketing Agency – Field Sales Solutions. We work in partnership with some of the biggest, most exciting brands out there.

In return for joining us as a Senior Database Engineer in our Business Intelligence department, we can offer you a salary of £50K + benefits.

Location:
Hybrid, minimum of 1 day per week in the Head Office, Thame

We’re looking for an ambitious and skilled database engineer to join our Business Intelligence function and play a key role in architecting, maintaining and troubleshooting internal database structures. You’ll be part of the Database team, working closely with the reporting and QA teams to deliver top level data outputs for internal and external facing reporting, including 3rd party integrations.

• 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

• 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 TSQL code
• Proficient in query optimization, partitioning and index design.
• Good understanding of data cleansing and preparation
• Strong analytical and problem-solving skills.
• Ability to collaborate across the whole BI team
• Practical and proven experience in designing and deploying Azure Data Factory data pipeline.
• Confident communicator, able to engage non‑technical stakeholders and clients.
• Highly organized, able to manage workload independently.
• Understanding how SQL feeds PBI
• Experience with Dev-ops and Source control
• Translating business questions into SQL and explaining query logic clearly
• Data engineering for machine learning modelling
• Able to build solutions from ingestion to presentation
• Good practice with exception handling
• Understanding of vectoring data

As well as an engaging and varied day job, we can also offer you a variety of benefits Including:

• Access to expertise & support for career development.
• Opportunity to work for a growing business.
• Incentive Programme.
• Health & Wellbeing programme.
• 25 Days Holiday + Bank Holidays.
• Performance related bonus.

You must be eligible to work in the UK and have a full UK Driving Licence.

Field Sales Solutions is an equal opportunities employer.

• Partnership
  - We are transparent, open, and work together with our clients and colleagues to achieve common goals.
• Return
  - We drive and evaluate all activity by identifying and delivering a positive ROI.
• Ownership
  - We understand our role and have a sense of purpose and accountability in everything we do.
• Upstanding – We are honest, reliable, and ethical in all we do, showing professionalism and integrity always.
• Determined – we know that success requires perseverance, and we are driven to achieve.

We are PROUD to be Field Sales Solutions.