What are the responsibilities and job description for the Digital Marketing and Business Intelligence Analyst position at Robbins Recruiting?
Robbins Recruiting has partnered with a leader in the roofing industry who is seeking a highly capable Digital Marketing & Business Intelligence Analyst who can bridge the gap between business intelligence and marketing analytics. As part of a small but dynamic team, you’ll have the opportunity to wear multiple hats, helping us optimize our marketing efforts and overall business performance.
\n- Business Intelligence (BI) Analytics:
- Develop and maintain centralized reporting for key business metrics, such as leads, sales, profitability, and gross margins.
- Extract and analyze data from multiple sources, including CRM systems and financial platforms.
- Collaborate with leadership to provide insights that drive strategic decision-making.
- Centralize and standardize data across all branches to ensure consistency and accuracy in reporting.
- Digital Marketing Analytics:
- Track and analyze performance across all digital marketing channels, including PPC, Local Service Ads, paid social, SEO, and more.
- Generate reports and insights on key marketing metrics such as CPC, CPL, ROAS, ROI, and conversion rates.
- Work closely with the marketing team to optimize campaign performance and marketing spend allocation.
- Data Engineering & ETL:
- Develop a centralized data framework that consolidates reporting from all branches into a single source of truth.
- Pull and aggregate data from various sources (CRMs, Google Analytics, ad platforms) to create comprehensive dashboards and reports.
- Familiarity with databases such as BigQuery, Snowflake, or similar platforms, with an understanding of how to structure and manage data pipelines in a growing data infrastructure.
- Implement ETL processes to ensure data accuracy and accessibility.
- Visualization & Reporting:
- Experience with data visualization tools such as Tableau, Power BI, or similar, with the ability to develop and maintain self-service dashboards that empower stakeholders to access insights independently.
- Create data-driven storytelling to support business and marketing objectives.
- Ensure accuracy and consistency of reporting across multiple business units.
- Data Research & Tool Development:
- Source and analyze third-party data (e.g., census data, real estate trends) to enrich marketing strategies.
- Develop proprietary tools, such as zip code-level scoring models, to optimize market targeting.
- Identify opportunities for automation and process improvement in data workflows.
- 4 years of experience in data analysis, business intelligence, or digital marketing analytics.
- Strong proficiency in Python for data analysis, automation, and ETL processes.
- Experience with SQL and working with databases such as BigQuery, Snowflake, or similar.
- Hands-on experience with digital marketing analytics (Google Analytics, ad platforms, etc.).
- Proficiency in data visualization tools (Tableau preferred; Power BI or similar acceptable).
- Ability to work independently with minimal direction and manage multiple projects simultaneously.
- Strong problem-solving skills with a proactive mindset.
- Excellent communication and storytelling abilities with data.
