Analytics Engineer: Snowflake to Power BI (On-Site)

Knichel Logistics; Cranberry Township (Butler County); On-site; USD 90,000 - 120,000; Full time

Benefits offered by this job

Competitive compensation and benefits

On-site role in Cranberry Township, PA

Job summary

Knichel Logistics is seeking an Analytics Engineer to own the path from our Snowflake warehouse to Power BI reports used by finance, operations, sales, customers and carriers. This on-site role reports to the CFO and sits in Cranberry Township, PA.

The role builds and maintains the data warehouse, reporting models and a growing portfolio of internal reports, with responsibilities spanning data pipelines, star schema design, DAX calculations, and row-level security for controlled access.

Qualifications

• 3+ years of experience in data engineering, analytics engineering or BI development.
• Strong experience with a cloud data warehouse; Snowflake preferred.
• Advanced SQL, including window functions, CTEs and query performance tuning.
• 3+ years developing Power BI reports and semantic models (Desktop and Service).
• Advanced DAX, including evaluation context, time intelligence and complex calculation logic.
• Hands-on experience implementing row-level security.
• Solid understanding of dimensional modeling and data warehousing concepts.
• Working knowledge of financial data and metrics (revenue, cost, margin, accounts receivable).
• Strong communication skills, with the ability to explain technical concepts to non-technical stakeholders.
• Bachelor's degree in Computer Science, Information Systems, Finance, Statistics or a related field, or equivalent experience.

Responsibilities

• Design, build and maintain data pipelines and transformation layers in Snowflake.
• Integrate data from operational systems, ERP/accounting, and third-party sources.
• Develop dimensional models (star schemas, fact and dimension tables).
• Centralize business rules and KPI definitions in the warehouse.
• Write efficient SQL; optimize deduplication, joins, null handling and performance.
• Support geospatial and distance-based analysis for lane and route optimization.

Skills

Advanced SQL

Strong communication skills

Dimensional modeling

Row‑level security

Education

Bachelor's degree in Computer Science, Information Systems, Finance, Statistics or a related field

Tools

Snowflake

Power BI

DAX

Power Query

Job description

Knichel Logistics is seeking an Analytics Engineer to own the path from our Snowflake warehouse to Power BI reports used by finance, operations, sales, customers and carriers. This on-site role reports to the CFO and sits in Cranberry Township, PA.

The role builds and maintains the data warehouse, reporting models and a growing portfolio of internal reports, with responsibilities spanning data pipelines, star schema design, DAX calculations, and row-level security for controlled access.