Magic
Accountant with SQL Coding Experience – Freelance, Remote
Application Deadline: 30 September 2024
Department: Client: Smoking
Employment Type: Freelance
Location: Philippines
Compensation: $7.00 / hour
Description
About the Client
Our client is a dynamic e-commerce company specializing in packing and shipping accessories used for marijuana. With a commitment to quality and innovation, they have established themselves as a leader in their niche market. The company is currently in an expansion phase, seeking to enhance their accounting and operational capabilities.
Why does this role exist?
This role exists to strengthen the financial reporting and data analysis capabilities of the Accounting and Operations department. The position will play a crucial role in improving accounting processes, enhancing operational efficiency, and providing valuable insights through SQL-driven data analysis. By bridging the gap between accounting and technology, this role will contribute significantly to the company’s growth and decision-making processes.
The Impact you’ll make
Financial Reporting and Analysis
Prepare and analyze financial reports using SQL to extract accurate data
Design and build SQL queries for ad hoc reporting and performance analysis
Assist in month-end and year-end closing procedures
Process Improvement and Automation
Collaborate on special projects to streamline operations and ensure compliance
Automate repetitive tasks using SQL for enhanced efficiency
Develop and implement new processes to improve overall financial operations
Data Management and Insights
Ensure accuracy and alignment of financial data across the organization
Identify trends and insights through SQL-driven data analysis
Support audit processes by providing relevant reports and data analysis
Cross-functional Collaboration
Work closely with the Controller and COO on special accounting and reporting projects
Liaise with stakeholders across departments to ensure data accuracy and relevance
Communicate financial insights effectively to non-financial team members
Measure of Success
Accuracy and timeliness of financial reports and analysis
Successful implementation of process improvements and automation initiatives
Quality and relevance of insights derived from data analysis
Skills, Knowledge and Expertise
Required Experience
Bachelor’s Degree in Accounting
Proven experience in SQL coding/scripting for financial reporting
Strong understanding of accounting principles and financial processes
Proficiency in data analysis and interpretation
Experience with ERP systems and e-commerce platforms (e.g., Amazon FBA, Shopify)
Your superpowers are…
Expert-level SQL coding skills with a focus on financial applications
Strong analytical thinking and problem-solving abilities
Excellent attention to detail and organizational skills
Ability to work independently and proactively
Clear and effective communication, both written and verbal
Adaptability and eagerness to learn new technologies and processes
Creativity in finding innovative solutions to complex problems
You should apply if…
You thrive in a fast-paced, growth-oriented environment
You’re passionate about leveraging technology to improve financial processes
You enjoy the challenge of turning complex data into actionable insights
You’re a self-starter who takes initiative and seeks out opportunities for improvement
You value collaboration and can work effectively with diverse teams
You’re excited about the potential of the e-commerce industry and are comfortable working in the cannabis accessories sector
Benefits
Magic
You must sign in to apply for this position.