SQL Server Lead — Data Warehouse & Security Analytics

N Consulting Global; Glasgow; On-site; GBP 65,000 - 95,000; Full time

Job summary

N Consulting Global in Glasgow seeks a Senior SQL Server developer to architect, build and optimise data warehouse components for security, risk and records-management reporting. You will design robust schemas, implement data quality controls and lead the end-to-end delivery of SQL Server solutions.

You will mentor peers, enforce coding standards, and collaborate with analysts, security and governance stakeholders to ensure compliant, testable data platforms and reliable production services.

Qualifications

• Expert T-SQL development with complex queries, stored procedures and set-based approaches.
• Strong SQL Server performance engineering including index tuning, partitions and tempdb.
• Testing mindset with automation using tSQLt or equivalent and data quality checks.
• Understanding of secure database development and data controls (access auditing, retention).
• Familiarity with Git/GitLab, code reviews and pull requests.
• Experience with CI/CD and release automation for database deployments.
• Artefact/repository management (Nexus) and dependency/version control.
• Scripting/automation using PowerShell, Linux shell and Python.
• Data governance/records management awareness and linkage to data products.
• Knowledge of Java/Scala with Spark in data processing contexts.

Responsibilities

• Own end-to-end SQL Server components for security, risk and records-use cases: requirements, design, build, review and deployment.
• Implement robust testing and quality controls (unit tests, data quality checks, reconciliations) across releases.
• Ensure database solutions meet security/records management requirements with appropriate access controls and logging.
• Design and evolve data models and physical schemas to support security metrics and governance.
• Provide production support including monitoring, incident triage and performance optimization, driving automation.

Skills

T-SQL development

SQL Server performance

Testing/QA mindset

Security/data controls

Source control

CI/CD tooling

Artifact management

Scripting/automation

Data governance awareness

Java/Scala with Spark

Education

Bachelor's degree in Computer Science or related field

Tools

Git/GitLab

Nexus

CI/CD tooling

PowerShell

Linux shell

Python

Java

Scala

Spark

Job description

N Consulting Global in Glasgow seeks a Senior SQL Server developer to architect, build and optimise data warehouse components for security, risk and records-management reporting. You will design robust schemas, implement data quality controls and lead the end-to-end delivery of SQL Server solutions.

You will mentor peers, enforce coding standards, and collaborate with analysts, security and governance stakeholders to ensure compliant, testable data platforms and reliable production services.