Analytics Engineer

FERRELLGAS INC
United States
2 days ago
Apply on www.builtincolorado.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Experienced
Experience required
2 years minimum
Working hours
Regular working hours

Tech stack

Query Performance Adaptable Database Systems Data Analysis ARM Architecture Business Intelligence Development BigQuery Code Review Continuous Integration Data Infrastructure Data Transformation Data Warehousing Database Queries
+17 more
Dimensional Modeling Raw Data Power BI SQL Databases Data Streaming Enterprise Data Management Cloud Platform System Large Language Models Snowflake Agentic-AI Git Data Layers AI Platforms Information Technology Star Schema Software Version Control Databricks

Job description

Remote Hiring Remotely in United States Mid level Remote Hiring Remotely in United States Mid level Build and maintain Snowflake transformation layers and Power BI semantic models supporting reporting, self-service analytics, and AI initiatives. Develop SQL and dbt transformations, apply data modeling and business rules, automate manual data processes, troubleshoot data quality issues, and coordinate data projects from requirements through delivery. Collaborate with IT, data warehouse teams, engineers, analysts, and business stakeholders while contributing to code reviews, testing, CI/CD, and documentation. The summary above was generated by AI 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., * 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.
  • 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

Benefits & conditions

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

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.builtincolorado.com
Prepare application

Good distractions

Loading talks and stories from around this role…