Assistant Manager, Business Intelligence Analyst

Duties & Responsibilities:
1. Data Extraction & Management (SQL)

• Write efficient, optimized SQL queries in BigQuery to extract the exact data needed for specific business questions.
• Troubleshoot data discrepancies between raw source systems and final reports to ensure accuracy.
• Manage data tables and views to ensure dashboards load quickly and consistently.

2. Visualization & Reporting

• Design, build, and maintain interactive dashboards using Looker Studio.
• Transform complex datasets into clear, user-friendly charts and tables that non-technical stakeholders can understand at a glance.
• Regularly update and refine existing reports based on business feedback.

3. Business Analysis

• Respond to ad-hoc data requests from management (e.g., sales performance, inventory tracking, cost analysis).
• Proactively identify trends, anomalies, or risks in the data and highlight them to the relevant teams.

4. Advanced Analytics (Bonus)

• If capable: Utilize Python for advanced statistical analysis, forecasting, or automating repetitive data tasks.

Job Requirements:
Technical Skills

• SQL (Must Have): Strong proficiency in SQL (specifically BigQuery syntax). You must be comfortable with Joins, Aggregations, Window Functions, and UNNEST.
• Visualization: Hands-on experience with Looker Studio is highly preferred. Experience with Power BI or Tableau is also acceptable if you are willing to adapt.
• Excel: Advanced proficiency in spreadsheet functions.

Experience & Mindset

• Senior Executive: 3+ years of experience. Must demonstrate the ability to solve vague business problems independently and design scalable data solutions.
• Problem Solving: A natural curiosity to ask "why" when numbers look wrong, rather than just reporting them.