Senior Associate, Analytics Solutions - Technology Services Group

• Translating analysis into clear implications and insights that can be used by the business. 
• Acting as a thought partner to the core team as they develop new measures and analytical approaches, applying sound business judgement to recommend pragmatic approaches rather than becoming overly focused on detailed technical analysis. 
• Developing charts, analytical views, dashboards, and reports that clearly communicate trends and findings, preferably using Tableau or Power BI. 
• Developing in-depth commentary and insights, and creating compelling presentations that clearly communicate the data’s narrative. 
• Taking complex information and turning it into a clear and understandable business story, using PowerPoint and other tools to communicate analytical findings and support discussions. 

• Collecting, cleaning, and preprocessing large and diverse data sets from multiple sources. 
• Extracting, transforming, and loading data from a wide range of data sources into staging datasets and ultimately into reporting and dashboard layers. 
• Building and maintaining ingestion and transformation routines from source systems (including APIs, SaaS platforms, and relational databases) into a lakehouse or data warehouse. 
• Developing dimensional data models and semantic layers that support self-serve reporting and consistent metric definitions. 
• Guaranteeing the accuracy and accessibility of all valuable data. 
• Contributing to the design and build of web application interfaces (including wireframes and form flows) that present analytics and capture structured business input, along with the backend and API services and role-based access behind them. 
• Deploying changes through CI/CD pipelines across development, test, and production environments. 
• Monitoring the health and performance of pipelines, reports, and applications; diagnosing production issues; and tuning query and caching behaviour so that what users see stays responsive. 
• Supporting users, triaging reported issues, and coordinating fixes and releases. 

• A degree in Business, Mathematics, Computer Science, or equivalent combination of education and industry experience. 
• 6+ years of hands-on experience in a data analyst, data business analyst, or insight analyst role. 
• Comfort working across the full analytical path (from the stakeholder conversation, to extracting and manipulating the data, to a finished insight) without needing each step handed off to someone else. 
• Substantial experience in SQL, including joins, subqueries, basic clauses, and complex filter statements. 
• Advanced Excel capability (including pivot tables, lookups, and complex formulas), with comfort extracting data from existing dashboards and reports in order to manipulate it, test different calculations, and understand trends. 
• A demonstrable ability to break stakeholder requirements down into discrete steps, activities, and data, and then build them into stories that directly answer stakeholder inquiries. 
• Proven experience in data analysis, visualization, and storytelling; developing meaningful and insightful presentations for various stakeholders. 
• Experience developing or refining business metrics, including defining the business logic, proxies, and assumptions behind them. 
• Strong communication skills, with the ability to explain analytical findings clearly, simplify complex analysis, and work collaboratively with a core delivery team. 

• Excellent analytical, problem-solving, and evaluation skills. 
• Superior consulting and client relationship management skills. 
• Strong communication, collaboration, and interpersonal skills. 
• Excellent facilitation skills and ability to present ideas and recommendations to various stakeholders. 
• Strong writing, communication, and presentation skills. 
• Sound business judgement, with the ability to maintain a business perspective and avoid getting unnecessarily deep into technical detail. 
• Comfortable operating across a broad remit, with the judgement to know where to go deep and where a pragmatic answer is enough. 
• Results-oriented individual with the ability to meet aggressive timelines. 
• Innovative and dynamic, bringing an entrepreneurial spirit to our business. 
• Strong work ethic, with the energy, enthusiasm, and commitment to develop their career. 

Interview recording & AI notetakers 

During the interview process, we may use transcription or AI notetaking tools. To protect privacy, legal compliance, and interviewer/candidate experience, the use of these tools is not permitted without your prior consent. We will ask for your consent and if you wish to decline, handwritten notes are welcome.

Compensation: Salary range is $100,000-$130,000 CAD

Salary ranges are designed to be competitive. Individual compensation is determined by skills, qualifications, and experience and is subject to negotiation and subject to the candidate meeting the specific requirements or the role. Exceptional candidates may be considered above the top of the range, and pay can increase quickly for those who make a big impact in the role.

A Taste of Some of the Great Benefits at Optimus

Financial

• Annual Bonus
• Retirement savings through our Group RRSP program
• Company equity for Managers and above
• Maternity and Parental Leave with top up compensation

Flexibility

• Work in a Hybrid model (when client projects permit)
• 12 Optimus Days paid

Health

• Top-tier health benefits
• Life & disability insurance
• Health Spending Dollars