Nirali Patel
ady7wy@r.postjobfree.com 407-***-**** www.linkedin.com/in/niralipatel125 Denver, CO
SUMMARY
Data analyst and developer with over 4 years of agency experience working with clients in retail, subscription, and healthcare industries. Passionate about storytelling data via robust data visualizations, implementing and improving on data processes and data models, and providing data-driven insights and analyses to stakeholders. WORK EXPERIENCE
Data Architect (Contract) Feb 2023 – May 2023
ANNUITAS Denver, CO
● Utilized Tableau and Power BI to design and develop full-funnel growth marketing dashboards
● Conducted a cohort analysis, identifying the retention and demographics/motivations of high-value LTV customers to improve customer loyalty and increase revenue for a food delivery subscription client
● Developed strategic KPI mapping frameworks and dashboard wireframes, aligning key metrics with business objectives to effectively track performance and drive actionable insights
● Collaborated with data developers to create Snowflake data models according to KPI frameworks Data Analyst Nov 2021 – Feb 2023
MERGE Denver, CO
● Developed data models, consolidating data from various marketing platforms and API connections, using Google BigQuery and Funnel.io to support data visualizations and automate data refreshes
● Acted as a subject matter expert in Tableau in a data migration from Google Looker Studio to Tableau by optimizing queries, hosting Tableau workshops, and assisting in a Tableau server build
● Designed visually compelling dashboards in Tableau and Google Looker Studio to facilitate comprehensive analysis of marketing performance for major healthcare and hospital clients
● Built and debugged event/conversion tracking in Google Tag Manager, ensuring accurate data capture
● Implemented end-to-end measurement tracking across KPIs and campaign taxonomy to guide campaign creation, inform data tracking and UTM parameters, and create data models with clean data
● Enhanced analytics capabilities by improving and documenting data processes internally, as well as communicating data requirements, limitations, and project/deliverable timelines with clients Data Analyst June 2019 – Oct 2021
Tinuiti Denver, CO
● Created data pipelines and flows using Tableau Prep and SQL to query from an AWS Redshift database to further streamline data flows, and automate data refreshes via Tableau Cloud
● Designed cross-channel and full funnel marketing performance Tableau dashboards highlighting performance across Google Ads, Facebook/IG, Google Analytics, and Adobe Analytics for clients in beauty, streaming, and healthcare industries
● Performed statistical analyses, such as regression and correlation, for mixed marketing studies and incremental lift studies and presented insights to inform strategic marketing optimizations
● Conducted marketing spend and revenue forecasts to better inform ROI goals for performance tracking
● Played a key role in enhancing analytical capabilities by proactively identifying process improvements, documenting data processes and campaign UTM taxonomy, and training new hires on analytics tools CERTIFICATES AND SKILLS
Skills
● BI tools
o Tableau Desktop/Cloud (4+ years)
o Google Looker Studio (2+ years)
o Power BI (~3 months)
● Data transformation/modeling tools
o Google BigQuery (1 year)
o Tableau Prep (3+ years)
o Funnel.io (1 year)
o Snowflake (~2 months)
o AWS Redshift (~3 months)
● Data analysis/statistical modeling tools
o R (3+ years)
o Python (2+ years)
o Microsoft Excel (4+ years)
● Marketing/sales platforms
o Google Analytics (3+ years)
o Adobe Analytics (1 year)
o Google Ads (3+ years)
o Google Tag Manager (1 year)
o Facebook/Instagram (2+ years)
o Salesforce (1 year)
o Marketo (1 year)
● Microsoft Office (8+ years)
● Google Suite (6+ years)
Certifications
● SnowPro Core Certificate (In Progress)
● dbt Fundamentals (In Progress)
● Tableau Desktop Certified Associate
● Google Analytics Individual Qualification
● Google Ads Measurement Certification
EDUCATION
University of Florida May 2019
Bachelor of Science (B.S.) in Statistics
Gainesville, Florida