Title: Analytics Engineer – Marketing Data Warehouse
Location: Remote
Duration: 6 Months Contract (possibility of extension)
 
Notes
Are there any technical tools/applications you would like the candidates to be proficient with.

• Strong SQL/Snowflake is a must, PowerBI experience nice to have, Scripting/coding is nice to have, Github is nice to have, Claude proficiency is nice to have.

 
What are the 3 "must haves" on the resume?

• SQL, building/maintaining data warehouse experience, data modeling

 
Description:
The Analytics Engineer will design, build, and maintain scalable data pipelines and models that power marketing analytics and reporting. This role bridges data engineering and analytics, ensuring marketing teams have reliable, well-structured data to drive strategic decisions, optimize campaigns, and integrate marketing technology tools.
 
Responsibilities

• Data Strategy & Architecture

• Develop and maintain a unified marketing data warehouse (e.g., Snowflake, BigQuery) to ensure reliability, performance, and accessibility.
• Define and implement best practices for data ingestion, transformation, and governance.
• Align KPIs and metrics to marketing and business objectives for consistent reporting across tools and dashboards.

 

• Marketing Tool Integration

• Integrate data from MarTech platforms (e.g., Marketo, Salesforce, Adobe) into centralized data systems.
• Work with engineering to build automated pipelines using tools like Fivetran, dbt, and Git for version control and deployment.
• Ensure data consistency and completeness across marketing systems and analytics platforms.

 

• Analytics Enablement

• Collaborate with marketing, sales, and finance teams to deliver actionable insights through dashboards and reports.
• Support advanced analytics use cases such as attribution modeling, campaign performance analysis, and customer segmentation.
• Implement continuous improvement practices for marketing data processes and reporting.

 

• Data Quality & Governance

• Establish and enforce data quality standards (accuracy, timeliness, consistency).
• Maintain documentation for data definitions, taxonomies, and standardized KPIs across analytics tools.

 
Must haves

• Strong SQL and experience with data modeling frameworks.
• Minimum years of experience: 1-2
• Proficiency in cloud data warehouses (Snowflake, BigQuery).
• Familiarity with marketing analytics tools (Marketo, Salesforce, Google Analytics, Power BI).
• Knowledge of version control (Git).
• Understanding of marketing metrics (ROI, CLV, attribution, funnel analysis).

 
Preferred Qualifications

• Experience in marketing analytics or supporting marketing operations.
• Ability to translate complex data concepts into actionable insights for non-technical stakeholders.
• Familiarity with predictive and prescriptive analytics techniques for marketing optimization.

 
 
At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws. This position’s starting pay is: $ 35.00/hr.