Job Summary: We are seeking a Senior Data Analyst to work on a data integration project in the insurance sector, focusing on Data Lake and integration with regulatory systems. Key Highlights: 1. Working with data analysis and structuring in cloud environments 2. Building staging and integration layers via APIs 3. Multidisciplinary team focused on synergy and professional growth We are looking for a **Senior Data Analyst** to work on a data integration project in the insurance sector, with emphasis on information structuring in a **Data Lake** and integration with regulatory systems. The professional will directly analyze data stored in a **cloud** environment (Data Lake), build *staging* layers, and perform integrations via APIs. Confitec’s work arrangement is hybrid, including in-office days at the company or client premises. We have a multidisciplinary team composed of system analysts, business analysts, and data analysts, where we value teamwork, synergy in achieving results, and professional growth. **Responsibilities and Duties** These are the main responsibilities required of the professional: * Analyze data in a Data Lake environment (structured and semi\-structured files); * Execute SQL queries using **AWS Athena**; * Identify and structure business entities (e.g., policy, premium, claim); * Build and maintain **staging** tables; * Develop data transformations (ETL/ELT); * Prepare a **data dictionary** and technical documentation; * Map data for API integration (e.g., systems such as Gepro); * Support validations with business areas (actuarial, accounting, products); * Participate in requirement analysis and refinement; **Requirements and Qualifications** * Experience with SQL (advanced level); * Experience in data analysis (minimum 2–4 years); * Experience with cloud-based data environments; * Knowledge of **Amazon S3**; * Experience in data modeling (even if informal); * Experience with ETL / data transformation; * Ability to analyze data without structured documentation \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_ **Differentiators (relevant to projects)** * Experience with **AWS Glue** * Experience with Data Lake (not just Data Warehouse) * Preferred knowledge of the insurance market * policy * premium * claim * Experience with API-based integrations * Preferred experience with regulatory projects (SUSEP, SRO, etc.) * Experience with financial/actuarial data **Behavioral Profile** We seek someone who: * Is investigative * Works autonomously * Can handle ambiguity * Can communicate effectively with business areas * Has structured thinking **Expected Tech Stack** * SQL (primary tool) * Athena * S3 * ETL tools (any) * Excel/Google Sheets (for validations) **Challenges of the Role** * Unmodeled data * Need to build understanding from scratch * Integration with external systems * Validation across multiple areas (business, actuarial, accounting) **What You Will Build** * Structured data layer (staging) * Reliable foundation for regulatory integration * Documentation that will serve as a company reference **Additional Information** * iFood Benefits * Flexible Working Hours * Program supporting and incentivizing courses and certifications * Discounts with partner universities * Health Insurance * Dental Insurance * Life Insurance * Profit Sharing (PLR) * Birthday Day Off * Pet Leave * Remote Work Allowance * TotalPass * Zenklub * Guapeco Do you know a company that has grown continuously for over 20 years? That develops **exclusive technological solutions** for leaders in the **insurance and reinsurance sector**? That combines **trust and technology** in its name — and also in daily operations? Nice to meet you — we are **Confitec**. #### **What Drives Us** Here, we believe that **people make the difference**. Our team consists of highly qualified professionals, committed and ready to tackle challenges confidently. We enjoy seeing **people grow**, learn, and evolve alongside us. Because our success only happens when yours does too. #### **Diversity and Inclusion** At Confitec, **everyone has space to be themselves**. We encourage diversity and foster a free, safe, and welcoming environment where **respect and appreciation** are part of our culture. All our job openings are designed to create **affirmative opportunities for everyone**. #### **Pride We Love to Share** We are very proud of our journey! **Confitec** has been certified by **Great Place to Work (GPTW)** since **2019**, with consecutive recognitions — proof of our commitment to building an ever-better workplace. We also participate in the ranking of the **Best Companies to Work for in Rio de Janeiro**, achieving inspiring results that motivate us to keep evolving: **2023** — 44th place **2024** — 25th place \+ **Mental Health Excellence Award** **2025** — 24th place Each achievement reinforces how deeply we live our **core values**: **Trust** **Respect** **Knowledge \& Innovation** **Results** **Commitment** #### **Want to Know How Our Selection Process Works?** https://confitec.com.br/blog/post/85/ #### **Benefits That Make a Difference (CLT Opportunities)** **SulAmérica Medical and Dental Assistance** **Meal or Food Allowance** — your choice! (via iFood Benefits) **Remote Work Allowance** **Maternity Leave (180 days)** and **Paternity Leave (20 days)** **PLR (Profit Sharing Plan)** **Childcare Allowance** **Life Insurance** **Transportation Allowance** #### **We Invest in Your Growth** Partnerships with universities and language schools offering **discounts for you and your family** — because we believe in continuous learning. #### **We Care for You Holistically** With **TotalPass** and **Zenklub**, you take care of both body and mind. #### **Here, Even Pets Get Their Moment!** Pet Leave of 2 days to enjoy the arrival of a new family member and the possibility to enroll in plans with **Guapeco**. #### **Flexibility That Adapts to You** Here, we believe in balance. We coordinate with management and **adjust schedules according to the team’s and your personal needs**. #### **Celebrating Is Part of Our Culture** **Birthday Day Off** to celebrate your way. **Special Occasion Gifts** and **Granado Kit** for new parents. **Monthly Happy Hour** with birthday celebrants. **Breakfast with CEO and Executive Team** to honor those who shape this story. **Year-End Party** — because great achievements deserve to be celebrated together! #### **Interested?** Then join us and **become a Confitecker!** **Together, let’s build the future of technology.**
João Silva
Indeed · HR
João Silva
Indeed · HR
