Who Can Apply
- Candidates must be legally authorized to work in Canada
Job Description
Insight Global is looking for an Intermediate BI Developer who will will support the development and delivery of Business Intelligence solutions for a confidential new business initiative. This role is focused on hands‑on BI development and data engineering, working from defined designs and requirements provided by senior team members.
The successful candidate will be responsible for building data pipelines, data models, and dashboards using the Microsoft BI stack and Azure data services. This role does not require solution architecture or ownership but does require strong technical execution, attention to detail, and the ability to deliver high‑quality BI assets in a fast‑paced environment.
BI Development & Data Engineering
Develop and maintain BI solutions based on established designs and technical direction.
ETL / ELT pipelines using Azure Data Factory and SQL‑based transformations
Write, optimize, and maintain T‑SQL queries to support data transformations, calculations, and reporting.
Support data ingestion from multiple source systems into the data warehouse.
Reporting & Visualization
Develop and maintain dashboards and reports using Power BI and/or Tableau.
Implement report logic, calculations, filters, and visuals as defined by business and technical requirements.
Ensure reports are accurate, performant, and aligned with business definitions.
Data Modeling & Quality
Build and maintain data models under senior guidance to support reporting and analytics.
Validate data accuracy, consistency, and completeness across BI solutions.
Assist with testing, troubleshooting, and resolving data quality issues.
Collaboration & Support
Work closely with Senior BI Developers and stakeholders to deliver assigned workstreams.
Participate in code reviews and incorporate feedback to improve solution quality.
Support ongoing maintenance, enhancements, and performance tuning of BI solutions.
Contribute to technical documentation, including mappings and report logic.
We may use artificial intelligence tools to assist with the screening, assessment, or selection of potential applicants for this position.
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com.To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.
Required Skills & Experience
5–7 years of hands‑on experience in BI development or analytics roles.
Strong T‑SQL skills (core querying, joins, aggregations, performance basics).
Hands‑on experience with Power BI and/or Tableau for dashboards and reporting.
Practical experience using Azure Data Factory for data ingestion and orchestration.
Experience working with data warehouses and reporting datasets.
Ability to work from defined requirements and designs and execute reliably.
Strong analytical and troubleshooting skills.
Clear written and verbal communication skills.
Nice to Have Skills & Experience
Exposure to Snowflake or modern cloud data warehouses.
Familiarity with ELT / ELT concepts and Azure data platforms.
Awareness of Microsoft Fabric or modern BI ecosystems.
Experience supporting enterprise or multi‑source BI environments.
Benefit packages for this role will start on the 1st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.