Senior Specialist - Data Engineering

Posted 8 Hours Ago
Be an Early Applicant
17 Locations
Remote
Mid level
Fintech • Payments • Financial Services
The Role
As a Data Engineering Senior Specialist, you will extract and integrate data, generate campaign bases, create promo qualifiers lists, and develop performance reports and visual representations of campaign results. Strong analytical skills and experience with SQL, Python, and data visualization tools are essential.
Summary Generated by Built In

You are as unique as your background, experience and point of view. Here, you’ll be encouraged, empowered and challenged to be your best self. You'll work with dynamic colleagues - experts in their fields - who are eager to share their knowledge with you. Your leaders will inspire and help you reach your potential and soar to new heights. Every day, you'll have new and exciting opportunities to make life brighter for our Clients - who are at the heart of everything we do. Discover how you can make a difference in the lives of individuals, families and communities around the world.

Job Description:

Position Overview: We are seeking a skilled and detail-oriented Data Specialist to join our Campaigns Team. The ideal candidate will play a crucial role in: generating campaign bases; identifying promo qualifiers and awardees; and creating performance and conversion reports. This position requires a strong analytical mindset, proficiency in querying and transforming data, and the ability to translate complex data into actionable campaign bases.

Key Responsibilities:

1. Data Extraction and Integration:

- Pull data from various source systems and databases

- Perform base and opportunity sizing for different client segments

- Cleanse data as needed and document data cleansing activities

- Ensure data accuracy and consistency across all sources

2. Campaign Base Generation:

- Develop and maintain scripts for campaign base creation

- Join multiple data sets to create comprehensive campaign bases

- Implement version control for all scripts and document changes

- Apply controls specified in the Communications Plan and Campaigns SOP

- Participate in test blasts and conduct UAT to validate the accuracy of the comms send out

3. Leaderboard and Promo Qualifiers List Generation:

- Identify those who qualify to promos and incentives indicated in the campaign mechanics

- Publish and refresh leaderboards to provide participants a view of their current points, rankings, and what actions they need to do to meet a certain incentive

4. Performance and Conversion Reporting:

- Develop and maintain reports to measure conversion rates

- Aggregate data at client and segment levels

- Create visualizations and dashboards to present campaign performance

5. Documentation and Knowledge Sharing:

- Maintain detailed documentation of all processes, scripts, and methodologies

- Collaborate with team members to share knowledge and best practices

- Conduct peer review

Required Qualifications:

- Bachelor's degree in Statistics, Mathematics, Computer Science, or related field

- 3+ years of experience in data analysis, preferably in marketing or campaign analytics

- Proficiency in SQL, Redshirt, Python, and AWS

- Experience with data visualization tools (e.g., Tableau, Power BI)

- Strong understanding of data structures and database management

- Excellent problem-solving and analytical skills

- Ability to work independently and as part of a team

- Strong attention to detail and commitment to data accuracy

Preferred Qualifications:

- Experience with version control systems (e.g., Git)

- Knowledge of marketing analytics and campaign management

Job Category:

Business Analysis - Process

Posting End Date:

30/03/2025

Top Skills

Python
SQL
The Company
Toronto, Ontario
499 Employees
On-site Workplace

What We Do

A UK company, Sun Life Financial of Canada is focused on building excellent customer service by offering the highest levels of customer care. We have been serving customers in the UK for over 100 years

Similar Jobs

Remote
17 Locations
2147 Employees

Sun Life Financial, Inc. Logo Sun Life Financial, Inc.

Specialist - Data Engineering

Fintech • Payments • Financial Services
Remote
17 Locations
499 Employees

Sun Life Financial, Inc. Logo Sun Life Financial, Inc.

Data Tech Lead

Fintech • Payments • Financial Services
Remote
17 Locations
499 Employees

Sun Life Financial, Inc. Logo Sun Life Financial, Inc.

Specialist - Tableau Developer

Fintech • Payments • Financial Services
Remote
17 Locations
499 Employees

Similar Companies Hiring

Bectran, Inc Thumbnail
Software • Machine Learning • Information Technology • Fintech • Automation • Artificial Intelligence
Schaumburg, IL
51 Employees
Energy CX Thumbnail
Utilities • Professional Services • Greentech • Financial Services • Energy • Consulting • Business Intelligence
Chicago, IL
55 Employees
MassMutual India Thumbnail
Insurance • Information Technology • Fintech • Financial Services • Big Data
Hyderabad, Telangana

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account