Analytics Engineer

Capgemini

Brasil

Hybrid

BRL 130,000 - 160,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Competitive salary
Performance-based bonuses
Private Health Insurance
Paid Time Off
Training & Development opportunities

Job summary

A leading global consulting firm in Brazil is seeking an experienced Analytics Engineer. This role is crucial in transforming raw data into high-quality datasets and involves developing data infrastructure, collaborating with teams, and ensuring data governance. Candidates should have over 4 years of experience in data analytics using Python, SQL, and Snowflake, along with a relevant bachelor's degree. The position offers competitive compensation, flexible work arrangements, and a dynamic work culture.

Qualifications

  • Over 4 years of experience in data development and analytics engineering using Python, SQL, DBT and Snowflake.
  • Fluency in English.

Responsibilities

  • Architect and build scalable data pipelines using modern ETL tools.
  • Transform raw data into clean, organized datasets.
  • Work closely with data analysts and stakeholders to gather requirements.
  • Implement and enforce data governance policies.

Skills

Data Transformation
Data Quality Assurance
Pipeline Design and Development
Technical Communication

Education

Bachelor’s degree in Computer Science, Data Science, Engineering or related field

Tools

SQL
Python
Snowflake
DBT

Job description

We are seeking a highly motivated Analytics Engineer to join our team.

Our Client is one of the United States’ largest insurers, providing a wide range of insurance and financial services products with gross written premiums well over US$25 Billion (P&C). They proudly serve more than 10 million U.S. households with more than 19 million individual policies across all 50 states through the efforts of over 48,000 exclusive and independent agents and nearly 18,500 employees. Finally, our Client is part of one the largest Insurance Groups in the world.

What to expect on your journey with us:
  • A solid and innovative company with a strong market presence
  • A dynamic, diverse, and multicultural work environment
  • Leaders with deep market knowledge and strategic vision
  • Continuous learning and development
Team Function

The Direct modeling team is focused on creating models to guide enterprise marketing decision that will help to promote brand awareness as well as boost sales through direct channel.

Role Description

This position plays a crucial role in the data ecosystem by iteratively transforming raw data into structured, high-quality datasets that are ready for analysis in partnership with data/decision scientists. The role primarily focuses on moderately complex business problems while receiving limited coaching and guidance from data leadership. The role combines the technical skills of a data engineer, the analytical mindset of a data analyst, and strong business acumen to ensure data is not only collected and stored efficiently but also made accessible and insightful for end users. In partnership with data/decision scientists, the position is responsible for end-to-end data workflow including data ingestion, transformation, modeling, and validation to enable data-driven decision-making across the organization. This position requires deep understanding of data engineering, business processes, and analytics principles as well as a proactive approach to solving complex data challenges.

Essential Job Functions:

1) Data infrastructure development: Pipeline Design and Development; Architects and builds scalable data pipelines using modern ETL (Extract, Load, Transform) tools and frameworks such as dbt (Data Build Tool), Apache Airflow, or similar. Automates data ingestion processes from various sources including databases, APIs, and third party services. Data Storage and Management - Designs and implements data warehousing solutions using platforms like Snowflake, Redshift, or BigQuery. Optimizes storage solutions for performance, cost efficiency, and scalability.

2) Data modeling and transformation: Data Modeling - Develops and maintains logical and physical data models to support business analytics. Creates and manages dimensional models, star/snowflake schemas, and other data structures. Data Transformation - Transforms raw data into clean, organized, and analytics-ready datasets using SQL, Python, or other relevant languages. Implements data transformation workflows to handle data cleansing, normalization, and enrichment. Data Quality Assurance - Conducts data validation and consistency checks to ensure the accuracy and reliability of data. Implements data quality monitoring and alerting mechanisms.

3) Collaboration and stakeholder management: Cross-Functional Collaboration - Works closely with data analysts, data scientists, and business stakeholders to gather requirements and understand their data needs. Acts as a liaison between technical teams and business units to translate business requirements into technical specifications. Technical Communication - Clearly communicates complex technical concepts and data insights to non-technical stakeholders. Provides training and support to team members on data tools, best practices, and methodologies.

4) Data governance and security knowledge: Governance Policies Implements and enforces data governance policies to ensure data privacy, security, and compliance with relevant regulations. Defines and manages data access, controls, permissions, and audit trails. Security Measures - Monitors and enforces data security measures to protect sensitive information from unauthorized access and breaches. Ensures compliance with industry standards and regulations such as GDPR, CCPA, or HIPAA and others as applicable.

Requirements
  • Over 4 years of experience in data development and analytics engineering using Python, SQL, DBT and Snowflake.
  • Bachelor’s degree in Computer Science, Data Science, Engineering or other Math or Technology related degrees.
  • Fluency in English
Software / Tools
  • SQL (must have)
  • Python (must have)
  • Snowflake (must have)
  • DBT (must have)
Other Critical Skills
  • Data Transformation
  • Data Quality Assurance
  • Pipeline Design and Development
  • Technical Communication

This position comes with a competitive compensation and benefits package.

  • A competitive salary and performance-based bonuses.
  • Flexible work arrangements (remote and/or office-based).
  • You will also enjoy a dynamic and inclusive work culture within a globally renowned group.
  • Private Health Insurance.
  • Paid Time Off.
  • Training & Development opportunities in partnership with renowned companies.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Engineer
Data Engineer

99x Brazil • Brazil

Remote
BRL 120,000 - 180,000
Fully remote work environment
Flexible working hours
Mentoring and career growth
+2
Data Engineer ID99039
Data Engineer ID99039

AgileEngine, LLC. • Campinas

Hybrid
BRL 494,000 - 713,000
Professional growth
Competitive compensation
Exciting projects
+1
Data Engineer ID99039
Data Engineer ID99039

AgileEngine, LLC. • Sorocaba

Hybrid
BRL 603,000 - 933,000
Professional growth
Competitive compensation
Exciting projects
+1
Data Engineer
Data Engineer

AgileEngine, LLC. • São Bernardo do Campo

Remote
BRL 520,000 - 694,000
Mentorship
Tech Talks
Education budget
+1
Data Engineer ID99039
Data Engineer ID99039

AgileEngine, LLC. • Rio de Janeiro

Hybrid
BRL 494,000 - 713,000
Professional growth
Competitive compensation
Exciting projects
+1
Data Engineer ID99039
Data Engineer ID99039

AgileEngine • Recife

Hybrid
BRL 384,000 - 494,000
Professional growth
Competitive compensation
Exciting projects
+1
Data Engineer ID99039
Data Engineer ID99039

AgileEngine, LLC. • Florianópolis

Hybrid
BRL 439,000 - 658,000
Professional growth
Competitive compensation
Exciting projects
+1
Data Engineer ID99039
Data Engineer ID99039

AgileEngine, LLC. • Belo Horizonte

Hybrid
BRL 494,000 - 713,000
Professional growth
Competitive compensation
Exciting projects
+1
Data Engineer ID99039
Data Engineer ID99039

AgileEngine, LLC. • São Paulo

Hybrid
BRL 494,000 - 658,000
Professional growth
Competitive compensation
Exciting projects
+1
Data Engineer ID99039
Data Engineer ID99039

AgileEngine, LLC. • Curitiba

Hybrid
BRL 603,000 - 905,000
Professional growth
Competitive compensation
Exciting projects
+1