Business Analyst

ABOUT US:   ESQgo, PC is an intellectual property law firm founded by an Amazon sellers' lawyer and a former $1,000,000+ Amazon seller. We guide online business owners through Amazon account and ASIN reinstatements, listing hijacker removal, intellectual property complaints and appeals, and many other issues and concerns. As a modern law firm, our mission is to focus not only on your immediate legal matter but also on your future goals and potential as an e-commerce business. We count on a highly talented and diverse team of professionals from different regions of the globe who come together virtually to advocate for our clients through innovative legal solutions.  Mision:   

• Providing entrepreneurs with creative yet logical solutions to support the growth of their online business.

Vision:   

• Empower entrepreneurs to achieve more by transcending legal representation.

Our Values:   

• Integrity 
• Collaboration 
• Innovation 
• Client Centricity 
• Accountability 

REPORTS TO:  

• CEO 

LOCATION:  

• Globally distributed 

PURPOSE OF THE ROLE:   To help the management team drive operational efficiency, service delivery, and support the firm's growth by ensuring that financial strategies align with overall business objectives based on data-driven insights. By leveraging your expertise in Power BI, Advanced Excel, Financial Analysis and through innovative data visualization and financial modeling, you will be instrumental in shaping the firm's financial health and strategic vision.  KEY RESPONSIBILITIES:   Data Analysis & Visualization:  

• Use Power BI to build and manage interactive dashboards, providing insights into financial performance and key operational metrics across all departments 
• Perform data mining and analysis using Advanced Excel (pivot tables, macros, advanced formulas) to identify trends, risks, and opportunities 
• Build comprehensible data-based reports, presentations, and centralized source of information for the leadership team

Business Forecasting & Reporting:  

• Collaborate with management by designing financial & budget forecasts and models
• Prepare weekly, monthly, quarterly, and annual financial reports, profit & loss, and balance sheet reports, ensuring accuracy and compliance with financial standards 
• Present financial reports and analysis to management, highlighting key insights and areas for potential improvement 
• Implement automation within Excel and Power BI to streamline data processing and reporting activities 

Financial Administration:  

• Administer vendor’s relationships, budgeting, payments, invoices, etc. 
• Manage client’s invoicing, billing, payment plans, and AR/AP processes 
• Support with clerical duties from the management team 
• Other duties as assigned 

QUALIFICATIONS:   Education:  

• Bachelor's degree in Business Administration, Finance, Accounting, or related fields 
• Power BI and Advanced Excel certifications preferred

Experience:  

• 5+ years in business or financial analyst roles required
• 2+ years of experience working in service-digital-based companies 

Competencies & Requirements:  

• Advanced written and spoken English
• Power BI 
• Advanced Excel (pivot tables, advanced formulas, VLOOKUP, INDEX-MATCH, and macros for complex data analysis) 
• Financial planning and forecasting 
• Proficient with Microsoft Office Suite, and financial apps 
• Availability to work in US-based PST time zone 

COMPENSATION:  

• Monthly base pay of $850 
• Monthly bonus potential based on KPI and financial growth 
• Yearly merit increase potential 
• Monthly stipend of $50 for healthcare support 
• Monthly stipend of $30 for technology and equipment 
• Learning incentives 
• Paid time off 
• Paid holidays 

SELECTION PROCESS:  

• Competency-based interview 
• Technical assessments 
• Final interview with Hiring Manager 

Disclaimer : The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not an exhaustive list of all responsibilities, duties and skills required of personnel so classified. All personnel may be required to perform duties outside of their normal responsibilities from time to time as needed.    ESQgo is an Equal Opportunity Employer and prohibits discrimination and harassment of any kind. All employment decisions at our company are based on business needs, job requirements and individual qualifications, without regard to actual or perceived race, color, religion, sex (including pregnancy), national origin, age, disability or certain classifications based on genetic information, or any other characteristic protected by federal, state, or local laws, regulations or ordinances.    If you have a disability and believe you need reasonable accommodation to search for a job opening or apply for a position, email careers@esqgo.com with your request. This email address is not for general employment inquiries or correspondence. We will only respond to those requests that are related to the accessibility of the online application system due to a disability.