Job Title: CRM Analytics Analyst (Digital Marketing Data Infrastructure)
Role Overview
We are seeking an analytical and driven CRM Analytics Analyst to play a pivotal role in building, scaling, and maintaining our internal digital marketing data infrastructure. In this role, you will be integral in managing data procedures, schemas, documentation, and pipelines to ensure all marketing performance reporting is timely, reliable, and actionable.
This is a hands-on technical role split between maintaining core data architectures (40%) and engineering new pipelines, custom dimensions, and calculated metrics (60%). You will serve as a thought leader in marketing data operations, continuously optimizing data flows across enterprise data warehouses and advertising platforms. If you have a strong background in data engineering and warehouse architecture, we want to hear from you.
Key Responsibilities
Data Infrastructure & Pipeline Management (40%)
• Maintenance & Reliability: Oversee and maintain current marketing data pipelines, stored procedures, schemas, and technical documentation to ensure zero-downtime reporting.
• Warehouse Administration: Manage data warehouse environments, scheduling procedures, and data governance frameworks to maintain high data integrity.
New Infrastructure & Metric Development (60%)
• Custom Architecture: Architect and develop new data infrastructure, custom dimensions, and calculated metrics to support complex marketing attribution and campaign analysis.
• ETL & Integration: Design and implement automated data ingestion pipelines connecting digital advertising platforms (such as Google Ads, Meta Ads, Microsoft Ads, and Google Analytics) directly to enterprise data repositories.
Qualifications & Requirements
Minimum Qualifications
• Education: Bachelor's Degree in a quantitative field (e.g., Computer Science, Statistics, Economics, Data Science) or equivalent experience.
• Experience Baseline: Professional experience in data engineering, data architecture, and CRM analytics within a large warehouse environment.
• Technical Mastery:
oAdvanced knowledge and practical proficiency in SQL for complex data transformation and querying.
oWorking knowledge of Python for scripting and data automation tasks.
oSignificant hands-on experience with modern cloud data warehouses such as Snowflake or BigQuery.
• Core Competencies: Familiarity with setting up scheduled procedures, managing data pipelines, and integrating marketing data sources (Google Analytics, Meta Ads, Google Ads, Microsoft Ads). Strong PC skills including MS Office.
Preferred Attributes
• Proven track record as a thought leader in digital marketing analytics infrastructure optimization.
• Strong problem-solving skills with the ability to translate marketing performance questions into robust data architecture solutions.
Equal Opportunity Employer / Disabled / Protected Veterans
The Know Your Rights poster is available here:
https://www.eeoc.gov/sites/default/files/2023-06/22-088_EEOC_KnowYourRights6.12.pdf
The pay transparency policy is available here:
https://www.dol.gov/sites/dolgov/files/ofccp/pdf/pay-transp_%20English_formattedESQA508c.pdf
For temporary assignments lasting 13 weeks or longer, AllSTEM Connections is pleased to offer major medical, dental, vision, 401k and any statutory sick pay where required.
We are committed to working with and providing reasonable accommodations to individuals with disabilities. If you need a reasonable accommodation for any part of the employment process, please contact your staffing representative who will reach out to our HR team.
AllSTEM Connections participates in the E-Verify program in certain locations as required by law. Learn more about the E-Verify program.
https://e-verify.uscis.gov/web/media/resourcesContents/E-Verify_Participation_Poster_ES.pdf
We also consider for employment qualified applicants regardless of criminal histories, consistent with legal requirements, including, if applicable, the City of Los Angeles' Fair Chance Initiative for Hiring Ordinance. Pursuant to applicable state and municipal Fair Chance Laws and Ordinances, we will consider for employment-qualified applicants with arrest and conviction records, including, if applicable, the San Francisco Fair Chance Ordinance. For Los Angeles, CA applicants: Qualified applications with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act.
Additional Skills
(none specified)
AllSTEM Representative Contact Info
Account Executive:
Nichols
Branch Phone:
(909) 244-1777
Location:
Ontario, CA