BI Developer

About the role

MicroAgility is hiring a BI Developer in Brampton, Ontario, on a one-year contract. You will design and build the data models, ETL pipelines and reporting solutions that power business decisions for the company's clients, working end to end from data warehouse design through semantic models to delivered reports.

Key responsibilities

• Design and build data warehouses, marts and semantic models.
• Develop ETL and ELT pipelines using SSIS, Azure Data Factory or similar tools.
• Build reports and dashboards using Power BI, Tableau or SSRS.
• Optimise data model performance and query efficiency.
• Implement data quality, validation and monitoring.
• Partner with business stakeholders on requirements and metric definitions.
• Document data models, transformation logic and reporting standards.

Required profile

• 4+ years of BI development experience.
• Bachelor's degree in Computer Science or a related field.
• Attention to detail, strong analytical mindset and excellent written and verbal communication.
• Agile, goal-oriented, performance-driven, with a passion for technology and continuous learning.

Required skills

• Strong SQL and hands-on data warehousing experience.
• ETL tools such as SSIS, Azure Data Factory, Informatica or Talend.
• Working knowledge of Power BI, Tableau or SSRS.
• Familiarity with dimensional modelling and Kimball methodology.
• Understanding of cloud data platforms such as Snowflake, Synapse or BigQuery.

What we offer

• Contract pay of CAD $90 per hour.
• Opportunity to work on innovative projects for high-profile clients.
• A collaborative, inclusive and supportive work environment.
• Opportunities for professional growth and development.