Senior Data Architect – Data & Analytics

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

We are looking for an experienced Senior Data & Analytics Architect to join a Data & Analytics Center of Excellence and help shape enterprise data strategy, architecture, and scalable data solutions.

This is an architecture-focused role requiring strong experience across Data Warehousing, Data Engineering, ETL, SQL, Cloud Data Platforms, BI, Data Security, and CI/CD.

What You’ll Do

• 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.

What We’re Looking For

Required:

• Bachelor's degree in Computer Science, Information Systems, or related field.
• 3+ years of experience in Data Architecture.
• 5+ years of experience with Data Warehousing.
• 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.

Nice to Have

• Data warehouse architecture experience with MOLAP, ROLAP, ODS, Data Marts, and EDW.
• Data security and encryption experience.
• Azure DevOps and GitHub.
• CI/CD experience.
• Banking or financial services experience.
• Experience working in environments with multiple firewall/security layers.

Ideal Candidate

The successful candidate will be a strong technical architect who can translate enterprise business requirements into scalable data solutions while communicating effectively with both technical and non-technical stakeholders.