Remote Data Engineer at Farmers - Brazil Remote — Columbus
Traveler-Friendly Insight
Remote Flexibility: This role explicitly offers flexible work arrangements (remote and/or office-based), making it viable for location-independent professionals based in Brazil. As employment is handled through Capgemini as Employer of Record, you'll likely need to maintain Brazilian residency for payroll and legal compliance — full nomadic globe-trotting across countries may not be possible under this arrangement.
Timezone Considerations: The role is part of a US-headquartered company (Farmers). Expect some overlap with US time zones (ET/CT), which from Brazil (BRT, UTC-3) means afternoon meetings, typically 1–5 PM local time. This is manageable and leaves mornings free for deep focus work.
Async Potential: Data engineering workflows — pipeline builds, dbt model development, SQL optimization — are inherently async-friendly. While collaboration with US teams will require some synchronous availability, the nature of the work supports significant independent, heads-down time.
Cost of Living Context (Brazil-based): Without a disclosed salary, it's hard to benchmark precisely. However, working for a US-linked company via Capgemini in Brazil typically offers above-local-market compensation. Major Brazilian cities like São Paulo and Rio de Janeiro have moderate-to-high costs, while cities like Florianópolis or Recife offer a strong quality of life at lower costs — worth considering if you have location flexibility within Brazil.
Travel-Relevant Perks: No explicit coworking allowance or equipment stipend was mentioned. The training & development benefit (partnered with renowned companies) could include conferences or in-person events worth factoring in.
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
We are seeking a highly skilled and motivated Data Engineer to join the 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: Development and deployment of scalable and robust data pipelines, ensuring seamless data integration and processing across diverse systems.
- 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.
- SQL & Data Engineering: 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
- 2+ years of experience working as an Analytics Engineer or equivalent.
- Hands-on experience with SQL, SQL Server, and Python.
- 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.
- Strong problem-solving and analytical skills, with the ability to work effectively in a collaborative environment.
Nice to Have
- Experience working with Snowflake & dbt
- Knowledge of orchestration tools like Airflow
Benefits
- A competitive salary and performance-based bonuses.
- Comprehensive benefits package.
- Flexible work arrangements (remote and/or office-based).
- 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.
Frequently Asked Questions
Is this Data Engineer role fully remote or office-based?
Who is the actual employer for this position — Farmers or Capgemini?
What is the required experience level for this Analytics Engineer role?
What benefits are included with this position?
Is experience with Snowflake and dbt required for this role?
