Platform Solutions Architect: Excel & Data Modeling

Allego; Waltham, Northern (MA, KY); Hybrid; USD 118,000 - 160,000; Full time

Job summary

Allego, a growing SaaS technology company in the Boston area, seeks a Technical Solutions Consultant to bridge presales, data architecture, and customer onboarding. You will design scalable data structures in the Allego platform using Excel and modeling techniques, translating requirements into production-ready solutions.

You will collaborate with Product, Engineering, and CS teams to deliver scalable platform configurations, integrations, and governance, while guiding customers through

Qualifications

• 3–5+ years in a hybrid Technical Solutions Consultant, Implementation Architect, Data Analyst, or Technical SE role within a fast-paced SaaS company.
• Deep experience modeling complex datasets in Excel; advanced formulas, pivot tables, data structuring.
• Architecture & scalability focus; translate front-end requirements into scalable data structures.
• Hands-on platform administration and governance in SaaS environments.
• Proven ability to manage technical deployment timelines and onboarding lifecycles.
• Familiarity with relational databases, APIs, JSON/CSV data transformation, SSO/SAML, cloud security.

Responsibilities

• Technical Discovery & Scope Definition: define project schedules and deliverables for platform deployments.
• Excel & Data Modeling: build multi-variable data models and robust data structures.
• Presentation-to-Model Translation: convert UI/UX requirements into back-end data models.
• Hands-on Platform Configuration & Delivery: configure platform back-ends and permissions.
• Scalable Solution Architecture: design configurations for current and future needs.
• Integrations & Technical Governance: support data ingestion, API mapping, and SSO/security.

Skills

Technical Solutions Consultant

Implementation Architect

Data Analyst

Technical SE

SaaS

Education

Bachelor’s degree in Computer Science / Data Analytics / Information Systems

Tools

Excel/Google Sheets

Salesforce

SQL

Postman

Asana

Smartsheet

Jira

Job description

Allego, a growing SaaS technology company in the Boston area, seeks a Technical Solutions Consultant to bridge presales, data architecture, and customer onboarding. You will design scalable data structures in the Allego platform using Excel and modeling techniques, translating requirements into production-ready solutions.

You will collaborate with Product, Engineering, and CS teams to deliver scalable platform configurations, integrations, and governance, while guiding customers through