Sr. Data Engineer, Marketing Analytics

Role Summary

As a Senior Data Engineer, Marketing Analytics, you will play an integral role in building Crowd Street’s new data platform from zero to one.  You will have the opportunity to influence the architecture of our new data platform and be responsible for the full lifecycle of software development, including design, implementation, testing, documentation, operation, and ongoing support. In this role, you will interact directly with teams across Crowd Street’s business to translate ambiguous data needs into actionable initiatives with particular emphasis on supporting Marketing with timely data collection and aggregation across various sources, as well as the creation of actionable reporting on key Marketing performance indicators.

The Success You’ll Build

• Unlock business-critical reporting through the ingestion of disparate data sources into our centralized data platform, including Marketing data from Google Ads, Google Analytics, Google Tag Manager, LinkedIn, Meta and other sources
• Reveal key insights through proper data modeling, aggregation and analysis in our data warehouse to enable reporting on ad campaign performance, attribution and user journey analysis
• Own and maintain data pipelines that support the essential day-to-day operation of Crowd Street’s business
• Collaborate with Application Engineering, Product Management, Marketing and other teams to identify and deliver the highest impact enhancements in a timely manner
• Monitor and manage the overall effectiveness of the data platform to balance performance, stability, and cost

 

The Experiences and Competencies Necessary for Success

• 5+ years of experience working hands-on in Microsoft’s Azure data stack including:

Azure Data Factory

• Experience building ETL pipelines from scratch
• Experience independently troubleshooting and resolving issues

Azure Synapse Analytics

• Experience building and maintaining data warehouses
• Experience writing Python (or similar) code in Synapse or Databricks Notebooks

• 3+ years of experience working hands-on with Google’s Marketing Analytics platform including:

Google Ads

• Experience automating data export via API
• Experience building campaign performance reports summarized by channel & creative

Google AnalyticsExperience automating data export via API

• Experience defining and measuring custom events

Google Tag ManagerExperience creating events and implementing triggers

• Experience debugging tag events on live sites

• Experience creating data models and authoring reports in Power BI
• Experience working in a dynamic startup environment
• Comfortable decomposing large, ambiguous projects into actionable tasks
• Experience designing and implementing data platforms using industry best practices
• Experience interacting directly with Marketing stakeholders to identify requirements and translate objectives into data solutions
• Experience collaborating as part of a team with fellow Data Engineers and Product Managers while executing agile practices like code reviews, pair programming, and demos

Preferred Qualifications

• Experience migrating Azure Data Factory & Synapse Analytics to Microsoft Fabric
• Knowledge of various Marketing attribution methodologies (first, last & multi-touch)
• Understanding of key Marketing metrics (CAC, CPC, CPM, etc.)

 

Compensation & Benefits Statement

The estimated salary range for this position is $140,000 - $160,000 per year. Internal level, title, and compensation for the final offer will be determined based on a variety of factors, including years of experience, skills, qualifications, and overall fit for the role. 

In addition to base salary, we offer a comprehensive benefits package, which includes:

• Stock option equity to share in the company’s success
• Variable pay opportunities based on performance
• 401(k) plan with corporate match to support long-term financial well-being
• Flexible time off to support work-life balance
• Home office stipend to help create a productive remote workspace
• Comprehensive health benefits