Lead Data Architect: Snowflake Platform (Remote)

eTeam; Waltham (MA); Remote; USD 180,000 - 240,000; Full time

Job summary

eTeam seeks a Lead Data Architect to own the Gas Data platform architecture, roadmap, and governance for a major data modernization effort. You will drive Snowflake-based design, data modeling, and scalable ingestion patterns while ensuring compliance and cost efficiency.

Lead migration strategies, establish data standards, and partner with stakeholders to deliver trusted data products for NY and NE gas value streams. This role emphasizes architecture artefacts and regulatory considerations.

Qualifications

• 10+ years in data and analytics roles, incl. 5+ years in a data architecture role on enterprise-scale platforms.
• End-to-end legacy-to-modern platform migration carried through to decommissioning the source system.
• Deep, hands-on architecture experience with a cloud data platform; Snowflake strongly preferred, incl. warehouse/lakehouse layering, workload design, performance tuning and cost characteristics.
• Strong SQL and dimensional/analytical data modelling.
• Experience designing ingestion and integration patterns across batch, streaming, file-based and API sources, including third‑party data.
• Experience designing API and data-service patterns for operational and analytical consumers.
• Proven track record of data governance, data quality, lineage and observability by design.
• Working knowledge of access control, data masking, retention and audit in a regulated environment.
• Python and modern data engineering tooling; IaC and CI/CD applied to data pipelines.
• Architecture artefacts that are used – data models, reference architectures, decision records, standards and design reviews.

Responsibilities

• 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 Medallion architecture considerations.
• Run design reviews and document the reasoning behind trade-offs.
• Ensure compliance to data masking requirements.
• Maintain the Gas Data Model to reflect business-defined data objects.
• Complete the technical plan for data migration and drive it to closure.
• Define the decommissioning value case in technical terms.
• Design reusable ingestion, API and service patterns for new sources and consumers.
• Establish onboarding patterns with licensing, refresh and quality controls; reduce manual transfers.
• Provide the technical view into Data Governance Council on standards and risk.

Skills

Snowflake

Data architecture

Data modelling

SQL

Python

CI/CD

Data governance

Data masking

API patterns

Ingestion patterns

Tools

Snowflake

Cloud data platform

Job description

eTeam seeks a Lead Data Architect to own the Gas Data platform architecture, roadmap, and governance for a major data modernization effort. You will drive Snowflake-based design, data modeling, and scalable ingestion patterns while ensuring compliance and cost efficiency.

Lead migration strategies, establish data standards, and partner with stakeholders to deliver trusted data products for NY and NE gas value streams. This role emphasizes architecture artefacts and regulatory considerations.