Job Summary

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. Design and develop complex microsoft ssis packages to facilitate data extraction, transformation, and loading processes.
2. Create and maintain sql server reporting (ssrs) reports for business intelligence and data visualization needs.
3. Manage and optimize sql server databases to ensure performance, security, and availability.
4. Collaborate with cross functional teams to gather requirements, provide technical guidance, and support data related projects.
5. Troubleshoot and resolve issues related to ssis packages, ssrs reports, and sql server databases.
6. Implement best practices for data integration, reporting, and database management.

Skill Requirements

1. Proficiency in microsoft sql server integration services (ssis) for etl processes.
2. Experience in designing and implementing sql server reporting services (ssrs) solutions for business reporting.
3. Strong knowledge of sql server database management, optimization, and troubleshooting.
4. Ability to work effectively in a team environment, communicate technical concepts clearly, and collaborate with stakeholders.
5. Problem-solving skills to analyze complex data requirements and identify optimal solutions.
6. Attention to detail and ability to prioritize tasks to meet project deadlines.

Other Requirements

1.Relevant certifications in Microsoft SSIS, SQL Server Reporting Services, or SQL Server are a plus.