Enterprise Data Architect Lead
Are you a hands-on data leader who excels at designing robust data platforms and building high-value analytics to drive informed business decisions?
This pivotal role involves transforming data from various sources into trusted insights, leading the development of a modern cloud-based data warehouse, and championing data-driven decision-making across the organization.
The Opportunity:
* Design and implement a scalable cloud-based data warehouse and modern data platform.
* Integrate data from diverse systems, including NetSuite, Arena PLM, Phocas, and other platforms.
* Build and maintain robust ETL/ELT pipelines for timely and trusted datasets.
* Develop dimensional/star-schema models and high-quality SQL transformation logic.
* Deliver Power BI and Phocas reporting across Finance, Operations, Sales, and Supply Chain.
* Create and govern semantic models and shared datasets for consistent KPIs and metrics.
* Lead data quality improvements and collaborate with system owners to resolve root-cause issues.
* Partner with senior stakeholders to translate business problems into clear insights.
* Coach business users to safely adopt curated datasets and self-service analytics.
* Develop a 1–2 year data and reporting roadmap to drive continuous improvement and modernization.
About You:
You'll thrive in this role if you're a proactive, pragmatic data specialist with a passion for building reliable, scalable analytical foundations. You bring:
Experience & Technical Expertise:
* 10+ years in data engineering, BI, analytics, or similar roles.
* Proven experience designing and owning cloud-based data warehouses.
* Strong SQL and hands-on experience with tools such as Azure, Snowflake, Redshift, Fabric, dbt, Matillion, Data Factory, or similar.
* Power BI expertise (DAX, data modeling, RLS, optimization).
* Background working with ERP or transactional systems (NetSuite highly advantageous).
* Data modeling capability (dimensional/star schema).
* Scripting experience (Python desirable).
* Familiarity with Phocas or readiness to learn quickly.
Business Partnership & Delivery:
* Strong ability to run requirements workshops and influence stakeholders—including senior leaders.
* Experience simplifying reporting environments and resolving conflicting data.
* Ability to prioritize effectively and deliver high-quality outcomes under constraints.
* Comfortable working in evolving environments where not everything is predefined.
Mindset:
* Hands-on, roll-your-sleeves-up approach.
* Ownership mentality—accountable for outcomes, not just tasks.
* Curious, practical, and iterative.
* Comfortable being the primary data point of contact in a mid-sized organization.
Qualifications:
* Degree in Computer Science, Information Systems, Data/Analytics, Engineering, or equivalent experience.
* Certifications in Azure, AWS, Snowflake, or Power BI are advantageous.
* Experience in manufacturing, supply chain, or distribution is highly regarded.