Digital Marketing Data Analyst

Company Overview

Shriners Children’s is a family that respects, supports, and values each other. We are engaged in providing excellence in patient care, embracing multi-disciplinary education, and research with global impact. We foster a learning environment that values evidenced based practice, experience, innovation, and critical thinking. Our compassion, integrity, accountability, and resilience defines us as leaders in pediatric specialty care for our children and their families.

Job Overview

Shriners Children's is the premier pediatric burn, orthopaedic, spinal cord injury, cleft lip and palate, and pediatric subspecialties medical center.  We have an opportunity for a DigitalMarketing Data Analyst reporting into our Corporate Headquarters location.

Shriners Children’s is looking for a Digital Marketing Data Analyst to join their team! As a Digital Marketing Data Analyst, you will play a pivotal role within our dynamic team. Your primary focus will be analyzing and interpreting digital marketing data to drive strategic decision-making and enhance marketing outcomes. Leveraging your expertise in data analytics and digital marketing systems and processes, you will extract actionable insights from complex datasets. The ideal candidate will have a strong foundation in PowerBI, SQL, and BigQuery, preferably with experience in audience development and integration support for platforms like Salesforce Marketing Cloud, Looker (Enterprise), and PowerBI.

This role presents a unique opportunity to contribute to the progress of digital marketing analytics and a broader data management practice that will interface with other strategic business units. The primary goal is to activate the data to create a positive influence on campaign performance, user experience and ad spend efficiency.

This role is ideal for a data-driven professional looking to make a significant impact on digital marketing performance for a mission driven healthcare organization through advanced data analytics and integration capabilities. If you are passionate about using data to drive marketing success, we would love to hear from you!

This position is hybrid with a mix of onsite and remote work, and is being filled as a temp to perm through a staffing agency.

Responsibilities

Data Management and Analysis:

• Develop and implement data collection processes to ensure accurate and timely capture of marketing performance metrics.
• Manage and analyze data from multiple sources, including Google Analytics, social media platforms, email marketing tools, and advertising platforms.
• Create and maintain dashboards and reports to track key performance indicators (KPIs) and campaign metrics using PowerBI, Looker Studio, or Tableau.
• Perform deep-dive analyses to identify trends, insights, and opportunities for improvement.
• Utilize PowerBI/Looker to create interactive dashboards and reports that provide actionable insights into marketing performance metrics, campaign outcomes, and operational efficiency.
• Conduct exploratory data analysis to identify trends, patterns, and anomalies within marketing datasets.

Campaign Measurement and Reporting:

• Measure and report on the performance of digital marketing campaigns, including paid media, organic search, social media, and email marketing.
• Provide regular reports and insights to marketing leadership and other stakeholders to inform strategic decisions.
• Develop and present comprehensive campaign performance reports, highlighting successes, areas for improvement, and actionable recommendations.

Optimization and Insights:

• Use data to identify opportunities for optimizing marketing campaigns and improving ROI.
• Conduct A/B testing and other experiments to determine the effectiveness of different marketing strategies and tactics.
• Provide data-driven recommendations to enhance targeting, messaging, and overall campaign effectiveness.
• Utilize first-party data to develop and refine audience segments for targeted advertising efforts.
• Collaborate with advertising partners to leverage data insights for improving conversions and ad spend efficiency.

Collaboration and Communication:

• Work closely with the digital marketing team to understand campaign objectives and data needs.
• Collaborate with cross-functional teams, including IT, web development vendors, digital and creative agencies, to ensure data integrity and alignment with marketing goals.
• Communicate complex data insights in a clear and concise manner to non-technical stakeholders.

Data Extraction and Manipulation:

• Write and optimize SQL queries to extract and manipulate data from relational databases, data warehouses, and other data sources, including BigQuery and Azure SQL.
• Perform data cleaning, transformation, and validation to ensure data accuracy and consistency.
• Automate data extraction and transformation processes to streamline analysis workflows and improve efficiency.

Customer Data Integration and Modeling:

• Support customer data modeling and integration efforts with Salesforce Marketing Cloud to ensure seamless data flow and comprehensive customer profiles.
• Leverage Server-Side Tag Management for enhanced data collection and processing.
• Develop and maintain robust data models to support advanced analytics and audience development initiatives.

Governance and Compliance:

• Ensure compliance with data regulations and privacy standards, particularly around HIPAA and consumer protection regulations, by implementing appropriate data governance practices and security measures.

Qualifications

Experience Required:

• 3 or more years of digital marketing analytics experience required
• Proficiency in PowerBI/Looker Studio/Tableau for data visualization and dashboard creation required
• Strong SQL skills, for data querying, manipulation, and extraction required
• Experience with Server-Side Tag Management required
• Proficiency in BigQuery for data storage, management, and analysis required
• Experience in Customer Data Modeling and Integration support for Salesforce Marketing Cloud required

Software Experience:

• Google Analytics and Google Tag Manager
• PowerBI/Looker Studio/Tableau
• SQL and BigQuery
• SEO optimization tools (e.g., BrightEdge, SEMrush)
• CRM platforms (e.g., Salesforce Marketing Cloud)
• Social media analytics tools
• Email marketing platforms (e.g., Mailchimp, Constant Contact)

Experience Preferred:

• Experience with Looker Studio and audience development preferred
• Familiarity with advertising platforms and leveraging first-party data for improving ad performance preferred
• Proficiency in DAX (Data Analysis Expressions) (PowerBI language) preferred 
• Experience developing pipelines and integrations to ingest, automate and export data preferred
• Experience with healthcare data standards and regulations, including HIPAA and HL7, preferred

Education Required:

• Bachelor's Degree in data analytics, statistics or a related field required