Senior Business Intelligence Developer

CIRA • Ottawa, ON

2d • CA$110,000 - CA$122,000 • Hybrid

About The Position

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.

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.
• 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.

Responsibilities

• 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 This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed