Data Analyst I, Business Intelligence

Position Summary

As part of the Business Intelligence team, the Data Analyst I is responsible for supporting the data analysis and data integrity of the Enterprise Technology department. In this role, you will coordinate with both internal National Council teams and external partners to collect, analyze, and report on key metrics and data-driven deliverables.

This is an individual contributor role without any direct reports. While this position can be done remotely from anywhere in the U.S., you must occasionally accommodate our Washington, D.C. business hours of 8:30 a.m. to 5:00 p.m. ET.

Key Responsibilities

• Support the collection, analysis, and reporting of all National Council data, ensuring accuracy and data integrity.
• Coordinate and produce ongoing team based and/or department-based reporting.
• Leverage existing enterprise systems to respond to internal and external data sharing requests.
• Develop and maintain a comprehensive understanding of data sources, ensuring the continuous availability, consistency, and accuracy of data by monitoring systems and proactively resolving any discrepancies or errors.
• Support the preparation, transformation, and validation of data from multiple sources using ETL methods to ensure consistency and accuracy in reporting and analysis.
• Identify and implement process improvements related to data collection, management, and reporting.
• Develop and maintain external reporting dashboards for clients and organizations.
• Support expertise and input on data related initiatives across National Council departments.
• Other duties as assigned.

Required Qualifications

• 3+ years of relevant professional experience in data analysis or a related field.
• Proficient knowledge of data querying techniques using SQL, or other software.
• Proficient knowledge of data analytics techniques for quantitative and qualitative data surveys.
• Proficient knowledge and experience with data visualization techniques through Tableau, PowerBI, or other software.
• Results-oriented with a high attention to detail, ability to multi-task and manage competing priorities, and the ability to meet deadlines in a fast-paced environment.
• Willingness to learn and commitment to ongoing education.

Preferred Qualifications

• Bachelor's degree or equivalent additional years of professional experience in a related field.
• Proficiency in Microsoft Office (MS Word, Excel, Access, and PowerPoint).
• Knowledge of advanced data collection, transformation, and analytics methodologies and experience managing large datasets.
• Experience in CRM databases (Salesforce, Microsoft Dynamics, etc.), learning management systems, and web based (cloud) data platforms, including Microsoft Fabric.
• Familiarity with Python for data manipulation, automation, or scripting in analytics workflows;
• Exposure to AI concepts and their application in data analysis, automation, or customer experience.
• Proven ability to work both independently and as a team.

Salary & Benefits

The salary range for this position is $76,000 to $99,400. Salary decisions within the range are based on experience, education and internal equity.

The National Council offers a comprehensive benefits package, which includes (but is not limited to):

• Medical, dental, vision, life and disability insurance
• 403(b) retirement plan with employer contributions after 1 year of service
• Paid time off, including vacation, sick, personal, floating holiday, bereavement and observed federal holidays
• Parental support benefits, including adoption, fertility and surrogacy reimbursement and two weeks paid parental leave
• Free unlimited Relias professional development courses
• Annual professional development and tuition reimbursement funds
• Calm Premium access

About Us

The vision of the National Council for Mental Wellbeing is to make mental wellbeing, including recovery from substance use challenges, a reality for everyone. Despite overwhelming need, nearly 30 million people across the U.S. do not have access to comprehensive mental health and substance use treatment.

Founded in 1969, the National Council is a 501(c)(3) membership organization that drives policy and social change on behalf of more than 3,200 mental health and substance use treatment organizations and the more than 15 million children, adults and families they serve. We advocate for policies to ensure equitable access to high-quality services. We build the capacity of mental health and substance use treatment organizations. And we promote greater understanding of mental wellbeing as a core component of comprehensive health and health care. Through our Mental Health First Aid (MHFA) program, we have trained more than 3 million people in the U.S. to identify, understand and respond to signs and symptoms of mental health and substance use challenges.

The National Council is growing to meet this moment. We've more than doubled our dedicated team to 240+ employees since 2020. Although we have office space in Washington, D.C., we operate as a remote-first organization, with employees working from their various locations across the United States.

The National Council is proud to be an equal-opportunity employer. We embrace individuals from all backgrounds and perspectives, welcoming people of all races, ethnicities, religions, genders, sexual orientations, and ages, as well as veterans, people with disabilities, and those with lived experiences in mental health and substance use challenges to apply. We are committed to fostering a welcoming environment and recruitment process for everyone. If you require accommodation during the application process, please contact us at Recruiter@thenationalcouncil.org.