Manulife is looking for a Senior Analytics Engineer to build, optimize, and automate their people data infrastructure to provide accurate, timely, and actionable insights to HR, leadership, and business stakeholders, enabling data-driven decision-making.
Requirements
- Expert in Power BI: advanced DAX and data modeling.
- Strong SQL skills for querying and transformation.
- Experience using Databricks for preparing datasets for analysis.
- Familiarity with API integrations and RaaS connections.
- Experience with Power Automate or other workflow automation tools.
- Exposure to Python or R .
Responsibilities
- Design, develop, and optimize Power BI datasets, models, and measures for people analytics dashboards; build reusable semantic layers and data models to ensure consistency across reporting.
- Integrate data from APIs and Report-as-a-Service (RaaS) endpoints; optimize SQL queries for performance and reliability; use Databricks for data exploration advanced transformations and applications.
- Develop Power Automate flows to streamline reporting processes and reduce manual work; maintain secure, reliable connections between BI tools and enterprise data sources.
- Implement validation and reconciliation steps to ensure data accuracy; maintain clear documentation for datasets, measures, and data source connections; partner with IT and Data Privacy teams to align on data access, security and governance.
- Serve as a technical expert for Power BI, Databricks, SQL; mentor junior team members and share best practices; lead proof-of-concept projects for new tools or analytical approaches.
Other
- 5+ years in analytics, BI engineering, or related data roles.
- Bachelor's or Master's degree in Data Science, Statistics, Computer Science, or a related field.
- Strong understanding of data governance and security.
- Experience with HRIS or people data (e.g. Workday).
- Familiarity with cloud data platforms and BI security models.
