Marco

Data Analyst

• Architect and implement the reporting stack from zero, including source connections, a central data layer, and Looker as the reporting front end
• Select and implement the ETL/ingestion approach for each source system
• Build clean, documented data models
• Make monthly reporting a review step rather than a data-entry exercise
• Consolidate data across Shopify Plus, Pipedrive, QuickBooks Online, ShipStation, PandaDoc, Rippling, Google Analytics, and Asana
• Establish agreed definitions for every metric and reconcile discrepancies between systems
• Flag data quality problems and work with department leads to fix them at the source
• Own the company-wide KPI framework and tracker
• Produce monthly performance reporting for all nine departments across three brands
• Explain performance movements, identify drivers, and flag leadership priorities
• Run ad hoc analysis for the executive team on profitability, customer segments, sales performance, and operational throughput
• Build and maintain Looker dashboards
• Produce a monthly executive reporting package
• Present findings to the executive team monthly and department teams regularly
• Turn analysis into specific recommendations
• Document every data source, definition, model, and process
• Build scalable reporting as the company adds departments, brands, and acquisitions
• Recommend and implement improvements to the data stack