Develop and maintain Power BI dashboards, reports, DAX measures, KPIs, and dimensional data models for insurance stakeholders. Write complex SQL for data extraction, transformation, reconciliation, and analysis. Investigate data-quality issues, validate reporting accuracy, optimize performance, and translate insurance business requirements into actionable analytics solutions. Collaborate with engineering, business, and analytics teams across multiple data sources.
Power BI
- Strong hands-on experience with Power BI Desktop and Power BI Service.
- Strong knowledge of DAX, Power Query, data modeling, relationships, drill-through, bookmarks, filters, and visualization best practices.
- Experience building complex dashboards and executive or business reporting solutions.
- Understanding of Power BI performance optimization and data model design.
- Strong SQL skills, including joins, CTEs, subqueries, window functions, aggregations, and complex transformations.
- Experience analyzing and reconciling data across multiple tables and data sources.
- Good understanding of relational databases, dimensional modeling, and data warehousing concepts.
- Ability to investigate data-quality issues and independently perform root-cause analysis.
- Good understanding of insurance data and business processes, preferably within Property & Casualty insurance.
- Familiarity with policy, coverage, exposure, premium, claims, losses, reserves, limits, deductibles, brokers or agents, and underwriting.
- Ability to understand insurance KPIs and translate business questions into analytical reports and dashboards.
- Experience working with policy, claims, underwriting, or premium-related datasets is preferred.
- Design, develop, and maintain interactive Power BI dashboards and reports for insurance business users.
- Develop efficient DAX measures, calculated columns, KPIs, and data models to support analytical and reporting requirements.
- Write and optimize complex SQL queries for data extraction, transformation, reconciliation, and analysis.
- Analyze large datasets to identify business trends, data issues, and actionable insights.
- Work with business stakeholders to understand requirements and translate them into reporting and analytical solutions.
- Perform data validation, reconciliation, and root-cause analysis to ensure reporting accuracy and consistency.
- Develop and maintain dimensional data models supporting reporting and analytics use cases.
- Collaborate with data engineering, business, and analytics teams to integrate data from multiple source systems.
- Apply insurance domain knowledge to interpret business data and develop meaningful KPIs and reporting solutions.
- Support report performance optimization, production issues, enhancements, and ongoing reporting needs.
- 4-6 years of overall experience in business intelligence, reporting, or data analytics.
- Hands-on experience with Power BI and SQL in enterprise reporting environments.
- Prior experience with an insurance carrier, broker, MGA, or insurance analytics organization is highly desirable.
- Exposure to Azure, Snowflake, Databricks, or SQL Server would be an advantage.
- Strong analytical thinking, problem-solving, and communication skills.
- Ability to interact with business stakeholders and independently convert requirements into technical solutions.
Similar Jobs
Artificial Intelligence • Cloud • Computer Vision • Hardware • Internet of Things • Software
Manage end-to-end implementation and adoption of Samsara’s IoT solutions for mid-market customers. Responsibilities include creating launch plans, tracking implementation progress and account health, delivering product training, demonstrating technology, resolving challenges, and coordinating with Sales, Support, Sales Engineering, and Product. The role requires strong customer communication, consultative implementation skills, technical product experience, stakeholder management, and fluency in English and French.
Top Skills:
Equipment MonitoringIotSaaSSamsara Connected Operations CloudVehicle Telematics
Information Technology • Software • Travel
Build and maintain a mature SaaS platform across Rails backend, JSON APIs, MySQL, and Vue.js frontend. Develop travel features, partner integrations, AI-powered functionality, and document generation; optimize performance, write automated tests, upgrade dependencies, address security issues, investigate production incidents, review code, and document work. The role requires autonomous feature ownership, careful work in a large codebase, and collaboration through Git and pull requests.
Top Skills:
Amazon CloudfrontAmazon S3Aws EcsAws LambdaCapybaraDockerFactorybotGitGithub ActionsJavaScriptJson ApisMySQLRspecRubyRuby On RailsSentryVueVuetify
Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
Leads complex, cross-functional technology programs and projects from initiation through delivery. Establishes governance, delivery plans, milestones, dependencies, risk frameworks, and stakeholder cadences. Partners with Product and Engineering leadership to translate strategic roadmaps into executable release plans, manages critical-path issues and escalations, and drives release readiness across multiple teams. The role also improves program execution, release governance, transparency, quality, and delivery velocity in a healthcare technology environment.
Top Skills:
AgileAha!Hybrid Delivery ModelsJIRASoftware Development Lifecycle (Sdlc)
What you need to know about the Calgary Tech Scene
Employees can spend up to one-third of their life at work, so choosing the right company is crucial, not just for the job itself but for the company culture as well. While startups often offer dynamic culture and growth opportunities, large corporations provide benefits like career development and networking, especially appealing to recent graduates. Fortunately, Calgary stands out as a hub for both, recognized as one of Startup Genome's Top 100 Emerging Ecosystems, while also playing host to a number of multinational enterprises. In Calgary, job seekers can find a wide range of opportunities.



