Location: Remote, OR
Company: Valuable Recruitment
to drive business intelligence.
The goal is to capture a comprehensive view of the entire customer journey, encompassing datapoints from initial advertising through to marketing engagement, sales process, fulfillment, support, and ongoing customer services.
Objectives Data Centralization: Aggregate data from diverse sources including Meta Business Suite (Ads running in Meta/FB Platform), Google Ads, Google Analytics 4, Hyros, Once Hub, Hubspot, Close (Sales CRM), Google Sheets, and others into a single repository (Big Query). Customer Journey Tracking: Correlate data across the entire customer journey from the abovementioned data centralization task, from top-of-funnel activities
such as ad views to post-purchase support and coaching program and retention metrics in order to derive actionable business insights. Technical Foundation : Leverage Big Query and Looker Studio to build a robust, scalable data architecture with KPIs for each departments (Marketing, Sales, Customer Success, etc.
). Project Timeline and Milestones: The expected project work duration is 5-10 business days, with following milestones as checkpoints. Milestone #1: Scoping out the available data sources and types. Designing the database structure and model. Milestone #2: Automating data collection from multiple platforms into Big Query. Milestone #3: Developing Looker Studio dashboards for marketing,
sales, support, and customer success teams. Milestone #4: Writing documentation and creating instructional videos (loom) for internal tech teams who will maintain the system after project completion.
Scope of Work Design and implement a database structure suitable for complex data aggregation and analysis. The sources of data includes and is not limited to: Ads Platforms (Google Ads, Meta/Facebook Ads, Tik Tok Ads, etc. )Analytics Platforms (GA4, GTM, Hyros, etc. )Marketing Platforms (Active Campaign, Hubspot, Wistia, etc. )Sales, Support, and Engagement, Fulfillment Platforms (Jotform, Once Hub, Close, Hubspot, Thinkific, Telegram, etc. )Payment & Sales Records (Sense Pass, Elective, Ontraport, Pay Pal, and other merchant accounts)Others (Google Sheets, Slack, etc.
) Develop automated data pipelines to collect and store data efficiently. Available implementations may include ( in order of preference ): Direct platform integration (i. e. Google Ads Big Query)API/webhook integration Zapier integration3rd party integration plugins Create intuitive and insightful visualizations and dashboards in Looker Studio. Some of the necessary KPI dashboards includes and is not limited to: Marketing Dashboard (Displaying KPIs for media buying, with ability to look up per-source performance)Sales Dashboard (Displaying KPIs for sales performance, with ability to dig deeper into the key metrics per sales rep, and filterable by lead-source)Companywide KPIs (Displaying KPIs for the overall company where revenue, expense, and ROAS can be displayed per source) Produce comprehensive documentation and training materials for ongoing maintenance and troubleshooting.
Some of the esential documentations would include: How to add a new data source and bring it into Big Query. Documentation of the database schema that was setup for Big Query. Best practices of how to add new data source in a way that can be used in Looker studio for correlations and calculations.
How to create new metrics to track in Looker Studio. Instructions on updating existing dashboard view to add new metrics. Instructions on building new dashboard with a set of metrics. Troubleshooting practices (SOP) for common/frequent issues that may arise in Big Query Looker Studio tech stack. Maintenance practices (SOP) for continued reliability. Candidate Requirements Expertise in Data Analytics: Proven track record in handling large datasets and performing complex analyses. Proficiency in Big Query and Looker Studio: Extensive experience in using Big Query for data warehousing and Looker Studio for data visualization.
Strong Background in API and Database Structures: Ability to integrate various APIs and understand complex database schemas. Problem-Solving Skills: Capable of identifying and resolving data-related issues effectively. Excellent Communication: Ability to articulate technical concepts clearly to both technical and non-technical stakeholders.
IT jobs refer to positions focused on the creation, maintenance, and support of computer systems and networks in various industries. These roles can include software development, network architecture, system administration, cybersecurity, information systems management, and technical support. Characteristically, IT jobs require a blend of technical skills, problem-solving abilities, and a continuous learning mindset due to the fast-paced nature of technological advancements. They often involve working with complex systems and data, necessitating attention to detail and a methodical approach to work. Additionally, collaboration with other professionals and clear communication are key, as IT roles typically support businesses in achieving strategic goals through technological solutions.
IT jobs refer to positions in the field of Information Technology, a sector dedicated to computing technology, telecommunications, and data management. These jobs typically involve the design, development, implementation, support, and management of computer-based information systems. Key characteristics of IT jobs include a focus on problem-solving, continual learning due to rapidly evolving technologies, and a blend of technical proficiency with soft skills like teamwork and communication. Roles can range from software developers and system analysts to network engineers and cyber security specialists, all contributing to the technological backbone of modern businesses.
IT jobs refer to positions within the Information Technology sector, where professionals focus on computer-based systems. These roles can range from software development, network administration, and cybersecurity to data analysis and IT support. IT jobs often feature continuous learning due to the fast-paced nature of tech advancements. Additionally, they may offer flexibility with options for remote work and have a significant emphasis on problem-solving and innovation. As technology becomes increasingly integral to all industries, IT jobs are in high demand and often offer competitive salaries.
IT jobs refer to positions in the field of Information Technology, a sector dedicated to computing technology, telecommunications, and data management. These jobs typically involve the design, development, implementation, support, and management of computer-based information systems. Key characteristics of IT jobs include a focus on problem-solving, continual learning due to rapidly evolving technologies, and a blend of technical proficiency with soft skills like teamwork and communication. Roles can range from software developers and system analysts to network engineers and cyber security specialists, all contributing to the technological backbone of modern businesses.
