linkedin
Enterprise Data Analyst
SPG Canada
Vancouver, CAN
Full Time
Mid
Hybrid
1 weeks ago
SQLMicrosoft FabricPower BIDAXPythonData Warehousing
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
SPG Canada is seeking an Enterprise Data Analyst to join the Data & Intelligence team. The role involves supporting data warehouse initiatives, performing data profiling and UAT, and collaborating with IT and operations to deliver BI reporting and data products.
Key Skills for This Role
SQLMicrosoft FabricPower BIDAXPythonData Warehousing
Responsibilities
- Support data warehouse and platform enhancement initiatives including new subject areas, data quality, and compliance.
- Liaise with IT and Operations teams to ensure technical and business solutions meet stakeholder needs for BI reporting, ad hoc extracts, data science projects, and CRM.
- Support business, contractual, and compliance data needs by creating and maintaining reporting pipelines and delivering one off reports.
- Perform data profiling; plan, execute, and review UAT cases; establish MVP and acceptance criteria for development sprints.
- Execute data projects ensuring business requirements are understood and user stories are well crafted for efficient ETL/ELT development.
- Develop and prioritize development stories, participate in Agile ceremonies, and contribute to after action reviews.
- Establish programmatic processes to proactively measure and manage data quality using SQL and related languages; coordinate remediation of data defects.
- Collaborate with the Data & Intelligence team to implement common data definitions and metadata documentation; serve as EDW and data source subject matter expert.
Requirements
- Bachelor's degree in a related quantitative field or 5 years of insurance industry data experience
- Strong hands on SQL proficiency
- Microsoft Fabric experience (or Google Cloud data architecture such as BigQuery)
- Power BI and DAX for reporting and dashboarding
- Practical exposure to data warehousing, business intelligence, data modeling, and master data management
- Demonstrated SCRUM/Agile experience
- Understanding of data governance, data integration, and master data management best practices
- Consultative style leveraging both business and technical resources
- Familiarity with EPIC broker management system (nice to have)
- Exposure to NetSuite / NetSuite Analytics Warehouse (nice to have)
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 with Google Cloud data architecture (e.g., BigQuery) is an accepted alternative platform background.
- 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 — new subject areas, improved data quality, faster data availability, internal compliance, and simplified usage.
- Liaise with IT and Operations teams to ensure technical and business solutions fully meet stakeholder needs for BI reporting, ad hoc extracts, data science projects, and customer relationship management.
- Support business, contractual, and compliance data needs by creating and maintaining reporting pipelines and delivering one off reports to internal and external partners.
- Perform data profiling; plan, execute, and review user acceptance test (UAT) cases.
- Execute data projects assigned by your line manager, ensuring business requirements are properly understood and user stories are well crafted.
- Develop and prioritize development stories, participate in Agile ceremonies, and contribute to after action reviews for data projects.
- Establish programmatic processes to proactively measure and manage data quality (ideally automated) using SQL and related languages; coordinate remediation of data defects.
- Collaborate with the Data & Intelligence team to implement common data definitions and metadata documentation. Serve as an EDW and data source subject matter expert.
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 — query authoring, performance tuning, and data validation.
- Microsoft Fabric experience (Google Cloud data architecture such as BigQuery accepted as an alternative platform background).
- Strong, hands on SQL and Python proficiency — query authoring, performance tuning, data validation, and transformation/automation work in Microsoft Fabric notebooks.
- 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.
- A consultative style that leverages both business and technical resources.
- Familiarity with the EPIC broker management system (nice to have).
- Exposure to NetSuite / NetSuite Analytics Warehouse (nice to have).
Benefits
- Dental care
- Extended health care
- Paid time off
- RRSP match
- Vision care
Salary Range
- The expected salary range for this position is from CAD 90,000 to CAD 100,000.
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