Solutions Specialist - Full Time

About the Calgary Stampede

The Calgary Stampede is a not-for-profit community organization that preserves and promotes our western heritage, cultures and community spirit with a vision to create a world-class, year-round gathering place for the community. Exemplifying the theme We’re Greatest Together, the Stampede is one of the most respected volunteer-based organizations in the world governed by a Board of Directors with over 2,500 passionate volunteers and 1,200 year-round employees.

As an organization that exists for the benefit of the community, inclusion and equity are woven into our core values of western hospitality, pride of place, integrity and commitment to the community. The world-class, year-round gathering place we have built for the community also welcomes visitors from around the world and those who are new to the local community. We know that blending diverse cultures with our long-standing traditions makes community spirit thrive.

Position Summary

Working with the Applications Manager, Business Analysts and Technical Specialists, this role owns technical design, configuration, integration, testing, deployment and support readiness. The ideal candidate brings experience with enterprise applications, APIs, SQL, Power BI dashboards, data modelling, automation, Okta identity and access management, security and governance. Experience with financial systems, Microsoft Power Platform, Microsoft Fabric or data warehousing is an asset.

Roles and Responsibilities

Responsibilities of this role include, but are not limited to:

Partner with the Applications Manager, Business Analyst and other Solutions Specialists to translate approved business direction and scope into practical technical designs, requirements and delivery plans.

Participate in discovery sessions led by the Applications Manager or Business Analyst, and lead focused technical discovery with business subject-matter experts when clarification is required.

Lead technical assessments and recommend solution options based on feasibility, security, integration, data, supportability, scalability, cost and alignment with application standards.

Configure, administer and optimize enterprise SaaS and business applications, including complex workflows, roles, permissions, notifications, business rules and environment settings.

Design, implement and support application integrations using APIs, webhooks, file transfers or integration platforms; define source-to-target mappings, triggers, transformations, validation and exception handling.

Partner with the Applications Manager, Business Analyst and business stakeholders to translate business questions into clear measures, key performance indicators, reporting requirements and actionable dashboards.

Design, build and maintain Power BI reports and dashboards, including SQL-based data validation, data preparation and modelling, calculations, visualizations, security, refresh schedules and publication; document metric definitions and data lineage so users can understand and trust the results.

Lead or support Okta application integrations and automated identity lifecycle processes, including SSO, MFA, SCIM or API-based provisioning, group and role mappings, profile mappings, Workflows and deprovisioning.

Troubleshoot application, integration, access and data issues using system logs, audit trails, queries, vendor tools and structured root-cause analysis.

Produce and maintain solution designs, technical specifications, configuration records, data mappings, test plans, deployment and rollback steps, runbooks and support documentation.

Coordinate system, integration and regression testing; support user acceptance testing and verify that solutions meet business, technical, security and operational requirements.

Collaborate with senior and intermediate specialists on solution delivery, peer reviews and shared technical decisions while retaining accountability for the design and supportability of assigned solutions.

Own the technical coordination and execution of releases, upgrades, environment changes, data migration, cutover, stabilization and transition to operational support for assigned solutions.

Apply governance, security and compliance requirements, including access controls, segregation of duties, auditability, data ownership and change controls.

Share technical knowledge with colleagues and contribute to reusable standards, patterns, documentation and support practices.

Contribute to implementation communications, training, adoption and change-management activities so technical solutions are understood and used effectively.

Manage multiple priorities and communicate technical decisions, risks, dependencies, incidents and trade-offs clearly to business and technical audiences.

5+ years of progressive experience delivering, integrating and supporting enterprise applications or technology solutions, including ownership of complex implementations or enhancements.

Extensive hands-on experience configuring, implementing, integrating and optimizing enterprise applications in SaaS, cloud or hybrid environments.

Strong working knowledge of APIs, JSON, webhooks, SFTP or similar integration methods, with experience mapping data and troubleshooting multi-system data exchanges.

Strong practical SQL skills for querying, validating, reconciling and troubleshooting data.

Hands-on experience developing and supporting Power BI reports and dashboards.

Experience with identity and access concepts such as SSO, MFA, SAML or OIDC, SCIM, role-based access, provisioning and deprovisioning.

Benefits

The Calgary Stampede offers a unique and exciting work environment, an excellent total compensation package and the opportunity for advancement and employee training.

All applicants are thanked in advance and only those selected for interviews will be contacted