Job Title: Lead Data Architect
Location: Waltham, Massachusetts (On-Site)
Job Summary: We are representing an opportunity for a technically strong architect who can shape the future of a modern data platform and help drive a complex legacy-to-modern migration to completion. Our team is looking for someone who can define standards, reduce unnecessary complexity, and create durable data capabilities that support trusted access, governance, and business value.
Responsibilities:
- Own the target-state architecture and technical roadmap for the gas data platform, including sequencing for evolving data and AI capabilities.
- Set modeling, layering, masking, access, retention, and audit standards to support secure and governed self-service.
- Lead migration strategy from legacy systems to modern data capabilities, including incremental report migration and the ODS decommissioning path.
- Design reusable ingestion, API, service, and data onboarding patterns that reduce manual file transfers and support quality, lineage, and control.
Required:
- 10+ years in data and analytics roles, including 5+ years in a data architecture role on enterprise-scale platforms.
- Hands-on cloud data platform architecture experience; Snowflake strongly preferred, including warehouse/lakehouse layering, workload design, performance tuning, and consumption cost characteristics.
- Strong SQL and dimensional/analytical data modeling skills sufficient to review and improve engineering designs.
- Experience designing ingestion and integration patterns across batch, streaming, file-based, and API sources, plus API and data-service patterns for operational and analytical consumers.
- Demonstrated experience building governance, data quality, lineage, observability, access control, data masking, retention, and audit into a platform by design.
- Python, modern data engineering tooling, infrastructure-as-code, and CI/CD applied to data pipelines, plus experience producing architecture artefacts used for models, standards, reference architectures, and design reviews.
About SSI People: With over 26 years of industry experience, SSi People has built its reputation and expertise on putting people first. Everything we do works toward delivering exceptional experience for our consultants, our clients, and our internal team. Through a genuine commitment to people in everything we do. We have developed refined processes and a stellar internal team to deliver talent quickly. More importantly, we focus on building long-term relationships, not transactions. Putting people first is just what we do well.
By applying for this job, you agree to receive calls, AI-generated calls, text messages, or emails from SSi People and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy here: SSi People Privacy Policy