We are seeking a Lead Solution/Data Architect with deep expertise in Snowflake and strong AWS cloud exposure to lead the design of a modern data platform for a leading US-based marketing agency serving nonprofit clients. This role blends technical leadership with strategic marketing insights, requiring someone who can both execute and guide a team through data-driven campaign design and segmentation. The ideal candidate will have experience in Medallion architecture (bronze, silver, gold layers) and will be adept at translating business requirements into scalable technical solutions. This role requires hands-on experience with data architecture, ingestion pipelines, medallion-layer modeling, CDP integration specifically with Hightouch, and analytics using Snowflake, dbt, and Power BI. You will collaborate with cross-functional teams to ensure the platforms performance, security, governance readiness, and long-term scalability in a cloud environment. Youll lead automation efforts for CI/CD pipelines, troubleshoot complex data issues, and contribute to governance policies around schema evolution, metadata tagging, PII handling, and access control.
We are a company committed to creating inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity employer that believes everyone matters. Qualified candidates will receive consideration for employment opportunities without regard to race, religion, sex, age, marital status, national origin, sexual orientation, citizenship status, disability, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to
Human Resources Request Form. The EEOC "Know Your Rights" Poster is available
here.
To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy:
https://insightglobal.com/workforce-privacy-policy/ .
10+ years of experience in data architecture, data engineering, or enterprise data
platform development
3+ years of hands-on experience with Snowflake, including design of secure,
high-performance, multitenant environments
Proven expertise in modern data stack technologies, including dbt, SQL, CI/CD for
data, and cloud platforms (Azure, AWS, or GCP)
Demonstrated ability to lead data platform projects end-to-end from ingestion
through transformation to BI and CDP activation
Strong experience designing and implementing medallion architectures (Bronze/Silver/Gold) and unified data models (UDMs)
Excellent problem-solving skills and ability to troubleshoot complex data pipeline or platform issues
Strong communication and stakeholder management skills, with experience working across business, technical, and vendor teams
Previously worked at a Marketing company
Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.