Business Data Modeler

Title: Business Data Modeler Location: Westwood, MA or Johnston, RI (Hybrid/Onsite) Job Summary We are seeking an experienced Business Data Architect / Data Modeler to lead enterprise-wide data architecture and modeling initiatives. The ideal candidate will have strong expertise in designing canonical data models, implementing semantic data mesh architectures, and enabling real-time data streaming solutions. This role will be responsible for establishing scalable data frameworks that support analytics, AI/ML initiatives, data governance, and enterprise integration across cloud platforms. Key Responsibilities • Design and maintain enterprise canonical data models to ensure consistency across business domains and applications. • Develop and implement semantic data mesh architectures to support decentralized data ownership and governance. • Define enterprise data standards, modeling frameworks, and best practices. • Architect and optimize real-time data streaming solutions using Kafka and event-driven architectures. • Design scalable cloud-based data platforms leveraging AWS services and Snowflake. • Collaborate with business stakeholders, data engineers, analytics teams, and application architects to translate business requirements into data solutions. • Establish data governance, metadata management, lineage, and data quality frameworks. • Support AI/ML initiatives by creating reusable, trusted, and governed data assets. • Design and optimize data warehouses, data lakes, and lakehouse architectures. • Develop data integration patterns for batch and real-time processing. • Conduct architecture reviews and provide recommendations for performance, scalability, and security improvements. • Mentor junior data architects, modelers, and engineering teams on enterprise data practices. Required Skills & Qualifications • 8+ years of experience in Data Architecture, Data Modeling, or Enterprise Data Management. • Strong expertise in Canonical Data Modeling and enterprise data architecture principles. • Experience implementing Semantic Data Mesh frameworks and domain-driven data architectures. • Hands-on experience with Apache Kafka and real-time/event-driven data pipelines. • Strong proficiency with AWS services: • S3 • Redshift • Glue • EMR • Lambda • Extensive experience with Snowflake architecture, modeling, and optimization. • Strong programming skills in Python and advanced SQL. • Experience designing enterprise data warehouses, data lakes, and modern data platforms. • Knowledge of data governance, metadata management, data lineage, and data quality practices. • Familiarity with AI/ML data preparation and feature engineering concepts. Preferred Qualifications • Experience with data cataloging and governance tools. • Knowledge of modern data architecture patterns including lakehouse and mesh architectures. • Experience working in regulated industries such as utilities, healthcare, banking, or insurance. • AWS, Snowflake, or Data Architecture certifications are a plus. • Experience supporting enterprise analytics and AI/ML platforms. Key Technologies Data Modeling: Canonical Data Modeling, Semantic Data Mesh Streaming: Kafka Cloud: AWS (S3, Redshift, Glue, EMR, Lambda) Data Platform: Snowflake Programming: Python, SQL Architecture: Data Lake, Data Warehouse, Lakehouse, Enterprise Data Governance Analytics & AI: AI/ML Enablement, Feature Stores, Data Products