Financial Reporting - Data Analytics Automation Lead
August 12
Description
• Identify Necessary Data: Determine the specific data needed to build comprehensive financial and operational reports. • Self-Service Data Acquisition: Independently acquire data from various sources, including Shopify apps, BigQuery, and Shopify Analytics. • Data Integration: Ensure seamless integration of data from multiple sources into Google Sheets for reporting purposes. • Conceptualize Reporting Solutions: Design and conceptualize complex reports, moving from raw data to finished reports with minimal guidance. • Advanced Formula Creation: Develop and optimize complex formulas that combine multiple functions to streamline and enhance reporting. • Custom Report Building: Utilize tools to create custom reports that meet specific business needs. • Automation: Implement automated processes for data extraction, transformation, and loading (ETL) to improve efficiency. • Continuous Improvement: Regularly evaluate and improve reporting processes to increase accuracy, efficiency, and effectiveness. • Problem-Solving: Address and resolve issues related to data acquisition, report creation, and automation independently. • Reporting Innovation: Stay up-to-date with new tools, technologies, and best practices to enhance reporting capabilities. • Cross-Functional Collaboration: Work closely with other departments to understand reporting needs and ensure alignment with business objectives. • Stakeholder Communication: Clearly communicate report findings, methodologies, and recommendations to stakeholders at all levels.
Requirements
• Proven experience in financial reporting and data analysis, with a focus on e-commerce platforms like Shopify. • Advanced Proficiency in Google Sheets: Expertise in functions such as QUERY(), ARRAYFORMULA(), IMPORTRANGE(), REGEXMATCH(), REGEXREPLACE(), FILTER(), COUNTIF(), VLOOKUP(), XLOOKUP(), INDEX()+MATCH(), LET(), and MAP() + LAMBDA(). • Experience with Shopify Reporting Tools like Report Pundit and Matrixify for flexible, automated reporting. • Ability to pull data from BigQuery into Google Sheets for custom reporting needs. • Familiarity with ETL tools like Parabola.io or Make.com for automating data workflows. • Ability to self-serve in acquiring and analyzing data, with minimal oversight. • Strong problem-solving skills, with the ability to conceptualize and implement complex reporting solutions. • Attention to detail and a commitment to delivering high-quality, accurate reports.
Apply Now