Top 7 Data warehouse architect Jobs in Schenectady, Ny

Manager, Information Services - Data Architect
State of New York - Board of Elections —Albany, NY
- $95,000 - $110,000 a year
- Full-time
- Background check
- System design
- Research
- Paid holidays
- Health insurance
2026 03-04 ETL Developer / Data Architect
VISTRADA —Albany, NY
- $80,000 - $130,000 a year
- Full-time
- Computer science
- Doctoral degree
- Computer Science
Quick Apply
AWS Data Engineer
Cloud and Things, Inc —Schenectady, NY
- $50 - $70 an hour
- Computer Science
- System design
- 3 years
Quick Apply
Data Architect-1994
PIP Global Safety —Latham, NY
- $119 an hour
- System design
- Continuous improvement
- Senior level
Quick Apply
NYS ITS Expert Software Architect
Diverse Agile Solutions —Menands, NY
- $50 - $55 an hour
- Full-time
- Remote
- Microsoft Access
- Computer Science
- Bachelor's degree
Quick Apply
13d
Oracle Utilities Onshore Report Strategy Lead
Accenture —Albany, NY
- Full-time
- Oracle
- US work authorization
- Military encouraged
- Paid holidays
- Disability insurance

Explore jobs in cities nearby

Check out jobs in cities near your current location, Columbus

Senior ELT Analytics Specialist (Database Administration Specialist 2, PN 20067096)
State of Ohio - Workers' Compensation —Columbus, OH
Knowledge of oral & written communication tools & techniques; customer support & personal service; technical writing & documentation practices; technology…
$41.81 - $61.49 an hour
6d
Lead ETL Developer- Enterprise Data Warehouse (EDW)
Huntington Bank —Columbus, OH
As a technical leader, you will partner across engineering, architecture, QA, and business teams to deliver high-quality, reliable data solutions.
$70,000 - $140,000 a year

I want to receive the latest job alert for data warehouse architect in schenectady, ny

By signing in to your account, you agree to SimplyHired's Terms of Service and consent to our Cookie and Privacy Policy.

Explore jobs in more locations

data warehouse architect jobs near schenectady, ny

Manager, Information Services - Data Architect

State of New York - Board of Elections
Albany, NY

Apply Now

Job Details

Full-time
$95,000 - $110,000 a year

Benefits

Paid holidays
Health insurance
Dental insurance
Paid time off
Vision insurance
Loan forgiveness
Paid sick time

Qualifications

Data model design
Commercial use (data warehousing systems)
Systems integration
Staff supervision
Data Integration (Data management)
Data modeling projects
System design
Integration Architecture Design (Architecture design skills)
Managing IT teams
Research
Managing data teams
Schema design
SQL
Query management

Full Job Description

Duties Description The Data Architect will serve as the enterprise data authority for the New York State Board of Elections, overseeing the design, governance, and operation of a Google BigQuery–based data warehouse supporting analytics, reporting, and research activities. Reporting to senior IT leadership, this position is responsible for ensuring the integrity, accessibility, and performance of organizational data sourced from multiple operational systems.
The role includes architectural oversight of data ingestion from Salesforce and ASP.NET / Microsoft SQL–based applications using MuleSoft, direct connectors, APIs, or other approved integration mechanisms. The Data Architect will also provide analytical leadership, investigate data anomalies and trends, and supervise a Data Analyst who assists in reporting, visualization, and research activities.

Key Responsibilities

Enterprise Data Architecture & Governance

Design, implement, and maintain the enterprise data architecture for a Google BigQuery–based data warehouse, including logical and physical data models, schemas, and partitioning strategies.
Establish and enforce data governance standards, including data quality, metadata management, retention, lineage, and access controls.
Define canonical data models and standards to ensure consistency across disparate source systems.

Data Integration & Ingestion

Oversee the ingestion of data from Salesforce applications, ASP.NET applications, and Microsoft SQL Server databases into BigQuery.
Coordinate the use of MuleSoft, native connectors, APIs, or other ETL/ELT tools to support secure, reliable, and scalable data pipelines.
Work with application owners, developers, and vendors to define data extraction, transformation, and loading strategies that minimize operational impact.
Support data migration and legacy system sunset efforts by ensuring historical data is accurately preserved and accessible in the warehouse.

Analytics, Research & Anomaly Investigation

Provide architectural and analytical guidance for enterprise reporting and analytics initiatives, including dashboards, ad hoc analysis, and trend reporting.
Research and analyze data anomalies, inconsistencies, or unexpected trends; perform root cause analysis and recommend corrective actions.
Partner with program, policy, and legal stakeholders to support data-driven research and decision-making.
Ensure analytical outputs are reproducible, auditable, and aligned with data governance policies.

Supervision & Collaboration

Supervise and provide technical direction to a Data Analyst responsible for reporting, visualization, and exploratory analysis.
Review analytical methodologies, SQL queries, and data products for accuracy, performance, and compliance with standards.
Collaborate with IT infrastructure, security, application development teams, and external vendors to ensure alignment across systems.

Security, Compliance & Operations

Work closely with the SBOE Chief Information Security Officer (CISO) and Secure Elections Center to ensure data security, privacy, and compliance with NYS cybersecurity and election integrity requirements.
Implement role-based access controls, audit logging, and data masking as appropriate within BigQuery and associated analytics tools.
Participate in architecture reviews, change control, and release management processes affecting data platforms.
Develop and maintain detailed technical documentation, including architecture diagrams, data dictionaries, and operational procedures.

Minimum Qualifications Minimum Qualifications

Experience designing and managing enterprise data warehouses or large-scale analytical data platforms.
Strong knowledge of relational and analytical data modeling concepts.
Experience integrating data from multiple operational systems using ETL/ELT tools, APIs, or middleware platforms.
Proficiency in SQL and data analysis techniques.
Experience working in a regulated, public-sector, or compliance-driven environment.
Demonstrated ability to lead technical work and oversee analytical staff.

Preferred Qualifications

Hands-on experience with Google BigQuery and Google Cloud Platform (GCP) data services.
Experience integrating Salesforce data and Microsoft SQL Server–based systems into cloud data warehouses.
Familiarity with MuleSoft or similar enterprise integration platforms.
Experience with analytics and visualization tools such as Looker, Tableau, or equivalent.
Knowledge of data governance frameworks and best practices.
Prior experience supporting election, campaign finance, or other public integrity data systems.

Additional Comments Benefits of Working for NYS – A generous benefits package worth approximately 65% of salary.
Holiday & Paid Time Off:

Thirteen (13) paid holidays annually
Up to Thirteen (13) days of paid vacation leave annually
Up to Five (5) days of paid personal leave annually
Up to Eight (8) days of paid sick leave annually

Health Care Benefits:

Eligible employees and dependents can pick from a variety of affordable health insurance programs
Family dental and vision benefits at no additional cost

Additional Benefits include, but are not limited to:

New York State Employees’ Retirement System (ERS) Membership
NYS Deferred Compensation 457(b) plan
Access to NY 529 and NY ABLE College Savings Programs, as well as U.S. Savings Bonds
Public Service Loan Forgiveness (PSLF)

The New York State Board of Elections is an equal opportunity employer, and we recognize that diversity in our workforce is critical to fulfilling our mission. We are dedicated to workplace inclusivity and encourage applicants with disabilities to apply.

Some positions may require additional credentials or a background check to verify your identity.

Apply Now

Refine Your Search

data warehouse architect jobs in schenectady, ny

Manager, Information Services - Data Architect

2026 03-04 ETL Developer / Data Architect

AWS Data Engineer

Data Architect-1994

NYS ITS Expert Software Architect

Oracle Utilities Onshore Report Strategy Lead

Explore jobs in cities nearby

I want to receive the latest job alert for data warehouse architect in schenectady, ny

Explore jobs in more locations

Job Seeker Tools

Employer Tools

Browse

Stay Connected