Senior Data Architect/Strategist at Robots & Pencils blending advanced data knowledge with problem solving to drive intelligent products and smarter business decisions.
About the role
- Full-Stack Data Engineer responsible for transforming data into actionable insights and structured reports. Join Manulife’s team to enhance analytics and reporting with hybrid work arrangement.
Responsibilities
- Build automated data extracts and feeds from curated Gold Layer models
- Develop formatted operational and regulatory reports (Power BI, Tableau, SAC, SSRS, Crystal Reports)
- Design and maintain ETL/ELT pipelines using ADF, Informatica or similar tools
- Create reliable outbound data delivery via SFTP, APIs, or managed file transfer platforms
- Implement data validation, reconciliation checks, and robust quality controls
- Maintain clear lineage from Gold Layer to downstream outputs with audit readiness
- Optimize extraction logic for performance and scalability
- Build and manage scheduling, monitoring, and alerting for production pipelines
- Work closely with Finance, Actuarial, Operations, and business partners to gather and translate reporting needs
- Document feeds, mappings, data definitions, and technical specifications
Requirements
- Bachelor’s degree in computer science, Software Engineering, or a related field (or equivalent experience)
- 4+ years’ experience in data engineering, BI engineering, or analytics engineering
- Advanced SQL skills and strong understanding of 3NF and analytic modeling
- Hands‑on experience with ETL/ELT platforms (Informatica, ADF or similar)
- Practical experience building formatted reports (Power BI/Tableau/SAC/SSRS/Crystal Reports)
- Ability to generate and automate file‑based outputs (CSV, TSV, XML, JSON etc.)
- Experience delivering feeds via SFTP, MFT, or API frameworks
- Strong data quality, validation, and reconciliation skills
- Good understanding of data warehousing and data model design
- Familiarity with scheduling/orchestration tools (ADF, Airflow, Control‑M, Autosys)
Benefits
- Health insurance
- Dental benefits
- Vision benefits
- Short- and long-term disability insurance
- Life and AD&D insurance coverage
- Adoption/surrogacy and wellness benefits
- Employee/family assistance plans
- Retirement savings plans
- Generous paid time off program including holidays, vacation, personal, and sick days
Job title
Job type
Experience level
Salary
Degree requirement
Tech skills
Location requirements
Report this job
Found something wrong with the page? Please let us know by submitting a report below.
Principal Data Architect at PointClickCare ensuring coherent and scalable data architecture. Driving unified data direction while collaborating with Engineering Architecture team for AI enablement.
Senior Data Engineer developing the data management layer for a financial brokerage platform with scalability for larger customers. Collaborating with teams in a fully remote, diverse environment.
Technical Lead overseeing data engineers, analysts, and architects to implement data solutions. Leading modernization of data infrastructures for diverse business objectives.
Data Engineer joining a consulting firm in Toronto with world - class team of engineers. Producing high quality data tools and pipelines while collaborating with leading companies.
Director of Data Engineering & AI Strategy driving Google Marketing Platform capabilities for global marketing partner Incubeta. Hands - on technical leadership at the intersection of ad tech and media.
Data Engineer at Alberta Blue Cross designing and implementing data solutions for business analytics. Collaborating on data pipelines and analytics projects in a hybrid work environment.
LP
Snowflake Data Engineer
LinkedIn Recruiter Post
Snowflake Data Engineer contract role in Toronto (hybrid). 10+ years experience with Snowflake, DBT, SQL, ETL, and cloud platforms required.
LP
Sr. IFRS17 Data Engineer
LinkedIn Recruiter Post
Sr. IFRS17 Data Engineer contract in Toronto (Hybrid). 10+ years experience with IFRS17, SQL, Python, PySpark, ETL, cloud platforms, and leadership skills.
Data Engineer helping to improve ETL processes for investment analyses at The Battle of Giants. Collaborating directly with leadership to shape strategies and insights.