Business Intelligence Analyst

The Business Intelligence (BI) Analyst is responsible for transforming raw data into actionable insights that drive strategic decision-making across Selkirk Sport. This role focuses on the technical execution of data analysis, dashboard creation, and metric validation. By bridging the gap between complex datasets and functional business needs, the BI Analyst ensures that leadership and departmental teams have access to accurate, real-time visibility into company performance.

Why Join Selkirk Sport?

• Lead brand design for the #1 brand in pickleball—an industry on the rise.
• Work on high-impact projects seen by millions.
• Collaborate with a fast-moving, innovative brand design team.
• Enjoy a high-energy work environment where your ideas shape the future of the sport.
• Competitive salary, benefits, and opportunities for growth.

Key Responsibilities

Data Analysis & Visualization

• Design, develop, and maintain automated dashboards and reports using tools like Power BI and Palantir.
• Perform deep-dive analysis to identify trends, anomalies, and opportunities within Operations, Finance, and E-Commerce datasets.
• Translate complex data findings into clear, visual stories and executive summaries for non-technical stakeholders.
• Ensure all visualizations are intuitive, high-performing, and mobile-responsive where necessary.

KPI Development & Requirements Gathering

• Collaborate with department managers to define and refine key performance indicators (KPIs) and success metrics.
• Translate business questions into technical data requirements and SQL queries.
• Establish and maintain a "single source of truth" by ensuring consistent logic across all reporting platforms.

Data Governance & Quality Assurance

• Conduct regular data validation and auditing to ensure reporting accuracy and integrity.
• Work with the Development Lead to troubleshoot data pipeline issues or discrepancies in the data warehouse.
• Maintain comprehensive documentation of data dictionaries, metric definitions, and calculation logic.
• Assist in the development of data governance standards to ensure naming conventions and tagging remain consistent.

System Integration & Optimization

• Utilize Palantir and other analytics environments to query and manipulate large datasets.
• Support the integration of new data sources (ERP, Shopify, Marketing APIs) into the central BI ecosystem.
• Identify opportunities to automate manual reporting processes and improve data refresh frequencies.

Cross-Functional Support

• Act as a technical resource for Operations, Marketing, and Finance teams to assist with ad-hoc reporting requests.
• Train internal stakeholders on how to navigate dashboards and interpret analytical outputs.
• Participate in sprint planning and stand-ups to provide updates on data modeling and analysis progress.

Qualifications

Required: * 1–3 years of experience in a Business Intelligence or Data Analyst role.

• Advanced SQL skills (complex joins, CTEs, window functions).
• Proven experience building production-level dashboards in Looker Studio, Power BI, Tableau, or similar.
• Strong understanding of relational databases, data warehousing concepts, and ETL processes.
• Exceptional analytical mindset with the ability to spot patterns in "noisy" data.

Preferred: * Experience with Palantir Foundry or similar advanced data integration platforms.

• Background in Consumer Packaged Goods (CPG), manufacturing, or e-commerce.
• Experience with Python or R for advanced statistical analysis.
• Familiarity with project management tools like Monday.com or Airtable.