Senior Technical Specialist - SQL Server

Job Summary

Job Specification – Senior Software Engineer – Database developer with SSAS

As a Software Engineer within London Finance Transformation of Lloyds Banking Group you will serve as a senior member of an agile team implementing trusted, secure, stable products which service the needs of customers at an enterprise scale. You will be responsible for driving technical innovation within the group, collaborating across multiple technology hubs, and developing critical business solutions that support the groups objectives and values.

Key Responsibilities:

• Key point of contact for developers in the Lab for all technical questions.

• Lead the design and development of enterprise software solutions with an ability to think beyond conventional approaches when required.

• Ensuring the team produces high-quality, maintainable, and secure production code that can execute effectively in multi-tiered / batch environments.

• Comfortable technically troubleshooting enterprise-scale systems across multiple layers and communicating resolutions effectively to technical and non-technical users.

• Able to translate and integrate business requirements within a defined scope of complexity.

• Keen to document and expand on the group’s established development guidelines, best practices, and system architecture using industry standard methodologies.

• Actively identifies technical and performance improvements with a view to integrating design patterns, new technologies and bleeding-edge engineering practices.

• Leading by example in the integration of Enterprise-wide agile practices and new ways of working across the group.

Key Technical Skills:

• Proficient in Transact SQL (T-SQL), SQL Server Integration Services (SSIS) & SQL Server Reporting Services (SSRS). Knowledge of the inner working of SQL Server is an advantage.

• Ownership of reviewing code implemented by the team to ensure it is robust, testable, and maintainable.

• Proficient in SQL Server Analysis Services (SSAS) with a strong focus on the multi-dimensional model. Experience with the tabular model is also advantageous. Ideally you will have been involved in designing large scale cubes, as well as maintaining them.

• Thorough understanding of developing and deploying to a Route-to-Live and Production environments with a DevOps mindset.

• Advanced skill in in debugging and performance tuning with understanding of extended events, DMVs execution plans, database statistics etc.

• Expertise in using GIT as Source Control Management tool.

• Table/index design and Query Optimisation experience.

• Data Modelling, Data warehousing SSAS Cube design experience beneficial.

• Experience of Business Intelligence Markup Language (BIML) beneficial.

• Experienced in writing and debugging C# code in SSIS Script components.

• Well versed using GIT as Source Control Management tool.

• Experience of Business Intelligence Markup Language (BIML) beneficial.

• Able to work to tight deadlines and have a head to work under pressure.

Required:

• 10+ years in working in an Enterprise environment (Financial organisation preferred).

• Batchelors degree or equivalent in a STEM discipline, computer science preferred.

• Good oral and written communication skills.

.

Key Responsibilities

1. Architect And Develop Comprehensive Solutions For Product And Sustenance Delivery Utilizing Sql Server, Ensuring Alignment With Client Specifications And Industry Best Practices.

2. Serve As A Subject Matter Expert In Sql Server, Providing Expert Guidance And Support To Team Members And Stakeholders Throughout The Project Lifecycle.

3. Evaluate And Integrate Emerging Technologies In Sql Server To Ensure Solutions Remain Cutting-Edge, Optimizing Performance And Meeting Rigorous Quality Standards.

4. Facilitate The Development Of A Skilled Workforce In Sql Server Through Conducting Interviews, Leading Training Sessions, And Offering Mentorship To Enhance Team Capabilities.

5. Collaborate With Stakeholders To Gather And Analyze Specifications, Delivering Tailored Solutions That Leverage Sql Server Functionalities To Meet Organizational Objectives.

6. Contribute To Competency Development By Envisioning And Articulating Innovative Propositions, Creating Whitepapers, And Conducting Market Trend Analysis To Inform Strategic Decisions.

7. Recommend And Implement Client Value Creation Initiatives By Applying Industry Best Practices In Sql Server, Ensuring Solutions Contribute To Enhanced Operational Efficiency And Effectiveness.

Skill Requirements

1. Expert Knowledge In Sql Server, Including Installation, Configuration, And Performance Tuning.

2. Strong Understanding Of Database Design Principles And Data Modeling.

3. Proficiency In Sql Development For Complex Query Optimization And Data Manipulation.

4. Familiarity With Data Integration Tools And Etl Processes.

5. Excellent Analytical And Problem-Solving Skills, With A Focus On Delivering High-Quality Solutions.

Other Requirements

1. Relevant Certifications Such As Microsoft Certified: Azure Database Administrator Associate Or Microsoft Certified: Data Analyst Associate Are Considered Valuable But Not Mandatory.