Senior Data Analyst

Senior Data Analyst

Client – Product Company Client is based out of three locations
- San Francisco, New York, Seattle, or Little Rock. Note – Remote is also ok if you find the right candidate, he will have to work in PST time zone. Note – This is a product company and they build complex market analysis platforms for very large clients mostly related to market-media domain specialization.

• 12-15+ years of experience in analytics or data science, with expertise in measurement and attribution.
• 3-5 years experience in AdTech industry required; familiarity with the TV industry is a plus.
• 3-5+ years of experience in AdTech & Marketing Analytics.
• Skilled in measurement, attribution, funnel analysis, and developing client ready dashboards in SQL, Python, Excel, Tableau, and Sigma.
• Hands on exposure to AdTech style analytics through campaign performance, subscription funnel modeling, and event stream data analysis.
• Analyzed campaign performance across Ad Spend, CAC, and impressions to evaluate acquisition efficiency; built Sigma dashboards and delivered recommendations that directly informed campaign scaling and budget allocation decisions.
• Proven track record of creating and presenting data-driven dashboards and presentations, effectively telling a story through insights, with hands-on experience in Metabase, Tableau, and Looker.
• Solid understanding of data modeling techniques, with the ability to explain complex concepts to different audiences.
• Ability to independently prepare analysis using SQL, Python, Excel, and statistical methods.
• Detail-oriented with strong time management skills, delivering high-quality, client-ready analytical reports across multiple projects.
• Comfortable presenting complex analyses to large, non-technical audiences, while also being able to adapt to effectively communicate with technical audiences.

Programming & Analytics: SQL, Python, Excel, PySpark, Airflow, Snowflake Business Intelligence & Storytelling:
Tableau (Certified), Sigma, Statistical Analysis, A/B Testing, Data Modelling

Certifications:

Tableau Certified Analyst (2020), Ongoing:
Databricks Academy
- Streaming & Lakeflow Declarative Pipelines Cloud & Big Data: AWS Cloud, Databricks

Structured multi-platform event data (iOS, Android, Web) into Snowflake models tracking the full user journey
- View → Click → Purchase - identifying conversion drop-offs and delivering funnel insights to product and marketing stakeholders. Analyzed campaign performance across Ad Spend, CAC, and impressions to evaluate acquisition efficiency; built Sigma dashboards and delivered recommendations that directly informed campaign scaling and budget allocation decisions. Unified fragmented marketing event streams into a consolidated attribution model delivering ~$300K annual cost savings.

Built iOS conversion forecasting model and multi-touch attribution logic to estimate ad conversions across partner and campaign levels. Presented findings, A/B test outcomes to senior business stakeholders and non-technical leadership tailoring storytelling to audience needs. Fintech & Insurance:
Designed customer identity and analytical models integrating multi-source transactional data (CRM, loyalty, usage signals) in Snowflake to evaluate customer behavior, engagement trends, and retention KPIs - enabling targeted loyalty programs and usage-based insurance analytics at Intact Financial, in close collaboration with business teams to refine metrics and support operational decision-making.

Built a large-scale event-driven data platform using PySpark and Spark SQL to ingest, validate, and transform multi-source client data from SFTP/S3 into curated analytics-ready gold datasets in Snowflake - optimizing Spark jobs for performance and reliability.

Analyzed ML model performance across large experimental datasets in python generating benchmarking reports and visual summaries of model behavior presenting results through HTML-based graphs in client-ready insight reports.

The Senior Data Analyst will work on reporting and analytics initiatives for…