FBS Senior Data Engineer (SnowFlake)

The Direct modeling team is focused on creating models to guide enterprise marketing decision that will help to promote brand awareness as well as boost sales through direct channel. This role will help the team to design, set up, and monitor the data ecosystem that’s needed to support the modeling needs. Tasks include, but not limited to, setting up data pipelines and design efficient data storage solutions., Data infrastructure development:

• 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), 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 and transformation:

• 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.
• Implements data transformation workflows to handle data cleansing, normalization, and enrichment.
• Data Quality Assurance - Conducts data validation and consistency checks to ensure the accuracy and reliability of data. Implements data quality monitoring and alerting mechanisms.

Collaboration and stakeholder management:

• Cross-Functional Collaboration - Works closely with data analysts, data scientists, and business stakeholders to gather requirements and understand their data needs.
• Acts as a liaison between technical teams and business units to translate business requirements into technical specifications.

Data governance and security knowledge:

• Governance Policies Implements and enforces data governance policies to ensure data privacy, security, and compliance with relevant regulations.
• Defines and manages data access, controls, permissions, and audit trails.
• Security Measures - Monitors and enforces data security measures to protect sensitive information from unauthorized access and breaches.
• Ensures compliance with industry standards and regulations such as GDPR, CCPA, or HIPAA and others as applicable.

High School Diploma or equivalent required. Bachelors degree preferred in computer science, data science, engineering, or a related field., * 4+ years working with Python and SQL

• Data Transformation
• Data Quality Assurance
• Pipeline Design and Development
• Technical Communication
• Experience working with DBT and SnowFlake
• Experience working with Data Governance

This position offers a competitive compensation and benefits package designed to support your wellbeing, growth, and work-life balance. While specific benefits may vary by country and employee level, offerings generally include competitive salary opportunities, performance-based bonuses, comprehensive benefits, and ongoing training and development resources.

Farmers- where ambition meets opportunity.

Farmers is known for more than its unforgettable jingle - it’s a team with a passion for purpose and making a real difference in people’s lives. Farmers employees deliver peace of mind when it matters most. The organization’s results-driven, high-performance culture thrives on creativity, accountability and bold solutions. Here, growth isn’t just a goal - it’s a way of life for both the organization and every individual on the team. Farmers employees tackle challenges head-on, learn from every experience and measure their impact on the customers who trust them.

Join us and help power the success of Farmers. As a team member, you’ll collaborate with Farmers’ award-winning workforce, benefit from a culture of innovation and support and contribute to their mission of delivering protection and peace of mind to millions of U.S. customers.

Ready to make your mark? Discover Farmers’ vibrant culture and explore career opportunities at www.Farmers.com/careers/corporate., * Legal Authorization to Work: Employment with FBS is conditional upon the candidate having valid, local legal authorization to work in the country where the role is based at the time of hire. FBS does not sponsor or obtain work authorization unless explicitly stated.

• Exclusivity of Employment and Conflict of Interest: Upon acceptance of an offer and during employment with FBS, employees will not be permitted to engage in parallel employment, professional activities, or paid work for other entities. Any ownership, partnership, directorship, or participation in other businesses or companies must be fully disclosed and formally reviewed in accordance with FBS internal conflict-of-interest and external engagement policies prior to the start date or as soon as such circumstances arise.

Failure to comply with these conditions may impact the hiring decision or employment continuation.

About Farmers Insurance “Farmers Insurance®” and “Farmers®” are tradenames for a group of insurers providing insurance for automobiles, homes and small businesses and a wide range of other insurance and financial services products. Farmers Insurance Exchange, the largest of the three primary insurers that make up Farmers Insurance, is recognized as one of the largest U.S. companies on the 2025 Fortune 500 list.