FBS Associate Analytics Engineer

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

This position plays a role in the data ecosystem by assisting in transforming raw data into structured, high-quality datasets that are ready for analysis. The role primarily focuses on low to moderately complex business problems while receiving coaching and guidance from data leadership. The role combines the technical skills of a data engineer, the analytical mindset of a data analyst, and working business acumen to ensure data is not only collected and stored efficiently but also accessible and insightful for end users. With some coaching and guidance from more experienced engineers, 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. The position requires understanding of data engineering, business processes, and analytics principles as well as a proactive approach to solving complex data challenges.

Requirements:
• Emerging data infrastructure development with coaching and guidance: 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.
• 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.
• Data Quality Assurance - Conducts data validation and consistency checks to ensure the accuracy and reliability of data.
• Ensures compliance with industry standards and regulations such as GDPR, CCPA, or HIPAA and others as applicable.
• Technology Stack - Utilizes modern data tools and technologies such as SQL, Python, dbt, Airflow, and cloud platforms like AWS, Azure, or GCP.
• Continuous Learning – Stays updated with the latest trends, best practices, and advancements in data engineering and analytics.
• Participates in professional development opportunities to enhance technical and analytical skills.
• Provides code as requirements for hardening and operationalization by technology with significant coaching, guidance, and feedback.
• Performs other duties as assigned.

Technical & Business Skills

• 1+ year of experience working on a Data Environment
• Good Analytics mindset
• Knowledge in SQL
• Strong verbal communication and listening skills.
• Demonstrated written communication skills.
• Demonstrated analytical skills.
• Demonstrated problem solving skills.
• Effective interpersonal skills.
• Seeks to acquire knowledge in area of specialty.
• Possesses strong technical aptitude. Basic experience with SQL or similar, dimensional modeling, pipeline orchestration, building data pipelines to transform data, and BI visualizations.
• Python experience is a plus

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.