Technical Solutions Architect

We are seeking a hands-on Technical Solutions Architect to guide the design and delivery of an enterprise costing and profitability platform. The solution will combine manufacturing and financial data from multiple ERP systems and facilities to provide a more accurate view of product costs and profitability. The core costing logic has already been developed primarily in SQL. This architect will evaluate the current approach, recommend the right future-state architecture, and help guide the solution through implementation. The role will also provide direction around data pipelines, integrations, modeling, and the Power BI user experience. This is not a purely strategic architecture role. The ideal candidate can provide technical guidance while remaining involved in design decisions, problem-solving, and implementation., * Evaluate the existing SQL-based costing model, data structure, pipelines, and Power BI approach.

• Recommend a practical and scalable architecture based on the work already completed.
• Guide technical decisions around SQL, data modeling, integrations, pipelines, and reporting.
• Determine where the current solution should be retained, optimized, or redesigned.
• Design an approach for combining data across multiple ERP systems, manufacturing facilities, and production processes.
• Help maintain traceability as materials, components, labor, overhead, yield, and scrap move through the manufacturing process.
• Guide the development of a business-friendly Power BI solution with strong usability, navigation, and drill-down capabilities.
• Partner with the Technical Project Manager to define technical priorities, dependencies, resources, and delivery milestones.
• Provide technical direction to SQL developers, data engineers, BI developers, and other project resources.
• Help resolve complex technical and data issues without continuously rebuilding the solution.
• Design the platform to support future ERP integrations, acquired businesses, and additional manufacturing locations.
• Remain involved through implementation to ensure the recommended architecture becomes a working production solution.

• Experience architecting and delivering enterprise data, analytics, or business intelligence solutions.
• Advanced SQL, relational database, and data-modeling experience.
• Experience integrating data from multiple ERP systems or other complex source systems.
• Strong understanding of data pipelines, ETL/ELT, data warehouses, and reporting layers.
• Experience designing Power BI solutions for business users.
• Ability to evaluate an existing technical solution and recommend what should be retained, improved, or redesigned.
• Experience providing hands-on technical guidance during implementation, not just creating high-level architecture.
• Ability to explain technical decisions and tradeoffs to both developers and business leaders.
• Microsoft Fabric, Azure, Snowflake, Python, or similar modern data-platform experience.
• Manufacturing, cost accounting, profitability, finance, or supply-chain data experience.
• Experience with complex bills of materials and product-cost traceability.
• Experience working with multiple ERP systems.
• Medical device, life sciences, or another regulated industry background.
• Consulting or advisory experience.
• Experience designing solutions that support acquisitions and future system integrations.