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.

We are seeking a highly skilled and motivated data engineer to join Analytics Engineering team within the Service Analytics and AI organization.

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.
• Problem-solving and analytical skills, with the ability to work effectively in a collaborative environment.

Nice to Have:

• Experience working with SnowFlake & DBT.
• Knowledge on orchestration tools like AirFlow.

Benefits:

• A competitive salary and performance-based bonuses.
• Comprehensive benefits package.
• Flexible work arrangements (remote and/or office-based).
• Private Health Insurance.
• Paid Time Off.
• Training & Development opportunities in partnership with renowned companies.