Full Stack Data Engineer (Analytics + ETL + Reporting)

United States Digital Space LLC; United States; Hybrid; USD 61,119 - 96,613; Full time

Job summary

United States Digital Space LLC is seeking a highly skilled Full-Stack Data Engineer (Analytics + ETL + Reporting) to turn curated data into actionable insights, automated feeds, and enterprise-grade reports. The role lives downstream of the Gold Layer, delivering reports, extracts, and secure feeds for Finance and Operations.

The position emphasizes hands-on ETL/ELT with Informatica and ADF, advanced SQL, and formatted reports via Power BI, Tableau, SAC, SSRS, and Crystal Reports in a hybrid

Qualifications

• Bachelor’s degree in computer science, software engineering, or related field or equivalent experience.
• 4+ years’ experience in data engineering, BI engineering, or analytics engineering.
• Advanced SQL and 3NF/analytic modeling.
• Hands-on ETL/ELT with Informatica, ADF or similar.
• Experience building formatted reports (Power BI/Tableau/SAC/SSRS/Crystal Reports).

Responsibilities

• Build automated data extracts and feeds from 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.
• Create reliable outbound data delivery via SFTP, APIs, or MFT platforms.
• Implement data validation, reconciliation checks, and quality controls.
• Maintain 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.
• Collaborate with Finance, Actuarial, Operations, and business partners to translate reporting needs.
• Document feeds, mappings, data definitions, and technical specs.

Skills

Advanced SQL

Data modeling

ETL/ELT pipelines

Reporting concepts

Cross-functional collaboration

Education

Bachelor’s degree in Computer Science or related field

Tools

Informatica

ADF

Power BI

Tableau

SSRS

Crystal Reports

SFTP/API frameworks

Job description

the company / John Hancock is seeking a highly skilled Full‑Stack Data Engineer (Analytics + ETL + Reporting) with expertise in turning curated data into actionable insights, automated feeds, and enterprise‑grade reports with hands-on experience on Informatica/ADF, data warehousing and data model design to join our Insurance Licensing \& Compensation engineering team. The successful candidate will design, develop, enhance, and turning curated data into actionable insights, automated feeds, and enterprise‑grade reports. As a Full‑Stack Data Engineer – Reporting, Extracts \& Feeds, you will work downstream of our established Gold Layer, transforming business‑ready data into reports, extracts, and secure feeds consumed across Finance, Distribution, Operations, and other enterprise functions.

Work Arrangement: Hybrid from nearest office (3 days in Office, 2 days from Home); Remote working arrangement is not available.

Position 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.

Required Qualifications:

• 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).
• Strong communication skills and ability to work cross‑functionally with business teams.

Preferred Qualifications:

• Exposure to cloud platforms (Azure preferred).
• Experience with Git, CI/CD pipelines, and DevOps practices.
• Familiarity with API gateways, REST APIs, and event‑driven patterns (Kafka/Event Hub).
• Understanding of metadata management and data governance frameworks.
• Background in insurance, or financial systems would be an asset.

*When you join our team:*

• We’ll empower you to learn and grow the career you want.
• We’ll recognize and support you in a flexible environment where well-being and inclusion are more than just words.
• As part of our global team, we’ll support you in shaping the future you want to see.

The role being advertised is an existing vacancy.

About the company and John Hancock

the company Financial Corporation is a leading international financial services provider, helping people make their decisions easier and lives better. To learn more about us, visit https://www.the company.com/en/about/our-story.html.

the company is an Equal Opportunity Employer

At the company/John Hancock, we embrace our diversity. We strive to attract, develop and retain a workforce that is as diverse as the customers we serve and to foster an inclusive work environment that embraces the strength of cultures and individuals. We are committed to fair recruitment, retention, advancement and compensation, and we administer all of our practices and programs without discrimination on the basis of race, ancestry, place of origin, colour, ethnic origin, citizenship, religion or religious beliefs, creed, sex (including pregnancy and pregnancy-related conditions), sexual orientation, genetic characteristics, veteran status, gender identity, gender expression, age, marital status, family status, disability, or any other ground protected by applicable law.

It is our priority to remove barriers to provide equal access to employment. A Human Resources representative will work with applicants who request a reasonable accommodation during the application process. All information shared during the accommodation request process will be stored and used in a manner that is consistent with applicable laws and the company/John Hancock policies. To request a reasonable accommodation in the application process, contact [e-mail].

Referenced Salary Location

Toronto, Ontario

Working Arrangement

Hybrid

Salary range is expected to be between

$86,100.00 CAD - $136,100.00 CAD

Employees also have the opportunity to participate in incentive programs and earn incentive compensation tied to business and individual performance. The actual salary will vary depending on local market conditions, geography and relevant job-related factors such as knowledge, skills, qualifications, experience, and education/training. If you are applying for this role outside of the primary location, please contact [e-mail] for the salary range for your location.

the company offers eligible employees a wide array of customizable benefits, including health, dental, mental health, vision, short- and long-term disability, life and AD\&D insurance coverage, adoption/surrogacy and wellness benefits, and employee/family assistance plans. We also offer eligible employees various retirement savings plans (including pension and a global share ownership plan with employer matching contributions) and financial education and counseling resources. Our generous paid time off program in Canada includes holidays, vacation, personal, and sick days, and we offer the full range of statutory leaves of absence. If you are applying for this role in the U.S., please contact [e-mail] for more information about U.S.-specific paid time off provisions.

We use data and analytics technologies, such as artificial intelligence (AI), and automated processing tools, to analyze and process the information you provide to us or third parties in the application process. For more information, please refer to our personal information collection statement.