Data Systems Architect & Analytics Lead

The Door; New York (NY); On-site; USD 65,000 - 75,000; Full time

Job summary

The Door is seeking a Data Systems & Solutions Manager to serve as the agency's primary technical resource for data systems administration, reporting infrastructure, and Salesforce support in New York City. You will ensure data reliability, scalability, and usability to support program operations, compliance, and strategic decision-making.

You will work with program staff and leadership to enhance the data ecosystem, improve reporting capabilities, and promote data quality, while supporting

Qualifications

• Four+ years in data systems administration, database management, BI, or related technical role.
• Strong knowledge of SQL and relational databases (Azure/SQ L Server)
• Experience maintaining data pipelines and system integrations
• Experience with CRM or program management systems
• Ability to build reports and dashboards for non-technical audiences
• Familiarity with HIPAA, data privacy, and information security best practices
• Ability to work independently in a fast-paced environment

Responsibilities

• Develop, optimize, and troubleshoot SQL queries, reports, and database processes.
• Manage relational databases, data warehouses, and reporting environments.
• Maintain ETL/ELT processes and data pipelines across systems.
• Monitor and resolve data integration failures and data quality issues.
• Import, transform, and reconcile data from multiple sources.
• Support database administration: schemas, access, maintenance.
• Automate reporting and improve data workflows.
• Collaborate with stakeholders to define technical requirements.

Skills

SQL

Data pipelines

Data governance

Analytics

HIPAA knowledge

Problem-solving

Documentation

Communication

Education

Bachelor's degree in Computer Science or related field

Tools

Salesforce

SQL Server / SSMS

Azure SQL

Power BI

Tableau

Job description

The Door is seeking a Data Systems & Solutions Manager to serve as the agency's primary technical resource for data systems administration, reporting infrastructure, and Salesforce support in New York City. You will ensure data reliability, scalability, and usability to support program operations, compliance, and strategic decision-making.

You will work with program staff and leadership to enhance the data ecosystem, improve reporting capabilities, and promote data quality, while supporting