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 presenceA dynamic, diverse, and multicultural work environmentLeaders with deep market knowledge and strategic visionContinuous learning and developmentWork with stakeholders to gather requirements and construct gold/semantic level data models from mart and staging layers. Building data pipelines, provide SME to team members on semantic layer, construct DBT models from scratch for automationResponsibilitiesPipeline Design and Development; Architects and builds scalable data pipelines using modern ELT (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 SnowflakeOptimizes storage solutions for performance, cost efficiency, and scalability. 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. 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. 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. Requirements5+ years of experience working in Analytics Engineer or relevantExperience working with SQL and PythonAdvanced knowledge of PowerBI (Power Query and DAX)4+ years of experience with pipeline automation tools (Fivetran would be a plus)Strong knowledge of DBT or other ELT frameworks/tools (Apache AirFlow). Strong English communication skillsNice to HaveExperience working with Microsoft FabricExperience in Insurance or Financial ServicesBenefitsThis position comes with competitive compensation and benefits package:Competitive salary and performance-based bonusesComprehensive benefits packageCareer development and training opportunitiesDynamic and inclusive work culture within a globally renowned groupPrivate Health and Dental InsurancePension PlanMeals ticketsLife Insurance
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
Work with stakeholders to gather requirements and construct gold/semantic level data models from mart and staging layers. Building data pipelines, provide SME to team members on semantic layer, construct DBT models from scratch for automation
Responsibilities
- Pipeline Design and Development; Architects and builds scalable data pipelines using modern ELT (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
- Optimizes storage solutions for performance, cost efficiency, and scalability.
- 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.
- 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.
- 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.
Requirements
- 5+ years of experience working in Analytics Engineer or relevant
- Experience working with SQL and Python
- Advanced knowledge of PowerBI (Power Query and DAX)
- 4+ years of experience with pipeline automation tools (Fivetran would be a plus)
- Strong knowledge of DBT or other ELT frameworks/tools (Apache AirFlow).
- Strong English communication skills
Nice to Have
- Experience working with Microsoft Fabric
- Experience in Insurance or Financial Services
Benefits
This position comes with competitive compensation and benefits package:
- Competitive salary and performance-based bonuses
- Comprehensive benefits package
- Career development and training opportunities
- Dynamic and inclusive work culture within a globally renowned group
- Private Health and Dental Insurance
- Pension Plan
- Meals tickets
- Life Insurance
Get the future you want
At Capgemini, we are driven by a shared purpose: Unleashing human energy through technology for an inclusive and sustainable future.Technology shapes the way we live our lives. How we work, learn, move and communicate. That means our technology expertise, combined with our business knowledge, does more than help you transform and manage your business. It can help you realize a better future and create a more sustainable, inclusive world.It’s a responsibility we don’t take lightly. That’s why, since our inception more than 50 years ago, we have always acted as a partner to our clients, not a service provider. A diverse collective of nearly 350,000 strategic and technological experts across more than 50 countries, we are all driven by one shared passion: to unleash human energy through technology.As we leverage cloud, data, AI, connectivity, software, digital engineering, and platforms to address the entire breadth of business needs, this passion drives a powerful commitment. To unlock the true value of technology for your business, our planet, and society at large. From advancing the digital consumer experience, to accelerating intelligent industry and transforming enterprise efficiency, we help you look beyond ‘can it be done?’ to define the right path forward to a better future.
Get the future you want
At Capgemini, we are driven by a shared purpose: Unleashing human energy through technology for an inclusive and sustainable future.
Technology shapes the way we live our lives. How we work, learn, move and communicate. That means our technology expertise, combined with our business knowledge, does more than help you transform and manage your business. It can help you realize a better future and create a more sustainable, inclusive world.
It’s a responsibility we don’t take lightly. That’s why, since our inception more than 50 years ago, we have always acted as a partner to our clients, not a service provider. A diverse collective of nearly 350,000 strategic and technological experts across more than 50 countries, we are all driven by one shared passion: to unleash human energy through technology.
As we leverage cloud, data, AI, connectivity, software, digital engineering, and platforms to address the entire breadth of business needs, this passion drives a powerful commitment. To unlock the true value of technology for your business, our planet, and society at large. From advancing the digital consumer experience, to accelerating intelligent industry and transforming enterprise efficiency, we help you look beyond ‘can it be done?’ to define the right path forward to a better future.
