Senior Business Intelligence Developer

CIRA; Ottawa; Hybrid; CAD 110,000 - 140,000; Full time

Job summary

CIRA is seeking a Senior Business Intelligence Developer to design and implement end-to-end BI solutions for internal teams and international customers. You will optimize SQL, develop ETL pipelines, and deliver insightful dashboards to support strategic decisions.

You will work with PostgreSQL/Oracle, BI tools like Power BI/Tableau, and cloud environments (AWS/Azure). Collaboration with stakeholders and CI/CD practices are part of the role in a hybrid Ottawa setting.

Qualifications

• 7+ years of experience designing and developing BI solutions.
• 7+ years of relational database experience (PostgreSQL/Oracle).
• Advanced SQL development and query optimization skills.
• 7+ years in dimensional data warehouse modelling.
• Experience with ETL tooling and BI reporting platforms.
• Strong Python for automation and data processing.
• Experience cloud platforms (AWS/Azure) and container tech.

Responsibilities

• Design, develop and support end-to-end BI solutions for internal teams and international customers.
• Model dimensional data warehouses, build ETL pipelines and data integrations.
• Develop reports and dashboards to support decision making.
• Gather requirements from stakeholders and provide ongoing support.
• Troubleshoot data, ETL and reporting issues across production environments.
• Contribute to BI architecture, standards and documentation.
• Participate in CI/CD and Agile development activities.
• Investigate root causes of production issues and implement long-term fixes.
• Collaborate with developers, QA, product owners and infra teams.

Skills

Senior BI Dev

SQL optimization

PostgreSQL/Oracle

Python

Power BI

Tableau

AWS

Azure

Docker

Kubernetes

CI/CD

Linux

Shell

Communication

Tools

Pentaho Data Integration

Informatica

Talend

SSIS

Power BI

Tableau

Apache Superset

Job description

Join the team that is building a trusted internet for Canadians! 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.

By working with the CIRA registry team, you’ll play a part in advancing the CIRA Registry Platform, which supports a wide range of domains globally. Help us drive innovation and maintain the high standards of stability and security that our platform is known for. Join us in advancing digital identity and technology in Canada and beyond.

Who You Are

You’re an experienced Senior Business Intelligence Developer who enjoys solving complex business problems through data. You have experience across the full business intelligence stack—from data modelling and ETL development to reporting, dashboards, analytics and production support.

You enjoy building trusted data solutions that help people make better decisions. Whether you're optimizing SQL, designing an ETL pipeline, creating an insightful dashboard or helping a customer solve a challenging problem, you're motivated by delivering measurable results.

You build high-quality, maintainable solutions and care deeply about data accuracy, performance and continuous improvement. You're equally comfortable working independently or collaborating with customers, stakeholders and technical teams to deliver reliable, scalable solutions.

What You'll Do

• Design, develop and support end-to-end business intelligence solutions for internal teams and international customers.
• 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.
• Work directly with customers and business stakeholders to gather requirements, define technical solutions and provide ongoing support.
• Troubleshoot and resolve data, ETL and reporting issues across national and international production environments.
• Contribute to business intelligence architecture, development standards, best practices and documentation.
• Participate in software release management, continuous integration and continuous delivery (CI/CD) processes and Agile development activities.
• 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.

What You Bring

• 7+ years of experience designing and developing business intelligence solutions.
• 7+ years of experience developing relational databases using PostgreSQL, Oracle or similar enterprise databases.
• Advanced SQL development and query optimization skills.
• 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 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.
• 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.
• Excellent verbal and written communication skills.
• Demonstrated ability to work directly with local and international business stakeholders to gather requirements and translate them into technical solutions.
• Ability to manage multiple priorities in a fast-paced environment.

Who We Are

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 [e-mail].