Senior Business Intelligence Developer

Canadian Internet Registration Authority

$100K — $120K *
Enterprise Technology
5 - 7 years of experience
Job Overview by Ladders

Qualifications

  • 7+ years of experience in business intelligence solutions design and development.
  • 7+ years of relational database development experience with PostgreSQL, Oracle or similar.
  • Advanced SQL skills for query development and optimization.
  • Proficient in dimensional data warehouse design using Kimball or similar methodologies.
  • 7+ years in developing ETL processes using tools like Pentaho, Informatica, or SSIS.
  • Strong Python skills for automation and data processing.
  • Experience with cloud BI solutions, particularly AWS or Azure.

Responsibilities

  • Design and develop comprehensive business intelligence solutions for both local and global teams.
  • Optimize and implement data warehouse models and ETL processes for enhanced data integration.
  • Create insightful reports and dashboards to facilitate informed decision-making.
  • Collaborate with stakeholders to gather requirements and provide technical solutions and support.
  • Troubleshoot and resolve issues in data and reporting across various production environments.
  • Contribute to the establishment of BI standards and architectural best practices.
  • Engage in CI/CD processes and Agile methodologies for software development.

Benefits

  • Opportunity to work with a diverse array of international clients.
  • Chance to contribute to cutting-edge BI tools and platforms.
  • Support for continuous professional development and skills growth.
  • Collaborative work environment with a focus on innovation and improvement.
Full Job Description
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.

Similar Jobs

More Jobs at Canadian Internet Registration Authority

More Enterprise Technology Jobs

Find similar Senior Business Intelligence Developer jobs: