Solution Architect - Client Reporting (Sigma)

Alpha Financial Markets Consulting; Hull and East Yorkshire; On-site; GBP 75,000 - 110,000; Full time

Benefits offered by this job

Competitive base salary

Entrepreneurial environment

25 days’ holiday

Comprehensive training and development

Inclusive, collaborative culture

Job summary

Alpha FMC's Alpha Technology Consulting unit seeks a Sigma Business Intelligence Architect to design and deliver scalable data and client reporting platforms for asset and wealth management clients. You will lead end-to-end Sigma analytics implementations, create semantic data models, dashboards, and governance, and mentor a cross-functional team of data engineers, analysts, and specialists.

Travel may be required.

Qualifications

• Bachelor's degree in Computer Science, MIS, or related field or commensurate experience.
• 5+ years in Technology Consulting, Business Analysis, or related fields.
• Proven experience managing full implementation lifecycle of client reporting or data transformation projects.
• Experience with relational data platforms and data modelling (Snowflake, Data Bricks, SQL Server, Oracle).
• Experience with ETL/ELT and data integration tools; data architecture knowledge.
• Programming: SQL, XML, C#, .NET, Assembly.
• Strong communication and client relationship skills.
• Preferred: 3+ years with Sigma platform including data model development and API integration.

Responsibilities

• Lead end-to-end Sigma analytics implementation projects.
• Create semantic data models within Sigma enabling self-service analytics.
• Define project scopes and statements of work for successful implementations.
• Design intuitive dashboards and reports translating complex requirements.
• Governance and stakeholder communication during project execution.
• Mentor cross-functional teams of data engineers, analysts, and specialists.
• Ensure documentation aligns with specifications and cloud standards.
• Promote best practices in SDLC, data migration, and integration.
• Contribute to internal accelerators and BI-focused propositions.
• Willingness to travel when required.

Skills

Front Office Technology

Sigma BI

SQL

XML

C#

.NET

Assembly

Data Modelling

Data Governance

Communication

Education

Bachelor’s degree in Computer Science / MIS

Tools

Sigma

PowerBI

Tableau

SSRS

Qlik

Git

Job description

The Alpha Technology Consulting (ATC) is part of the Alpha Financial Markets Consulting (Alpha FMC) group, the leading global consultancy to the asset and wealth management industry. We are a boutique management consulting firm that offers the world’s top asset and wealth managers a competitive edge through our expertise and industry insight. Our team is of a uniquely high calibre and by focusing on asset and wealth management alone we build deep knowledge and experience within our industry. We work with a blue-chip client base, including 21 of the top 25 largest global asset management firms, and work with over 130 clients across the globe. We have our headquarters located the United Kingdom, as well as offices in major global financial centres across the United States, Canada, France, Luxembourg, Switzerland, Denmark and Asia. Alpha Technology Consulting represents the technology implementation / business integration arm of the Alpha group, with deep expertise in delivering change and transformation programmes centred around Asset & Wealth technology solutions.

To clients, we are a trusted partner for creating programmes, however, we are so much more to our employees. At Alpha, we pride ourselves in being meritocratic environment perfect for building a career, meeting great people, as well as a rewarding place to work.

Our Corporate Strategy

Alpha is increasingly establishing ourselves as the leading consultancy to the global asset and wealth management industry. To date, we have grown and been successful by deploying the highest calibre of consulting expertise to our clients. Unlike our competitors, we are:

• Sector focused: because we have always focused exclusively on Asset and Wealth Management, we provide deep and focused knowledge that our competitors cannot match
• Global: we operate seamlessly across geographies, allowing us to service the largest global clients with the highest calibre of consultant

Alpha Technology Consulting

As technology specialists, ATC:

• Provide knowledgeable resources who can implement, configure and support the major platforms used by our clients
• Assist clients with their journey to the next generation of client reporting solutions
• Help clients to define and implement their future state data architectures
• Help clients with bespoke development that complements their core application architecture
• Provide knowledgeable and client-focused support for client’s major applications, including upgrades, migrations and business-as-usual issue management

ATC resources will be:

• Able to implement, configure and support key business applications
• Able to build out and implement data management strategies across client organisations
• Able to undertake bespoke development, including of key data interfaces

Role Requirements:

Alpha FMC is looking for a Sigma Business Intelligence Architect to join our growing team. We are seeking people with strong Front Office Technology skills, along with a personal desire to build a unique, world-class service offering for our clients.

Business Intelligence Architect: You will design and implement scalable, secure, and high-performance data and client reporting solutions. You will collaborate with cross-functional teams and clients to deliver robust data platforms, pipelines, and integrations while adhering to industry best practice. In your role as a Sigma Business Intelligence Architect, you will be responsible for the following:

• Lead end-to-end implementation of Sigma-based analytics solutions, encompassing discovery workshops, technical architecture design, data source integration, user acceptance testing, and comprehensive knowledge transfer to client teams.
• Create semantic layers and data models within Sigma that enable self-service analytics while maintaining data governance, consistency, and query performance across the platform.
• Define and lead project planning to establish a detailed statement of work and tasks associated for a successful implementation.
• Design and build intuitive, interactive dashboards and reports that translate complex business requirements into user-friendly analytics experiences.
• Manage the governance of implementation projects including regular status calls with project progression updates, monitoring individual project tasks and budget. Provide effective and proactive communication to Clients and the Alpha project team.
• Build and mentor a cross-functional team of data engineers, analysts, and implementation specialists to deliver high-quality Sigma deployments.
• Ensure documentation and development are aligned with defined specifications and cloud architecture standards.
• Define and promote best practice technical methodologies for implementation, such as SDLC, data architecture, data migration strategies, and integration patterns, while influencing client teams to adopt industry best practices.
• Contribute to the development of internal accelerators and propositions within a BI / reporting focused framework.
• Willingness to travel when required

Role Requirements (Skills, Experience and Qualifications)

General skills:

• Bachelor’s degree in Computer Science / Management Information Systems, or related field or commensurate level of experience.
• 5+ years of experience in Technology Consulting, Business Analysis, or related fields.
• Proven expertise in managing the full implementation lifecycle of client reporting or data transformation projects
• Experience with one or more in the following technical area(s) specific to the investment management industry:
  • Relational data platforms (Snowflake, Data Bricks, SQL Server, Oracle) and data modelling
  • Data engineering with ETL/ELT and data integration tools
  • Data architecture
• Experience with one or more of the following Programming Language(s):
  • SQL, XML, C#, .NET, Assembly
• Advanced knowledge in designing scalable, secure, and reliable data solutions.
• Experience with data lifecycle management, data governance, and quality frameworks.
• Outstanding demonstrated verbal and written communication.
• Excellent interpersonal and client relationship skills.

Preferred skills:

• Proficiency with one or more client reporting and BI platform(s)
  • Client Reporting: Seismic, Kurtosys, SimCorp Coric, FactSet Vermilion, Assette
  • BI Solutions: Sigma, PowerBI, Tableau, SSRS, Qlik
• 3+ years of hands-on experience with Sigma platform including:
  • Data model and workbook development
  • Custom JavaScript and Sigma extensions
  • Sigma API and SDK integration
• Experience in Consulting or Professional Services
• Experience in SDLC (Agile / Waterfall) within the SCRUM framework, CI/CD or other methodologies.
• Strong experience with version control systems (e.g., Git, GitHub, GitLab) and collaborative development workflows.
• Experience with Investment Management Systems and financial instruments.
• Experience with the functional work areas of investment organizations (Front Office, Middle Office, Back Office).
• Experience with asset and wealth management reporting components (Factsheets, Holdings, Performance, Characteristics, Disclosures, Commentaries, etc.)
• Entrepreneurial approach.

Benefits:

We will offer:

• A competitive base salary for a suitably senior profile
• Fantastic opportunity to be entrepreneurial in a growing market with a reputable company brand
• 25 days’ holiday additional to bank holidays
• Supportive, social and collaborative environment
• Comprehensive training and development programmes

At Alpha FMC we are committed to employing individuals from all backgrounds, that reflects the multi-cultural society we live in. We pride ourselves on operating an inclusive working environment and providing the best people to meet our client’s expectations of service.