FBS PowerBI Engineer

Farmers Group Inc.; United States; On-site; USD 90,000 - 130,000; Full time

Job summary

Farmers Insurance is seeking a data engineer in the United States to design and maintain reporting, analytics, and data solutions across on-prem and cloud platforms. You will translate business needs into scalable data pipelines and ensure data is reliable for reporting, analytics, and AI/ML use cases.

The role focuses on building reports, data modeling, and ensuring performance, security, and compliance. Collaboration with analytics teams will leverage Snowflake, PowerBI, and SQL as core tools.

Qualifications

• 5+ years of experience working as Data Engineers or equivalent.
• Strong experience working with PowerBI (Power Query and DAX).
• Strong knowledge in SQL.

Responsibilities

• Design, develop, and maintain reports, dashboards, and datasets to support business reporting and analytics needs.
• Support preparation and transformation of structured and unstructured data for analytics, natural language processing, and AI-driven use cases.
• Collaborate with business, reporting, and analytics teams to understand requirements and deliver reporting solutions aligned with business needs.
• Support preparation and transformation of structured and unstructured data for reporting, analytics, and AI-driven use cases.
• Design, develop, and maintain data pipelines to integrate data from multiple sources into enterprise platforms such as Snowflake or Lakehouse environments.
• Configure and support data connectivity including gateways, service accounts, and secure access to data platforms.
• Troubleshoot and resolve reporting and data issues such as refresh failures, data discrepancies, and connectivity problems to ensure reliability.
• Apply performance optimization techniques across reports, datasets, and data pipelines to improve efficiency and user experience.
• Ensure adherence to data governance, security, and compliance standards, including access management and standardized processes.
• Translate business requirements into technical specifications and support delivery of reporting and data initiatives within defined timelines.
• Create and maintain documentation for reports, datasets, data pipelines, and support processes.
• Support data validation, cleansing, and enrichment to ensure accuracy for reporting, analytics, and AI/ML consumption.
• Perform other duties as assigned.

Skills

PowerBI (Power Query and DAX)

SQL

Education

High School Diploma or equivalent

Bachelor's degree preferred

Tools

Snowflake

Job description

Select how often (in days) to receive an alert:

36345

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 usand 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.

Responsible for developing and supporting reporting, analytics, and data solutions across on-premises and cloud platforms. Primarily focuses on building, enhancing, and maintaining reporting solutions and datasets, while also supporting data pipelines, integration, and data platforms. Ensures data is reliable, governed, and available in a ready-to-use format for reporting, analytics, and AI/ML use cases. Translates business requirements into scalable reporting and data engineering solutions, including data modeling, connectivity, and production support

Essential Job Functions

• Design, develop, and maintain reports, dashboards, and datasets to support business reporting and analytics needs.
• Support preparation and transformation of structured and unstructured data for analytics, natural language processing, and AI-driven use cases.
• Collaborate with business, reporting, and analytics teams to understand requirements and deliver reporting solutions aligned with business needs.
• Support preparation and transformation of structured and unstructured data for reporting, analytics, and AI-driven use cases.
• Design, develop, and maintain data pipelines to integrate data from multiple sources into enterprise platforms such as Snowflake or Lakehouse environments.
• Configure and support data connectivity including gateways, service accounts, and secure access to data platforms.
• Troubleshoot and resolve reporting and data issues such as refresh failures, data discrepancies, and connectivity problems to ensure reliability.
• Apply performance optimization techniques across reports, datasets, and data pipelines to improve efficiency and user experience.
• Ensure adherence to data governance, security, and compliance standards, including access management and standardized processes.
• Translate business requirements into technical specifications and support delivery of reporting and data initiatives within defined timelines.
• Create and maintain documentation for reports, datasets, data pipelines, and support processes.
• Support data validation, cleansing, and enrichment to ensure accuracy for reporting, analytics, and AI/ML consumption.
• Perform other duties as assigned.

Education Requirements

High School Diploma or equivalent required. Bachelor's degree preferred.

Experience Requirements

• 5+ years of experience working as Data Engineers or equivalent
• Strong experience working with PowerBI (Power Query and DAX)
• Strong knowledge in SQL

Additional Qualification

• Understanding of Snowflake
• Datawarehouse Concepts

Benefits

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.

Important Hiring Conditions and Disclosures

By applying for this position, candidates acknowledge and agree that:

Personal Data Processing: The personal data provided during the recruitment and selection process will be collected, processed, andretainedfor legitimate recruitment and compliance purposes,in accordance withapplicable data protection and privacy laws and FBS internal policies.

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 withFBS internalconflict‑of‑interestand 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. For more information about Farmers Insurance, visit Farmers.com.