Pay
$155K–$227K is typical
The middle half of what similar US postings state. This one doesn’t list pay.
From 3,272 postings in the last year. Stated ranges, not salaries paid.
Listed location: Hybrid or RemoteRead the full posting
Physical and Environmental Requirements: While performing the duties of this Job, the employee is regularly required to talk or hear. The employee is frequently required to stand and sit. The employee is occasionally required to walk and reach with hands and arms. The employee must occasionally lift and/or move up to 50 pounds. Specific vision abilities required by this job include close vision and color vision. Work Environment: This is a full-time remote or Hybrid position, with occasional travel to Bay Cities Container offices or facilities as needed. In this role, you will be instrumental in shaping Bay Cities Container's data landscape, driving innovation, and enhancing operational efficiency through data-driven insights and solutions.Read the full posting
Design and maintain data pipelines from ERP, logistics and workflow systems into Microsoft Fabric
Build Power BI semantic models and DAX measures for P&L, balance sheet and cost reporting
Design and orchestrate AI agent workflows for business process automation
Build margin analysis, vendor spend tracking and cost-per-unit models from ERP cost data
Lead and mentor a small BI/analytics team, spreading work across people
Design and maintain data pipelines from multiple legacy source systems (ERP, logistics, workflow management) through to Microsoft Fabric.
Build and maintain Power BI semantic models deployed to Microsoft Fabric.
Design and orchestrate AI agent workflows for business process automation.
Build margin analysis, vendor spend tracking, and cost-per-unit modeling.
Lead and mentor a small BI/Analytics team.
5+ years SQL Server/T-SQL- complex analytical queries, views, stored procedures, dimensional modeling. This is a daily tool, not an occasional one.
AI/LLM experience- Hands-on with Claude, OpenAI, or similar. Understanding of prompt engineering, agent orchestration, or agentic AI patterns.
Experience in packaging, printing, or discrete manufacturing.
3+ years Power BI/DAX- Semantic model development, DAX measures, evaluation context. Experience deploying models to production environments.
Python- Data transformation, scripting, and automation. Experience with data science libraries (pandas, scikit-learn) is a plus.
From the employer’s posting.
Open 5 monthsWe first saw this posting 173 days ago and it is still up. Roles open this long are often slow to fill or kept open to collect applications.
These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.
$155K–$227K is typical
The middle half of what similar US postings state. This one doesn’t list pay.
From 3,272 postings in the last year. Stated ranges, not salaries paid.
Day 173
Up longer than most. Similar jobs usually come down between day 8 and day 57.
From 9,984 similar postings that came down. Coming down is not always a hire.
2 open jobs
Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.
- Data Warehouse Design- Dimensional modeling, star schemas, ETL/ELT patterns, slowly-changing dimensions. You've built and maintained a production data warehouse. - Python- Data transformation, scripting, and automation. Experience with data science libraries (pandas, scikit-learn) is a plus. - Git Version Control- All code, models, and documentation are version-controlled. Comfortable with collaborative development workflows.
We are hiring an Enterprise Data & AI Architect to own and extend the data intelligence and AI automation platform that drives our business transformation. You will report directly to the CIO and lead a small BI/analytics team (3-4 members). This is a hands-on technical leadership role. You will write SQL, build semantic models, design data pipelines, configure AI-assisted workflows, and deliver measurable business outcomes- not just draw architecture diagrams. You'll inherit a functioning platform with real production workloads and be expected to keep it running while expanding its capabilities. What You'll Do
Data Architecture & Warehousing - 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.
Required - 5+ years SQL Server/T-SQL- complex analytical queries, views, stored procedures, dimensional modeling. This is a daily tool, not an occasional one. - 3+ years Power BI/DAX- Semantic model development, DAX measures, evaluation context. Experience deploying models to production environments.
- 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. Azure Synapse, Databricks, or Snowflake experience translates well. - Data Warehouse Design- Dimensional modeling, star schemas, ETL/ELT patterns, slowly-changing dimensions. You've built and maintained a production data warehouse.
- 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. 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). The specific system is learnable; the domain intuition is not.
- Financial reporting concepts- GL structure, P&L, Balance Sheet, Cost Accounting. You'll partner closely with Finance. - PowerShell- Infrastructure scripting, automation, and diagnostics in a Windows/Azure environment. - Azure AD/Identity Management- Service accounts, credential lifecycle, gateway authentication.
- PowerShell- Infrastructure scripting, automation, and diagnostics in a Windows/Azure environment. - Azure AD/Identity Management- Service accounts, credential lifecycle, gateway authentication. Nice to Have
Business Intelligence & Reporting - Build and maintain Power BI semantic models deployed to Microsoft Fabric. - Develop DAX measure libraries for financial and operational reporting.
- 5+ years SQL Server/T-SQL- complex analytical queries, views, stored procedures, dimensional modeling. This is a daily tool, not an occasional one. - 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. Azure Synapse, Databricks, or Snowflake experience translates well.
What Success Looks Like - First 30 days: Understand the data architecture end-to-end (source systems-data warehouse-Fabric-Power BI)- Take ownership of existing production models and dashboards- Meet with key business stakeholders to understand their priorities- Assess current security Posture. - First 90 Days: Deliver 2-3 projects end-to-end with measurable business impact. Reduce single-person dependencies on critical data paths. Implement proper secrets management and access controls. Ensure all platform assets are under enterprise IT governance.
- 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-of0concepts that sit on a shelf.
Complete your application on recruiting.paylocity.com. The employer’s form will show what is required.
Already applied? Track this application
Description
Bay Cities Container has an exciting opportunity for an Enterprise Data & AI Architect for a remote based position. The ideal candidate will live anywhere in the United States but have the ability to travel to our corporate location as needed. Bay Cities is an Employee Owned (ESOP) corrugated packaging and display manufacturer. We design, manufacture, and deliver custom packaging, point-of-purchase displays, and fulfillment solutions for major national brands. We are in the middle of a CEO sponsored digital transformation- building an enterprise intelligence platform that connect our manufacturing, financial, sales, and operational systems through modern data architecture and AI. This is not a planning exercise. We have a functioning platform with proven results already in production.
The Role
We are hiring an Enterprise Data & AI Architect to own and extend the data intelligence and AI automation platform that drives our business transformation. You will report directly to the CIO and lead a small BI/analytics team (3-4 members).
This is a hands-on technical leadership role. You will write SQL, build semantic models, design data pipelines, configure AI-assisted workflows, and deliver measurable business outcomes- not just draw architecture diagrams. You'll inherit a functioning platform with real production workloads and be expected to keep it running while expanding its capabilities.
What You'll Do
Data Architecture & Warehousing
Business Intelligence & Reporting
AI & Automation
Manufacturing Cost Intelligence
Stakeholder Delivery
Team Leadership
Requirements
Required
Strongly Preferred
Nice to Have
What You Don't Need to Know (We'll Teach You)
What Success Looks Like
What We Offer
Other
New Data Leadership postings at the employers we follow are up 8% over the last 6 weeks compared with the 6 before.
Each bar is one week of new postings. The darkest bars are the last 6 weeks.
Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.
We file this job under Data Leadership, by the work the posting describes.
Data leaders run data teams or design how a company's data fits together. Managers hire, set priorities and answer for whether the data work pays off; architects choose the systems and the shape of the data.
Expect years of hands-on data work, experience leading people or projects, and the ability to explain tradeoffs to executives.
Unlike a senior engineer or analyst, most of a data leader's week goes to people, planning and decisions rather than building.
The government has no code for data leaders, so these figures are for the closest group, computer and information systems managers, which includes data processing and data operations managers.
Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 11-3021.
Selected passages from the saved posting. Check the full description for conditions and exceptions.
No pay amount identified in the saved description.
Hybrid or Remote
Description Bay Cities Container has an exciting opportunity for an Enterprise Data & AI Architect for a remote based position. The ideal candidate will live anywhere in the United States but have the ability to travel to our corporate location as needed. Bay Cities is an Employee Owned (ESOP) corrugated packaging and display manufacturer. We design, manufacture, and deliver custom packaging, point-of-purchase displays, and fulfillment solutions for major national brands. We are in the middle of a CEO sponsored digital transformation- building an enterprise intelligence platform that connect our manufacturing, financial, sales, and operational systems through modern data architecture and AI. This is not a planning exercise. We have a functioning platform with proven results already in production. The Role
- Physical and Environmental Requirements: While performing the duties of this Job, the employee is regularly required to talk or hear. The employee is frequently required to stand and sit. The employee is occasionally required to walk and reach with hands and arms. The employee must occasionally lift and/or move up to 50 pounds. Specific vision abilities required by this job include close vision and color vision. - Work Environment: This is a full-time remote or Hybrid position, with occasional travel to Bay Cities Container offices or facilities as needed. - In this role, you will be instrumental in shaping Bay Cities Container's data landscape, driving innovation, and enhancing operational efficiency through data-driven insights and solutions.
Other - US Persons Only (US citizens, lawful permanent residents, refugee or asylee – all require proper identification and documentation). - Up to 25% travel required.