Business Intelligence Analyst (SQL/BigQuery)

Location: Fully remote, must be based in Latin America; listed locations include Colombia, Peru, Ecuador, Brazil, and Argentina.

Company

hirify.global is a remote work platform connecting professionals in Latin America with international companies; the client is a design and manufacturing company operating across e-commerce, retail, marketplaces, and B2B wholesale.

What you will do

• Build, maintain, and enhance automated Looker or Google Data Studio dashboards tracking revenue, gross margin, and operational KPIs across channels.
• Write and optimize SQL queries in BigQuery to extract, transform, and model data from ERPs, e-commerce platforms, and marketplace APIs.
• Produce monthly business intelligence reports and executive-ready narratives for senior leadership.
• Design automated reporting workflows using Google Sheets, BigQuery, and BI tools.
• Identify trends, anomalies, and leading indicators in product mix and channel performance, providing strategic recommendations.
• Validate data accuracy, resolve reporting discrepancies, and collaborate with sales, merchandising, operations, finance, and engineering teams on reporting, architecture, integrations, and pipelines.

Requirements

• At least 3 years of hands-on experience in business intelligence, data analytics, or a quantitative analytical role.
• Strong SQL proficiency, preferably with BigQuery, and experience with modern BI tools such as Looker, Tableau, Power BI, or similar.
• Advanced Google Sheets experience for ad hoc analysis, data modeling, and automated reporting.
• Ability to design clear, intuitive dashboards and translate complex datasets into strategic executive summaries.
• Experience with or strong domain interest in e-commerce, retail, consumer products, or manufacturing.
• Strong problem-solving skills and ability to work autonomously in a fast-paced, remote environment.
• Fluent English is mandatory for regular collaboration with an international team.
• Must be based in Latin America.

Nice to have

• Python experience for data manipulation, automation, or scripting.
• Background in financial reporting, gross margin analysis, contribution margin, or P&L structures.
• Familiarity with e-commerce platforms such as Shopify or Amazon Seller Central, or ERP system integrations.
• Academic degree in Data Science, Business Analytics, Economics, or a related quantitative field.

Culture & Benefits

• Fully remote work within Latin America with flexible schedules.
• Remote, async-first environment with autonomous work.
• Work with international clients and teams in an English-speaking environment.
• Career growth through dynamic projects.
• Compensation in USD.
• Long-term independent contractor agreement with no paid time off, health insurance, or other additional benefits.

Hiring process

• Initial interview with the recruiting team.
• Technical interview with the client, followed by a cultural fit interview with the client’s manager.
• Final interview with a C-level executive; the process usually has four stages and takes approximately 4–6 weeks, with possible additional technical rounds or take-home tests.