Enterprise Data Architecture Lead

PURVIEW; New York (NY); On-site; USD 140,000 - 180,000; Full time

Job summary

PURVIEW is seeking a Senior Data & Analytics Architect to join its Data & Analytics Center of Excellence in New York. You will shape enterprise data strategy and scalable data solutions across data warehousing, data engineering, ETL, and cloud data platforms.

You will partner with BI, analytics, product, IT, and business teams to design and implement robust data architectures while ensuring security and compliance. Strong collaboration and leadership are essential.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, or related field.
• 3+ years of experience in Data Architecture.
• 5+ years of Data Warehousing experience.
• 5+ years of Data Engineering experience.
• Strong SQL and database architecture experience.
• Experience with Microsoft SQL Server and/or Oracle.
• Strong ETL experience with SSIS, Azure Pipelines, dbt, or Informatica.
• Experience with Microsoft Fabric, Snowflake, or Databricks.
• Experience with Power BI, Tableau, or Qlik.
• Programming/query experience with SQL, Python, DAX, or similar technologies.

Responsibilities

• Define and enhance enterprise data strategy and architecture.
• Architect and enhance data warehouse and data lake solutions.
• Design and develop ETL processes, data marts, tables, and other data objects.
• Partner with BI, analytics, product, IT, and business teams.
• Develop and maintain data dictionaries, architecture documentation, and technical standards.
• Support enterprise data initiatives and provide architecture guidance.
• Troubleshoot data platform and pipeline issues.
• Support data migration and integration initiatives.
• Implement scalable and maintainable data architecture.
• Apply data security, identity, privacy, authorization, and encryption practices.
• Work with Azure DevOps/GitHub and CI/CD development practices.

Skills

Data Architecture

Data Warehousing

Data Engineering

SQL

ETL

Azure DevOps/GitHub

Python

BI Tools

Education

Bachelor's degree in Computer Science or Information Systems

Tools

Microsoft SQL Server

Oracle

SSIS

Azure Pipelines

dbt

Informatica

Microsoft Fabric

Snowflake

Databricks

Power BI

Tableau

Qlik

Job description

PURVIEW is seeking a Senior Data & Analytics Architect to join its Data & Analytics Center of Excellence in New York. You will shape enterprise data strategy and scalable data solutions across data warehousing, data engineering, ETL, and cloud data platforms.

You will partner with BI, analytics, product, IT, and business teams to design and implement robust data architectures while ensuring security and compliance. Strong collaboration and leadership are essential.