Mark Amanfu
Analytics Engineer at HBO Max- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Credentials
-
Google Analytics
Google
Experience
-
HBO Max
-
Entertainment Providers
-
700 & Above Employee
-
Analytics Engineer
-
2022 - Present
Analytics engineer at HBO Max, WarnerMedia's direct-to-consumer streaming platform. Responsibilities include, but are not limited to: • Delivering executive leadership reporting and ad hoc analysis using Looker for HBO Max and the subscriber growth and revenue teams • Designing and implementing dbt (Data Build Tool) data models that support flexible querying and data visualization • Writing fast and efficient SQL to support data-warehousing concepts such as star schemas, slowly changing dimensions, ELT/ETL, and MPP databases • Writing testable Python code to ensure that customers receive the most defect-free experience possible Show less
-
-
-
Warner Bros. Discovery
-
United States
-
Entertainment Providers
-
700 & Above Employee
-
Analytics Engineer
-
2022 - Present
Analytics engineer at HBO Max, WarnerMedia's direct-to-consumer streaming platform. Responsibilities include, but are not limited to: • Delivering executive leadership reporting and ad hoc analysis using Looker for HBO Max and the subscriber growth and revenue teams • Designing and implementing dbt (Data Build Tool) data models that support flexible querying and data visualization • Writing fast and efficient SQL to support data-warehousing concepts such as star schemas, slowly changing dimensions, ELT/ETL, and MPP databases • Writing testable Python code to ensure that customers receive the most defect-free experience possible Show less
-
-
-
RAPP
-
United States
-
Advertising Services
-
700 & Above Employee
-
Senior Analytics Engineer
-
2019 - 2022
Provide clients with accurate measurement of marketing touchpoints and the corresponding activation of analytics and reporting platforms. Areas of focus include: Data Engineering • Design and optimize ETL workflows using Python, Bash, R, SQL, Cron, and Airflow, leveraging Git for version control • Extract data by connecting to various APIs, web scraping, and other sources, including but not limited to SFTPs, Azure Blob Storage, Amazon S3 buckets, and Google Cloud Storage • Experienced with schema design, data architecture, data modeling, AWS, and Microsoft Azure services • Manage multiple projects simultaneously using project management and collaboration tools such as JIRA and Confluence Digital Measurement • Digital analytics tracking architecture, implementation, and validation / diagnostics • Tag management systems / content and URL tagging • Mobile measurement platforms Analytics Tech Activation • Tableau, Datorama, and Domo activation • Google Analytics / Adobe Analytics configuration • Analytics and data science infrastructure • Attribution platform onboarding • Analytical data mart design and specifications • Data privacy and compliance consultation Client: Toyota Show less
-
-
-
Self-Employed
-
United States
-
Financial Services
-
400 - 500 Employee
-
Private Tutor
-
2013 - 2020
• Tutor for UCLA Extension students enrolled in Stats XL10 and foreign-born Santa Monica College students • Prepare students for upcoming quizzes and tests via problem-solving practice and thorough explanations of complex concepts • Improve students’ sentence structure and writing ability, resulting in higher grades each semester • Tutor for UCLA Extension students enrolled in Stats XL10 and foreign-born Santa Monica College students • Prepare students for upcoming quizzes and tests via problem-solving practice and thorough explanations of complex concepts • Improve students’ sentence structure and writing ability, resulting in higher grades each semester
-
-
-
Quigley-Simpson
-
United States
-
Advertising Services
-
100 - 200 Employee
-
Marketing Data Analyst
-
2018 - 2019
• Evangelize a measurement culture and contribute to analytics documentation (e.g., data dictionary, variable map) using knowledge management tools (e.g., SharePoint, Wiki) to provide a reference repository for the organization. • Monitor and provide optimization recommendations for omni-channel marketing campaigns • Assist in the creation and management of key client marketing and media performance reports and dashboards, as well as assist in data ETL and automation processes via R, Python, Excel, Alteryx and Tableau • Test/control design methodology for A/B, multi-variate, creative, or lift-based testing/studies • Execute analysis (e.g., segmentation, campaign) using analytic and/or statistical/applied statistical tools (e.g., R, Excel, Python) to address business questions, issues, and opportunities. • Perform analytical “deep dives” as needed • Translation of complex statistical concepts and models into client-facing products and presentations that tell a clear and concise story for the layperson • Review and refine data process within organization to ensure the accuracy, efficacy, and serialization of data across internal and external stakeholders and partners • Research, document, and resolve internal and external stakeholder data processes, visualization, or access issues Clients: Procter & Gamble, Chase, NBCUniversal and Sutter Health Quigley-Simpson is a full-service advertising agency specializing in strategic planning, marketing, media planning & media buying, brand building, creative development, production and Multi-Cultural advertising. Visit www.quigleysimpson.com for more information. Show less
-
-
-
565 Media
-
United States
-
Technology, Information and Internet
-
1 - 100 Employee
-
Digital Marketing Analyst
-
2017 - 2018
• Expertise in planning, executing, and optimizing campaigns across digital advertising platforms, focusing on Facebook, AdWords, Bing Ads, Yahoo, and Pinterest • Conduct comprehensive data analysis of marketing campaigns and events, and provide recommendations that drive optimizations across channels • Update agency, greater team on key industry trends, media research, marketplace conditions, and how it all impacts our clients; make strategic recommendations accordingly _______________________________________________ 565 Media LLC provides best-in-class Online Marketing & User Acquisition services for Startups & Mid-Sized E-Commerce companies. Show less
-
-
-
SQA Services, Inc.
-
Business Consulting and Services
-
100 - 200 Employee
-
Database Analyst
-
2017 - 2017
Contracted consultant for SpaceX specializing in the use of statistics and programming to aid clients in making more data driven supplier selection, scoring, and oversight decisions Contracted consultant for SpaceX specializing in the use of statistics and programming to aid clients in making more data driven supplier selection, scoring, and oversight decisions
-
-
Education
-
University of California, Los Angeles
Bachelor’s Degree, Statistics -
2017 - 2017
UCLA Extension
COM SCI X 414.65 Advanced SQL Syntax
Community
