Matt Sokol Email & Phone Number

Chicago, IL, US

Chicago, Illinois, US

Chicago, IL, US

Columbia, Maryland, US

• Led development of Lower’s foundational data warehouse efforts in Snowflake by designing, building, and testing dbt models for marketing analytics, financial reporting, and product analytics
• Created ELT pipelines using Python/Fivetran to extract first and third party data from REST/SOAP endpoints into Snowflake (Salesforce, Google Ads, Workday, AWS RDS)
• Built services in AWS Lambda and VPC to retrieve semi-structured XML and JSON data from IP-restricted sources, using the AWS Python SDK to extract data from AWS for transformation and loading into Snowflake
• Built and maintained CI processes using Github Actions runners to ensure seamless code development and increased uptime and accuracy in Lower’s production data warehouse environment

Columbus, Ohio, US

• Built REST API integration within ETL process to automate the creation and posting of accounting journal entries in Oracle Netsuite. Designed unit testing and data validation processes to ensure data was being posted.
• Created new data models within the data warehouse Rails application to improve the visibility of unit test failures occurring during the ETL build process, allowing the team to better analyze and visualize issue trends.
• Worked closely with Accounting and Finance departments to define, implement, and troubleshoot reinsurance and accounting booking logic in data warehouse resulting in consistent and accurate data for month-end reporting.
• Used Terraform to configure DMS replication tasks, allowing access to Root’s mobile app RDS databases within Redshift for analytics and modeling (Terraform, RDS, DMS, Glue)
• Performed regular code reviews and on-call duties for the Data Engineering team

Columbus, Ohio, US

• Developed, executed, and analyzed A/B testing on Root’s email marketing and push notifications within Braze leading to increased open, click, and post engagement conversion rates
• Built and maintained ETL processes for CRM data, allowing us to bring CRM analytics in-house and improve efficiency and accuracy of reporting (SQL, Fivetran)
• Optimized HTML, CSS, and Liquid code within Root’s marketing emails to increase personalization and cross-platform responsiveness

Columbus, Ohio, US

• Built and maintained monitoring dashboards for business KPI's and ongoing A/B tests using SQL and R
• Collaborated with engineers and product managers to build strategic and measurable A/B tests within the Root mobile app
• Performed analysis on A/B tests and provide project managers with decision recommendations based on findings
• Conducted ad-hoc analysis of Root users to discover new areas of product testing and potential business improvements

Columbus, Ohio, US

• Managed and optimized performance of in-app programmatic and paid search channels
• Performed daily creative performance analysis and budget optimization across all channels
• Worked cross-functionally with Product teams to assess the quality of users as they entered into Root’s customer funnel

Columbus, OH, US

• Developed and executed all Express and Express Factory Outlet email campaigns within Adobe Campaign
• Worked with cross-functional teams to ensure that complex segmentation and testing strategies are executed flawlessly
• Coded and ran ad hoc SQL queries on Express customer database

Parsippany, New Jersey, US

• Established monthly and quarterly performance data reports for GAF external program vendors
• Created application usage heat maps, performance trend charts, and various other visualizations using Tableau
• Utilized data analysis to suggest recommendations to improve program performance and sustainability

Parsippany, New Jersey, US

• Served on various team-based projects within GAF's Certified Contractor Programs team to strengthen email campaigns and vendor programs
• Utilized Qualtrics and SurveyMonkey to conduct consumer satisfaction surveys for up to 4,000 roofing contractors
• Used Oracle Eloqua reporting data to analyze trends in email campaigns and investigate ways to improve unique click-through rates
• Worked with GAF certified roofing contractors to assess the value-added benefits of various CCP vendor programs
• Communicated with CCP program vendors to collect and organize marketing materials for monthly Tools4Success Guide newsletter
• Created a dynamic workbook to efficiently organize and plan 2 years of marketing material for vendor programs

New York, NY, US

• Created and distributed daily, weekly, and monthly newsletter content for Target, Credit Suisse, and Genesys
• Managed social media accounts for Credit Suisse's The Financialist, ensuring that content was posted on a consistent basis while maintaining high standards
• Created weekly content for Marriot's SpringHill Suites Facebook, Twitter, and Instagram accounts
• Collaborated with other interns to assemble and present an industry trends report every three weeks