Analytics Engineer

Knichel Logistics • Cranberry Township, PA

2d • Onsite

About The Position

Knichel Logistics is hiring an Analytics Engineer to own the path from its Snowflake data warehouse to the Power BI reports used by Finance, Operations, Sales, customers, and carriers. The role reports to the CFO and supports an intermodal marketing and freight brokerage business with data spanning shipment and load activity, rail and truckload operations, carrier performance, customer quotes and billing, carrier settlements, and financial accounting. The position adds capacity to a small team that builds and maintains the data platform end to end, taking ownership of the warehouse, reporting models, and a growing portfolio of internal and external reports.

This is a hands-on builder role involving Snowflake SQL, dimensional and star-schema design, DAX, row-level security, and close collaboration with business teams to ensure reports answer their needs. The Analytics Engineer will build data pipelines and transformation layers, develop Power BI semantic models and dashboards, partner with Finance, Pricing, Operations, and Sales, and establish automation, reconciliation, documentation, and data-quality practices.

The position is onsite in Cranberry Township, Pennsylvania, and is full-time and exempt. Applicants must be legally authorized to work in the United States at the time of hire. Knichel Logistics cannot provide employment-based visa sponsorship or other employer-sponsored work authorization for this position, now or in the future.

Requirements

• At least 3 years of experience in data engineering, analytics engineering, or BI development.
• Strong experience with a cloud data warehouse; Snowflake is preferred.
• Advanced SQL skills, including window functions, CTEs, and query performance tuning.
• At least 3 years developing Power BI reports and semantic models using Power BI Desktop and Service.
• Advanced DAX skills, 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, including revenue, cost, margin, and accounts receivable.
• Strong communication skills and 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.
• Legally authorized to work in the United States at the time of hire; employer-sponsored work authorization is not available for this position.

Nice To Haves

• Experience in transportation, logistics, freight brokerage, or intermodal.
• Experience with ERP or accounting systems; Sage Intacct is a plus.
• Experience with Power Query, Power Automate, and Dataverse.
• Experience distributing Power BI content to external users, including guest access, embedded analytics, or subscriptions.
• Experience with geospatial analysis and mapping visuals.
• Experience with dbt or similar transformation tools and Git-based version control.
• Microsoft PL-300 or SnowPro Core certification.

Responsibilities

• Design, build, and maintain Snowflake data pipelines and transformation layers using a raw, curated, and presentation architecture.
• Integrate data from operational systems, accounting and ERP systems, and third-party sources using managed ingestion tools.
• Develop dimensional models, including star schemas and fact and dimension tables, at an appropriate grain for each business process.
• Centralize business rules and KPI definitions in the warehouse so reports use consistent definitions.
• Write efficient, maintainable SQL and apply best practices for deduplication, join logic, null handling, and query performance.
• Support geospatial and distance-based analysis for lane, network, and route optimization use cases.
• Build and maintain Power BI semantic models, including relationships, date tables, and centralized measure libraries.
• Develop advanced DAX calculations for time intelligence, period-over-period comparisons, what-if scenarios, segmentation, and ranking.
• Design and implement row-level security for internal role-based access and external customer and partner reporting.
• Manage Power BI Service workspaces, apps, scheduled and incremental refresh, deployment, and report distribution.
• Deliver executive-ready dashboards with clear visual hierarchy, consistent design standards, and drill-through to detail.
• Partner with Finance on cash flow forecasting, accounts receivable, working capital, and P&L reporting.
• Partner with Pricing on margin analysis, quote-to-actual variance, and lane profitability.
• Partner with Operations and Sales on service performance, carrier and customer scorecards, and sales performance reporting.
• Translate analysis into concise, actionable recommendations for leadership.
• Build and maintain workflow automations and data integrations using the Microsoft Power Platform.
• Reconcile reporting to source systems and the general ledger, and establish data quality checks and monitoring.
• Document data models, metric definitions, processes, and security setups to support maintainability and knowledge sharing.
• Support existing reports, including refresh monitoring and issue resolution; deliver report enhancements and new reporting products.
• Deliver secure external-facing reports with validated access controls and work with stakeholders on an analytics roadmap.

Benefits

• Competitive compensation and benefits package.
• Opportunity to play a key role in delivering best-in-class service to customers.
• Collaborative work environment within the headquarters in Cranberry Township, Pennsylvania.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level