Senior Data Systems Analyst

At Fountain House, we believe in the power of community to transform the lives of individuals with serious mental illness. Every day, thousands of members choose to come to Fountain House to contribute their talents, learn new skills, access opportunities, and form friendships. Members and staff operate successful employment, education, wellness programs and work as partners to perform all the functions that keep our community going. The Fountain House model has been replicated in more than 300 locations in 30 countries and 32 states and currently serves more than 100,000 people with mental illness worldwide. As originators of this approach, we provide leadership by constantly advancing the practice and by leading the conversation around mental health recovery. As a result, Fountain House has created a comprehensive Community System of Care. This includes Clubhouses in Manhattan, the Bronx, Hollywood, California and Care Management, Community Oriented Recovery and Empowerment Services and a large housing program ranging from 24-hour supervised residences to scattered site supported apartments. We are committed to reducing social isolation, advocating for mental health policy change, and driving solutions that empower our members.

Your Impact

As Senior Data Systems Analyst at Fountain House, you will lead the design, optimization, and integration of Fountain House's data systems to ensure actionable, reliable, and scalable data is available across research, programs, and strategic decision-making.

Full-time

Can be based anywhere

$100k - $120k

Data Infrastructure & ETL Development

• Design and implement robust ETL pipelines integrating data from systems such as Electronic Health Records (EHR), Excel/OneDrive, SharePoint, and other sources into SQL Server databases.
• Lead data migrations from legacy systems and oversee long-term system integrations and upgrades.
• Write and maintain stored procedures, views, and functions to standardize, clean, and model data effectively.
• Develop scalable data pipelines with an emphasis on accuracy, security, automation, and performance optimization.
• Maintain metadata and data dictionaries to support governance and reproducibility.

Business Intelligence Development

• Develop dynamic, stakeholder-focused Power BI dashboards and reports (including paginated reports) to support program tracking, service improvement, and compliance reporting.
• Architect efficient Power BI data models and datasets with calculated columns, measures, and refresh schedules.
• Design accessible and actionable visualizations aligned with programmatic outcomes and research questions.
• Optimize reporting performance, backend refresh rates, and dataflows to ensure reliable and timely outputs.

Collaboration, Strategy & Communication

• Act as a key liaison between IT, Research, and Quality Assurance Compliance/Program staff to align data initiatives with organizational goals.
• Support with building tools for QI/QA such as dashboards
• Support research and evaluation teams through data exploration, analysis, and statistical reporting.
• Provide documentation and training to non-technical staff and support organizational data literacy.
• Translate technical concepts and findings into accessible language and visualizations for cross-functional audiences.
• Use data analytics to inform and support performance improvement initiatives across the organization.

Who You Are

• A mission-aligned Senior Data Analyst that thrives in a collaborative environment, bridging technical execution with organizational impact.
• A natural collaborator who brings clarity, coordination, and follow-through to multi-stakeholder environments that include data users, clinicians and IT staff.
• A proactive communicator who thrives in dynamic, people-centered workspaces.

What You Bring

• Minimum 3 years of related experience
• Bachelor's degree in Information Systems, Computer Science, Data Analytics, or related field.
• Experience with Azure Data Services (Data Factory, Synapse Analytics).
• Experience with SQL Server, ETL pipelines (manual or automated), and Microsoft Power Platform tools.
• Experience developing reports and dashboards to support organizational decision-making and compliance.
• Strong understanding of data quality assurance, validation, and governance best practices.
• Deep proficiency in Power BI, including DAX and Power Query, and related tools (Excel, SharePoint, OneDrive).
• Familiarity with HIPAA and IRB standards; experience working with healthcare or sensitive data.
• Experience with Python or R for statistical modeling or automation.
• Proven expertise in Microsoft SQL Server, ETL processes, and data modeling for reporting and analysis.
• Excellent verbal and written communication skills, with the ability to explain technical concepts to non-technical staff.
• Experience working across departments with a diverse team of stakeholders.
• Ability to manage multiple priorities, work independently, and adapt to evolving data needs and timelines.

Why Join Fountain House?

• Empower Marginalized Communities - Elevate the voices of individuals with lived experience and drive real systemic change.
• Innovate in Mental Health Advocacy - Join a mission-driven team at the forefront of mental health reform.
• Professional Growth & Leadership - Access mentorship, training, and career development opportunities in a rapidly evolving field.

Join Us & Make an Impact!

Be part of a movement that is transforming mental health care through research, advocacy, and community.

Fountain House, Inc. is an Equal Opportunity Employer

At this time Fountain House, Inc. is not able to sponsor visas

Note: This job description should not be construed to imply that these requirements are the exclusive standards of the position. Incumbents will follow any other instructions, and perform any other related duties, as may be required. The employer has the right to revise this job description at any time. This job description is not to be construed as a contract for employment.