Apply on Employer Site

PracticeTek · 7 hours ago

Marketing Intelligence Analyst

San Diego, CA

Full-time

Hybrid

Mid, Senior Level

$100K/yr - $120K/yr

4+ years exp

PracticeTek is a leading provider of retail healthcare technology solutions, committed to revolutionizing healthcare practices. The Marketing Intelligence Analyst will collaborate with various teams to design and develop insightful reports and dashboards that drive meaningful business decisions.

Health Care

Responsibilities

Collaborate with the Business Systems architect and business stakeholders to understand business problems and user requirements

Produce creative analytic dashboards and visualizations to develop actionable insights and business impact

Build, maintain, and optimize our SQL data warehouse and validate against HubSpot and SFDC

Actively participate in all aspects of report and dashboard development including the gathering of business requirements, documenting technical specifications, prototyping, testing, and implementation

Manage daily/weekly/monthly data refreshes, data maintenance, and Tableau administrative duties

Provide training and assistance as needed to other Tableau users

Qualification

SQLTableauSalesforceHubSpotData warehousingData visualizationMulti-taskingProactivePythonCommunication skills

Required

4+ years of experience building/modifying stored procedures (T-SQL) in order to troubleshoot issues with dashboards and able to write complex SQL queries

Experience in modern data warehousing techniques (dimensional modeling, ETL processes, etc.)

Must have experience working with and reporting on Salesforce and HubSpot CRM data

Expert knowledge of Excel with the ability to use 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 and the ability to convey 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 able to adapt to evolving priorities