Role Description - Develop interactive dashboards and reports using tools like Power BI or Tableau - Translate business requirements into scalable data models and reporting solutions - Implement and validate complex business logic within reporting layers - Write and optimize advanced SQL queries for data extraction and transformation - Work with Snowflake (or similar cloud data warehouses) for data sourcing - Support User Acceptance Testing (UAT), including defect resolution and enhancements - Collaborate with business stakeholders, data engineers, and QA teams - Maintain and enhance existing BI solutions for performance and usability Qualifications - Strong experience with Power BI and/or Tableau - Advanced proficiency in SQL (query writing, optimization, performance tuning) - Hands-on experience with Snowflake or similar data platforms - Solid understanding of data modeling and reporting best practices - Experience with Excel (advanced functions) and VBA - Ability to implement complex business logic in reporting tools - Experience working in Asset Management / Financial Services domain Requirements - Basic familiarity with dbt (data build tool) Benefits - Strong analytical and problem-solving abilities - Good communication skills for stakeholder interaction - Ability to work in Agile / fast-paced environments

• Administration Interns are responsible for various administrative and professional functions within the department assigned. • This may include, but not limited to, researching, creating, updating, and recording department-specific documentation, as well as customer service responsibilities. • The RBI Intern will learn to design and implement reporting and dashboards geared toward optimizing operations within Easterseals MORC. • Executes both technical and analytical functions to ensure smooth flow of business operations. • Works directly with stakeholders and key team members to define, design, and deliver actionable insights.

• Administer AWS QuickSight environments, managing users, permissions, groups, namespaces, and resource access. • Use CLI, SDKs, or APIs to automate administrative tasks (user provisioning, permissions updates, dataset refreshes, etc.). • Design, build, deploy, and maintain dashboards, reports, and analyses in QuickSight (authors, visuals, stories). • Optimize performance of datasets and dashboards (e.g. SPICE, query tuning, data prep). • Establish and enforce governance, access controls, and usage policies within QuickSight. • Collaborate with data engineers, analysts, and stakeholders to understand reporting needs and translate them into QuickSight solutions. • Monitor usage, error logs, refresh failures, and proactively resolve issues. • Maintain documentation of data models, dataset lineage, dashboard specifications, and administrative procedures. • Provide training and support for business users and analytics teams on QuickSight usage and best practices. • Evaluate new QuickSight features, enhancements, or third-party tools for possible adoption.

Title: Senior Business Intelligence Analyst - 12-month secondment/contract Location: Northfield Dr W, Waterloo, ON, Canada Department: Enterprise Solutions Office Job Description: Company Description Who We Are With every job, there’s always the question of “why”. Why join a company? Why be part of their mission? Here, the why is easy. It’s because at some point, we’ve all needed someone there for us. At the OTIP Group of Companies (OGC), we believe that something special happens when employees feel valued for the work they do, supported as the people they are, and included in the very fabric of the organization: they bring their best to work every day. And that's why we mean it when we say we put our people at the centre of everything we do. Join us as we grow our way into a future that reimagines what it means to deliver meaningful benefits support and service. Job Description What You’ll Do: Reporting to the the Director, Business Solutions, you'll be responsible for OTIP business solutions initiatives, including those which leverage business data for greater insights. Intended to drive continuous improvement and efficiencies, this role includes contribution to strategic projects and business objectives across all lines of business with a focus on rapid innovation and emerging technologies. The core parts of your role will be to: - Provides business solutions expertise in support of stakeholders to identify high-value opportunities for the application of business intelligence and emerging technologies. - Devises strategies, alternatives, and recommendations for effective delivery of business solutions that meet stakeholder needs, leveraging business intelligence and emerging technologies. - Leads the facilitation of cross functional working groups, providing analytical support and recommendations. - Responsible for the design, build and operationalization of business intelligence and emerging technologies. - Builds strong internal customer relationships with colleagues, key stakeholders, and business leaders to proactively understand strategic objectives within all areas of the business. - Synthesizes large amounts of data to identify key trends and presents the results in a logical and concise manner effectively to stakeholders. - Accountable for the analysis and ongoing continuous improvement of consumable datasets, connecting data points across all channels, such as social media platforms, website/mobile, etc. - Contributes to organizational effectiveness through the development, analysis, and implementation of business intelligence and emerging technologies initiatives. - Actively seeks out external benchmarks and best practices to improve our competitive advantage. - Provides technical leadership to junior team members and performs other duties within the Business Solutions function, as assigned. Qualifications Let’s Talk About You: This is the unique blend of skills and experience we would love to see in an ideal candidate: - A university degree, college diploma or certification in a related field with knowledge of best practices employed by the IIBA and BABOK. - 3+ years of experience business analysis or related field - Advanced knowledge of MS reporting tool or equivalent BI reporting suite. - Proven ability to coach and mentor on technical solutions. - Intermediate knowledge of business analysis and design techniques; including strong understanding of the Microsoft Power Platform - Microsoft certifications considered an asset: Power Platform Fundamentals, MS Power BI - Excellent oral and written communication, presentation, facilitation and influencing skills. - Process related certification/designation or commitment to complete. Lean, Six Sigma, Kaizen - Demonstrated ability to translate technical solutions into non-technical details. - Knowledge of SQL or any database query language - Excellent organization, communication, and problem-solving skills. - Advance PC skills, Microsoft Excel, Word, Access. We also consider your potential. If you know you have what it takes to do the job, but your experience doesn’t exactly match the qualifications above, we encourage you to apply and provide us with more details about why you think you would be a great fit. Additional Information Salary Range: This position offers a competitive salary within a range of min $74,600 mid $93,300 max $112,000, along with rewarding bonuses that recognize your dedication. At the OTIP Group of Companies (OGC), we value transparency and take multiple factors into account when determining your starting salary, including your skills, experience, and alignment with the role as well as internal equity, while positioning you for continued growth and recognition over time. Some of the Perks We Offer: We offer best-in-class pension and benefits, total reward programs and comprehensive mental wellness support to set you up for every success in and outside of work. Here are just some of the reasons you’ll love working here: - Defined benefit pension plan for a financially confident retirement - 100% coverage of approved continuing education and licensing fees (including RIBO courses in Ontario) - Access to a wealth of learning resources, including LinkedIn Learning for professional development - Flexible work-from-home and hybrid options - Unlock your potential with opportunities for advancement Recruitment Process: Please note that we do not currently use artificial intelligence (AI) in our recruitment process and this position is being posted to fill an existing vacancy. OTIP and its group of companies strive to create an accessible and inclusive work environment where everyone is treated with respect and dignity. Upon individual request, we will endeavor to remove any barrier to the recruitment and selection processes and provide accommodations for persons with disabilities. As a business, we protect what matters most to our members. As an employer, we value what matters most in our workplace. Together, this includes fostering a diverse, equitable and inclusive environment for all. We are committed to learning and evolving so we can continue to celebrate what makes us special. You are who you are, and our differences are what make us unique. We are an equal opportunity employer and encourage applications from all qualified individuals. We thank all applicants for their interest; however, only candidates selected for an interview will be contacted. Let’s work together! If you are interested in this opportunity, please apply online. #LI-Remote, #LI-Hybrid