Technical Business Analyst

Open Systems Technologies; Montreal (administrative region); On-site; CAD 75,000 - 95,000; Full time

Job summary

Open Systems Technologies is seeking a qualified candidate to analyze and decompose Technology Infrastructure product costs in Montreal, Quebec. The role involves developing cost attribution views and identifying cost drivers to enhance transparency and support decision-making.

The ideal candidate will be proficient in Snowflake/SnowSQL, advanced Excel, and PowerPoint, enabling them to translate complex data into clear insights while supporting budgeting and forecasting initiatives.

Qualifications

• Proficient in Snowflake/SnowSQL for data querying and transformation.
• Advanced Excel skills for financial modeling and large dataset handling.
• Effective in making executive-ready presentations using PowerPoint.

Responsibilities

• Analyze and decompose fully-loaded Technology Infrastructure product costs.
• Develop clear cost attribution views to improve transparency.
• Identify key cost drivers and trends to support decision-making.

Skills

Snowflake / SnowSQL

Advanced Excel

PowerPoint

Job description

• Analyze and decompose fully-loaded Technology Infrastructure product costs at the program and funding request level
• Develop clear cost attribution views and improve transparency across infrastructure components
• Identify key cost drivers, trends, and variances to support decision-making
• Partner with Technology Business Managers to develop what-if scenario models to evaluate potential cost impacts
• Support Technology teams in assessing financial implications across: Product, Application, Business segment, Region, Legal entity
• Translate complex data into clear, executive-ready insights
• Surface material changes, risks, and opportunities
• Support planning, forecasting, and Technology investment decisions
• Stakeholder Support & Ad Hoc Analysis
• Support ad hoc analytical requests from senior stakeholders
• Partner with Finance and Technology teams on budgeting, forecasting, and funding discussions
• Contribute to enhancing cost transparency frameworks, methodologies, and reporting tools

Skills Required

• :Snowflake / SnowSQL (data querying, transformation, and validation
• )Advanced Excel (financial modelling, large dataset handling
• )PowerPoint (executive-ready presentations and communication

Nice to Have (Strongly Preferred

• :Experience with AI-enabled productivity tools, such as: Microsoft 365 Copilot, Power BI Copilot, GitHub Copilot, Claude, Grok, or similar generative AI platfor
• msAbility to leverage AI tools to enhance analysis, modelling efficiency, and insight generati