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.

The Digital Marketing Data Analyst is responsible for analyzing and interpreting digital marketing data to drive strategic decision-making and enhance marketing outcomes.  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 is full time perminant position. This position is hybrid with a mix of onsite and remote work.

• 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.
• 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.
• 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.
• 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.
• 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.
• 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.
• Ensure compliance with data regulations and privacy standards, particularly around HIPAA and consumer protection regulations, by implementing appropriate data governance practices and security measures.

This is not an all-inclusive list of this job’s responsibilities. The incumbent may be required to perform other related duties and participate in special projects as assigned.

Minimum

• 3+ years of digital marketing analytics experience 
• Proficiency in PowerBI/Looker Studio/Tableau for data visualization and dashboard creation 
• Strong SQL skills, for data querying, manipulation, and extraction 
• Experience with Server-Side Tag Management 
• Proficiency in BigQuery for data storage, management, and analysis 
• Experience in Customer Data Modeling and Integration support for Salesforce Marketing Cloud 
• 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)
• Bachelor's Degree in data analytics, statistics or a related field

Preferred:

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