Overview

We are seeking a contract-based Dashboard Developer & Business Intelligence Consultant to design and develop dashboards and reports for our internal sales and marketing teams. The ideal candidate will possess advanced proficiency in data visualization and business intelligence tools. Additionally, the candidate should have expertise in architecting and implementing scalable, high-performance data warehouse solutions optimized for cost-efficiency and rapid query execution using SQL. Proficiency in data modeling techniques, including schema design (e.g., star and snowflake schemas), data deduplication, cleansing, and transformation processes, is essential to ensure data integrity and quality.

Requirements

• Design and develop dashboards and reports for sales and marketing teams, providing visibility into KPIs, channel performance, and marketing asset effectiveness.
• Translate business requirements from sales and marketing stakeholders into technical specifications and deliver completed dashboards or reports.
• Architect, implement, and manage scalable data warehouse solutions, optimizing for cost efficiency and rapid query execution.
• Build and maintain ETL/data pipelines to extract, transform, and load data from multiple sources, including ad networks (Facebook/Meta Ads API, Google Ads API), CRMs (HubSpot, Salesforce), and third-party APIs.
• Apply advanced data modeling techniques (including schema design such as star and snowflake schemas) to support efficient reporting and analysis.
• Write and optimize SQL queries for high performance and cost-effectiveness in large-scale data environments.
• Implement data management best practices including cleansing, deduplication, validation, and governance to ensure data integrity and quality.
• Ensure all dashboards and reports are delivered quickly, accurately, and meet agreed deadlines.
• Maintain documentation for dashboard logic, data models, and data processing workflows.
  
  

Requirements

• Expertise in data visualization and business intelligence tools (e.g., Tableau, Power BI, Looker, or equivalent).
• Experience designing and building data warehouses, preferably using cloud platforms like Snowflake or Google Cloud.
• Demonstrated experience integrating data from multiple APIs and sources.
• Strong proficiency in SQL with a focus on writing optimized queries for performance and cost-efficiency.
• Experience in data modeling techniques to create unified data views from multiple data sources.
• Experience developing complex BI dashboards visualizing key business metrics and funnels.
• Understanding of data deduplication strategies and data validation best practices.
• Ability to work independently, manage project timelines effectively, and deliver high-quality dashboards quickly.
• Experience implementing tracking for metrics like LTV, pipeline conversion rates, and marketing attribution.
• Familiarity with UTM parameters and various marketing attribution models.
  
  

Bonus, But Not Required

Direct Experience Implementing:

• Multi-Touch Attribution Modeling & Reporting
• Predictive Churn Analysis & Reporting
• Building Projection and/or Forecasting Models
• Correlating Conversation Intelligence Data (e.g., linking call insights from Gong.io to lead source, contact traits, or customer behaviors)
• Advanced AI Integrations for Additional Insights
• Using Python or R for Advanced Data Analysis
  
  

Important: For your application to be considered, please ensure you provide a portfolio or examples of previous dashboards or reports you've built during the application process.

Please apply directly—reaching out to the hiring manager or other Crisp team members won't improve or fast track your application.