Senior Data Engineer - Remote Eligible

Senior Data Engineer

Solvd is an AI-first advisory and digital engineering firm delivering measurable business impact through strategic digital transformation. We are seeking a highly skilled and consultative Senior Data Engineer to join our team. A senior specialist to ingest and structure novel advertising data, land it into Snowflake, and prepare it for reporting. You'll play a crucial role in building new advertising business from the ground up, with a focus on data ingestion, analysis, and reporting. This is a unique opportunity to own projects from end-to-end, work with novel data sources, and provide strategic thought leadership in a fast-paced environment.

Responsibilities:

• Data Ingestion & Pipeline Development: Design, build, and maintain robust data pipelines to ingest new advertising data from sources such as Google Ad Manager and others into our Snowflake data lake.
• Data Modeling: Transform raw, often unstructured data into clean, well-structured data marts within Snowflake. You will be responsible for creating a single source of truth that is optimized for reporting and analysis.
• Data Quality Assurance: Implement processes and checks to ensure the accuracy and integrity of our new data sources. You'll identify and resolve data quality issues like duplicates or inconsistencies before the data is used for reporting.
• Technical Guidance & Requirements Gathering: Partner with business stakeholders to understand their data needs and translate them into technical requirements. You'll provide expert advice on data availability and feasibility, helping to shape the strategic direction of our advertising data platform.
• Tooling & Architecture: Contribute to the design and evolution of our data architecture, ensuring our Snowflake instance is structured efficiently and our processes align with best practices. You'll also work closely with our Tableau users to ensure data is optimized for their reporting needs.

Mandatory Requirements:

• Significant experience with data engineering, including ingesting, cleansing, and transforming novel datasets.
• Proficiency in Snowflake for data modeling and warehousing.
• Expertise in Tableau for building dashboards and reporting.
• Strong analytical skills with a proven ability to perform root cause analysis and quality assurance on data.
• Demonstrated experience with requirements gathering and acting as a consultative partner to non-technical stakeholders.
• Familiarity with the ad tech ecosystem, particularly with data from sources like Google Ad Manager.

Optional Requirements:

• Experience working with an advertising or marketing line of business.
• Previous experience in a fast-paced environment where data sources are constantly evolving.
• Excellent communication skills with the ability to explain complex technical concepts to a variety of audiences.

Tech Stack:

• Snowflake for data warehousing.
• Tableau for BI and reporting.
• Google Ad Manager integration is underway; experience with this tool is a plus.
• Existing data lake architecture includes raw, structured, and curated zones.
• Preference for data marts that plug into Tableau's relationship system — not heavily SQL-based dashboards.