FBS Data Analyst (SQL, Google Analytics)

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

Objective

To support the numerous in-flight and upcoming business initiatives Farmers needs a dedicated support team to manage our customer and product analytics tools, Segment, Mixpanel, and Salesforce Data360 (formerly Data Cloud). This team will operate as cross functional center of excellence building and supporting a Customer Events Hub focused on delivering real-time event streaming and product analytics capabilities for business partners.

Requirements

This role will be focused on the "What" - Data governance and Insights. They will co-own tracking plans with product owners and business analysts. They will builds Mixpanel dashboards and translate business user stories into technical requirements

Key Responsibilities

Tracking Plan Management: Co-owns and maintains Segment Tracking Plans with application product managers to ensure data is sent according to business needs.

Requirements & Documentation: Consults on data projects of intermediate complexity to understand design requirements and draft documentation for data collection.

Product Analytics: Builds and maintains reports and dashboards in Mixpanel to track user behavior and KPIs

Data Quality: Validates data assumptions and ensures tracking plans are aligned across various applications to maintain a "single version of the truth".

Stakeholder Consulting: Consults with application development teams to ensure data is being captured and sent according to the enterprise data catalogue.

Develops basic value-based analytics solutions for quality, business process functionality, or other strategic/data/analytic initiatives of limited complexity.

Collaborates with cross-functional teams to identify and establish analytics requirements.

Creates detailed documentation and business plans that address stakeholder needs.

Liaises between IT and Product Management for data solutions.

Develops and implements basic enterprise-wide data integration strategies that utilize various data-marts and data warehouse applications to enhance reporting.

Continuously works to improve data platforms, dashboards, and reports to meet emerging and changing business demands and guidelines. Consults with guidance from Principal on UAT, technical specifications, strategic planning, contract design, technical support, testing updates, and trainings

Uses basic understanding of data elements, structures, standards typically involved in financial services transactions, reporting, and cloud-based data storage/sharing to adopt and apply standards in a way that satisfies and balances regulatory and compliance requirements with business needs.

Manages data from single sources and uses project management skills to complete simple projects with coaching and guidance

Transmits data and proactively works to ensure data quality.

Troubleshoots data issues and devises creative and effective ways to avoid or mitigate issues

Tools & Skills:

Data Analytics - Intermediate

Project Management - Intermediate

Data Visualization - Intermediate

SQL - Intermediate (MUST)

Python - Basic

Experience in Analytics using any of this:

Twilio Segment / Rudderstacck / Tealum / mParticle - Entry Level

Mixpanel / PowerBI / Tableau Entry Level

Google Analytics / Amplitude / Logrocket - Entry Level

Great Communication Skills (This position will be the point of contact between Stakeholders and the Area)

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