Data Governance Specialist (Data Analytics) - BMO Insurance
- Toronto, ON, Canada
$55,500.00 - $120,000.00 · Full-time
Applications open in a new tab.
Job details
- Pay
- $55,500.00 - $120,000.00
- Job type
- Full-time
- Apply by
- Experience
- Approximately 4–6 years of relevant experience in data analytics, business intelligence, data governance, data management, reporting, or a related field.
- Posting language
- English
- Posted
Original job description
We are seeking a Data Governance Specialist (Data Analytics) to join our Data Governance & Reporting team.
This role combines data governance with hands-on analytics, reporting, and automation to help ensure data is accurate, well-managed, accessible, and effectively used to support business decisions. The successful candidate will work with business and technology partners to improve data quality, metadata, data lineage, reporting, and governance practices while developing analytical solutions using Power BI, SQL, Python, and Power Automate.
Key Responsibilities
- Support the implementation and ongoing improvement of data governance policies, standards, processes, and controls.
- Partner with data owners, data stewards, business teams, and technology partners to improve data quality, integrity, usability, and accountability.
- Maintain and document metadata, business definitions, data lineage, data flows, and source-to-target mappings.
- Identify, investigate, and support the resolution of data quality and reporting issues.
- Develop and maintain Power BI dashboards and reports that provide meaningful business insights.
- Use SQL, Python, Power Query, and DAX to extract, transform, analyze, validate, and visualize data.
- Develop automated workflows using Power Automate and other technologies to improve reporting and data-management processes.
- Perform data reconciliation and validation to ensure the accuracy and reliability of analytical and reporting solutions.
- Translate business requirements into practical governance, reporting, and analytical solutions.
- Collaborate with cross-functional teams and communicate data insights and technical concepts clearly to both technical and non-technical audiences.
- Post-secondary education in Data Analytics, Data Science, Computer Science, Information Management, Business Analytics, or a related discipline, or equivalent professional experience.
- Approximately 4–6 years of relevant experience in data analytics, business intelligence, data governance, data management, reporting, or a related field.
- Hands-on experience with Power BI, including DAX, Power Query, data modeling, dashboards, and data visualization.
- Strong SQL skills and experience working with relational databases.
- Working knowledge of Python for data analysis, transformation, validation, or automation.
- Experience with Power Automate or similar workflow-automation technologies.
- Understanding of data governance concepts such as data quality, metadata management, data lineage, data classification, privacy, and data lifecycle management.
- Experience working with ETL processes, data integration, data validation, and analytical datasets.
- Strong analytical, problem-solving, communication, and stakeholder-management skills.
- Ability to work independently, manage multiple priorities, and collaborate effectively across business and technology teams.
- Experience with SharePoint and Microsoft 365 would be beneficial.
- Knowledge of Informatica, an enterprise cloud data management and data integration platform, would be considered an asset.
- Insurance industry knowledge or experience would be considered an asset.
$55,500.00 - $120,000.00
Pay Type:
Salaried
The above represents BMO Financial Group’s pay range and type.
Salaries will vary based on factors such as location, skills, experience, education, and qualifications for the role, and may include a commission structure. Salaries for part-time roles will be pro-rated based on number of hours regularly worked. For commission roles, the salary listed above represents BMO Financial Group’s expected target for the first year in this position.
BMO Financial Group’s total compensation package will vary based on the pay type of the position and may include performance-based incentives, discretionary bonuses, as well as other perks and rewards. BMO also offers health insurance, tuition reimbursement, accident and life insurance, and retirement savings plans. To view more details of our benefits, please visit: https://jobs.bmo.com/global/en/Total-Rewards
About Us
At BMO we are driven by a shared Purpose: Boldly Grow the Good in business and life. It calls on us to create lasting, positive change for our customers, our communities and our people. By working together, innovating and pushing boundaries, we transform lives and businesses, and power economic growth around the world.
As a member of the BMO team you are valued, respected and heard, and you have more ways to grow and make an impact. We strive to help you make an impact from day one – for yourself and our customers. We’ll support you with the tools and resources you need to reach new milestones, as you help our customers reach theirs. From in-depth training and coaching, to manager support and network-building opportunities, we’ll help you gain valuable experience, and broaden your skillset.
To find out more visit us at https://jobs.bmo.com/ca/en
BMO is committed to an inclusive, equitable and accessible workplace. By learning from each other’s differences, we gain strength through our people and our perspectives. Accommodations are available on request for candidates taking part in all aspects of the selection process. To request accommodation, please contact your recruiter.
Note to Recruiters: BMO does not accept unsolicited resumes from any source other than directly from a candidate. Any unsolicited resumes sent to BMO, directly or indirectly, will be considered BMO property. BMO will not pay a fee for any placement resulting from the receipt of an unsolicited resume. A recruiting agency must first have a valid, written and fully executed agency agreement contract for service to submit resumes.
More about this job
Responsibilities
Implement and improve data governance policies, standards, controls, metadata, lineage, and data quality in partnership with business and technology teams. Develop and maintain Power BI reporting and analytical solutions, automate workflows, validate data, and communicate insights to technical and non-technical stakeholders.
Requirements
Requires post-secondary education in a relevant discipline or equivalent experience, with approximately 4–6 years in analytics, business intelligence, governance, data management, or reporting. Candidates should have hands-on Power BI, SQL, and Python experience, familiarity with Power Automate and data governance concepts, and strong analytical and communication skills.
Skills
- Data Governance
- Power BI
- DAX
- Power Query
- SQL
- Python
- Power Automate
- Data Modeling
- Data Visualization
- Data Quality
- Metadata Management
- Data Lineage
- ETL
- Data Integration
- Data Validation
- Stakeholder Management
Benefits
- Health Insurance
- Tuition Reimbursement
- Accident Insurance
- Life Insurance
- Retirement Savings Plans
- Performance-Based Incentives
- Discretionary Bonuses
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Technology
- Finance & Accounting
Keywords
- Data Governance
- Data Analytics
- Business Intelligence
- Power BI
- DAX
- Power Query
- SQL
- Python
- Power Automate
- SharePoint
- Microsoft 365
- Informatica
- Data Quality
- Metadata Management
- Data Lineage
- Data Classification
- Data Lifecycle Management
- ETL
- Data Integration
- Data Validation
- Data Reconciliation
- Data Modeling
- Dashboards
- Reporting
- Data Privacy
- Source-to-Target Mapping
- Insurance
- Relational Databases