Data Engineer - AWS (Remote Set-up)

Data Engineer

ECLARO: A Quick Summary

Utilizing our proprietary TRINIT-E® Service Maturity Model, we help clients implement programs to promote innovation, automation, and process improvement.

About the Role

As a Data Engineer on the Finance & Valuation Solutions (FinVal) team, you will play a critical role in delivering and optimizing cloud-native data solutions that support our finance, valuation, and policy administration workflows. You will collaborate with engineers, analysts, and business partners to build high-quality, well-tested solutions that align with business objectives, supporting both new implementations and enhancements to existing systems.

Solution design should be modern, flexible, scalable, and decoupled wherever possible, built and deployed as infrastructure-as-code on AWS.

Key Responsibilities

• Design, implement, and optimize end-to-end data pipelines on AWS (Glue, Step Functions, Lambda) for ingesting, transforming, and reconciling structured and unstructured financial data.
• Build robust ETL processes integrating data across diverse sources, including policy administration systems (e.g., Sapiens CoreSuite), IAS, and bank/partner file feeds.

• Perform technical assessments and deliver solutions that meet business requirements, deadlines, and quality standards.
• Provision and manage AWS resources via infrastructure-as-code (AWS CDK), including S3, DynamoDB, Glue, IAM, and KMS.
• Implement secure data handling for sensitive financial data and PII, including KMS/CMK encryption, enforced SSL, and least-privilege access.
• Monitor pipeline performance, troubleshoot issues, and implement optimizations for reliability and efficiency.

• Write clean, maintainable, and well-tested code.
• Develop unit tests and conduct functional and integration testing as a standard part of delivery.
• Work within CI/CD pipelines (GitHub Actions), supporting automated quality gates including unit-test coverage, security scanning, and build validation.
• Participate in code reviews and uphold coding standards and version-control discipline.

• Build strong working relationships with internal and external stakeholders and maintain clear communication throughout delivery.
• Create and maintain technical documentation, including code, processes, architecture diagrams, integration specifications, and operational runbooks.
• Provide post-implementation and production support, resolving issues quickly to minimize business disruption.
• Work within an agile framework, including planning, stand-ups, and reviews, to ensure timely delivery.

• Proficiency with AWS data and serverless services (Glue, Lambda, S3, DynamoDB, Step Functions, QuickSight).
• Strong Python development skills.
• Infrastructure-as-code experience, preferably AWS CDK (CloudFormation/Terraform also relevant).
• Unit testing and CI/CD pipeline experience (GitHub Actions or equivalent).
• SQL Server (queries, SSIS, SSRS) and ETL processes for supporting and modernizing legacy solutions.
• Knowledge of APIs and their integration.
• Understanding of SDLC, testing, deployment, and version-control best practices.
• Experience ensuring secure handling of sensitive financial data and PII.
• Proficiency in data validation and data cleansing practices.
• Experience with project management/tracking tools (e.g., Jira).

Qualifications:

• Bachelor's degree in Computer Science, Engineering, Data Science, or a related field, or equivalent experience.
• 3–5 years of experience building and operating data pipelines and data engineering solutions with demonstrable AWS cloud experience.

• Experience in the insurance or financial services industry.
• AWS certification (Cloud Practitioner or Associate-level).
• Experience with core banking systems and financial transaction processing.
• Familiarity with policy administration platforms (e.g., Sapiens CoreSuite) and/or actuarial/valuation data flows.