Description:
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.