Business Intelligence Analyst

Accountabilities:: Dashboard development and business reporting: Build, maintain, and enhance automated dashboards using Looker, Google Data Studio, or similar business intelligence tools to track revenue, gross margin, operational KPIs, and channel performance. SQL development and data modeling: Write, optimize, and maintain SQL queries in BigQuery to extract, transform, and model data from ERP systems, e-commerce platforms, and marketplace APIs. Executive reporting and insights: Produce monthly business intelligence reports that translate performance metrics into clear, concise, executive-ready narratives for senior leadership, supporting informed strategic and operational decisions. Reporting automation: Design and implement automated reporting workflows using Google Sheets, BigQuery, and BI platforms to reduce manual tasks, improve efficiency, and ensure timely access to business information. Business performance analysis: Analyze sales trends, gross margins, product mix, and channel profitability to identify anomalies, emerging patterns, and leading indicators, providing actionable recommendations to improve business outcomes. Data quality and validation: Validate reporting outputs against source systems, investigate discrepancies, and implement measures to ensure data accuracy, consistency, and reliability across dashboards and reports. Cross-functional collaboration: Partner with sales, merchandising, operations, and finance teams to understand business needs and develop reporting solutions that address operational challenges and strategic priorities. Data infrastructure improvement: Collaborate with engineering teams on database architecture, data integration, and pipeline enhancements to support a growing analytics infrastructure and expanding business operations. Continuous improvement: Identify opportunities to strengthen analytics capabilities, simplify reporting processes, and improve the accessibility and usability of business intelligence tools across the organization. Requirements: At least three years of hands-on experience in business intelligence, data analytics, or another quantitative analytical role. Strong SQL skills, preferably with Google BigQuery, including the ability to query, transform, and model complex datasets efficiently. Experience with modern business intelligence and visualization platforms such as Looker, Tableau, Power BI, or equivalent tools. Advanced Google Sheets proficiency, including ad hoc analysis, data modeling, spreadsheet automation, and reporting workflows. Proven ability to design intuitive, user-friendly dashboards and communicate complex data findings through clear, strategic summaries for executive audiences. Experience working with commercial and financial performance metrics, including revenue, gross margin, product mix, and sales channel profitability, or a strong ability to develop these skills. Familiarity with e-commerce, retail, consumer products, or manufacturing environments, with an understanding of multi-channel business operations. Strong analytical thinking and problem-solving skills, with the ability to investigate discrepancies, identify trends, and translate findings into practical business recommendations. Ability to work independently, manage priorities effectively, and deliver accurate, high-quality results in a fast-paced, remote, asynchronous environment. Fluent English, both written and spoken, with the ability to collaborate regularly with international colleagues and communicate insights clearly to senior stakeholders. Current residence in Latin America, with the ability to work remotely from Brazil or another eligible Latin American country, subject to the hiring arrangement. Nice to have: Experience using Python for data manipulation, scripting, reporting automation, or analytics workflows. Background in financial reporting, gross margin analysis, contribution margin, or profit and loss (P&L) structures. Familiarity with e-commerce platforms such as Shopify and Amazon Seller Central, as well as ERP systems and their integrations. A degree in Data Science, Business Analytics, Economics, or another related quantitative discipline. Experience supporting leadership teams with data-driven recommendations in a growing, multi-channel business. Benefits: USD-denominated compensation: Earn compensation in US dollars. Fully remote work: Work from Brazil or another eligible Latin American location. Flexible schedule: Benefit from flexible working hours within a remote, asynchronous work environment. International collaboration: Work closely with an international team and senior business leaders in an English-speaking environment. Career development: Build expertise in business intelligence, data modeling, analytics automation, and strategic business reporting. Long-term engagement: Join a long-term independent contractor arrangement with opportunities to contribute to evolving data infrastructure and business intelligence initiatives. Meaningful business impact: Help shape leadership decisions by delivering insights into revenue, profitability, and operational performance.