BI Developer

BI Developer

About This Role

Workplace Arrangements:

This is a fully remote role! The incumbent may be asked to come onsite to our Ottawa, Ontario Home Office quarterly for team gatherings.

What You'll Be Doing

• Design, develop, test, deploy, and support BI, reporting, dashboard, semantic layer, and analytics solutions using approved BI, data warehouse, and cloud analytics platforms.
• Gather and translate business requirements into scalable BI, data, and analytics deliverables that support business goals and a single version of the truth.
• Write, validate, troubleshoot, and optimize complex SQL and BigQuery/GCP solutions to support reporting, analysis, reconciliation, data quality, and governed reporting.
• Develop and support BI platform objects, datasets, dashboards, visualizations, metrics, filters, prompts, semantic models, and other analytics components.
• Complete development tasks according to defined performance, cost, security, governance, data quality, and tool standards.
• Deliver assigned work within agreed timelines, ensuring solutions meet business requirements and technical quality expectations.
• Follow SDLC, Change Management, deployment, documentation, and DevOps procedures as defined by the team and organization.
• Create and execute technical testing, data validation, reconciliation, and production readiness activities.
• Monitor, tune, support, troubleshoot, and improve BI and data environments, including reports, dashboards, data refreshes, SQL performance, BigQuery cost/performance, data quality, standards, procedures, and operational reliability.
• Escalate delays, risks, blockers, and business-impacting issues to the appropriate project lead, manager, or support team.
• Apply automation, Python, JavaScript, AI, conversational analytics, and agent-based technologies where appropriate to improve analytics delivery, operational support, and business user experience.
• Collaborate with business, BI, data, integration, infrastructure, security, and vendor teams to support reliable, scalable, and governed analytics solutions.

What You'll Bring

• Bachelor’s degree or college diploma in Information Technology, Computer Science, Computer Engineering, Data Analytics, Business Intelligence, or an equivalent combination of education and experience.
• 5+ years of experience developing, maintaining, and supporting BI, reporting, analytics, or data warehouse solutions.
• 5+ years of experience writing, validating, troubleshooting, and optimizing SQL queries, views, joins, aggregations, and data transformations.