CIRA
Senior Business Intelligence Developer
Ottawa, Ontario · Senior
Sponsorship not specifiedDetected 11 hours ago
PythonGitSQLPostgreSQLAWSCloud PlatformsDockerTerraformAnsibleHelmCI/CDLinuxData EngineeringData VisualizationCommunicationCollaboration
> stay_score
odds of building a lasting career here
40Risky
Cap-exempt (no lottery)0
Sponsors this role90
Entry-level history0
PERM / green-card track0
Lottery odds40
Fits your clock70
Thin sponsorship signal and lottery-bound. A low-probability bet with your clock running. Prioritize cap-exempt roles and proven entry-level sponsors first.
Lottery odds assume a STEM candidate.
Personalize to your clock →> community_outcomes
No reports yet — be the first to help the next applicant.
About the role
- CIRA may be best known for managing the.CA domain but our impact reaches far beyond that.
- We're at the forefront of advancing cybersecurity technologies and leading projects that improve the digital experience for users across Canada and the world.
- Our broad scope of activities is driven by one central goal: to strengthen and secure Canada's digital landscape.
Responsibilities
- Design, implement and optimize dimensional data warehouse models, database objects, ETL pipelines and data integration processes.
- Develop reports, dashboards, data extracts and analytical datasets that support better decision-making.
- Investigate the root causes of production issues and implement long-term solutions.
- Collaborate with developers, quality assurance (QA), product owners and infrastructure teams to deliver reliable business intelligence solutions.
- Ability to manage multiple priorities in a fast-paced environment.
Requirements
- 7+ years of experience designing and developing business intelligence solutions.
- 7+ years of experience developing relational databases using PostgreSQL, Oracle or similar enterprise databases.
- 7+ years of experience designing and implementing dimensional data warehouse models using Kimball or similar methodologies.
- 7+ years of experience developing ETL and data integration solutions using Pentaho Data Integration, Informatica, Talend, SQL Server Integration Services (SSIS) or similar platforms.
- Experience with container technologies, including Docker and Kubernetes.
- Experience deploying applications using Helm or similar deployment frameworks.
- Experience implementing CI/CD pipelines and development automation.
- Experience with Infrastructure as Code (Terraform, Ansible, etc.)
- Strong experience with Git and modern source control practices.
- Experience working with Linux and shell scripting.
- Advanced SQL development and query optimization skills.
- Experience developing reports and dashboards using Pentaho Report Designer, Apache Superset, Power BI, Tableau or similar business intelligence platforms.
- Strong Python development skills for automation, data processing and integration.
- Experience developing and deploying business intelligence solutions in cloud environments such as Amazon Web Services (AWS) or Microsoft Azure.
Company info
- At CIRA, we're driven by a passion to make a positive impact on Canada's digital future. We're not just asking, 'What more can we do?'-we're actively exploring new frontiers to enhance and secure the internet for all Canadians. Our recognition as one of the National Capital Region's Top Employers for ten years is a testament to our vibrant culture. We believe in fostering an environment where collaboration and candour are second nature and where diverse perspectives are integral to our success, because we know that great ideas come from everywhere. If you're passionate about innovation and ready to make a difference in a dynamic field, join us and help shape the future of the internet!
- CIRA embraces a blend of remote and IRL in-office work to keep our team connected and engaged. Our Ottawa headquarters is a hub for regular events and social activities that bring our team together, encouraging a strong sense of community within our organization. No matter where you work from, you'll always feel part of our vibrant team and our shared mission.
- At CIRA, people remain at the centre of our recruitment process. While CIRA uses recruitment platforms that include artificial intelligence-enabled features, which may be used to support administrative processes or skills-based assessments, these features are intended to assist our recruitment activities and do not replace human judgment. All applicant screenings, interviews, evaluations and selection decisions are conducted by our staff. Artificial intelligence is not used to make autonomous or final hiring decisions.
- This posting is for an existing vacancy. CIRA is committed to fair, inclusive and accessible recruitment practices. Accommodations are available upon request throughout the recruitment, assessment and selection process. If you require any assistance or accommodation, please contact us at peopleandculture@cira.ca.
- At CIRA, we're driven by a passion to make a positive impact on Canada's digital future.
- We're not just asking, 'What more can we do?'-we're actively exploring new frontiers to enhance and secure the internet for all Canadians.
- Our recognition as one of the National Capital Region's Top Employers for ten years is a testament to our vibrant culture.
- We believe in fostering an environment where collaboration and candour are second nature and where diverse perspectives are integral to our success, because we know that great ideas come from everywhere.
- If you're passionate about innovation and ready to make a difference in a dynamic field, join us and help shape the future of the internet!
- CIRA embraces a blend of remote and IRL in-office work to keep our team connected and engaged.
- Our Ottawa headquarters is a hub for regular events and social activities that bring our team together, encouraging a strong sense of community within our organization.
- No matter where you work from, you'll always feel part of our vibrant team and our shared mission.
- At CIRA, people remain at the centre of our recruitment process.
- While CIRA uses recruitment platforms that include artificial intelligence-enabled features, which may be used to support administrative processes or skills-based assessments, these features are intended to assist our recruitment activities and do not replace human judgment.
This listing is sourced directly from CIRA's careers page and normalized into a canonical job model.