Capgemini Technology Services

FBS Data Engineer

Mexico full-time Mid Salary not listed
full-time Mid level Technology & IT Curated
Sign in to apply Free account — we bring you straight back to this role.

About the role

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
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. This role will help the team to design, set up, and monitor the data ecosystem that's needed to support the modeling needs. Tasks include, but not limited to, setting up data pipelines and design efficient data storage solutions.
Responsibilities.
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), 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.

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.

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.

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

4+ years working with Python and SQL

Data Transformation

Data Quality Assurance

Pipeline Design and Development

Technical Communication

Experience working with DBT and SnowFlake

Experience working with Data Governance

Nice to Have
Experience working with Databricks
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.
Originally posted on Himalayas

Interview prep

Walk in with sharper answers.

Use this as a quick practice sheet before you speak with the employer.

Mid
Technology & IT Accounting Data Analysis MySQL Operations Python Mid level

Likely questions

  1. Tell us about work you have done that is close to the FBS Data Engineer role.
  2. How would you approach your first 30 days at Capgemini Technology Services?
  3. Which of Accounting, Data Analysis and MySQL have you used recently, and what did it help you achieve?
  4. Describe a time you solved a problem without waiting to be told exactly what to do.
  5. How do you handle busy days, changing priorities, or pressure at work?

Prepare before the call

  • A recent example that proves your experience with Accounting, Data Analysis and MySQL.
  • One short story with a problem, your action, and the result.
  • Two examples that show the strengths listed on your CV.
  • A clear reason why this role and company interest you.
  • Your availability, preferred work style, and salary expectations.

Ask them

  • What would success look like in the first 90 days?
  • What are the main problems this hire should help solve?
  • How does the team give feedback and measure good work?
  • What does a normal working week look like for this role?
Practice line

I am interested in the FBS Data Engineer role because I can bring practical experience in Accounting, Data Analysis and MySQL, learn the team quickly, and contribute to the outcomes Capgemini Technology Services needs from this hire.

Related jobs.

More roles from this company or category.