Business Intelligence Analyst

Job Description

About PSA BDP:

PSA BDP, a member of the PSA Group, is a leading provider of globally integrated and port-centric supply chain, transportation, and logistics solutions. The company is headquartered in Philadelphia, PA, and employs more than 5,500 people worldwide.

We are a team that celebrates our unique diversity and close-knit community atmosphere. Our core values begin at the very top and span the broad reach of our global community.

We offer dynamic careers for those individuals looking to be a part of something bigger and provide unequivocal opportunities for growth within the organization.

PSA BDP serves over 5,000 customers, including some of the world's leading multinational companies within the chemical, retail & consumer, life sciences & pharmaceuticals, and electric vehicle & industrial verticals.

Job Summary:

The Business Intelligence (BI) Analyst transforms data into actionable insights through reporting, visualization, and analysis. Responsibilities include gathering requirements, maintaining data accuracy, building dashboards in Tableau, and supporting both internal and client needs. The role involves troubleshooting, documentation, training, and promoting self-service analytics. Strong collaboration with stakeholders and a focus on continuous improvement and industry best practices are key.

Business Intelligence (B.I.) Solution

• Work with business and technical stakeholders to gather requirements for enhancements (source data corrections, new data sources, changes to source systems) and submit to the relevant IT teams
• Perform thorough testing and validation of new enhancements by both IT and BI teams.
• Troubleshoot and resolve issues with IT or Salesforce
• Empower internal peers and clients to realize benefits of business intelligence via training, documentation, and on-going collaboration. Find opportunities to support & enhance self-service analytics for those outside of the B.I. department.
• Maintain functional and technical documentation around Tableau Cloud, data engineering, & business intelligence processes
• Participate in new client implementation efforts to identify unique data & reporting requirements. Assist in building out standard reports based on these needs and support further client-specific customization.
• Use Teamwork Desk ticketing system to monitor and organize incoming requests
• Use Teamwork Project (project management tool) to organize, plan, & track work
  
  

Data Management & Analysis

• Create, maintain, and document Tableau databases, fields, and their sources
• Understand different databases and applications in reporting requirements along with data validation, data mapping, and best practices in design
• Identify and assist in fixing inaccurate data, working with IT and business users to pinpoint root cause(s) of the issue in source systems or data pipelines
• Ensure data handling and reporting practices adhere to privacy regulations and company policies.
• Create comprehensive datasets by gather data from various sources, including databases, spreadsheets, and external data providers.
• Clean and preprocess data to ensure quality, accuracy, and consistency. This may involve dealing with missing values, duplicates, and outliers.
  
  

Reporting & Visualization

• Create meaningful, visually appealing, & flexible reports using Tableau & Tableau Prep to communicate actionable insights to internal and external non-technical stakeholders effectively.
• Engage with internal stakeholders and departments to identify opportunities to streamline processes and decision-making whether through dashboards, automated reports, or Excel formulas & macros.
• Assist stakeholders with ad-hoc requests for analyses using both internal and external data
• Communicate findings and insights to both technical and non-technical stakeholders through presentations and documentation
• Maintain and improve reporting to respond to both changes in client strategy & business rules, as well as implementing new technologies and techniques
• Identify opportunities to design and iterate on products with scalability, flexibility, and maintainability in mind.
• Monitor usage and engagement of BI projects
  
  

Business Understanding

• Develop deep understanding of organizational source systems and processes to support analyses, identify data quality issues, and improve solutions
• Work with stakeholders to grow domain knowledge of the broader logistics industry
• Work with stakeholders to gather requirements based on business needs and then translate them into appropriate business intelligence solutions
• Create and translate internal and client business data needs into the development and implementation of creative, enticing, and efficient dashboards, as well as maintenance and continual improvement of current dashboards & reporting
• Develop and track key performance indicators (KPIs) to assess the success of business initiatives and strategies.
  
  

Tool Proficiency and Learning

• Keep well-informed of industry trends, emerging technologies, and best practices in business intelligence and data analysis.
• Stay current with BI tools and latest features and capabilities to maximize their utility in data analysis and reporting.
• Learn from Business Intelligence Data Scientist and assist with data pipeline and report automation efforts
  
  

Job Requirements

What You’ll Need

Required Skills & Experience

• Bachelor’s Degree
• Business Intelligence, Analytics, Data Science, Data Engineering, or related fields preferred
• Hands-on experience with Tableau (or similar tools like Power BI, Qlik)
• Familiarity with Tableau Prep or other no/low-code data prep tools
• Moderate proficiency with Microsoft Excel, including formulas/macros for ad-hoc analysis
• Experience performing detailed analyses and communicating findings
• Strong attention to detail and problem-solving skills with curiosity and persistence
• Ability to work independently and take ownership of tasks and processes
• Strong sense of accountability and solution-oriented mindset
• Working domain knowledge of the domestic (US/CA) logistics industry or related areas (accounting, operations, sales, pricing, etc.)
  
  

Preferred Skills & Experience

• 1-2 years work experience in Business Intelligence, Analytics, Data Science, Data Engineering, or related fields.
• Knowledge of international logistics or global freight operations
• Familiarity with 3G TMS (Descartes)
• Experience with Teamwork Desk/Project or similar project/ticketing tools
• Exposure to below tools (or similar):
• Python
• SQL
• AWS
• DevOps
• GitHub
• Snowflake
  

Please note: There is no relocation or immigration assistance associated with this opening.

Compensation based on experience. We offer a very competitive salary, full benefits, matching 401(k), tuition reimbursement, and casual dress environment.

Please visit our website: www.bdpinternational.com

*** This is a great opportunity to advance your career! Come join our growing BDP team!***

BDP International - The Employer of Choice

Follow BDP International Career Pages!

Facebook l Twitter l LinkedIn