Business Intelligence Analyst - 21063

SQL Query Optimization: Write, maintain, and optimize complex SQL queries in Google BigQuery to extract, transform, and model data from ERP systems, e-commerce platforms, and marketplace APIs.

Data Accuracy & Reconciliation: Conduct rigorous data validation against source systems to ensure absolute accuracy, flagging and resolving data discrepancies promptly.

Cross-Functional Analytics: Partner with sales, merchandising, finance, and engineering teams to model data structures, refine data pipelines, and answer real-time strategic questions during management meetings.

Professional Experience: 3–5 years of hands-on experience in business intelligence, data analytics, or financial analytics, ideally within e-commerce, retail, consumer products, or manufacturing environments.

SQL & BI Mastery: Advanced proficiency in SQL (Google BigQuery strongly preferred) and hands-on experience with modern BI tools (Looker, Google Looker Studio, Tableau, Power BI, or equivalent).

Data Visualization & Storytelling: Proven ability to translate complex quantitative data into clean, intuitive dashboards and concise written narratives that explain what the data means and what action leadership should take.

Advanced Google Sheets & Modeling: Strong expertise using Google Sheets for ad-hoc financial modeling, automated data ingestion, and rapid reporting.

Remote Independence: Excellent written and verbal English communication skills, with proven ability to operate autonomously in an async-first, distributed global team environment. (Conversational Spanish is a plus).

Hands-on proficiency with Python for data manipulation, automation, or API scripting.

Strong background in financial structures (gross margin, contribution margin, P&L analysis, or product unit economics).

Exposure to e-commerce/retail tech stacks, including Shopify, Amazon Seller Central, marketplace APIs, or ERP systems.

Academic background in Data Science, Business Analytics, Economics, or a related quantitative field (or an MBA with an analytics focus).

Reporting Automation Rate: Successfully automating recurring weekly and monthly reporting workflows with minimal manual intervention.

Data Accuracy & Integrity: Maintaining 100% data reconciliation accuracy across all executive dashboards and source systems.

Strategic Dashboard Engagement: Delivering actionable dashboards and monthly narrative briefs that are actively adopted by executive leadership to drive commercial decisions.