Data Engineer - Warehouse/Distribution

Description

Franklin Logistics is a local, family owned business started in 1985. Franklin Logistics has expanded to multiple locations in the Chambersburg, PA area and has grown into a premier 3PL provider and industrial developer. With 40 years of experience of supply chain solutions, Franklin Logistics provides warehousing, trans-loading, and transportation for businesses. 

Franklin Logistics takes extreme ownership in our customers’ needs while delivering world class service. We embrace change and are relentless about improvement while investing in our relationships and honoring our commitments. We maintain a fun workplace while being vigilant about employee and customer safety. Franklin Logistics is easy to work with and treats everyone with respect.

As a Data Engineer and Power BI Specialist, you will play a critical role in developing and maintaining data pipelines, integrating multiple data sources, and designing dynamic reporting solutions. You will be responsible for enabling data-driven decision-making across our warehousing and distribution operations by utilizing Power BI and other data engineering tools. Your work will help improve operational efficiency, inventory management, supply chain optimization, and overall business intelligence. 

The Data Engineer and Power BI Specialist is a full-time, salary, exempt position. Business hours are Monday - Friday, 7:00 am - 5:00 pm. 

Key Responsibilities:

Data Engineering

• Design, develop, and maintain scalable ETL (Extract, Transform, Load) processes to integrate data from various sources (warehouse management systems, transportation management systems, Paylocity).
• Build and optimize data pipelines to support data processing and analytics in a warehousing and distribution context.
• Work with stakeholders to identify key data sources and ensure data quality, consistency, and security.
• Develop and maintain relational and NoSQL databases for storing operational, transactional, and historical data.
• Implement data validation, cleansing, and transformation processes to ensure the integrity and quality of data used for analytics.

Power BI Development:

• Create and maintain interactive Power BI dashboards and reports to provide real-time insights into warehousing, inventory, and distribution operations.
• Design and implement data visualizations that are user-friendly and actionable for cross-functional teams, including logistics, operations, transportation, and management.
• Provide training and support for business users on Power BI and self-service reporting capabilities.
• Implement and manage Power BI data models, ensuring performance optimization, security, and scalability.
• Develop key performance indicators (KPIs) and metrics to track supply chain efficiency, warehouse throughput, order accuracy, and other key logistics performance metrics.

Collaboration & Stakeholder Engagement:

• Work closely with warehouse managers, logistics coordinators, and business leaders to understand data needs and translate them into technical solutions.
• Collaborate with internal and external teams and other data professionals to ensure proper data governance, integration, and reporting strategies.
• Provide actionable insights to support business decisions and optimize operations, including inventory forecasting, demand planning, and route optimization.

Data Quality & Performance:

• Ensure high data accuracy, reliability, and timeliness by continuously monitoring and refining data systems.
• Troubleshoot and resolve issues with data discrepancies, report accuracy, or performance.
• Manage the ongoing maintenance of Power BI reports, ensuring they remain up to date with the evolving needs of the business.

Requirements

Technical Skills:

• Strong experience in data engineering, with a deep understanding of data modeling, ETL processes, and database management.
• Proficiency in Power BI for building reports, dashboards, and data models.
• Experience with SQL, DAX (Data Analysis Expressions), and Power Query for data transformation and analysis.
• Familiarity with cloud platforms (e.g., AWS, Azure, or Google Cloud) and data warehousing solutions.
• Strong programming skills in languages like Python, R, or similar for data manipulation and automation.
• Experience working with data pipelines and workflow orchestration tools (e.g., Apache Airflow, Azure Data Factory, etc.).

Industry Knowledge:

• Previous experience in warehousing, logistics, or distribution environments is highly desirable.
• Understanding of supply chain processes, inventory management, and order fulfillment operations.
• Familiarity with Warehouse Management Systems (WMS), Transportation Management Systems (TMS), or related software.

Soft Skills:

• Strong analytical mindset with attention to detail.
• Excellent communication skills to work effectively with both technical teams and business stakeholders.
• Ability to translate complex technical concepts into business-friendly language.
• Problem-solving orientation with the ability to work independently and within cross-functional teams.
• Experience in prioritizing and managing multiple tasks in a fast-paced environment.

  All employees receive:

• Paid on the job training 
• A safe, clean, and respectful workplace 
• Opportunity to advance within the organization
• Employee appreciation and engagement events
• Employee recognition and continuous performance feedback 

Full-time employees receive: (after 60 days of successful employment)

• Paid Holidays and vacation time 
• Paid Time Off for employee’s birthday
• Health, Dental, and Vision Coverage 
• Company Paid Life Insurance
• 401k profit sharing after one year of employment  

Franklin Logistics is committed to equal opportunity in the terms and conditions of employment for all employees and job applicants without regard to race, color, religion, sex, sexual orientation, age, gender identity or gender expression, national origin, disability or veteran status and complies with all applicable national, state and local laws governing nondiscrimination in employment as well as employment eligibility verification requirements of the Immigration and Nationality Act.

Applicants requiring special accommodations during and after the application process can contact our Human Resources department at (717) 262-2906.