Solution Architect - Client Reporting (Sigma)

Alpha Financial Markets Consulting; United States; Hybrid; USD 125,000 - 186,000; Full time

Benefits offered by this job

Competitive base salary

401k/RRSP matching

25 days annual paid time off

Up to 7 sick days

Comprehensive benefits package

Job summary

Alpha FMC is seeking a Sigma Business Intelligence Architect to design and deliver scalable data and client reporting solutions for North America. You will lead end-to-end Sigma analytics implementations, build semantic models, and drive data governance across client projects.

Collaboration with cross-functional teams and travel when required is expected. The role requires a Bachelor’s in CS/MIS, 5+ years in technology consulting or related fields, and hands-on experience with Sigma, data

Qualifications

• Bachelor’s degree in Computer Science / MIS or related field.
• 5+ years of technology consulting, business analysis or related fields.
• Experience managing full lifecycle of client reporting or data transformation projects.
• Experience with relational data platforms and data modelling.
• Strong data governance, security and architecture principles.

Responsibilities

• Lead end-to-end implementation of Sigma-based analytics solutions, including discovery workshops, architecture design, data source integration, testing and knowledge transfer.
• Create semantic layers and data models within Sigma to enable self-service analytics with governance.
• Define project plans and SOW for successful implementations.
• Design and build dashboards and reports translating business requirements into analytics experiences.
• Mentor cross-functional data engineers, analysts, and implementation specialists.
• Ensure documentation aligns with specifications and cloud standards.

Education

Bachelor’s degree in Computer Science / Management Information Systems, or related field

Tools

Snowflake

Data Bricks

SQL Server

Oracle

ETL/ELT

Data architecture

SQL

XML

.NET

C#

JavaScript

Job description

Solution Architect - Client Reporting (Sigma)

North America

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.

• 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)

• 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.
• 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.)

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.

Demographic Questions

At Alpha, we work hard to foster a diverse and inclusive environment and therefore we ask all applicants to complete a short questionnaire before we review their application. This helps us better understand the people who apply for Alpha, see how different demographics progress through our hiring process and enable us to do all we can to enable people from all backgrounds to succeed. All of the information shared: is voluntary (we've included a 'prefer not to say' option for every question) and will have no impact at all on the outcome of your application (we only use this data in the form of grouped, aggregated responses for equal opportunities monitoring in our hiring process).

Voluntary Self-Identification

For government reporting purposes, we ask candidates to respond to the below self-identification survey. Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiringprocess or thereafter. Any information that you do provide will be recorded and maintained in a confidential file.

As set forth in Alpha Financial Markets Consulting’s Equal Employment Opportunity policy,we do not discriminate on the basis of any protected group status under any applicable law.

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection. As a government contractor subject to the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measure the effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categories is as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.