Enterprise Data & AI Architect

Bay Cities Container • Pico Rivera, CA

2d • Hybrid

About The Position

Bay Cities, an Employee-Owned Company, is a leading creative packaging and display partner to brand marketers, retailers and e-commerce. They are seeking an Enterprise Data & AI Architect for a remote-based position, with the ideal candidate living anywhere in the United States but able to travel to the corporate location in Southern California as needed. Bay Cities is an Employee Owned (ESOP) corrugated packaging and display manufacturer, currently undergoing a CEO-sponsored digital transformation to build an enterprise intelligence platform. This platform connects manufacturing, financial, sales, and operational systems through modern data architecture and AI, with a functioning platform and proven results already in production. The role involves owning and extending this data intelligence and AI automation platform, reporting directly to the CIO and leading a small BI/analytics team (3-4 members). This is a hands-on technical leadership role requiring the candidate to write SQL, build semantic models, design data pipelines, configure AI-assisted workflows, and deliver measurable business outcomes, while maintaining and expanding existing production workloads.

Requirements

• 5+ years SQL Server/T-SQL- complex analytical queries, views, stored procedures, dimensional modeling.
• 3+ years Power BI/DAX- Semantic model development, DAX measures, evaluation context.
• Experience deploying models to production environments.
• Microsoft Fabric or equivalent cloud analytics platform- Data warehouse, pipelines, semantic models, workspace governance.
• Data Warehouse Design- Dimensional modeling, star schemas, ETL/ELT patterns, slowly-changing dimensions.
• Experience building and maintaining a production data warehouse.
• Python- Data transformation, scripting, and automation.
• Git Version Control- All code, models, and documentation are version-controlled.
• Comfortable with collaborative development workflows.
• API Integration- Rest APIs, authentication flows, webhook patterns.
• AI/LLM experience- Hands-on with Claude, OpenAI, or similar.
• Understanding of prompt engineering, agent orchestration, or agentic AI patterns.
• Workflow Automation Platforms- n8n, Azure Logic Apps, Power Automate, Zapier, or Make.
• Experience building automated data flows and business process automation.
• Manufacturing or industrial ERP systems- Any background with ERP platforms in a manufacturing context (SSAP, Oracle, Infor, Epicor, Amtech or similar).
• Financial reporting concepts- GL structure, P&L, Balance Sheet, Cost Accounting.
• PowerShell- Infrastructure scripting, automation, and diagnostics in a Windows/Azure environment.
• Azure AD/Identity Management- Service accounts, credential lifecycle, gateway authentication.

Nice To Haves

• Experience in packaging, printing, or discrete manufacturing.
• Change Management Awareness- understanding how technology adoption affects people.
• Vector database experience (Chroma, Pinecone, Weaviate).
• Data Vault 2.0 methodology.

Responsibilities

• Own and extend a SQL Server analytics data warehouse with dimensional modeling (star schema, conformed dimensions, fact/dimension tables).
• Design and maintain data pipelines from multiple legacy source systems (ERP, logistics, workflow management) through to Microsoft Fabric.
• Handle complex temporal data challenges- reconciling multiple systems with incompatible time grains.
• Maintain schema governance, documentation, and data lineage.
• Build and maintain Power BI semantic models deployed to Microsoft Fabric.
• Develop DAX measure libraries for financial and operational reporting.
• Deliver executive dashboards- P&L, Balance Sheet, Flash Reports, cost analysis, operational metrics.
• Ensure data quality through validation and reconciliation between source systems and reporting layers.
• Design and orchestrate AI agent workflows for business process automation.
• Build workflow automations for data pipelines, alerting, and system integration.
• Implement agent-assisted analytics- where AI investigates, subject matter experts validate, and the system learns.
• Manage prompt engineering, AI governance, and safety boundaries for production AI systems.
• Work with legacy ERP cost models (Activity-Based Costing, BOM structures, GL interaction).
• Build margin analysis, vendor spend tracking, and cost-per-unit modeling.
• Reconcile estimated costs against actuals across multiple systems.
• Translate business needs from executives (CFO, CRO, COO) into data products.
• Manage a portfolio of concurrent analytics projects from intake through delivery.
• Deliver iteratively- prove value in days, not months.
• Lead and mentor a small BI/Analytics team.
• Distribute work to eliminate single-person bottlenecks and knowledge concentration.
• Build team capability so institutional knowledge compounds across people, not in one person.
• Ensure IT governance: proper secrets management, access controls, and security practices.

Benefits

• ESOP Ownership- You become an employee-owner. Your work builds your equity.
• Direct Impact- Small team, big mandate, CEO-sponsored transformation with proven results.
• Modern Stack- Microsoft Fabric, Power BI, AI Agents, Git-based development.
• Autonomy- Build real systems that deliver real business outcomes, not proof-of0-concepts that sit on a shelf.
• Growth- This role expands as the platform expands. You'll shape what it becomes.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed