Analytics Architect / Project Lead
Brazil / Argentina / Colombia
Cloud Solutions – Data Platform /
Full-time /
Remote
Solvd is an AI-first advisory and digital engineering firm delivering measurable business impact through strategic digital transformation. Taking an AI-first approach, we bridge the critical gap between experimentation and real ROI, weaving artificial intelligence into everything we do and helping clients at all stages accelerate AI integration into each process layer. Our mission is to empower passionate people to thrive in the era of AI while maintaining rigorous ethical AI standards. We’re supported by a global team with offices in the USA, Poland, Ukraine and Georgia.
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.
