Analytics Engineer

Ferrellgas is hiring an Analytics Engineer to build and maintain data assets for reporting, self-service analytics, and AI initiatives. The role supports Snowflake data transformations, develops Power BI semantic models, and automates manual processes while collaborating across IT, data teams, and business stakeholders.

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

Requirements:

• 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
• 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
• Experience with AI platforms is a plus, particularly integrating AI tools such as LLMs, Snowflake Cortex, or AI agents with enterprise data