Senior Business Intelligence Developer
cira · Ottawa
Job description
About the role
Join the team building a trusted internet for Canadians. As a Senior Business Intelligence Developer at CIRA you will help advance the CIRA Registry Platform and deliver high‑quality data solutions that support internal teams and international customers.
Key responsibilities
- Design, develop and support end‑to‑end business intelligence solutions, including data warehouses, ETL pipelines and reporting dashboards.
- Gather requirements from customers and stakeholders, define technical solutions and provide ongoing production support.
- Troubleshoot and resolve data, ETL and reporting issues across national and international environments.
- Contribute to BI architecture, standards, documentation and participate in CI/CD and Agile development processes.
- Collaborate with developers, QA, product owners and infrastructure teams to deliver reliable solutions.
Required profile
- 7+ years of experience designing and developing business intelligence solutions.
- Strong background in relational databases (PostgreSQL, Oracle) and advanced SQL query optimization.
- Proven ability to work independently and with cross‑functional teams to deliver scalable, maintainable data products.
Required skills
- PostgreSQL, Oracle (relational databases)
- Advanced SQL development and optimization
- Dimensional data warehouse modeling (Kimball methodology)
- ETL tools: Pentaho Data Integration, Informatica, Talend, SSIS
- Reporting/visualisation: Pentaho Report Designer, Apache Superset, Power BI, Tableau
- Python for automation and data processing
- Cloud platforms: AWS, Microsoft Azure
- Containerisation: Docker, Kubernetes, Helm
- CI/CD pipelines, Terraform, Ansible, Git, Linux shell scripting
Questions fréquentes
Why are you reporting this job?
Explore further
Salaries, guides and searches in Canada.
Salaries by job title
Apply in 30 seconds
Enter your email to apply. An account will be created automatically.
By continuing, you accept our terms of use.
Already have an account? Login
Published 12 hours ago
Expires 1 month from now
2 views · 0 interested
Boost your chances
Upload your CV — we will match you with relevant openings.
Analyzing your CV...
cira
Ottawa