Project Manager III

Title:

Lead Data Architect

Location:

Remote (but needs to be in MA)

Duration: 12 months

The Lead Data Architect owns the technical target state for Gas data platform and the sequenced technical roadmap to achieve it. The role defines the Gas Data platform architecture, migration strategy and data standards that turn a legacy-to-modern migration into a durable, governed capability – enabling NY and NE Gas value streams to access trusted data, consume reusable data products, and operate safely at lower cost.

• 1. Snowflake hands on experience and platform expertise
• 2. Data architecture experience
• 3.Data Modeling experience

• Produce and maintain the Gas Data platform target-state architecture and the technical roadmap to evolve data and AI capabilities.
• Set modelling and layering standards, including the Medallion architecture where the Gold/Curated Data layer is genuinely required versus where raw data plus report-level SQL and establish faster, cheaper path to business value. Prevent over-engineering of the Curated Data Layer ahead of demonstrated need.
• Run design review for significant changes; make the call when there is a trade-off between speed, performance and durability, and document the reasoning.
• Ensure compliance to all data masking business requirements
• Maintain the Gas Data Model to reflect business defined, abstract data objects in the Gold/Curated Data Layer

• Complete the technical plan data migration and drive it to closure, including the incremental report migration approach and the ODS decommissioning path.
• Build the formal legacy application data migration strategy, segmenting applications into:
  
  - historical, live-feed-until-sunset, feature-parity replacement, and security-priority. Sequence by business value, dependency complexity and data residency need.
• Define the decommissioning value case in technical terms – what is retired, when, and what cost and risk that removes.

• Design reusable ingestion, API and service patterns so new sources and consumers follow a known route rather than a bespoke build.
• Establish the third-party and external data onboarding pattern, including licensing, refresh and quality controls, and playbooks for priority sources.
• Reduce manual file transfers and spreadsheet-based processes through automated, monitored ingestion.

• Architect DQ measurement into the platform: completeness, freshness, lineage, exception capture and issue resolution routing.
• Design access, masking, retention and audit patterns that let business users self-serve safely.
• Provide the technical view into the Data Governance Council on standards, certification criteria and risk.

• [10] years in data and analytics roles, including [5] years in a data architecture role on enterprise-scale platforms.
• At least one end-to-end legacy-to-modern platform migration carried through to decommissioning of the source system – not a parallel build left running.
• Deep, hands‑on architecture experience with a cloud data platform;
  Snowflake strongly preferred, including warehouse/lakehouse layering, workload design, performance tuning and consumption cost characteristics.
• Strong SQL and dimensional/analytical data modelling, at a level sufficient to review and improve the designs of engineers in the team.
• Experience designing ingestion and integration patterns across batch, streaming, file-based and API sources, including third‑party and vendor‑supplied data.
• Experience designing API and data‑service patterns serving both operational and analytical consumers.
• Demonstrated track record of building data governance, data quality,…