MSBI Developer - Relocation to Toronto, Ontario

ADASTRA CORPORATION - United States (30+ days ago)


Job Duties and Responsibilities

  • Develop and maintain security model and data access levels within the reporting infrastructure
  • Develop data driven reports, dashboard and analytics
  • Apply advanced knowledge of visual design, PowerBI dashboard, and PowerBI tools
  • Will be responsible for the execution and troubleshooting of DW/BI solutions on MS SQL
  • Create reports and self-service methods that help ensure data is available to decision makers
  • Effectively develop complex analytics and reports and support and understand data dimensionality, methodology, design and schema
  • Support ETL by performing loading and ensuring all data is accurate and up-to-date

Required Skills, Education, Knowledge and Experience

  • Minimum of 5 years of experience with data analytics and various report development software
  • Minimum of 2 years of Power BI experience
  • 5+ years of experience writing advanced SQL queries
  • Demonstrated proficiency in general database administration concepts and efficient query writing
  • Hands-on development expertise server platform with focus SSIS package
  • Solid expertise in SSIS, SSIS, SSAS, SSRS in an enterprise scale environment
  • Excellent communication & team management skills
  • Strong written, verbal skills
  • Possess a team-oriented attitude and work ethic
  • Strong problem-solving skills and initiative

Equal Opportunity Employer

In our commitment to promote fair and equitable treatment of all employees and applicants, Adastra Corporation provides equal employment opportunities for all individuals regardless of age, sex, disability, race, ethnic origin, citizenship, creed, sexual orientation, marital status or any other ground as described in the Ontario Human Rights Code. In addition, accommodation will be provided during the hiring process. Adastra Corporation’s implementation and support of employment initiatives encourage diversified labour force participation and equal access to opportunities based on merit and performance.

Job Type: Full-time


  • Power BI: 2 years
  • analytics: 5 years


  • Bachelor's