Data Engineering & Systems Manager

The Door•New York, NY

About The Position

The Data Engineering & Systems Manager serves as the agency’s primary technical resource for data systems administration, database management, reporting infrastructure, system integrations, and Salesforce platform support. The role ensures the reliability, scalability, integrity, and usability of data systems that support program operations, compliance reporting, agency performance measurement, and strategic decision-making. The Manager works with program staff, agency leadership, and technical stakeholders to maintain and enhance the organization’s data ecosystem, improve reporting capabilities, strengthen data quality, and support effective technology use across the agency. The position also supports monthly, quarterly, annual, and ad hoc reporting, agency-wide dashboard metrics, and performance management initiatives. It reports to the Assistant Director of Data Systems and Solutions. Responsibilities span data engineering and database management, systems administration, analytics and reporting, data governance and documentation, and staff training and collaboration. The role develops and maintains SQL queries, databases, data pipelines, integrations, Salesforce and case-management configurations, dashboards, recurring reports, technical documentation, and data governance practices. It also provides technical support and training, promotes responsible AI use in alignment with organizational policies and privacy and security requirements, and supports technology adoption, process improvement, and systems modernization.

Requirements

Bachelor’s degree in Computer Science, Information Systems, Data Analytics, Data Science, Engineering, Mathematics, Statistics, or a related field; an equivalent combination of education and relevant experience may be considered.
Four or more years of experience in data systems administration, database management, data engineering, business intelligence, reporting, or a related technical role.
Strong knowledge of SQL and relational database systems, such as Azure SQL, SQL Server Management Studio (SSMS), or similar platforms.
A track record of maintaining data pipelines, automated workflows, and system integrations.
Hands-on administration of CRM, case-management, or program-management systems.
Skill in building reports, dashboards, and data visualizations.
Ability to explain technical concepts clearly to non-technical stakeholders.
Proven ability to produce technical documentation, workflow documentation, and user training materials.
Ability to diagnose and resolve complex system, integration, reporting, and data quality issues.
Strong analytical, critical-thinking, and problem-solving skills.
Familiarity with HIPAA, data privacy, and information security best practices.
Ability to work independently and collaboratively in a fast-paced, mission-driven environment.

Nice To Haves

Salesforce, Microsoft, SQL, or related technical certifications.
Background in nonprofit, human services, youth development, education, healthcare, or related settings.
Understanding of emerging AI technologies and the ability to assess, implement, and monitor AI solutions in line with organizational policies, data privacy requirements, and responsible AI practices.
Salesforce Administration expertise.
Familiarity supporting integrations between Salesforce and systems such as electronic medical records, Formstack, and School Information Systems.
Working knowledge of API-based integrations and data exchange processes.

Responsibilities

Develop, maintain, optimize, and troubleshoot SQL queries, reports, and database processes.
Manage and support relational databases, data warehouses, and reporting environments.
Maintain ETL/ELT processes and automated data pipelines to ensure reliable data movement across systems.
Monitor, troubleshoot, and resolve data integration failures, pipeline issues, and data quality concerns.
Import, transform, validate, and reconcile data from multiple source systems.
Support database administration, including field creation, schema updates, user access management, and system maintenance.
Identify and implement opportunities to automate reporting and improve data workflows.
Collaborate with stakeholders to define technical requirements and develop scalable data solutions.
Configure and maintain Salesforce and related case-management systems supporting program operations.
Manage system configurations, including layouts, fields, record types, workflows, reports, dashboards, and user permissions.
Troubleshoot technical issues and coordinate system enhancements and feature releases.
Ensure systems support operational needs, reporting requirements, and compliance standards.
Provide technical support and consultation to program staff and leadership.
Develop and maintain dashboards, reports, and business intelligence solutions using Salesforce, SQL, Power BI, Tableau, or similar platforms.
Develop and maintain agency-wide performance metrics and dashboard reporting.
Produce recurring operational, compliance, funding, and leadership reports.
Develop automated reporting processes and performance measurement tools.
Analyze complex datasets and present findings, trends, and recommendations to technical and non-technical audiences.
Support data-informed decision-making across programs and agency leadership.
Develop and maintain data dictionaries, system documentation, workflow documentation, metadata inventories, business process maps, and technical specifications.
Establish and promote data governance standards and best practices.
Support agency-wide data quality monitoring and continuous improvement efforts.
Document system configurations, integrations, reporting processes, and technical procedures.
Ensure compliance with organizational policies related to data security, privacy, retention, and governance.
Promote responsible AI use in alignment with organizational policies, data governance standards, privacy requirements, security practices, and applicable regulations, including HIPAA where appropriate.
Develop user guides, training materials, and standard operating procedures.
Conduct staff onboarding and training on agency systems, reporting tools, and data collection processes.
Serve as a liaison between program teams and technical resources.
Partner with managers and leadership to identify system, reporting, and operational needs.
Support strategic initiatives focused on technology adoption, process improvement, and systems modernization.