Job Description
Data Architect - Iselin, NJ (Hybrid) OMG Technology Summit, NJ Job Details $70 an hour 6 hours ago Qualifications KYC Data model design SSO Cloud identity and access management (IAM) Commercial use (data warehousing systems) Performance tuning Databricks Data Integration (Data management) Authorization controls implementation Database compliance measures IT user and group management PCI Spark System performance optimization Snowflake SQL Cloud database architecture Airflow Anti-Money Laundering (AML) compliance (compliance procedures implemented) Integration Platforms (Enterprise solutions) Metadata tagging Data access controls implementation Identity and access management (IAM) architecture design Database migration or upgrading Access control management Data encryption implementation Stream Processing System tuning Data performance optimization Metadata management Full Job Description Hello All, This opportunity is for a Data Architect- Iselin, NJ[Hybrid]. Please find the job description below for your reference. Please respond at your earliest convenience.
Responsibilities:
Define and maintain reference architectures (Lakehouse, CDC, streaming) and domain data models (conceptual, logical, physical). Create and enforce data standards:
naming conventions, data types, modeling practices, semantic definitions (aligned to business glossaries). Establish metadata operating model:
ownership, stewardship, processes for Catalog, Glossary, Data Dictionary, and Data Lineage. Integrate lineage capture across pipelines (ETL/ELT/streaming), BI layers, and ML workflows. Architect cross-platform data flows across Databricks, Oracle/SQL Server, Snowflake and metadata tools. Define IAM models:
RBAC/ABAC, SSO/federation, SCIM provisioning; directory-driven entitlements and periodic access reviews. Define catalog strategy (e.g., Unity Catalog/Purview/Collibra/Alation) and integrate with CI/CD for automated registration and lineage. Design reusable pipeline frameworks with configuration-driven IO, logging, metrics, retry/error handling, and data quality checks. Required Qualifications Data Modeling:
Dimensional (star/snowflake), 3NF, Data Vault, business glossary-to-model mapping, SCD types, time-series/event modeling. Metadata & Governance:
Practical use and integration of Data Catalogs, Lineage, Oracle/SQL Server (data modeling, migration/CDC patterns). Snowflake (roles, warehouses, performance tuning, tasks/streams, dynamic tables). Databricks/Spark (SQL/PySpark, Structured Streaming, Delta Lake; Unity Catalog). Security & Compliance:
IAM/RBAC, masking, tokenization, encryption; PCI/AML/KYC/GDPR/DPDP
awareness. Integration & Orchestration:
Databricks Workflows, Airflow/ADF, API integrations with catalog tools; schema registry Exceptional interpersonal and collaboration skills within a team environment Other Job Details:
Location:
Iselin, NJ[Hybrid Model] Candidate rate: : $70 on C2C and $65 on W2 Docs required: ID proof will be required.