Senior BI DeveloperIaawg • Calgary, AB, CA

Senior BI Developer

Iaawg • Calgary, AB, CA

17 days ago

Job type

Full-time

Job description

PPI (an independent subsidiary of iA Financial)

is an Insurance Marketing Organization that sits between independent advisors and insurance companies. From coast-to-coast, we provide value-added services and support such as digital tools, education, marketing, and processing, to help advisors elevate and grow their business with a socially responsible mindset.

Collaborate with data analysts to understand data needs and translate them into technical solutions.

Design, develop, and maintain scalable data architectures, tables and pipelines.

Implement, build and extract data in warehouse / data lake using SQL Server (on-prem) and Azure cloud technologies, in collaboration with IT.

Collaborate and assist in new data acquisition and examinations.

Design and develop data integration packages in the pursuance of ETL / ELT.

Document processes and development.

Actively share knowledge and promote best practices related to data architecture, acquisition, integration, warehousing and governance, including but not limited to creating documentation, holding training sessions, and participating in cross-functional team meetings to ensure that all teams and technical counterparts are aligned with the latest methodologies and technologies.

Ensure data quality, integrity, and security across all platforms. Work with leadership to ensure the proper controls are being managed and reviewed for all data integrations.

Develop and maintain a data inventory in the analytics warehouse, which includes a full list of available data models, model attributes, statistical reporting inventory, ad hoc data marts, and user access

Own the single source of truth conceptual model in the data warehouse and ensure that all enrichments adhere to the model design principles.

Collaborate with IT to ensure privacy / security and access to data is properly aligned to organizational standards.

Provide thought leadership and support executive decision making around the use of data, setting enterprise standards, and enforcing data governance policies across the organization

Implement best practices for data governance and compliance.

Provide project management for the implementation of data strategy and governance projects.

Support the analysis, design, development and implementation of new reporting requirements.

Assist with development and optimization of Power BI dashboards, reports, and data models.

Assist in the design, development, and implementation of Microsoft Power Platform solutions.

Apply industry knowledge of life insurance, financial reporting, and brokerage to inform data solutions.

Communicate effectively with technical and non-technical stakeholders to align solutions with business goals and corporate strategy.

Bachelor’s or master’s degree in computer science, Information Systems, or related field.

5+ years of experience in data engineering and business intelligence development.

Proficient in SQL Server, SSIS and T-SQL programming.

Experience with Azure services : Azure Data Lake Storage (ADLS), Azure Databricks, Azure Data Factory (ADF).

Expertise in Snowflake data warehousing.

Strong skills in Power BI development.

Familiarity with Azure DevOps and agile methodologies.

Experience with Version Control Systems or Source Code Management tools such as GitHub for version control, collaboration, and code management.

Knowledge of data modeling, ETL processes, and data warehousing concepts.

Excellent communication skills in English; proficiency in French is a plus.

Strong problem-solving abilities and attention to detail.

Ability to work collaboratively in a team environment and support cross-functional teams.

Collaborate with other team members in planning, reviews and retrospectives.

Demonstrated supervisory skills an asset.

PowerPoint and presentation skills.

Proficient with Microsoft Office Suite : Outlook, Teams, PowerPoint, Excel, Word.

Familiarity with other BI tools and programming languages is a plus.Let us know you’re interested!

#J-18808-Ljbffr

Create a job alert for this search

Bi Developer • Calgary, AB, CA

Similar jobs

Senior Salesforce Developer — Hybrid, AI‑Driven Integrations

AW Capital • Calgary

Full-time

A leading alternative mortgage lender is seeking a skilled Salesforce Developer in Calgary.You will be responsible for designing and deploying custom solutions, maintaining third-party integrations...Show more

Last updated: 30+ days ago • Promoted

Senior Data & Analytics Engineer

Wagepoint • Calgary, Alberta, CA

Full-time

Quick Apply

Wagepoint is a small-but-mighty fintech on a mission to make payroll simple (and maybe even delightful).Our online software takes care of the “ugh” stuff — like wage calculations and tax reporting ...Show more

Last updated: 30+ days ago

Senior SQL Developer with Capital markets experience - Luxoft

Luxoft • calgary, ab, ca

Full-time

Building a risk applications and tools for innovative international top-tier hedge fund from the ground up, comprising the systems for traders, pre-trade checks and analysis, risks and limits manag...Show more

Last updated: 1 day ago • Promoted

Senior Data Analyst : AI-Driven Analytics & Dashboards

Xplornet Communications Inc. • Calgary

Full-time

A leading telecommunications company in Calgary, Alberta, is seeking a Senior Data Analyst to create advanced analytics and support impactful decision-making. The successful candidate will lead the ...Show more

Last updated: 4 days ago • Promoted

Developer

Compunnel Inc. • Calgary

Full-time

Get AI-powered advice on this job and more exclusive features.Sign in to access AI-powered advices.Continue with Google Continue with Google. Continue with Google Continue with Google.Continue with ...Show more

Last updated: 12 days ago • Promoted

SAP BI Reporting Analyst

Precision Drilling • Calgary

Full-time

Job Title SAP BI Reporting Analyst.Precision Drilling is a leading land drilling contractor providing High Performance, High Value services across North America and select international markets.Gui...Show more

Last updated: 12 days ago • Promoted

Analyste Senior Dérivé (Hybride)

NATIONAL BANK OF CANADA • Calgary, Alberta

Full-time +2

Marchés financiers et trésorerie, Opérations .Une carrière en tant qu’analyste senior support aux cambistes dans l’équipe des Opérations Marchés des capitaux (OMC) c’est mettre ton expertise à cont...Show more

Last updated: 5 days ago • Promoted

Senior BI Developer

Bridgewater Bank • Calgary

Full-time

WHERE OTHERS SEE DATA YOU SEE opportunity.We’re looking for a BI rockstar to take our data game to the next level! As our Senior BI Developer (BI Developer III) you’ll be the go-to expert for all t...Show more

Last updated: 7 hours ago • Promoted • New!

Technology Lead - Senior Power BI, Data Engineer

Infosys • Calgary

Full-time

Technology Lead - Senior Power BI, Data Engineer.Infosys is seeking a Technology Lead - Power BI.This position will interface with key stakeholders and apply technical proficiency across different ...Show more

Last updated: 12 days ago • Promoted

Senior BI Analyst

Targeted Talent • Calgary, AB, Canada

Permanent

We are looking for an experienced.Our client is a global enterprise company with a product that you've likely used.This is a really exciting opportunity to work for a company whose product is u...Show more

Last updated: 30+ days ago • Promoted

Maximo AMS Developer – Integrations & BI Expert

IBM • Calgary

Full-time

A leading IT services firm in Calgary is looking for a Maximo AMS Application Developer to design and implement technical solutions. This role requires 5+ years of experience with Maximo, strong Jav...Show more

Last updated: 12 days ago • Promoted

Senior SAP Analytics & Power BI Lead Consultant

Infosys Limited • Calgary

Full-time

A global leader in digital services is seeking an experienced Power BI Developer in Calgary.The role requires over 10 years of expertise in business intelligence focusing on data visualization tool...Show more

Last updated: 2 days ago • Promoted

Senior Developer

ZayZoon Inc • Calgary

Full-time

At ZayZoon, we are on a mission to save ten million hardworking employees ten billion dollars.We’ve created a financial empowerment platform that helps businesses of all sizes make a big impact on ...Show more

Last updated: 30+ days ago • Promoted

Senior Developer

Critical Mass • Calgary

Full-time

As a key member of our development team, you will independently design and implement solutions for JIRA tickets, rigorously test your work across environments, and actively contribute to stand‑ups ...Show more

Last updated: 12 days ago • Promoted

Senior Data Architect — Hybrid, Azure and Data Platform

Co-operators Assurance et services financiers • Calgary

Full-time

Une coopérative canadienne de services financiers recherche un Architecte de données / Architecte principal(e) de données pour établir des solutions de données évolutives et conformes aux normes d'ar...Show more

Last updated: 12 days ago • Promoted

Senior Microsoft AI Developer

PwC Canada • Calgary

Full-time

Join to apply for the Senior Microsoft AI Developer role at PwC Canada.As a pivotal member of PwC Canada’s Products & Technology (P&T) organization, reporting directly to the Director of Software D...Show more

Last updated: 12 days ago • Promoted

Senior Power BI Developer — Data Modernization & Insights

Long View Systems • Calgary

Full-time

A leading IT services company in Canada is seeking a mid-senior level Power BI Developer to be part of their Data Modernization team. The role involves working with clients to design and implement d...Show more

Last updated: 12 days ago • Promoted

Senior AI Developer

Seequent • Calgary

Full-time

Be among the first 25 applicants.At Seequent, we help organisations understand the underground, giving them the confidence to make better decisions faster. We build world‑leading technology that is ...Show more

Last updated: 30+ days ago • Promoted