Enterprise Data Architect
Job Description: • Work directly with the VP of Data Engineering to help develop enterprise data strategy in collaboration with our business and technology partners • Lead the architecture of enterprise data solutions, including data platforms, data modeling, integrations, and data DevOps • Develop and maintain comprehensive data models that support business processes and analytics • Implement best practices for data governance, data quality, and data security across the organization • Ensure the alignment of data architecture with business goals and IT strategies • Design and implement a medallion architecture in Snowflake (Bronze, Silver, Gold layers) • Analyze raw data ingested into the Bronze layer, transform and cleanse it into the Silver layer, and consolidate it into a Gold layer as a single source of truth for enterprise analytics • Collaborate with business and technical stakeholders to understand data across various systems, including ERPs, CRMs, transactional databases, and architect a medallion architecture in Snowflake • Ensure data is appropriately cleansed, manipulated, enhanced, and transformed for analytical consumption • Use tools like dbt to manage transformations and model dependencies across layers • Develop and maintain architecture diagrams, data flow documentation, and implementation plans • Provide guidance on data governance, quality, and security standards • Design and oversee the architecture of our data engineering platform, ensuring scalability, reliability, security, and performance • Provide architectural guidance for data engineering teams utilizing tools such as Apache Airflow, Snowflake, dbt, OpenFlow, Zapier, Postgres, SQL Server, and Tableau • Collaborate with internal business partners to identify solutions and document functional requirements for new processes and existing issues • Work directly with teams responsible for shaping how we acquire, collect and leverage data • Collaborate with cross-functional teams, including IT, business analysts, and product managers, to understand data requirements and deliver effective solutions • Stay current with industry trends and emerging technologies to continuously improve data architecture practices Requirements: • Proven experience as a Data Architect with a focus on Snowflake • Strong proficiency in SQL • Deep understanding of data warehousing concepts, dimensional and relational modeling, and ETL/ELT pipelines • Experience working with ERP, CRM, and other transactional systems • Excellent communication and collaboration skills with both technical and non-technical stakeholders • Ability to create clear and effective architecture diagrams and project plans • Familiarity with data governance, metadata management, and data quality frameworks • Experience working with Master Data Management tools Benefits: • nationwide coverage for Medical, Dental, Vision, Life, and Disability insurance • additional Voluntary Benefits • 401(k) Retirement Savings Plan • Health Savings Accounts (HSA) • Flexible Spending Accounts (FSA) Apply tot his job