WHO WE ARE

AccertaClaim Servicorp Inc. (ACSI) and its subsidiary, Accerta Services Inc. (ASI), also known as Accerta.

Accerta is a social enterprise, that manages dental, vision, drug, and healthcare benefits programs exclusively for government and social services agencies in Canada. Our targeted experience and innovative technology provide cost savings, reliable service, process continuity, and accurate, insightful data that enables governments to make informed strategic decisions, reducing stress on the healthcare system through streamlined administration.

Accerta is a Certified B Corporation which is a testament to the values we’ve built our business on: serving our customers, caring for our employees, and supporting our community and the environment. Being part of the B Corp movement means we’re committed to continual improvement and making business a force for good. Thank you to our team and stakeholders who have helped us achieve this significant milestone!

ABOUT THIS OPPORTUNITY

The Manager, Business Intelligence and Database Administration, is a highly technical, hands-on leadership role responsible for overseeing and executing data visualization and data infrastructure initiatives. This role bridges the gap between business and technology by delivering reliable analytics platforms, ensuring database integrity and performance, and mentoring a small team of BI and data professionals. The incumbent will ensure that the organization leverages accurate, timely, and actionable insights, while maintaining a secure, optimized, and scalable database environment.

ACCOUNTABILITIES

Power BI & Analytics Leadership

• Design and Development: Lead the end-to-end design, development, and deployment of Power BI dashboards and reports that translate raw data into actionable business insights.
• Data Modeling: Architect and optimize semantic data models, including tabular and multidimensional models, to support self-service and enterprise-wide reporting needs.
• Stakeholder Engagement: Collaborate with department leads and executives to understand analytical requirements, define KPIs, and guide the organization’s data visualization strategy.
• Governance & Standards: Establish and enforce governance practices across Power BI datasets, workspaces, and reports to ensure data accuracy, consistency, and security.
• Advanced Analytics: Explore opportunities to enhance Power BI outputs through the integration of predictive analytics, AI/ML, or R/Python for advanced data storytelling.

Database Administration & Operations

• SQL Server Management: Administer, monitor, and optimize Microsoft SQL Server environments, both on-premise and cloud-hosted, ensuring high availability, disaster recovery, and optimal performance.
• Security & Compliance: Implement robust access control, encryption, and data masking strategies in line with privacy regulations and organizational security policies.
• Performance Tuning: Proactively address performance bottlenecks by optimizing queries, indexes, and server configurations.
• Data Integrity: Maintain rigorous data quality and validation processes across systems to ensure that insights are based on accurate and trustworthy information.
• Backup & Recovery: Oversee regular backup procedures, failover mechanisms, and recovery testing to minimize data loss and ensure business continuity.

Team & Project Management

• Hands-on Leadership: Lead by example by actively contributing to development and problem resolution alongside team members while managing overall workloads and deliverables.
• Mentorship & Coaching: Develop the technical and professional capabilities of team members through training, performance feedback, and knowledge sharing.
• Resource Planning: Align team capacity and skillsets to meet project timelines and business objectives; prioritize and delegate tasks effectively.
• Project Oversight: Coordinate with PMO and cross-functional teams to manage timelines, risks, and resource dependencies for BI and data-related initiatives.
• Process Improvement: Define and implement repeatable development, testing, and deployment workflows, introducing automation where feasible.

QUALIFICATIONS

Knowledge and Experience:

Experience:

• Minimum of 5 years of progressive experience in Power BI development, including building enterprise dashboards and self-service data solutions.
• Minimum of 5 years managing Microsoft SQL Server environments, including clustering, high availability, disaster recovery, and security.
• At least 2 years of experience in a team leadership or management role with proven ability to mentor and develop direct reports.
• Demonstrated success in balancing project delivery with day-to-day operational responsibilities.

Technical Skills:

• BI Stack: Expert-level knowledge of Power BI Desktop, Power BI Service, SSIS, SSAS, and SSRS.
• Data Engineering: Proficiency in ETL processes, data pipelines, data warehouse development, and integration with multiple data sources.
• Data Security: Strong understanding of data access control models, row-level security, and role-based permissions within BI tools and databases.
• Scripting & Queries: Advanced skills in T-SQL, DAX, MDX, and query optimization techniques.
• Cloud Technologies: Experience with Azure Data Services (Data Factory, SQL Database, Synapse) is an asset.
• Documentation: Skilled in maintaining comprehensive technical documentation, including data dictionaries, process flows, and solution architectures.

Nice to Have:

• Familiarity with DevOps practices for BI and database deployments, including CI/CD pipelines using tools such as Azure DevOps or GitHub Actions.
• Knowledge of data governance frameworks and best practices related to metadata management, data lineage, and data stewardship.
• Experience integrating Power BI with cloud-based platforms (e.g., Dynamics 365).
• Familiarity with Agile delivery methodologies, including Scrum or Kanban.
• Experience in public sector, health, or government-funded environments with heightened privacy and compliance standards

Education:

• University or college diploma in Computer Science, Information Technology, Business Analytics, or a related field. Additional certifications in Microsoft data technologies or project management are a strong asset

Core Competencies:

• Analytical Thinking: Ability to dissect complex business problems and develop efficient data solutions.
• Communication: Strong written and verbal skills, with the ability to convey complex data concepts to non-technical stakeholders.
• Execution: Demonstrated ability to deliver results in fast-paced, deadline-driven environments.
• Strategic Mindset: Understands the bigger picture and contributes to data strategy, architecture, and long-term roadmap planning.
• Adaptability: Comfortable with shifting priorities and evolving business needs, embracing innovation and continuous learning.

WHAT WE OFFER

• Group Benefits: Coverage begins on the employee’s first day and includes a Health Care Spending Account and Personal Spending Account (depending on allocation).
• Pension Plan: Eligibility starts on the employee’s first day, and a 5% employee contribution is matched by a 5% employer contribution.
• Performance-based incentive programs: Opportunities to increase your earnings.
• Growth opportunities in a company that promotes from within.
• Volunteering: Time off to volunteer within our community
• Hybrid: working environment with a laptop and two monitors.
• Home Office Stipend: A one-time payment of $750 included in the employee’s first paycheck.
• Mental Health Support: Access to Mental Health on Demand for employees and their dependents.
• Member Assistance Program: Includes Employee Assistance Program services.
• Community Volunteering: Up to 8 hours of paid time off annually to volunteer in your community.
• Financial Wellness: Opportunities to contribute to non-matching GRRSPs, TFSAs, and FHSAs, along with financial information sessions.
• Education Reimbursement: Tuition reimbursement for post-graduate courses, upon prior approval.
• Employee Referral Reward: Employees can earn a $1,000 reward for successful referrals.

FLEXIBLE WORK ARRANGEMENT:

We support a hybrid approach, which will give everyone the best of both worlds – a mix of home and in-office workdays.  Hybrid schedules will be determined in partnership between individuals, managers, and the team. 

HOW TO APPLY

We accept applications submitted via email to kmcbride@accerta.ca

INCLUSION AND EQUAL OPPORTUNITY EMPLOYMENT

Accerta is an equal opportunity employer and committed to fostering diversity and inclusion in the workplace. We are committed to fair employment practices and all qualified applicants will receive consideration for employment. We offer accommodation for applicants with disabilities, as required throughout the recruitment process.  Accommodations are available on request for candidates taking part in all aspects of the selection process.

To request accommodation, please contact accessibility@accerta.ca.

We appreciate your interest in working with us; however, only those applicants selected for interviews will be contacted.

Final candidates for this position may be required to undergo a security screening, including criminal records check, judicial matters check, vulnerable sector screening and employment reference check.  

To learn more about us please go to: www.accerta.ca