Solution Architect - Client Reporting (Sigma)

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

Benefits offered by this job

401k/RRSP matching

25 days annual paid time off

Sick leave (up to 7 days)

Job summary

Alpha FMC seeks a Sigma Business Intelligence Architect to design and deliver scalable, secure data and reporting platforms for front office clients. You will lead analytics implementations, build dashboards, and govern data solutions across multiple projects.

You will collaborate with cross-functional teams, mentor analysts, and ensure adherence to cloud architecture standards while traveling as needed.

Qualifications

• Bachelor’s degree in Computer Science, MIS, or related field.
• 5+ years of experience in Technology Consulting/Business Analysis.
• Experience managing full implementation lifecycles of client reporting or data transformation projects.
• Proficiency with investment management data platforms and BI tooling.

Responsibilities

• Lead end-to-end Sigma analytics implementations from discovery to knowledge transfer.
• Create semantic data models and self-service analytics in Sigma.
• Define project plans and detailed work statements for successful implementations.
• Design intuitive dashboards and reports translating business requirements into analytics experiences.
• Mentor cross‑functional teams of data engineers, analysts, and implementation specialists.

Skills

Front Office Tech

Client-facing

Interpersonal skills

Data governance

Communication

Education

Bachelor’s degree in CS / MIS

Tools

Sigma

PowerBI

Tableau

SSRS

Qlik

Job description

Alpha Group is a leading global consultancy to the financial services industry. Founded in 2003, Alpha has spent over 20 years bringing together specialist, 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.

• Established yet entrepreneurial – with over 20 years of success and a proven record on the London Stock Exchange, Alpha offers the stability of an established consultancy with the energy of a fast-growth business.
• Backed by Bridgepoint – as part of one of the world’s leading growth investors, Alpha benefits from strategic investment that fuels innovation, expansion and new offerings – creating even more opportunity for our people.
• Exposure to senior leadership – whether you are in an internal or a client-facing role, you will have the opportunity to work with and learn from the best of the best – high performers at the top of their game.
• Learning and growth opportunities – we run tailored training to help you be successful, provide you excellent mentorship, and offer up to 5 days paid training time per year. Perhaps the best training though is the experience on the job – as everyone at Alpha has high responsibility and autonomy, you can develop your skillsets quickly.
• Performance-driven culture with real impact – advancement at Alpha is based on impact and capability, not tenure or quotas. You’ll have autonomy and see the tangible difference your ideas and decisions make.

About Alpha Tech Services

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.

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 caliber 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 caliber of consultant

As technology specialists, we:

• Provide knowledgeable resources who can implement, configure and support the major platforms used by our clients
• Form a range of partnerships with key vendors to position itself as a preferred implementation partner for major business applications
• Assist clients with their journey to the next generation of cloud-based architectures
• 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
• Implement, configure and support key business applications
• Build out and implement data management strategies across client organizations
• 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)

• 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
• Experience with one or more of the following Programming Language(s):
• 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)
• BI Solutions: Sigma, PowerBI, Tableau, SSRS, Qlik
• 3+ years of hands‑on experience with Sigma platform including:
• Data model and workbook development
• 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.

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  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.
• Pregnancy loss support, offering paid time off and resources to support employees through loss.
• Menopause support, ensuring employees have access to resources and flexibility during this stage of life.
• Flo subscription coverage for up to two memberships per year to support reproductive and hormonal health.
• Flexible hybrid schedules help balance work and family commitments.
• A supportive community of working parents that shares resources and fosters connection.
• Leadership that models healthy work–life integration, reflecting our belief that family and professional success go hand in hand.

Our Commitment to Inclusion

At Alpha, diversity, equity and inclusion are critical to our success. Our priorities show a focus on fostering an inclusive, equitable workplace where individuals are treated fairly regardless of gender or background. We welcome applications from disabled people and are committed to making our recruitment process and workplace accessible and inclusive for everyone.