Senior Business Intelligence & Reporting Specialist

AlayaCare is revolutionizing the way home health care is delivered. Our leading cloud-based software allows our clients around the world to manage their employees, scheduling, billing, and enable better delivery of care. We're a fast-growing SaaS company with a team of 600+ team members across Canada, US, Australia, and Brazil. We aspire to be the global leader in home health care software solutions. We take pride in our open and transparent culture, our bias for action, and our commitment to a workplace where we can be ourselves.

About the role:

Reporting directly to the Director of Business Intelligence, the successful candidate will employ advanced analytics, reporting, and data visualization to give our business and our products a competitive edge. Responsibilities include understanding and managing the data and how it interconnects, as well as structuring data for self-serve BI and BA opportunities. This role calls for someone who is business-oriented, experienced with data modeling, data analysis, data visualization, and enjoys process framing, solution shaping & creation, and facilitating implementation.

The ideal candidate will be a self-starter, a critical thinker, and highly interested in applying new data analysis and data visualization technologies and methods to address key business questions.

Location, travel, and in-office requirements:

AlayaCare supports a flexible hybrid working model, suggesting that our employees maintain a regular in-office presence based in their nearest office while providing the flexibility for some remote work. Our team encourages in-person collaboration and as such, the preferred candidate location for this position would be within the Greater Toronto Area or the Greater Montreal Area.

Some out-of-town travel may be required (-5% of the time) for quarterly planning or finance team events/summits.

What you'll be responsible for:

• Automating report creation for the management team and the board of directors
• Extracting, transforming, and loading data from multiple sources
• Developing scalable and reusable data models
• Ensuring accuracy and reliability of data, sourced from our different platforms (e.g. HubSpot, NetSuite, Zendesk, Jira, etc.)
• Designing and implementing accessible, high-impact visualizations that clearly communicate results, elucidate patterns, promote accountability, generate actionable insights, and facilitate decision making
• Supporting integration of event tracking data from multiple platforms
• Producing technical and user documentation
• Delivering concise and meaningful reporting to cross-functional teams
• Leading, planning and executing BI projects to meet business objectives
• Designing, building and deploying powerful BI solutions as per business requirements
• Generating insights & presenting effective data-driven business recommendations to various stakeholders
• Supporting business units in making informed decisions and understanding the “what” and “why” via data analysis and visual storytelling
• Implementing BI leading practices throughout the project lifecycle
• Highlighting the business data needed to produce the most insightful future analytics
• Providing end-user training on BI tools and data models, empowering business users to analyze available data and create their own dashboards
• Keeping abreast of current and upcoming technologies and tools
• Handling escalations from business departments or from junior colleagues when necessary

What you bring to the team:

• Bachelor's degree in a related discipline or completion of other post-secondary education with a mix of relevant experience
• 4+ years of experience in BI development, data modeling, and dashboard development
• Strong knowledge and practical experience with SQL
• In-depth understanding of key data modeling concepts such as dimensions, measures, aggregation, cardinality, etc.
• Familiarity with Looker and Snowflake
• Proficiency in Microsoft Excel
• Previous experience with ETL Jobs
• Excellent communication skills both verbally and in writing to collaborate, communicate, and story-tell across various levels (both technical and non-technical), including executive and senior leadership teams
• Proficiency in statistical programming languages (e.g. Python, R, SAS) is an advantage
• Basic knowledge of Azure DevOps, Git Hub repository, and other DevOps tools is desirable
• An ability to translate complex analytical results into actionable business initiatives and reports
• Independence and strong organizational skills
• Team player who can thrive in a fast-paced and performance-driven environment
• Curiosity and passion for helping business departments drive their success utilizing data
• Innovative problem-solving skills, with the ability to envision new analytical solutions to any problem
• Confidence in diplomatically challenging perceptions and biases of individuals at all organizational levels to bring about improvements
• Effective organization, planning, prioritization, and time management skills
• Able to manage complex or specialized projects
• Business-oriented with a solid understanding of business requirements and vernacular in one or more of the following domains: Sales & Marketing, Finance, Customer Success and/or Software Development
• Bilingualism in French and English would be a definite advantage

What Makes AlayaCare a Great Place to Work:

• Our products make a positive difference in the lives of countless care workers and care recipients
• Equity in a well-funded, high-growth company
• Flexible hybrid working model and aesthetically pleasing and creatively designed office spaces within prime locations
• Competitive pay, including equity in a growing, well-funded company
• A comprehensive group benefits program, which includes telemedicine
• An employee expense program for health, wellness, lifestyle, productivity expenses and more!
• A parental leave top-up plan
• A flexible vacation policy
• Wellness Fridays throughout the summer months for extra relaxation time
• A paid Volunteer Time off Program
• Opportunities for career growth and development
• An entrepreneurial culture fostering transparency, collaboration, and innovation
• We are proudly recognized as part of Deloitte's Technology Fast 50 programme.