Data Engineer

Solution Partners, Inc.; Brasil; Presencial; BRL 180 000 - 240 000; Tempo integral

Resumo da oferta

Solution Partners, Inc. is seeking a Data Engineer on the Conversions team to migrate policy data from legacy systems to a modern policy platform. You will profile data, build staging pipelines, resolve data quality issues, and deliver validated data loads with mentorship from an experienced conversion manager.

The role emphasizes SQL, data engineering, and effective communication to support iterative delivery throughout the data migration lifecycle, from discovery to production cutover.

Qualificações

• 2-5 years of experience in data engineering within insurance or financial domains.
• Proficiency in SQL Server and ETL processes.
• Experience with AWS services (RDS, S3, Secrets Manager) and data profiling.
• Strong data validation and data cleansing practices.

Responsabilidades

• Profile source data and identify data quality gaps and transformation requirements.
• Design and maintain SQL staging views to transform legacy data for the target system.
• Create lookup/reference views mapping source codes to target platform values.
• Build and execute validation queries and reconciliation checks.
• Collaborate with stakeholders and document data mappings and specs.
• Leverage AI coding assistants to accelerate SQL development and documentation.
• Maintain data pipelines in cloud environments and ensure secure handling of sensitive data.

Conhecimentos

SQL

Data profiling

Data validation

ETL

AWS

Excel

AI coding assistants

Code comprehension

Communication

Problem solving

Ferramentas

SQL Server

AWS RDS

S3

Secrets Manager

Descrição da oferta de emprego

For this role we need someone who is working or worked in the past for a Life Insurance company.

As a Data Engineer on the Conversions team, you will play a critical role in migrating insurance policy data from administration systems to a modern policy administration platform. Your primary responsibility is to profile source data, build staging pipelines, resolve data quality issues, and deliver validated data loads. This role offers direct mentorship from an experienced conversion manager and exposure to the full data migration lifecycle from initial discovery through production cutover. This position requires technical expertise in SQL and data engineering, combined with effective communication to support iterative delivery cycles

Key Responsibilitie

• s:
  Data Profiling & Analys
• is:o Profile source system data to identify data quality gaps, mapping requirements, and transformation log
• ic.o Investigate data anomalies, trace root causes across related tables, and document findings for stakeholder revi
• nt:o Design and maintain SQL staging views that transform legacy data into target system form
• at.o Create and maintain lookup/reference views that map source system codes to target platform valu
• es.Data Validation & Quali
• ty:o Build and execute validation queries, reconciliation checks, and load report resolution workflo
• ws.o Participate in iterative data quality cycles (profile, fix, reload, validate) until target thresholds are m
• et.o Implement data validation checks, monitor data quality, and address issues related to data integrity and accura
• cy.Collaboration with Stakeholde
• rs:o Resolve load report findings and deliver clean data packag
• es.o Maintain ongoing communication with internal teams to ensure requirements are fully understood and reflected in delivered solutio
• ns.o Provide regular updates on project progress, issues, and mileston
• es.Automation & Tooli
• ng:o Maintain and populate target staging databases in cloud environments (AWS RD
• S).Documentation & Knowledge Shari
• ng:o Document data mappings, transformation logic, product specifications, and data dictionari
• es.o Create and maintain comprehensive technical documentation including SQL scripts, process workflows, and integration specificatio
• ns.o Share knowledge and expertise with team members, promoting best practices and fostering a culture of collaborative learni
• ng.AI-Assisted Developme
• nt:o Leverage AI coding assistants (e.g., Claude, Copilot) to accelerate SQL development, data profiling, script generation, and documentati
• on.O Write effective prompts to guide AI tools for complex data analysis, code generation, and automated reporti
• ng.o Review, validate, and refine AI-generated outputs to ensure accuracy and alignment with business requiremen
• on.o Stay up to date with emerging data engineering technologies, AI tooling, and best practices to improve solution delive
• ry.o Absorb insurance domain knowledge through mentorship, documentation review, and hands-on data explorati
• on.Code Quality and Best Practic
• es:o Write clean, efficient, and maintainable code, adhering to coding standards and best practic

Qualificati

• ons:
  2-5 years of exper
• ienceHighly Prefe
• ienceo Experience with policy administration sy
• stemso Experience in the insurance/financial ind
• ustry
  Proficiency in SQL Server (queries, views, stored procedures, CTEs, window functions) and ETL (Extract, Transform, Load) pro
• cessesAWS: RDS, S3, Secrets Manager, or equivalent cloud database expe
• rienceProficiency in Excel for data analysis and legacy data
• review
• GitHubExperience with project management software (e.g.,
• liveryExperience ensuring secure data handling, especially sensitive financial data and personally identifiable information
• (PII)Proficient in data validation and data cleansing pra
• cticesExperience using AI coding assistants (Claude, GitHub Copilot, or similar) for development workflows, prompt engineering, and automated an

alysis Compet

• encies:
  Excellent communication and interpersonal skills, capable of conveying complex technical concepts to non-technical stake
• holders.Strong problem-solving abilities and analytical t
• hinking.Self-directed learner who thrives with mentorship - eager to absorb insurance domain knowledge and conversion meth
• odology.Ability to work on multiple projects simultaneously while ensuring high-quality d
• elivery.Attention to detail, with a focus on delivering accurate and validat