James Cooke

Experience

• 

  Cello Signal

  Jun 2013 - Oct 2019

  Database Developer

  Working as part of a team to deliver automated communications for clients including (but not limited to) Lloyds Banking Group, BHF and nPower. • Understand client data and how it is supplied and used• Consult with internal and external stakeholders to determine requirements• Design and build relational databases within SQL Server• Writing complex stored procedures• Create and implement SSIS solutions for ETL• Utilise APIs to interface with 3rd party web services• Write in C# to provide bespoke solutions Show less

• 

  Ecclesiastical Insurance Group

  Oct 2019 - Sept 2022

  Data & Analytics Developer

  Working in the Data Development Team, focusing on delivering both project orientated major revisions and supporting business as usual change in relation to the underlying Kimball methodology data warehouse and other reporting systems. Development activity is focused on the SQL Server stack, primarily in SSIS and T-SQL. Key Accountabilities: • Supporting the Data Development Manager and Data Development Team with design and specification of ETL solutions.• Working closely with colleagues across Data & Analytics and Horizon Programme to ensure solutions will meet needs throughout the BI Platform stack.• Delivering performant and maintainable solutions to meet specified requirements.• Developing solutions in line with Data Development Team standards and practice following development lifecycle.• Performing and/or arranging relevant testing of solutions in line with test strategy.• Providing on-demand operational support for the production BI environment.• Maintenance of appropriate solution and system documentation. Knowledge, Skills and Experience: Kimball methodology data warehousing SQL Server 2017 SSIS (Visual Studio) T-SQL (SSMS) TFS / Redgate version control applications and processes JIRA• Translating requirements to solution; ability to gathering relevant information, research and propose solutions.• Great team player with ability to deliver individually and collaboratively.• Managing own workload, taking accountability to drive delivery.• Experience of working in a pressured and complex environment• Confident and influential communicator at all levels: good verbal, written, and presentation skills• Customer focused and excellent understanding of the value of data and what it means to be data-driven• Excellent working knowledge of data protection legislation and its practical application Show less

• 

  Ecclesiastical Insurance UK

  Oct 2023 - now

  Focused on delivering a greenfield cloud migration and business as usual change in relation to the on-premises data warehouse and other reporting systems. In addition to my responsibilities as a Developer, I also perform the role of Scrum Master on a long-term transformational programme for the business.Responsibilities:• Delivery lead and technical leadership of architectural design, development and build of new cloud pipeline from DFE to presentation layer.• Shared strategic leadership of development team.• Reviewed and re-developed peer review and quality control process.• Redesigned unit testing framework for handovers of reports into system test.• Servant-Leadership, facilitation, and the removal of blockers for the workstream.• Coaching of team members in Scrum principles and customer relationships.• Management of relationships and conflict resolution between developers and customers where there are complex project challenges.• Chair and facilitation of Scrum Events for the workstream.• Organisation and chairing of department meetings.• Technical support to all levels of stakeholder across the business.Technologies:• ELT / ETL (Azure Data Factory / dbt / SSIS / Data Tools)• SQL (Snowflake / SSMS)• Version control (Bitbucket)• C# (Visual Studio)• Power BI / DAX• JIRA Show less

  • Data & Analytics Developer / Scrum Master

    Sept 2022 - now

  • Data Operations Manager (Interim)

    Oct 2023 - Feb 2024