Analytics Engineer

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.

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

• 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

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