What are the responsibilities and job description for the Data Architect / Eng. position at ANDMORE®?
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:
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.
- 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.
- 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.