Analytics Architect / Project Lead

Solvd Inc. is a rapidly growing AI-native consulting and technology services firm delivering enterprise transformation across cloud, data, software engineering, and artificial intelligence. We work with industry-leading organizations to design, build, and operationalize technology solutions that drive measurable business outcomes.

Following the acquisition of Tooploox, a premier AI and product development company, Solvd now offers true end-to-end delivery—from strategic advisory and solution design to custom AI development and enterprise-scale implementation. Our capability centers combine deep technical expertise, proven delivery methodologies, and sector-specific knowledge to address complex business challenges quickly and effectively.

We are seeking a highly skilled and consultative Analytics Architect to join our team. A senior leader to own data quality, guide ambiguous workstreams, and break big-picture goals into executable chunks.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 Engineering: Ingest, assess, and cleanse novel advertising data from sources like Google Ad Manager and others, landing it in our Snowflake instance. You'll be instrumental in establishing a single source of truth for our advertising performance data.

• Data Modeling & Reporting: Build well-constructed data marts in our curated Snowflake zone that can be used for reporting. You will create and maintain dashboards in Tableau, leveraging its natural relationship system to provide clear, actionable insights.

• Analysis & Quality Assurance: Conduct deep analysis and QA on new datasets, identifying data quality issues like duplicates or nonsensical user journeys. You'll work closely with business partners to guide them on what events or data points are most valuable.

• Business & Requirements Gathering: Act as a business advisor, translating high-level business goals into concrete technical requirements. You'll need to bridge the gap between our team's vision and the current state of our data, offering recommendations and helping to set realistic expectations.

• Insights & Content Generation: Perform analyses on our unique datasets to generate compelling insights and content for our advertising, partnerships, marketing, and PR teams. You'll need to be proactive in identifying trends and new opportunities for analysis, such as mapping private label brands to retailers.

• Thought Leadership: You'll be expected to provide guidance and best practices, particularly regarding working with new data sources and navigating the nuances of advertising data. We need a candidate who can "read between the lines" and help define the path forward.

• As a Project Lead you’ll be expected ensure alignment and communication across contributors.

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.

When you join Solvd, you'll…

• Shape real-world AI-driven projects across key industries, working with clients from startup innovation to enterprise transformation.

• Be part of a global team with equal opportunities for collaboration across continents and cultures.

• Thrive in an inclusive environment that prioritizes continuous learning, innovation, and ethical AI standards.

Ready to make an impact?

If you're excited to build things that matter, champion responsible AI, and grow with some of the industry’s sharpest minds. Apply today and let’s innovate together.