indeed
Enterprise Data Analyst
Cansure
Vancouver, CAN
Full Time
Mid
Hybrid
1 weeks ago
SQLMicrosoft FabricPower BIPythonData WarehousingData Quality
Free
Job Fit Check
Base Career helps you apply smarter for this job.
?%
Ready to ScanKey skills for this role
SQLMicrosoft FabricPower BI
About the Role
Specialty Program Group Canada is looking for an Enterprise Data Analyst to join their Data & Intelligence team. The role requires strong SQL skills, hands-on experience with Microsoft Fabric and Power BI, and involves supporting data warehouse initiatives, data quality, and governance.
Key Skills for This Role
SQLMicrosoft FabricPower BIPythonData WarehousingData Quality
Responsibilities
- Support various data warehouse and platform enhancement initiatives.
- Liaise with IT and Operations teams to ensure technical and business solutions meet stakeholder needs.
- Support business, contractual, and compliance data needs by creating and maintaining reporting pipelines.
- Perform data profiling; plan, execute, and review user acceptance test (UAT) cases.
- Execute data projects assigned by line manager, ensuring business requirements are understood.
- Develop and prioritize development stories, participate in Agile ceremonies.
- Establish programmatic processes to proactively measure and manage data quality using SQL.
- Collaborate with the Data & Intelligence team to implement common data definitions and metadata documentation.
Requirements
- Bachelor’s degree in a related quantitative field, or 5 years of related insurance industry data experience
- Strong, hands on SQL proficiency
- Microsoft Fabric experience (or Google Cloud data architecture such as BigQuery)
- Strong, hands on SQL and Python proficiency
- Power BI and DAX for reporting and dashboarding
- Practical exposure to data warehousing, business intelligence, data modeling, and master data management concepts
- Demonstrated SCRUM/Agile experience
Full Job Posting
Overview
- We are looking for an Enterprise Data Analyst to join our Data & Intelligence team.
- Strong SQL skills and hands on experience with Microsoft Fabric are core to this role, along with Power BI.
- Experience in the insurance industry is preferred.
- This is a hybrid position based in our Vancouver, BC office.
Responsibilities
- Support various data warehouse and platform enhancement initiatives.
- Liaise with IT and Operations teams to ensure technical and business solutions fully meet stakeholder needs.
- Support business, contractual, and compliance data needs by creating and maintaining reporting pipelines.
- Perform data profiling; plan, execute, and review user acceptance test (UAT) cases.
- Execute data projects assigned by your line manager.
- Develop and prioritize development stories, participate in Agile ceremonies.
- Establish programmatic processes to proactively measure and manage data quality using SQL.
- Collaborate with the Data & Intelligence team to implement common data definitions and metadata documentation.
Qualifications and Characteristics
- Bachelor’s degree in a related quantitative field, or 5 years of related insurance industry data experience.
- Strong, hands on SQL proficiency.
- Microsoft Fabric experience (Google Cloud data architecture such as BigQuery accepted as alternative).
- Strong, hands on SQL and Python proficiency.
- Power BI and DAX for reporting and dashboarding.
- Practical exposure to data warehousing, business intelligence, data modeling, and master data management concepts.
- Demonstrated SCRUM/Agile experience.
- Understanding of data governance, data integration, and master data management best practices.
Benefits
- Dental care
- Extended health care
- Paid time off
- RRSP match
- Vision care
Salary Range
- CAD 90,000 to CAD 100,000 per year.
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career