Share this job
DCC-Transportation-Power BI Analyst-Remote
Apply for this job

Job Title: Power BI Analyst

The Power BI Analyst position, specializing in the transportation industry, is responsible for extracting, analyzing, and visualizing data from various transportation systems (like fleet management, logistics, and route optimization). This role involves gathering requirements, analyzing business processes, and working with operational team, technical teams, and management to implement solutions that optimize workflows, enhance efficiency, and align with organizational goals.

Our candidates will be using Power BI to generate insightful dashboards and reports, enabling data-driven decision-making for our Dedicated Fleet operations, cost optimization, route planning, and customer service improvements, while collaborating closely with transportation stakeholders to understand their specific needs and translate them into actionable insights. 


Essential Duties and Responsibilities (include the following. Other duties may be assigned.)

Data Acquisition and Integration:

Gather data from diverse transportation sources like GPS tracking systems, dispatch systems, and warehouse management systems, ensuring data quality and consistency for analysis. 

Data Modeling and Transformation:

Clean, transform, and structure complex transportation data within Power BI to create accurate and meaningful data models for analysis. 

Dashboard Development:

Design and build interactive dashboards in Power BI that visually represent key transportation metrics like fuel consumption, delivery times, vehicle utilization, and driver performance, allowing for easy monitoring and trend identification. 

Performance Analysis:

Analyze transportation data to identify areas for improvement, such as inefficient routes, excessive idling time, or delivery delays, and present findings to relevant stakeholders. 

Cost Optimization:

Develop reports that track transportation costs, allowing for cost-saving initiatives through route optimization, fuel efficiency strategies, and fleet management. 

Customer Service Insights:

Analyze customer delivery data to identify patterns and trends impacting customer satisfaction, enabling proactive measures to improve service levels. 

Stakeholder Collaboration:

Work closely with transportation managers, dispatchers, and other relevant teams to understand their data needs and tailor reports accordingly. 

 

Qualifications

Proficient in Power BI:

Strong understanding of Power BI functionalities including data cleaning, transformation, data modeling, visualization techniques, and DAX expressions. 

Transportation Domain Knowledge:

Familiarity with transportation industry concepts like fleet management, logistics, route planning, and delivery metrics. 

Data Analysis Skills:

Ability to analyze large datasets, identify trends, and interpret results to extract actionable insights. 

Data Visualization Expertise:

Create visually appealing and user-friendly dashboards that effectively communicate complex data insights. 

SQL Skills:

Proficiency in SQL to query and extract data from various transportation databases. 

Communication and Collaboration:

Effectively communicate findings to stakeholders across different levels of the organization. 

 

Education and /or Experience

BS degree in Computer Science, Information Systems, Supply Chain, Transportation Management or related field.

5 years of experience working in a large multi-site enterprise environment

Experience working with cross-functional teams to gather and document requirements.

Excellent analytical, problem-solving, and organizational skills.

Strong interpersonal and communication skills, with the ability to engage with stakeholders effectively.

Ability to translate business needs into actionable requirements.


Apply for this job
Powered by