marcohire - Data Analyst
Requirements
• You have built a reporting stack before, not just worked inside one someone else built • You are equally comfortable in a SQL editor and in front of a leadership team • You think in definitions—you know that "revenue" meaning three different things in three systems is the real problem, not a rounding error • You make a recommendation rather than handing over a chart and waiting • You are self-directed and work well with a U.S. team, with a bias toward asking early rather than guessing • You are fluent in English, with clear verbal and written communication • You are comfortable being the only data person in the building, and you document accordingly • 3–5 years in a data analyst, business intelligence, or analytics engineering role • Strong SQL, and hands-on experience building or managing a cloud data warehouse (BigQuery, Snowflake, Redshift, or similar) • Experience implementing ETL/ingestion from SaaS APIs—Fivetran, Airbyte, or equivalent • Demonstrated experience building dashboards in Looker or Looker Studio from scratch, including the data model underneath them • Advanced spreadsheet skills—you can take messy data from several systems and get to a number people can trust • Proven ability to explain data to people who are not analysts, and to present to executives • E-commerce and CRM data experience, particularly Shopify and a sales CRM such as Pipedrive • Familiarity with accounting data and financial concepts such as margin, COGS, and contribution • Python or a similar language for data manipulation and automation • Experience at a small company where you owned reporting end to end rather than one slice of it • Experience integrating data from an acquired company into an existing reporting structure
Responsibilities
• Standing up the BI stack • Architect and implement the reporting stack from zero: source connections, a central data layer, and Looker as the reporting front end • Select and implement the ETL/ingestion approach (Fivetran, Airbyte, native connectors, or direct API) for each source system, with a clear case for the cost and trade-offs of each • Build clean, documented data models that other people can read and extend • Make monthly reporting a review step rather than a data-entry exercise • Pull and consolidate data across Shopify Plus, Pipedrive, QuickBooks Online, ShipStation, PandaDoc, Rippling, Google Analytics, and Asana • Establish one agreed definition for every metric, so revenue, margin, and pipeline mean the same thing in every report • Reconcile discrepancies between systems and find the source of the difference rather than reporting around it • Flag data quality problems and work with department leads to fix them at the source • Measurement and analysis • Own the company-wide KPI framework and tracker: maintain the definitions, keep targets current, and make sure each department is measured on the right things • Produce monthly performance reporting for all nine departments across three brands • Go past the number itself—explain the movement, identify the driver, and flag what leadership should be paying attention to • Run ad hoc analysis for the executive team on product line profitability, customer segments, sales performance, and operational throughput • Reporting and presentation • Build and maintain Looker dashboards that department leads open themselves instead of requesting a report • Produce a monthly executive package that is clear enough to be read cold and short enough to actually get read • Present findings live to the executive team monthly, and to department teams on a regular cadence • Turn analysis into specific recommendations rather than leaving the audience to interpret it • Documentation and scale • Document every data source, definition, model, and process so reporting does not depend on one person • Build reporting that scales as the company adds departments, brands, and acquisitions • Recommend and implement improvements to the stack as the business grows
Benefits
• Our client is DSLRPros (Enterprise UAS, LLC), a leading U.S. commercial drone and UAS reseller serving public safety agencies, enterprises, and government buyers. The company runs three brands and nine departments on an all-SaaS stack—Shopify Plus, Pipedrive, QuickBooks Online, ShipStation, PandaDoc, Rippling, Google Analytics, and Asana—and is growing through both organic expansion and acquisition. • A company-wide KPI framework and tracker are already in place, with department leads entering monthly actuals after each month close. What does not exist yet is a reporting layer: there is no BI tool, no central data warehouse, and no automated pipeline between the systems. That is what this role is here to build.
Apply in one click
Upload My Resume
Drop here or click to browse · Tap to choose · PDF, DOCX, DOC, RTF, TXT