Data Architect

We at Andmore are seeking a technically skilled and business-aware Data Architect to lead the development of scalable data infrastructure that powers B2B marketing analytics and decision-making. This role requires deep expertise in  Snowflake and the ability to collaborate with marketing technology teams, front-end developers, and CRM specialists to deliver data solutions that support customer engagement and internal operations.

Key Responsibilities:

• Design and optimize data pipelines and models using DBT and Snowflake, tailored to B2B marketing use cases.
• Design and implement logical and physical data models (e.g., dimensional modeling) to represent analytics use-cases.
• Lead technical discussions with front-end developers (e.g., Power BI specialists), marketing analysts, and CRM engineers to ensure data structures support reporting and analytics needs.
• Collaborate with marketing operations and CRM teams (Microsoft Dynamics) to integrate and harmonize data across platforms, enabling unified customer views and actionable insights.
• Translate functional marketing requirements into technical specifications by asking targeted questions and proposing scalable data architecture solutions.
• Implement data governance and metadata management using tools like Snowflake or Microsoft Purview, ensuring compliance and transparency.
• Support self-service analytics and dashboarding through Power BI, enabling marketing teams to explore campaign performance and audience behavior.
• Monitor and troubleshoot data workflows, ensuring high availability, data quality, and performance across marketing data assets.
• Contribute to the evolution of the marketing data stack, including experimentation with new tools and architecture patterns.

Required Qualifications:

• Bachelor's degree in Computer Science, Engineering, Information Systems, or a related field.
• 7+ years of experience in data engineering, with a strong focus on cloud-based data platforms and data modeling.
• Proven expertise in Snowflake.
• Strong SQL skills and experience with dimensional modeling for marketing and activity data.
• Experience working with marketing data sources such as CRM, web analytics, and campaign management platforms.
• Excellent communication skills, with a focus on technical collaboration across teams.
• Ability to design and implement scalable data architecture solutions.

Recommended Skills & Tools:

• Familiarity with Snowflake or Microsoft Purview for data governance and cataloging.
• Experience integrating data from Microsoft Dynamics and other B2B Marketing platforms.
• Experience with DBT for data transformations
• Working knowledge of Power BI for dashboarding and reporting.
• Understanding of data privacy, compliance (e.g., GDPR), and security best practices.
• Strategic thinker with a proactive approach to problem-solving.
• Strong interpersonal and technical collaboration skills.
• Passion for continuous learning and staying current with data engineering trends.