Marketing Intelligence Analyst
Description:
• Collaborate with the Business Systems architect and business stakeholders to understand business problems and user requirements.
• Design and develop insightful reports, dashboards, and data analysis projects that inform business decisions.
• Produce creative analytic dashboards and visualizations that generate actionable insights and business impact.
• Build, maintain, and optimize the SQL data warehouse and validate data against HubSpot and Salesforce.
• Participate in gathering business requirements, documenting technical specifications, prototyping, testing, and implementing reports and dashboards.
• Manage daily, weekly, and monthly data refreshes and ongoing data maintenance.
• Perform Tableau administrative duties and support dashboard publishing and customization.
• Provide training and assistance to other Tableau users as needed.
• Work with marketing, sales, and customer success teams to automate performance metrics.
• Analyze data problems and improve related business processes in a rapidly evolving technical environment.
Requirements:
• 4+ years of experience building or modifying stored procedures in T-SQL to troubleshoot dashboard issues.
• Experience writing complex SQL queries.
• Experience with modern data warehousing techniques, including dimensional modeling and ETL processes.
• Must have experience working with and reporting on Salesforce and HubSpot CRM data.
• Expert knowledge of Excel, including advanced formulas and pivot tables.
• 2+ years of experience building, customizing, and publishing Tableau visualizations and dashboards.
• Advanced understanding of data visualization practices and methods.
• Exceptional communication skills with the ability to explain technical requirements to non-technical users.
• Ability to multi-task and prioritize according to project timelines.
• Bachelor’s degree in a related field from an accredited institution.
• Proactive, independent, and adaptable to evolving priorities.
• Experience with Python (preferred).
Benefits:
• Base salary range of $78,000 to $100,000.
• Health, dental, and vision insurance.
• Paid time off.
• 401(k) with company match.
• Eligibility for additional compensation such as bonuses.
• Eligibility for equity, as applicable.
Apply tot his job
Apply To this Job
• Collaborate with the Business Systems architect and business stakeholders to understand business problems and user requirements.
• Design and develop insightful reports, dashboards, and data analysis projects that inform business decisions.
• Produce creative analytic dashboards and visualizations that generate actionable insights and business impact.
• Build, maintain, and optimize the SQL data warehouse and validate data against HubSpot and Salesforce.
• Participate in gathering business requirements, documenting technical specifications, prototyping, testing, and implementing reports and dashboards.
• Manage daily, weekly, and monthly data refreshes and ongoing data maintenance.
• Perform Tableau administrative duties and support dashboard publishing and customization.
• Provide training and assistance to other Tableau users as needed.
• Work with marketing, sales, and customer success teams to automate performance metrics.
• Analyze data problems and improve related business processes in a rapidly evolving technical environment.
Requirements:
• 4+ years of experience building or modifying stored procedures in T-SQL to troubleshoot dashboard issues.
• Experience writing complex SQL queries.
• Experience with modern data warehousing techniques, including dimensional modeling and ETL processes.
• Must have experience working with and reporting on Salesforce and HubSpot CRM data.
• Expert knowledge of Excel, including advanced formulas and pivot tables.
• 2+ years of experience building, customizing, and publishing Tableau visualizations and dashboards.
• Advanced understanding of data visualization practices and methods.
• Exceptional communication skills with the ability to explain technical requirements to non-technical users.
• Ability to multi-task and prioritize according to project timelines.
• Bachelor’s degree in a related field from an accredited institution.
• Proactive, independent, and adaptable to evolving priorities.
• Experience with Python (preferred).
Benefits:
• Base salary range of $78,000 to $100,000.
• Health, dental, and vision insurance.
• Paid time off.
• 401(k) with company match.
• Eligibility for additional compensation such as bonuses.
• Eligibility for equity, as applicable.
Apply tot his job
Apply To this Job