FBS Data Analyst (SQL)

Job Description

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
• Twilio Segment - -Entry Level
• Mixpanel / PowerBI / Tableau  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.