FBS AWS Data 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 works on data projects of intermediate complexity to lead in the design, development, and implementation of data products.

Key Responsibilities

•Preps/cleanses data to optimize for downstream reporting via Farmers standard visualization or AI/ML tools with coaching and feedback

•Translates business data stories into a technical story breakdown structure and work estimates for a schedule or planned agile sprint.

•Develops and maintains moderately complex scalable data pipelines for both streaming and batch requirements and builds out new API integrations to support increased demands of data volume and complexity

•Produces data building blocks, data models, and data flows for varying client requests such as dimensional data, standard and ad hoc reporting, data feeds, dashboard reporting, and data science research and exploration.

•Creates business user access methods to structured and unstructured data. Utilizes techniques such as mapping data to a common data model, natural language processing, transforming data as necessary to satisfy business rules, AI, statistical computations, and validation

•Responsible for acquiring, curating, and publishing data both on prem and in the cloud for analytical or operational uses for basic to moderate scenarios.

•Ensures the data is in a ready-to-use form that creates a single version of the truth across all data consumers, including business/technology users, reporting and visualization specialists and data scientists with coaching and support.

•Utilizes skills to translate business analytic requests/requirements into design, development, testing, deployment, and production maintenance tasks.

•Works with various technologies from big data, relational and non-relational databases, cloud environments, different programming languages and various reporting tools and is familiar with a few but requires training for some.

Requirements:
• 4-6 years of experience in a similar as a Data Engineer with AWS Tools

• BS in Computer Science or similar
• Full English Fluency
• Exp Insurance within finance area (PLUS)

Technical Experience

• Python and SQL – Intermediate (MUST)
• AWS tools such as AWS Glue, S3, AWS Lambda, Iceberg and Lake Formation (MUST)
• Snowflake - Intermediate (4-6 Years) (MUST)
• DBT - Entry Level (1-3 Years) (MUST)
• AWS Cloud Data - Intermediate (4-6 Years) (MUST)
• MSSQL - Entry Level (1-3 Years) (Desirable)
• Communications - Intermediate
• Office Suite - Intermediate
• Rally - Entry Level or similar
• Agile - Entry Level, knowledge

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.