Quick overview
Job description
Senior Architect – Data & Analytics
Location: Long Island City (Hybrid)
Job Type: Contract W2
Job Summary
We are seeking a Senior Architect – Data & Analytics to help establish and evolve the long-term data strategy and architecture for a Data & Analytics Center of Excellence.
The ideal candidate will have strong experience in data architecture, data warehousing, data engineering, ETL, SQL, cloud data platforms, and business intelligence. This role will work closely with data management teams, business intelligence teams, product managers, IT teams, and business stakeholders to design scalable and maintainable data solutions.
Key Responsibilities
- Develop and enhance enterprise data architecture and data strategy.
- Collaborate with data management teams to understand enterprise data requirements.
- Design and enhance data warehouse and data lake solutions.
- Develop data objects including tables, data marts, and ETL components.
- Design and maintain scalable ETL/data pipeline solutions.
- Partner with BI, analytics, product, and business teams to deliver high-quality data solutions.
- Develop and maintain data dictionaries, architecture documentation, standards, and development frameworks.
- Provide data architecture and analysis support for business initiatives.
- Troubleshoot data platform, pipeline, and architecture-related issues.
- Support data migration from various source systems into SQL Server environments.
- Apply data security practices across network, identity, privacy, authorization, and encryption.
- Work with IT teams to ensure data platforms and development practices meet enterprise standards.
- Participate in Azure DevOps, GitHub, and CI/CD practices.
- Stay current with emerging data technologies and industry trends.
Required Qualifications
- Bachelor's degree in Computer Science, Information Systems, or related field.
- 3+ years of experience in a Data Architect role.
- 5+ years of Data Warehouse experience.
- 5+ years of Data Engineering experience.
- Strong experience with Microsoft SQL Server and/or Oracle.
- Strong SQL skills, including:
- Query optimization
- Performance tuning
- Index maintenance
- Database structures
- Experience with ETL technologies such as:
- SSIS
- Azure Pipelines
- dbt
- Informatica
- Strong programming/query experience with SQL, Python, DAX, or similar technologies.
- Experience with BI/reporting platforms such as Power BI, Tableau, or Qlik.
- Experience with cloud data platforms such as:
- Microsoft Fabric
- Snowflake
- Databricks
Additional Technical Skills
- Data warehousing architecture: MOLAP, ROLAP, ODS, Data Marts, Enterprise Data Warehouse.
- Big Data and SQL-based storage technologies.
- Data security and authorization concepts.
- Azure Active Directory / Azure AD and SSO.
- Data encryption concepts and standards.
- XML and HTML.
- Azure DevOps and GitHub.
- CI/CD development practices.
- Experience working across multiple firewall/security layers.
- Financial services or banking industry experience is preferred.
Soft Skills
- Strong analytical and problem-solving skills.
- Excellent communication skills with both technical and non-technical stakeholders.
- Ability to work independently and collaboratively.
- Strong project prioritization and organizational skills.
- Ability to learn and adapt to evolving technologies and business requirements.
Work Environment
- Hybrid work environment.
- Standard office environment.
- May require occasional weekend or extended-hours support.
- Critical system outages and system upgrades may require short-notice 24/7 coverage.
Similar jobs
- TA

Data ArchitectRecently posted
The Avian Consulting LLC · Atlanta, GA · Hybrid · Posted 16 Nov 2026 🇺🇸
Stakeholder ManagementDockerOracle+24TechnologySalary not listed - VE
W2// Senior Data Modeler / Data ArchitectRecently posted
VensIT Corp · Dallas, TX · Hybrid · Posted 16 Nov 2026 🇺🇸
SQLSnowflakeTechnologySalary not listed - BH
Principal Data Architect Auto Apply
Bhhc · Bay Area · Hybrid 🇺🇸
OnboardingSnowflakeCRM+8Technology$226.7k - $236.3k/yr - SE
AI/ML Data ArchitectRecently posted
SunRay Enterprise Inc · United States · Hybrid · Posted 16 Nov 2026 🇺🇸
NLPHugging FaceGenerative AI+3TechnologySalary not listed - IT
Data Solution ArchitectRecently posted
ISite Technologies Inc · New York, NY · Hybrid · Posted 16 Nov 2026 🇺🇸
AgileTechnologySalary not listed - KT

Senior Data ArchitectRecently posted
Kforce Technology Staffing · Orem, UT · On-site · Posted 16 Nov 2026 🇺🇸
SQLT-SQLETL+4TechnologySalary not listed - PS
Data Architect | W2 RoleRecently posted
Pull Skill Technologies · Washington, DC · Hybrid · Posted 16 Nov 2026 🇺🇸
SQLApache SparkETL+13TechnologySalary not listed - VA
Data ArchitectRecently posted
Valueprosite · United States · Hybrid · Posted 16 Nov 2026 🇺🇸
SnowflakeDatabricksTechnologySalary not listed - HK
Manager, Research Data Management and AcquisitionRecently posted
Harvard Kennedy School · Cambridge, MA · Hybrid · Posted 16 Nov 2026 🇺🇸
Stakeholder ManagementGDPRHIPAATechnologySalary not listed - SI
SAP BDC Data ArchitectRecently posted Auto Apply
SAP IT Business Systeme · Miami, FL · Hybrid · Posted 16 Nov 2026 🇺🇸
Stakeholder ManagementProcurementProject ManagementTechnology$151.9k - $340.9k/yr - EJ
Data ArchitectRecently posted
eJAmerica · Grapeland, Texas · On-site · Posted 17 Nov 2026 🇺🇸
Stakeholder ManagementSQLApache Spark+15TechnologySalary not listed - VT
Data ArchitectRecently posted
Vedanta Telecom LLC · Texas City, Texas · Hybrid · Posted 17 Nov 2026 🇺🇸
GCPOracleSQL+21TechnologySalary not listed