Analytics Engineer

Overview

The Analytics Engineer builds and maintains the data assets that power Ferrellgas reporting, self-service analytics, and AI initiatives. This role supports development of the data transformation layer in Snowflake, helping turn raw source data into clean, business-ready data, builds and maintains Power BI semantic models, and automates the manual processes that slow the business down. The Analytics Engineer shares responsibility for the team’s data models and transformation code, providing coverage and continuity across the full data flow from raw data to business-ready data. The ideal candidate has strong data modeling fundamentals, hands-on SQL and Power BI expertise, and a builder’s mindset for replacing manual work with reliable, automated solutions.

At Ferrellgas our corporate roles are fully remote, enabling talented professionals to support our field operations from wherever they are. These positions play a critical role in driving business growth, providing strategic and operational support that empowers our teams in the field to deliver exceptional results.

Why You’ll Love Working Here

At Ferrellgas, we’re committed to supporting our team with benefits that promote health, financial security, and personal growth:

• Comprehensive Health Coverage: Medical, dental, vision, accident, and critical illness insurance
• Income Protection: Company-provided short-term and long-term disability, life insurance, and AD&D
• Financial Wellness: 401(k) with company match, Employee Stock Ownership Plan (ESOP), Flexible Spending Account (FSA), and Health Savings Account (HSA)
• Time Off & Family Support: Paid Time Off (PTO), parental leave, and tuition reimbursement
• Wellness & Assistance Programs: Wellness program, Employee Assistance Program (EAP), and Medicare support
• Employee Perks: Referral program, employee discount programs, and propane savings

Responsibilities

• Build and maintain Power BI semantic models and support the Snowflake data transformation layer, which together serve as the foundation for reporting, self-service analytics, and AI data agents.
• Support development of the data transformation layer in Snowflake, helping transform raw data into business-ready data that is structured, performant, and ready for downstream consumption.
• Design and build transformation logic that applies business rules consistently and aligns with the team’s standards and architecture.
• Publish and maintain well documented and performant Power BI semantic models that enable reporting and self-service.
• Identify, prioritize, and automate recurring manual processes such as data refreshes, extracts, and report distribution.
• Translate business requirements into scalable data models and validate that models answer real business questions.
• Write clean, efficient, and well-documented SQL transformations using dbt, with Git-based version control.
• Manage data projects end to end, coordinating with IT source system owners, the Data Warehouse team, and business end users from requirements gathering through development, testing, and delivery.
• Participate in code reviews, testing, CI/CD, and documentation practices established by the team.
• Troubleshoot and resolve data quality issues in the transformation and semantic layers.
• Stay current with Snowflake and reporting platform capabilities and contribute ideas for improving the team’s analytics infrastructure.

Qualifications

• Bachelor’s degree in a quantitative field (Computer Science, Engineering, Applied Math, Statistics, Analytics, or related field).
• 3+ years of experience in analytics engineering, BI development, or a closely related role.
• Strong SQL skills, including CTEs, window functions, and query performance tuning.
• 2+ years of hands-on experience with Snowflake or a comparable cloud data platform (e.g., BigQuery, Databricks).
• 2+ years building Power BI semantic models, with working knowledge of DAX and M.
• Understanding of semantic layer concepts, star schema design, and dimensional modeling principles.
• Experience with data transformation tools such as dbt, including Git-based version control.
• Experience with AI platforms is a plus, particularly integrating AI tools such as LLMs, Snowflake Cortex, or AI agents with enterprise data.
• Strong attention to detail and commitment to data quality and documentation.
• Collaborative team player who can work effectively with engineers, analysts, and business stakeholders.
• Passionate about learning new technologies and adapting to changing environments.
• Must be a U.S. citizen, national, permanent resident, or otherwise authorized to work in the United States
• Applicants must not require visa sponsorship now or in the future

Why Ferrellgas?

At Ferrellgas we’re honored to be part of tight-knit communities across America and thousands of customers’ lives. From our nationwide charitable partnerships with Operation Warm and Operation BBQ Relief to fundraisers for local schools, fire departments, veteran organizations and more, we are always looking for ways to give back to the communities we live in and serve.

Hear from our current employees and discover the people behind Ferrellgas: Employee Testimonials               

Ready to take the next step in your career? Apply today and be part of our growing team!