Business Analyst I

Port City Logistics Inc • Port Wentworth, GA

1d

About The Position

We are looking for a skilled and adaptable Front-End BI Analyst to join our IT leadership team during an exciting period of data transformation. As a Third-Party Logistics (3PL) provider, data is the lifeblood of our operational efficiency and customer satisfaction. We are currently transitioning our primary operational and customer-facing dashboards from Power BI to Sigma Computing. In this role, you will be the driving force behind this migration, designing intuitive, high-performance dashboards while collaborating with business leaders and customers to translate complex 3PL data into actionable insights. You will work directly with data warehouses built on Snowflake and PostgreSQL, turning "silver layer" data into robust analytical datasets.

Requirements

• 4+ years of experience in Business Intelligence, Data Analytics, or a front-end data developer role.
• Proven experience building dashboards in both Power BI and Sigma Computing.
• Strong ability to write complex, performant SQL queries to manipulate data from Snowflake and PostgreSQL.
• Experience working with modern cloud data platforms (Snowflake preferred) and relational databases (Postgres/SQL Server).
• Comfort working with Medallion architecture, specifically transforming silver layer data into Gold/analytical presentation layers.
• Proven experience in data reconciliation, data quality assurance (DQA), or writing automated audit scripts to compare large datasets across disparate sources.
• Ability to dissect complex business logic (e.g., transit times, cost and revenue allocations) to find where discrepancies or edge cases were dropped or miscalculated in the aggregation layer.

Nice To Haves

• Experience in 3PL, Supply Chain, Warehousing (WMS), or Transportation Management Systems (TMS).
• Comfort presenting data solutions directly to external clients or enterprise stakeholders.
• Ability to nudge stakeholders toward standardized metrics rather than just being an order taker for custom reports.
• Exceptional ability to bridge the gap between technical data structures and business-friendly insights.

Responsibilities

• Recreate, optimize, and enhance existing Power BI operational and customer dashboards within Sigma.
• Build intuitive, visually compelling, and high-performing dashboards in Sigma that allow both internal teams and external customers to self-serve.
• Query and transform "silver layer" data into clean, curated analytical datasets optimized for front-end reporting.
• Partner with individual managers, directors, and external customers to define custom reporting needs and translate them into technical specifications.
• Identify opportunities to standardize KPIs (e.g., on-time delivery, warehouse throughput, carrier performance) across different customers to reduce custom tech debt.
• Act as a Sigma evangelist, training internal users on how to navigate and utilize the new platform.
• Work seamlessly across our dual data warehouse environments: Snowflake and PostgreSQL.
• Collaborate with internal and external data engineering teams to ensure data lineage, accuracy, and performance tuning at the BI layer.
• Systematically validate large-scale "Gold" and "Platinum" layer datasets built by our external development partner within PostgreSQL.
• Utilize advanced data tracing techniques to map data from target dashboards back to the raw source data (SaaS TMS and SQL Server WMS).
• Design and execute validation methodologies to proactively identify aggregation errors, logical flaws, and faulty assumptions made during the data modeling process before they impact customer-facing reports.

Benefits

• Opportunity to spearhead a modern cloud-data BI migration.
• Exposure to cutting-edge tech stacks (Snowflake, Sigma, Postgres).
• A collaborative IT environment where your work directly impacts company growth and customer retention.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed