Deskripsi Pekerjaan
Keytiger is a dynamic and rapidly expanding e-commerce firm operating globally. We specialize in identifying profitable market niches and optimizing digital storefronts to drive substantial revenue growth. Our business model relies heavily on precise, data-driven strategies, and we are currently seeking a highly analytical Business Analyst to join our remote team and serve as the cornerstone of our data and reporting initiatives.
In this critical role, you will work 100% remotely from home, directly transforming raw data from multiple e-commerce channels, advertising platforms, and financial systems into clear, actionable reports and strategic recommendations. This position is ideal for a true Excel expert who enjoys solving complex business puzzles and uncovering the narrative hidden within vast datasets.
Your primary tools will be advanced Microsoft Excel functions, including complex formulas, pivot tables, macros, and VBA scripting. You will design comprehensive financial models, automate repetitive data processing tasks, and build dynamic KPI dashboards that provide real-time visibility to our leadership team. Collaboration with the Accounting, Marketing, and Operations departments is essential to ensure all business decisions are empirically validated.
We are seeking a professional who is not only technically proficient in Excel but also possesses strong business acumen and critical thinking skills. You will enjoy significant autonomy in managing your workflow while adhering to strict reporting deadlines. Your analytical contributions will have a direct impact on critical business areas such as pricing optimization, inventory turnover, and advertising return on investment.
If you are passionate about turning data into dollars and have the advanced Excel skills to do it, we strongly encourage you to apply. Join Keytiger and advance your career in a supportive, fully remote environment where your insights are valued and your professional growth is a priority.
Tanggung Jawab
- EXTRACT, TRANSFORM, AND LOAD (ETL) raw sales and operational data from various sources, ensuring accuracy and completeness.
- DEVELOP AND MAINTAIN complex Excel workbooks using advanced formulas (INDEX-MATCH, SUMIFS, ARRAY), macros, and VBA to automate reporting cycles.
- BUILD INTERACTIVE DASHBOARDS AND REPORTS summarizing Key Performance Indicators (KPIs) such as revenue, costs, profit margins, and customer acquisition costs.
- PERFORM VARIANCE ANALYSIS against budgets and forecasts, identifying trends, risks, and opportunities for business optimization.
- COLLABORATE WITH THE ACCOUNTING TEAM to reconcile financial data and ensure data integrity between operational systems and financial statements.
- PRESENT FINDINGS AND RECOMMENDATIONS to management clearly, supporting strategic decisions with robust quantitative evidence.
- PROVIDE AD-HOC ANALYSIS AND REPORTING support to the marketing and operations teams as needed.
Kualifikasi
- BACHELOR'S DEGREE in Finance, Accounting, Business Administration, Economics, or a related quantitative field.
- MINIMUM OF 3 YEARS of professional experience as a Business Analyst, Data Analyst, or Financial Analyst, preferably within an e-commerce or retail environment.
- EXPERT-LEVEL PROFICIENCY IN MICROSOFT EXCEL is mandatory. Candidates must be comfortable with VLOOKUPs, Pivot Tables, Macros, and advanced formulas.
- STRONG ANALYTICAL AND PROBLEM-SOLVING SKILLS with the ability to interpret complex data sets and translate them into actionable business insights.
- EXCELLENT VERBAL AND WRITTEN ENGLISH COMMUNICATION SKILLS are required for effective collaboration with a global team.
- SELF-MOTIVATED AND DISCIPLINED, with proven time management skills and the ability to thrive in a full-time work-from-home setup.
- EXPERIENCE WITH DATA VISUALIZATION TOOLS (e.g., Power BI, Tableau) or SQL is a strong plus but not strictly required.
- HIGH ATTENTION TO DETAIL and a commitment to delivering accurate, error-free reports under tight deadlines.