Business Intelligence Developer

  • Canadian Internet Registration Authority (CIRA)
  • Ottawa, ON, Canada
  • Apr 17, 2018
Full time Business Development Data & Analytics Information Technology

Job Description

The Canadian Internet Registration Authority (CIRA) is a leading organization at the heart of Canada’s Internet. We shape our country’s Internet infrastructure, employ cutting-edge technologies, and push the bounds of possibility. CIRA manages Canada's .CA domain name registry, develops and implements policies that support Canada's Internet community and is a prominent voice on issues of national and international importance relating to Internet governance.

 

With over two million .CA domain names registered and growing, CIRA has experienced significant growth over the last few years and has been named by AON Hewitt as one of Canada's 50 Best Small and Medium sized employers for 2015 and platinum status for 2016. We are looking for talented professionals who are passionate about the future of the internet and who value working with a seasoned team.

Who you are:

You are a dynamic individual possessing experience in business intelligence with a desire to grow within the organization and support internal data assets and business intelligence processes.

 

You will work in a fast-paced environment as a member of the Information Management Team supporting CIRA databases and reporting systems from a data integrity/quality perspective. You will be involved in designing and developing decision support solutions and assist with data troubleshooting activities and production data updates.  You’re an analytical, big picture BI thinker who can jump in and work collaboratively to solve problems at any level.

What you’ll do:

  • Design and develop data models as per business specifications.
  • Design, develop, document and support data warehouse schemas and ETL processes.
  • Design and develop business intelligence solutions for internal departments.
  • Respond to ad hoc data requests from departments within the organization.
  • Gather specifications for reporting needs from internal partners.
  • Develop processes for updating production system data as required.
  • Investigate and resolve data quality issues and escalate situations according to department processes.

What you bring:

Required Qualifications:

  • Excellent SQL skills.
  • 3-5 years experience with:
    • Database design and development with Oracle (10g or greater) or PostgreSQL
    • Data warehouse modeling and development
    • Any ETL tool
    • Content development with professional BI software (IBM Cognos, Microstrategy, Pentaho, Business Objects, Qlik, Tableau)
  • Experience working with open source BI software
  • Working within a well-defined software lifecycle process: design and document, release management using source repository and development testing
  • Data management processes and procedures
  • Strong understanding of reporting/decision support system architecture
  • Practical experience in dimensional modeling
  • Proficiency in English is essential