• Work on different projects to help Astrafy customers get the most out of their data. • Collaborate with stakeholders to understand the business needs. • Challenge and refine the requirements to ensure alignment with business objectives. • Perform a thorough analysis of the client's database to assess the available data. • Conduct workshops with stakeholders to validate KPIs. • Define visualizations and the overall dashboard structure in Looker (using Miro or Figma). • Build or refine the data model to support Looker’s data exploration (using BigQuery and dbt). • Develop LookML models for transforming and structuring data. • Ensure flexibility for users to explore custom reports. • Focus on usability and clear data presentation. • Leverage AI-driven solutions to enhance user experience. • Write articles to share expertise, insights, and innovations.

• Analyze customer acquisition performance across paid search, display, affiliate, and organic channels — spend efficiency, conversion rates, cost per acquisition, and cost per subscriber — and recommend optimizations to the performance marketing team. • Build and maintain reporting on subscription funnel economics: trial starts, trial-to-paid conversion, rebill/retention, churn, and customer lifetime value by channel and campaign. • Analyze A/B and pricing test results to guide decisions on page content, UX, offers, and pricing. • Investigate anomalies in traffic, conversion, and revenue data; distinguish real business changes from tracking or attribution artifacts before findings reach stakeholders. • Retrieve and aggregate data from multiple sources (web analytics, ad platforms, billing/subscription systems, internal databases) into clear, actionable reporting for stakeholders at all levels. • Design, build, and maintain automated dashboards and reporting solutions in our BI platform (Domo), migrating existing manual and legacy reporting into governed, automated pipelines. • Automate and optimize existing manual data workflows, reducing time-to-insight and error risk. • Partner with leadership to define key metrics, KPIs, and dashboards that measure business performance; maintain clear metric definitions and a single source of truth. • Plan the reporting and analytics roadmap at a high level with business owners, then prioritize and execute the work individually and with BI contractors. • Work with cross-functional teams (marketing, product, engineering, finance) and external agency partners on day-to-day execution of analytics projects and initiatives. • Over time, coordinate work with BI contractors supporting platform development, reviewing output for quality and consistency.

• Design, develop, test, document, maintain, and troubleshoot database objects, ETL processes, and custom reporting solutions for Business Intelligence and data integration tools • Implement reliable data pipelines and scalable data structures • Create and optimize various reporting products for business users • Support the full project lifecycle including requirements gathering and defining, solution design, development, quality assurance testing, and user acceptance testing phases of projects

• Design, develop, test, document, maintain, and troubleshoot database objects, ETL processes, and custom reporting solutions. • Responsible for implementing reliable data pipelines and scalable data structures. • Create and optimize various reporting products for business users. • Actively support the full project lifecycle including gathering and defining requirements, solution design, solution development, testing, and user acceptance testing.