Solution Architect - Client Reporting (Sigma)

About Alpha Group

Alpha Group is a leading global consultancy to the financial services industry. Founded in 2003, Alpha has spent over 20 years bringing together specialists, sector-focused strategy, management consulting, and technology expertise to support the entire client transformation lifecycle. Having partnered with more than 1,200 clients worldwide across the asset and wealth management, alternatives, and insurance industries, Alpha is a trusted advisor for complex change programs.

We now have over 1,180 consultants working with clients across North America, the UK, Europe, the Middle East, and APAC. In 2024, in recognition of our successful track record and strong growth prospects, Alpha was acquired by Bridgepoint, one of the world's leading quoted private asset growth investors.

Our people are at the heart of everything we do. Many of our team have built long and fulfilling careers with us, often staying for over a decade. Alpha offers a genuinely rewarding place to work: a meritocratic environment where your career can flourish, and a welcoming culture where you can be yourself, connect with others, and thrive.

As we look to the future, we’re excited to be looking for new Alpha colleagues—individuals who are collaborative, innovative, and ambitious. We hope you will join us and help shape the next chapter of our growth journey.

Why join Alpha?

• Flexibility that supports real life – We trust our team to manage their time and energy in the way that works best for them. Our hybrid and flexible working model allows you to balance client delivery with personal commitments — without sacrificing career progression.
• Inclusive parental leave & family support – We offer generous parental leave for all parents alongside a truly supportive return-to-work culture. Many of our team members transition smoothly back through flexible scheduling, ramp-up periods, and ongoing mentorship.
• Established yet entrepreneurial – Alpha combines the stability of a global consultancy with the agility of a high-growth firm, giving you autonomy, visibility, and the ability to shape your career.
• Learning built in, not added on – You’ll receive tailored training, structured mentorship, and up to 5 paid training days each year, plus on-the-job experience that accelerates your growth.
• A diverse culture and leadership team – We’re proud to have diversity within our senior leadership here at Alpha across North America and globally. We invest in developing all leaders through coaching, internal communities, and opportunities to work closely with partners.
• A truly supportive environment – We’re a meritocratic culture where your impact matters more than face time. We care about results, high standards, and collaboration.

About Alpha Tech Services

Alpha Tech Services 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 caliber 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 centers across the United States, Canada, France, Luxembourg, Switzerland, Denmark, and Asia. Alpha Tech Services represents the technology implementation/business integration arm of the Alpha group, with deep expertise in delivering change and transformation programs centered around Asset & Wealth technology solutions. To clients, we are a trusted partner for creating programs, however, we are so much more to our employees. At Alpha, we pride ourselves in being a meritocratic environment perfect for building a career and meeting great people, as well as a rewarding place to work.

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.

Compensation and Perks:

The anticipated base salary for this role varies based on geographic location and is structured across three compensation zones. These zones reflect local market conditions and cost of labor. Geographic placement is determined by the employee’s primary work location.

Zone A | $163,000 – $186,200
Applies to candidates working in designated high-cost metropolitan areas, including: Los Angeles, CA; San Francisco, CA; Boston, MA; New York City, NY; and Washington, DC, as well as remote roles based in Massachusetts or the New York Tri-State Area.

Zone B | $135,000 – $170,000
Applies to candidates working in key metropolitan markets, including: Austin, TX; Atlanta, GA; Chicago, IL; Charlotte, NC; Denver, CO; and Philadelphia, PA, as well as remote roles based in Texas, California, Pennsylvania, Florida, or Colorado.

Zone C | $125,000 – $160,075
Applies to all other U.S. locations not listed above.

Toronto | CAD 170,000 - CAD 205,675
Applies to candidates working in the Toronto region

Final compensation will be determined based on experience, qualifications, and work location. In addition to base salary, this role is eligible for a discretionary bonus and a comprehensive benefits package. We are committed to equitable and transparent compensation practices across all locations.

• Competitive salary with annual profit-sharing opportunity
• 401k/RRSP matching
• 25 days of annual paid time off
• Up to 7 days annually for sick leave
• Supplemented medical, dental and vision coverage
• Generous reimbursement for commuting, mobile phone, and home internet expenses
• North America team-wide training and retreats
• Sponsorship towards professional certifications / training supported with 5 days of paid training time.

We are committed to creating an environment where careers and families can thrive together. Our family-friendly benefits are designed to support employees through every stage of caregiving:

• Comprehensive parental leave for all parents, including 8 weeks of birthing leave and 8 weeks of bonding leave.
• Return with Care Program to support a smooth transition back to work after leave.
• Child Sickness Leave, providing up to 5 days of protected time for returning parents.
• Menstrual care support, offering employees time off as needed to manage menstrual-related illness.