FBS Analytics Engineer

Capgemini

United States

Hybrid

USD 120,000 - 180,000

Full time

4 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Competitive salary
Performance-based bonuses
Comprehensive benefits
Flexible work arrangements
Dynamic and inclusive culture
Private Health Insurance
Paid Time Off
Training & Development opportunities

Job summary

Capgemini partners with Farmers to hire a skilled Analytics Engineer for the Service Analytics and AI organization. You will design, build, and maintain scalable data pipelines and analytics solutions that empower Advanced Analytics, BI, and Data Science initiatives.

You will play a crucial role in building a semantic data layer and delivering AI-driven solutions. You will collaborate with data scientists, engineers, analysts, product managers, and business stakeholders to implement robust

Qualifications

  • 3+ years of experience as Analytics Engineer or equivalent
  • Hands-on SQL, Python, Snowflake and DBT experience
  • Experience with Git and Airflow workflows
  • Proven ability to design and build scalable data pipelines
  • Expertise in ETL/ELT, data modeling, and data warehouse integration
  • Experience with CI/CD workflows and data engineering tools
  • Strong problem-solving and collaboration skills

Responsibilities

  • Design, develop, and deploy scalable data pipelines across diverse systems.
  • Establish best practices for data engineering, governance, performance optimization, and automation.
  • Participate in code reviews and promote coding standards.
  • Design, build, and maintain ETL/ELT pipelines and reusable data processing libraries.
  • Implement CI/CD pipelines for analytics workflows.
  • Collaborate with data scientists, analysts, and product stakeholders to understand requirements.
  • Explain complex data concepts to non-technical stakeholders.
  • Perform advanced SQL development and large-scale data processing.
  • Work with Snowflake features like data sharing, tasks, streams, and performance tuning.
  • Build scalable transformation frameworks and testing/documentation pipelines using dbt.
  • Develop star schemas, conformed dimensions, and analytical data models.
  • Ensure data quality, lineage, metadata, observability, and lifecycle management.
  • Deliver data products within Agile teams in modern cloud environments.

Skills

SQL
Python
Snowflake
DBT
ETL/ELT pipelines
CI/CD
Airflow
Git
Data modeling
Data warehousing

Tools

dbt
Airflow
Git

Job description

FBS – Farmer Business Services is part of Farmers operations with the purpose of building a global approach to identifying, recruiting, hiring, and retaining top talent. By combining international reach with US expertise, we build diverse and high-performing teams that are equipped to thrive in today’s competitive marketplace.

We believe that the foundation of every successful business lies in having the right people with the right skills. That is where we come in—helping Farmers build a winning team that delivers consistent and sustainable results.

Since we don’t have a local legal entity, we’ve partnered with Capgemini, which acts as the Employer of Record. Capgemini is responsible for managing local payroll and benefits.

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

Seeking a highly skilled and motivated data engineer to join Analytics Engineering team within the Service Analytics and AI organization. This role is pivotal in designing, building, and maintaining scalable data pipelines and analytics solutions that empower Advanced Analytics, Business Intelligence, and Data Science initiatives. You will play a crucial role in building a semantic data layer, defining and implementing cutting-edge data products, and delivering innovative AI-driven solutions that fuel business growth and enhance customer experience.

Responsibilities
  • Data Pipeline Development: Lead the design, development, and deployment of scalable and robust data pipelines, ensuring seamless data integration and processing across diverse systems.
  • Analytics Engineering Best Practices: Establish and uphold best practices for data engineering, including coding standards, data governance, performance optimization, and automation strategies.
  • Code Quality and Review: Participate in code reviews, provide constructive feedback, and contribute to the team's continuous improvement in coding practices and methodologies.
  • ETL/ELT Development: Design, build, and maintain robust ETL/ELT pipelines, reusable frameworks, and libraries to process and transform data from diverse sources, ensuring accuracy, quality, and consistency.
  • Automation and CI/CD: Implement CI/CD pipelines to streamline the deployment, testing, and maintenance of analytics engineering processes.
  • Cross-functional Collaboration: Partner with data scientists, engineers, analysts, product managers, and business stakeholders to understand requirements
  • Stakeholder Communication: Articulate complex technical concepts to non-technical stakeholders, fostering alignment and ensuring a shared understanding of data initiatives across teams.
  • SQL & Data Engineering: Advanced SQL development, query optimization, complex transformations, and large-scale data processing.
  • Hands-on experience designing and developing enterprise-scale data solutions using Snowflake including performance tuning, data sharing, tasks, streams, and modern platform capabilities.
  • Experience building scalable transformation frameworks, reusable business logic, testing, documentation, and deployment pipelines using dbt.
  • Star schemas, conformed dimensions, historical tracking, KPI frameworks, and analytical data models.
  • Data quality, lineage, metadata management, testing, observability, and model lifecycle management.
  • Experience delivering data products within Agile product teams and modern cloud environments.
Requirements
  • 3+ years of experience working as an Analytics Engineer or equivalent
  • Hands-on experience with SQL, SQL Server, Python, SnowFlake and DBT.
  • Experience in version control systems such as Git, and workflow management tools such as Airflow
  • Proven experience in designing and building scalable data pipelines.
  • Expertise in ETL/ELT processes, data modeling, and integration of data from multiple sources into a data warehouse.
  • Experience with CI/CD workflows and tools for data engineering.
  • Strong problem-solving and analytical skills, with the ability to work effectively in a collaborative environment.
Benefits

This position comes with a competitive compensation and benefits package.

  • A competitive salary and performance-based bonuses.
  • Comprehensive benefits package.
  • 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

FBS Associate Analytics Engineer
FBS Associate Analytics Engineer

Capgemini • Los Angeles (CA)

Hybrid
USD 110,000 - 165,000
Private Health Insurance
Paid Time Off
Performance bonus
+2
FBS Senior Analytics Engineer
FBS Senior Analytics Engineer

Capgemini • Los Angeles (CA)

Hybrid
USD 120,000 - 180,000
Private Health Insurance
Paid Time Off
Training & Development opportunities
+1
FBS Data Engineer (Javascript, SQL experience)
FBS Data Engineer (Javascript, SQL experience)

Capgemini • United States

Hybrid
PHP 669,600 - 892,800
Competitive salary
Performance-based bonuses
Flexible work arrangements
+2
FBS Sr Data Engineer (SQL, Informatica) (Remote)
FBS Sr Data Engineer (SQL, Informatica) (Remote)

Capgemini • United States

Hybrid
USD 110,000 - 160,000
Competitive salary
Bonuses based on performance
Comprehensive benefits
+5
FBS (Mexico) - Associate Analytics Engineer (USFITFU)
FBS (Mexico) - Associate Analytics Engineer (USFITFU)

Farmers Insurance • United States

Remote
USD 110,000 - 150,000
Competitive compensation
Performance-based bonuses
Comprehensive benefits
+1
Senior Data Engineer — Remote, Big Data & AI Enablement
Senior Data Engineer — Remote, Big Data & AI Enablement

Capgemini • United States

Hybrid
USD 110,000 - 160,000
Competitive salary
Bonuses based on performance
Comprehensive benefits
+5
FBS Cloud Engineer
FBS Cloud Engineer

Capgemini • United States

Hybrid
MXN 1,531,000 - 2,212,000
Competitive salary and performance-based bonuses
Comprehensive benefits package
Flexible work arrangements
+4
FBS - Actuarial Predictive Analyst II
FBS - Actuarial Predictive Analyst II

Capgemini • United States

Hybrid
USD 70,000 - 120,000
Comprehensive benefits package
Career development and training
Senior Analytics Engineer
Senior Analytics Engineer

Jobgether • United States

Remote
USD 155,000 - 170,000
Remote work arrangement
Stock options
Health benefits
+2
FBS (Mexico) - Data Scientist
FBS (Mexico) - Data Scientist

Farmers Insurance • United States

Remote
USD 120,000 - 160,000
Competitive compensation
Performance-based bonuses
Comprehensive benefits
+1