Role Title: Data Engineer

ECLARO: A quick Summary

ECLARO is an award-winning professional services firm headquartered in New York City and operating in the U.S., Canada, UK, Ireland, Australia and the Philippines. We are dedicated to a singular purpose: providing the Right People to meet every client's needs and solve business challenges through strategic staffing, permanent placement, custom outsourcing & offshoring. 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
Data Pipeline & Solutions Delivery
• 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.

Infrastructure as Code & Cloud Engineering
• Provision and manage AWS resources via infrastructure-as-code (AWS CDK) — S3, DynamoDB, Glue, IAM, KMS — rather than manual console changes.
• 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.

Code Quality, Testing & CI/CD
• Write clean, maintainable, well-tested code. Develop unit tests and conduct functional and integration testing as a standard part of delivery — not an afterthought.
• 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.

Collaboration, Documentation & Support
• Build strong working relationships with internal and external stakeholders; maintain clear communication so requirements are fully understood and reflected in delivered solutions.
• Create and maintain technical documentation — code, processes, architecture diagrams, integration specs, and operational runbooks.
• Provide post-implementation and production support, resolving issues quickly to minimize business disruption.
• Work within an agile framework — planning, stand-ups, and reviews — to ensure timely delivery.

Technical Skills
• 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).

Job Profile
Education:
• Bachelor's degree in computer science, engineering, data science, or a related field — or equivalent experience.
Experience:
• 3-5 years building and operating data pipelines / data engineering solutions, with demonstrable AWS cloud experience.
Highly preferred:
• Experience in the insurance / 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.

Data Engineer (Fin and Val) - Python and AWS