inficareJersey City, NJ
BigQuery Architect
Job Title: BigQuery Architect
Location: NY/NJ (Hybrid - 2 days onsite)
Job Type: Contract
Experience: 12+ years
Job Overview
Key Responsibilities:
- Design and implement enterprise-scale data warehouse and Lakehouse solutions using BigQueryDefine canonical and dimensional data models and enterprise information architectures
- Architect large-scale data ingestion, transformation, and reporting pipelines
- Design partitioning, clustering, materialized views, and query optimization strategies
- Build metadata-driven, reusable ingestion frameworks using Dataflow, Dataproc, Pub/Sub, Cloud Composer, and Data FusionDefine enterprise data governance frameworks including IAM, row/column-level security, and data masking
- Ensure compliance with GDPR, HIPAA, and CCPARequired SkillsBigQuery, GCP, Data Warehousing, Lakehouse architecture
- Dataflow, Dataproc, Pub/Sub, Cloud Composer (Airflow), Data FusionELT frameworks, SQL-based transformations
- Data governance, IAM, data lineage, data quality
- Cloud migration from Oracle, Teradata, Snowflake, Redshift, Hadoop, or Azure
Preferred Skills:
- BigQuery ML and Vertex AI integration
- Data Mesh and Data Product implementation
- Insurance or Banking domain experience
- Experience with petabyte-scale datasets
- Location & Work ModelNY/NJ metro area.
Hybrid: 2 days per week onsite.
Engagement Details: Contract engagement. Duration to be confirmed.
Also on the board Same function, level within a rung
Level
Manager
Location
Jersey City, NJ
Occupation
Database Architects
Industry
Computer Systems Design Services
Posted
today