Business Intelligence Analyst/Developer

At Progi, it's more than a job, it's a dynamic, respectful, and stimulating workplace. Here, we all share the same source code: teamwork, passion, and excellence. Our algorithm is programmed to embrace challenges with a smile and see change as an opportunity to innovate.

Progi is a Canadian software company located in Trois-Rivières, Quebec. We develop software solutions for the automotive and insurance industries. We are proud of our prestigious customer base, but even more proud of our exceptional team.

Progi is looking for a Business Intelligence Analyst/Developer to join its Business Intelligence team.

Reporting to the Business Intelligence Coordinator, you will contribute to the development of modern analytics solutions that transform data into meaningful business insights. You will work closely with internal stakeholders to understand their business needs, design high-quality Power BI dashboards and reports, and build scalable semantic models using Google BigQuery and Google Cloud Platform (GCP).

You will also help evolve Progi's BI practices by promoting automation, data quality, and visualization best practices.

Your Day-to-Day

• Collaborate with internal stakeholders to understand reporting needs and key business performance indicators.
• Translate business objectives into actionable reporting and analytics solutions.
• Design and develop interactive reports using Power BI, Power BI Paginated Reports, and Power BI Embedded.
• Migrate legacy SSRS reports to Power BI Report Builder.
• Develop data transformations within Power BI and Dataform on Google Cloud Platform.
• Design scalable, efficient, and maintainable data models.
• Leverage BigQuery datasets to support reporting and analytics.
• Collaborate with back-end developers and Data Engineers to ensure data quality, consistency, and availability.
• Configure and monitor automated data refreshes and cloud-based reporting pipelines.
• Maintain, optimize, and enhance existing reports and dashboards.
• Document data sources, data models, calculations, and transformation logic.
• Train users on Power BI solutions and promote self-service analytics.
• Provide technical and functional support for reporting solutions.
• Contribute to the continuous improvement of BI standards, tools, and best practices.

What You Need to Apply

• Experience developing Business Intelligence solutions using Power BI.
• Strong knowledge of Power BI Desktop, Power BI Service, Power BI Report Builder, and Power BI Embedded.
• Experience working with Google BigQuery.
• Knowledge of Google Cloud Platform services such as Cloud Storage, Dataform, and Cloud Composer (or equivalent).
• Strong SQL skills.
• Good knowledge of the DAX language.
• Experience with data modeling and semantic models.
• Solid understanding of ETL/ELT concepts, data governance, and data quality.
• Understanding of cloud-based data architectures.
• Strong analytical and problem-solving skills.
• Excellent ability to synthesize information.
• Attention to detail and a commitment to quality.
• Excellent communication and interpersonal skills.
• Relevant university degree.
• Advanced English.
• Knowledge of Python (asset).
• Experience with dbt or Dataform (asset).
• Experience migrating traditional BI solutions to cloud environments (asset).
• Relevant certifications (Microsoft Power BI, Microsoft Fabric, Google Cloud Platform, Databricks, etc.) (asset).

• Group RRSP with employer contributions.
• Comprehensive group insurance plan (including dental insurance fully paid by the employer).
• Modern downtown offices (complete with a rooftop terrace and BBQ).
• On-site fitness facilities.
• Free downtown parking year-round, even on weekends.
• Employee referral bonus program ($$$).
• Team lunches.
• Summer schedule.
• Happy Hours and many social activities.