Business Analytics Specialist

**_We are a _**_leading financial services provider committed to making decisions easier and lives better for our customers and _**_colleagues around the world. From our environmental initiatives to our community investments, we lead with values throughout our business. _**_To help us stand out, we help you step up, because when colleagues are healthy, respected and meaningfully challenged, we all thrive. Discover how you can grow your career, make impact and drive real change with our Winning Team today. _**

**Working Arrangement**

Hybrid

**The opportunity**

This is an exciting opportunity to work within an Agile Kanban Business Analytics squad in an organization that has unique touch points across the Group Benefits business.

**Responsibilities**:

- Work with business stakeholders to understand their data, metrics, KPI or insights needs
- Become the data owner & primary administration support for the internal CRM tool from a data integrity and user maintenance perspective
- Ability to interact with business on explaining analytics solution and presenting analytics insights.
- Maintain/enhance our PowerBI and SSRS/SSIS Solutions
- Support/investigate complex SSIS/Python packages that transform data
- Actively engaged in the agile development cycle for infrastructure/analytics items from a data testing perspective
- Providing direction to self-service Power BI reports and responding to ad-hoc data requests
- Ability to explain technical concepts to the business and management. Demonstrated ability to work with both technical and non-technical resources

**How will you create an impact?**

Will be reporting to Director - Data Analytics.

This is an exciting opportunity to work within an Agile Kanban Business Analytics squad in an organization that has unique touch points across the Group Benefits business.

**What motivates you?**
- You obsess about customers, listen, engage and act for their benefit.
- You think big, with curiosity to discover ways to use your agile approach and enable business outcomes.
- You thrive in teams and enjoy getting things done together.
- You take ownership and build solutions, focusing on what matters.
- You do what is right, work with integrity and speak up.
- You share your humanity, helping us build a diverse and inclusive work environment for everyone.

**What we are looking for**
- 3-5+ Years of work experience in related fields
- Undergraduate degree in Math, Stats, Finance, Computer Science, or a related field
- Advanced working SQL knowledge and experience working with multidimensional and relational databases
- Solid working knowledge of data processing tools using SQL, Spark, Python or similar open source and commercial technologies
- Advanced working knowledge of data visualization tools such as PowerBI or Tableau, both as a user and developer.
- Experience initializing and managing cloud platforms: AWS, Azure etc.
Significant experience with SQL, Stored Procedures and ETL processes using SSIS and other data extraction tools
- Ability to explain technical concepts to the business and management. Demonstrated ability to work with both technical and non-technical resources
- Solid understanding and knowledge of visualization BI tools such as Microsoft Power BI, Tableau.
- Practical experience with big data processing frameworks and techniques such as Azure, AWS, Hortonworks, Spark, Hive etc.
- Ability to interact with business on explaining analytics solution and presenting analytics insights.
- Capable of adapting quickly, manage multiple demands and competing priorities, deliver to deadlines

**What can we offer you?**
- A competitive salary and benefits packages.
- A growth trajectory that extends upward and outward, encouraging you to follow your passions and learn new skills.
- A focus on growing your career path with us.
- Flexible work policies and strong work-life balance.
- Professional development and leadership opportunities.

**Our commitment to you**
- Values-first culture
We lead with our Values every day and bring them to life together.
- Boundless opportunity
We create opportunities to learn and grow at every stage of your career.
- Continuous innovation
We invite you to help redefine the future of financial services.
- Delivering the promise of Diversity, Equity and Inclusion
We foster an inclusive workplace where everyone thrives.
- Championing Corporate Citizenship
We build a business that benefits all stakeholders and has a positive social and environmental impact.

**About John Hancock and Manulife**

**Manulife is an Equal Opportunity Employer**

**Salary & Benefits**

The annual base salary for this role is listed below.

**Primary Location**

Waterloo, Ontario

**Salary range is expected to be between**

$58,100.00 CAD - $107,900.00 CAD

Manulife offers eligible employees a wide array of customizable benefits, including health, dental, mental health, vision, short