Solution Architect – Product & Technology | EPM/CPM | Data Warehousing | Power BI (DAX), SQL | React, Microservices | 4–8 Years | PIN0390 | Acterys

How You'll Make an Impact

• Partner with Product Management and domain experts to define, own, and evolve the solution architecture and roadmap for a set of Acterys features and capabilities within a cloud‑based SaaS environment.  
• Collaborate closely with Engineering teams to define pragmatic, well‑reasoned solution designs that balance functional needs with performance, security, scalability, and maintainability.  
• Review and validate engineering designs and implementations to ensure alignment with approved solution architecture, architectural standards, and compliance requirements.  
• Support delivery teams throughout the delivery lifecycle by helping resolve complex technical challenges, guiding refactoring efforts, and improving solution quality as requirements and constraints evolve.
  Research & Continuous Improvement: 
• Stay informed of relevant industry trends, technologies, and architectural practices, evaluating opportunities to evolve solution patterns, blueprints, and delivery approaches. 
• Leverage modern tooling, including AI‑assisted research and analysis, to support informed architectural decisions and continuous improvement.
  Architecture Communication & Enablement: 
• Maintain clear, accurate architecture artifacts and decision records, ensuring solutions are well understood and traceable across stakeholders. 
• Proactively communicate architectural decisions and changes, while mentoring and supporting engineers through design reviews, working sessions, and ongoing knowledge sharing.
  Architecture Governance: 
• Actively participate in architecture governance, contributing to the definition and application of standards, principles, policies, and best practices. 
• Help ensure architectural decisions are consistent, well‑reasoned, and aligned with platform strategy, compliance expectations, and long‑term sustainability.
  Innovation & Proof of Concept: 
• Collaborate with cross‑functional stakeholders on proof‑of‑concept initiatives to explore new capabilities and support business cases for future features and enhancements. 
• Contribute to a culture of innovation by helping teams experiment responsibly while maintaining architectural quality and customer trust. 

We'd Love to See

• 2+ years’ experience in applied Solution Architecture, 5+ years’ experience in software development 
• Strong working knowledge of Microsoft Azure with a focus on Microsoft SQL Server and/or Azure SQL Server 
• Good knowledge of relational databases/OLTP and SQL language for reporting, including knowledge of TSQL and procedural SQL 
• Good understanding of Data Warehousing key concepts: 
• Star Schema (Dimensions, Fact tables, Measures) 
• Familiarity with ETL for DWs 
• Strengths and weaknesses of DWs 
• Good knowledge of Power BI technology stack: 
• Familiar with DAX and M 
• Familiar with building Power BI Models 
• Prior experience with financial systems and reports 
• P&L, Balance Sheet, Cash Flow reports 
• Prior experience with financial systems, CPM, ERPs, cloud-based accounting systems (Xero, QuickBooks, etc.) highly regarded 
• Experience in designing distributed and concurrent systems and microservices and APIs (REST, GraphQL) 
• Knowledge of and experience with development of cloud-based SaaS applications 
• Proven collaboration, communication and influencing skills across diverse stakeholders 
• Working knowledge of Angular and Typescript is beneficial 
• Interest in AI and willingness to explore AI-driven solutions to enhance performance and drive efficiencies 

About
At Vena, we’re reimagining how businesses plan and grow: powered by data, collaboration, and innovation 🌱 Headquartered in Toronto with a global reach, we help finance teams work smarter using the tools they already love (yes, we’re talking about Excel!). Trusted by over 1,800 organizations and 150,000+ users every day, Vena Solutions brings clarity to complexity. We're a people led company that leads with our CORE values (Customer Trust, One Team, Respect & Authenticity and Execution Excellence) and are driven by our mission We’re growing fast, thinking big, and having fun along the way. The future of finance is being built here, and we’d love for you to be part of it 🚀Why Choose Us:💰 CompensationWe offer competitive and comprehensive total rewards packages that we review yearly to stay ahead of the market! Transparency is key, we keep you in the loop on how we design our comp programs. Build your future with our Employee Stock Option Program, Retirement Savings, Support & 401k Matching Programs.🎓 Personal Growth & LearningLevel up your skills with Vena!  We support your journey with education subsidies, professional development programs, and learning opportunities to help you grow your career and reach your goals. Your future is bright and we’re here to invest in it!🧘‍♀️ Health & WellnessYour well-being = our priority!  Great health & dental plans, wellness sessions (virtual & in-person), Employee Assistance Program (EAP), and a free Headspace subscription to support your mental health.🌍 Global ReachVena is everywhere you are!  With offices in Toronto, London, and Indore, as well as team members across the United States, EMEA and beyond, we're a truly global company. Collaborate with colleagues around the world and bring diverse ideas to life: no passport required!🌴 Time OffRecharge with generous leave options - perfect for vacation, wellness, personal time, parental support, volunteering, and more.🏡 FlexibilityWe embrace a flexible culture that supports different ways of working, depending on the role and location. While some of our teams enjoy hybrid arrangements, others thrive in-office or remotely. With modern workspaces in Toronto, Indore, and London, we offer inspiring environments when you need them - and the freedom to work in ways that work best for you and your team.✨ AI-Powered InnovationAt Vena, we don’t just keep up, we're leading the way! 🚀We empower team members at every level to actively explore AI best practices, identify meaningful opportunities to apply AI in their work, and champion innovative solutions that drive impact.By fostering a culture of curiosity, innovation, and responsible use, we’re building a future where AI enhances how we work, think, and lead. From automating workflows to enhancing insights, AI is woven into everything we do.👉 Check us out:▶️YouTube💼 LinkedIn🔗GlassDoor