Skip to main content

Data Engineer and Architect

New York, NY
Permanent
Role: Sr. Data Engineer and Architect
Location: Melville, NY (Long Island, NY) - in office 2-3 days/wk in client office

Design end to end data architectures on GCP leveraging
Experience architecting solutions in Cloud Data Engineering platform (eg: GCP, AWS, Azure)

Have you worked closely with client enterprise architect?
Have you acted as a mentor to technical offshore data analytics team?

Client Management Experience:
Experience work closely with client enterprise architect.
Act as a mentor to technical offshore data analytics team

Data Architecture experience:
Experience architecting solutions in Cloud Data Engineering platform (eg: GCP, AWS, Azure)
Design end to end data architectures on GCP leveraging BigQuery, Dataflow, Dataproc, Pub/Sub, Cloud Composer, Cloud Storage, and Looker.
Develop modern data lake, data warehouse, and lakehouse architectures using best practices and well architected frameworks in GCP and prefer to have experience in AWS, Azure & Databricks
Create logical and physical data models, data flow diagrams, integration patterns, and reference architectures.
Architect scalable ETL/ELT pipelines using Dataflow (Apache Beam), Dataproc (Spark), and/or Cloud Composer orchestrations.
Lead cloud-native modernization initiatives: migration from legacy platforms to GCP.
2. Data Engineering & Development Oversight
Provide expert guidance to data engineering teams on standards, patterns, and reusable frameworks.
Optimize BigQuery performance including partitioning, clustering, materialized views, BI Engine, and storage optimizations.
Implement data quality, metadata management, observability, and lineage frameworks using tools like Dataplex and Data Catalog.
Ensure CI/CD adoption using Cloud Build, GitHub/GitLab pipelines, and infrastructure-as-code (Terraform).

Data Governance & Security
Help define data governance standards including access models, encryption, retention, and data lifecycle management.
Implement IAM policies, VPC Service Controls, organizational policy constraints, and secure data sharing patterns.
Ensure compliance with GDPR, HIPAA, PCI, and internal corporate policies.

Job Type: Permanent

Job ID: 253923844