John Payne Email and Phone Number
As a seasoned developer and engineer, I am passionate about harnessing the power of data to drive business growth and operational efficiency. With over 8 years experience, I bring a comprehensive skill set to the modern data stack. My proficiency encompasses AWS Redshift / S3, Snowflake, and DBT Labs, where I have spearheaded the development and migration of sophisticated data warehouse architectures. My core competencies include using SQL and Python to build and manage ETL pipelines, develop optimized data models, and automate testing frameworks. In the realm of data visualization and analytics, I am skilled in Looker/LookML, and Tableau. My expertise in these tools enables me to lead strategy, engineer data warehousing solutions, and develop semantic layer architectures. These solutions provide stakeholders and customers with data products that drive business decisions. I've also led integration projects that synchronize Salesforce and Marketo platforms, enabling automated marketing workflows and improving accuracy of ROI reporting. Furthermore, my experience with Google Analytics 4 (GA4) has been instrumental in tracking user behavior, refining marketing strategies, and elevating user experience through actionable insights.
-
Senior Analytics EngineerUnite Us Aug 2023 - PresentNew York, Ny, Us
-
Sql Developer, Marketing AnalystVetsource Dec 2022 - Aug 2023Portland, Or, Us• Build project roadmaps that outline goals, resource requirements, and estimated timelines.• Develop and test data models, collaborate with team members, set up error notifications, and debug issues using dbt and Github.• Optimize Snowflake cloud compute resources w/ modular SQL statements in dbt, workflow automation, monitoring and testing, and scaling warehouses.• Improved Marketo and Salesforce sync, maximizing capabilities for lead scoring and marketing automation.• Create clear and concise documentation for SQL code, database schemas, and data dictionaries. -
Marketing AnalystVetsource Aug 2021 - Dec 2022Portland, Or, Us• Create and automate reports and dashboards in LookML and Looker.• Develop attribution, LTV, and other various data models using dbt and SQL.• Identify audience cohorts and segmentation opportunities by analyzing cross channel touchpoints, user engagement, conversion, and retention.• Present actionable insights to internal and external stakeholders using Lucid charts and Powerpoint.
-
Data AnalystBuilders Capital Jul 2020 - Aug 2021Puyallup, Washington, Us• Gather and document business requirements, define performance metrics and KPI's, and lead projects to deliver automated reporting and ad hoc insights.• Use data modeling best practices to Developed ETL pipelines using SQL and Python.• Create visualizations and automated dashboards using Tableau and Tableau Server.• Performed A/B testing and statistical analysis with Python, numpy, scipy.stats, matplotlib, and seabird to drive informed decisions around website development and marketing initiatives. -
Field Marketing AnalystSales Partnerships, Inc. Jan 2020 - Jun 2020Broomfield, Co, Us• Build automated dashboards, ad hoc reporting, and presentations using Power BI and Powerpoint.• Lead communication across departments to prioritize requests and drive proactive planning.• Develop data models using SQL to assist in business analysis.• Assist in the development of training tools to support dashboard best practices. -
Sales And Marketing AnalystRegency Technologies, Llc Jan 2015 - Dec 2019Stow, Ohio, Us• Deliver actionable insights on sales performance and industry market trends using Tableau.• Develop and manage ETL pipelines to ensure sales and marketing data available for analyses.• Create and deliver quality presentations using lucid charts and PowerPoint to senior management.• Develop commodity disposition guidance based on current sales trends for assigning triage process to appropriate sales channels.
John Payne Education Details
-
Mississippi State UniversityEducation -
ThinkfulData Analytics
Frequently Asked Questions about John Payne
What company does John Payne work for?
John Payne works for Unite Us
What is John Payne's role at the current company?
John Payne's current role is Senior Analytics Engineer | Data Strategy | Best Practices Advocate.
What schools did John Payne attend?
John Payne attended Mississippi State University, Thinkful.
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial