Job Title: Front-End BI Analyst
Role OverviewWe 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.
Key ResponsibilitiesBI Migration & Dashboard Development
- Lead the Transition: Recreate, optimize, and enhance existing Power BI operational and customer dashboards within Sigma.
- Front-End Design: Build intuitive, visually compelling, and high-performing dashboards in Sigma that allow both internal teams and external customers to self-serve.
- Data Modeling & Analytics: Query and transform "silver layer" data into clean, curated analytical datasets optimized for front-end reporting.
Stakeholder Collaboration & Product Ownership
- Requirements Gathering: Partner with individual managers, directors, and external customers to define custom reporting needs and translate them into technical specifications.
- Metrics Standardization: Identify opportunities to standardize KPIs (e.g., on-time delivery, warehouse throughput, carrier performance) across different customers to reduce custom tech debt.
- Enablement: Act as a Sigma evangelist, training internal users on how to navigate and utilize the new platform.
Data Ecosystem Collaboration
- Multi-Source Integration: Work seamlessly across our dual data warehouse environments:
- Snowflake: Our internal data warehouse consolidating SaaS TMS and SQL Server WMS data.
- PostgreSQL: A partner-developed warehouse dedicated to advanced transportation and logistics modeling initiatives.
- Data Governance: Collaborate with internal and external data engineering teams to ensure data lineage, accuracy, and performance tuning at the BI layer.
- Data Reconciliation & Validation at Scale: Systematically validate large-scale "Gold" and "Platinum" layer datasets built by our external development partner within PostgreSQL.