The Data Analyst is an integral part of the data team at BHSB, which is tasked with helping all areas of work collaboratively advance Baltimore City's behavioral health system by bringing innovative thought to development and growth through the use of data. The incumbent analyzes and presents data in various formats for various audiences, including developing reports, presentations, and other documents. This position collaborates with other data team members to manage data and produce statistical analyses. A key priority is to prepare reports and presentations that inform ongoing activities across the organization to enhance behavioral health and wellness initiatives across Baltimore City and monitor and improve the quality of services delivered by the city's public behavioral health system (PBHS). This position also researches publicly available data relevant to BHSB's priorities and initiatives and incorporates it into analyses and presentations to inform planning and monitoring activities. This is a full time, exempt position reporting to the Director, Impact & Measurement, working in a hybrid work environment in Baltimore City, MD.
Essential Functions

• Design and conduct, quantitative and qualitative research studies and analyses, and develop structured interview protocols and content. Lead stakeholder interviews, conduct and direct literature reviews and environmental scans related to various projects, and evaluate the impacts for various populations.
• A strong understanding of the social determinants of health and the purpose of disaggregating data to assess if health outcomes and opportunities are distributed fairly across different groups and regions in Baltimore City is required.
• Collaborate with other members of the Data team and other BHSB teams to continuously improve data integrity and reporting effectiveness.
• Participate in data-related projects, including data normalization, data maintenance, and quality assurance.
• Extract, clean, transform, validate, and/or model data to understand or draw conclusions from it to inform decision-making and advance behavioral health and wellness.
• Perform data management tasks, including data checking and cleaning, creation, and maintenance of data dictionaries for datasets, merging data and creating and recording variables to prepare data for analyses.
• Recommend operating methods to improve processing, distribution, data flow, collection, and database editing procedures.
• Test data to identify data integrity issues and collaborate with other members of the data team to plan solutions.
• Perform data archive procedures within established guidelines.
• Collaborate with other members of the data team to make data accessible to BHSB staff and external partners.
• Present data in ways that are easily understood by all audiences.
• Consult with programmers and end-users concerning the outline of data requirements.
• Troubleshoot problems concerning database records and communication with end users of the system.
• Implement appropriate methodological procedures for statistical analyses such as overall descriptive statistics, exploratory data analysis, including graphs, summaries, and necessary transformations and confirmatory data analysis.
• Research publicly available data relevant to BHSB's priorities and initiatives and incorporate it into analyses and presentations.
• Collaborate with internal and external partners to analyze, summarize, and present data in various formats, including raw output, tables, graphics, oral, and written reports.
• Collaborate with community members to respectfully seek their advice and information about the community related to various programming, research, and indicators.
• Prepare written reports of statistical analysis.
• Collaborate with other BHSB staff as needed to support implementation of analyses.
• Complete ad hoc data projects as assigned.
• Train end-users on how to use Power BI reports and Power Apps applications effectively.

Other

• Work effectively and collaboratively with others, both internally and externally.
• Uphold and operationalize the values of BHSB, which are Integrity, Equity, Innovation, Collaboration and Quality.
• Consistently work to apply a lens of equity, inclusion and anti-racism.
• To perform assigned work functions, this position and those it supervises may have access to protected health information (PHI). It is expected that the employee will operate from a place of integrity and assume an ethical obligation to protect the privacy and security of all PHI accessed by any employee on the team and will follow all of BHSB's policies and procedures related to the Health Insurance Portability and Accountability Act (HIPAA).
• Serve as part of BHSB's disaster response team as needed, in any capacity that is needed.
• Perform other duties as assigned.

Education and experience:

• Master's degree from an accredited college or university in public health, social work, epidemiology, biostatistics, or closely related field that provides training in practical data management and analysis in the public setting with coursework in epidemiology.
• Minimum two (2) years of experience post-Master's degree in applied data management and analysis.

General Skills

• Knowledge of behavioral health and population health data.
• Understanding and application of social determinants of health and health equity.
• Strong communication skills in explaining technical aspects of a project to non-technical staff.
• Ability to take ownership of tasks and be accountable for progress.
• Excellent verbal and written communication skills, with the ability to effectively document procedures.
• Self-motivated and willing to proactively address issues.
• Ability to manage multiple tasks and projects simultaneously.
• Attention to detail.
• Ability to interact in a virtual environment

Technical Skills

• 2-4 years' experience utilizing MS Excel and MS Power BI features and statistical packages such as SAS, SPSS, and/or STATA software.
• 2-4 years' experience working with health and/or behavioral health data.
• Demonstrated knowledge and application of data cleansing and migration techniques.
• Strong MS SQL skills.
• Demonstrated analytical skills and passion for analyzing data.
• Experience with data modeling.
• Ability to investigate data issues and participate in remediation activities.
• Ability to use statistical and data analysis skills to solve data quality issues.
• Ability to review detailed documents to validate data in operating systems.
• Familiarity with IDC9 and IDC10 coding.

Supervisory Requirements: This position has no supervisory responsibilities.
This role may require travel to other locations for meetings and other business-related needs.Ability to travel locally 25% of the time is required. It is important to have access to some form of transportation to travel to off-site meetings, conferences, and site visits.
Total Rewards:
BHSB's compensation strategy is based on our values and culture and is a step in our work toward becoming a justice-oriented, antiracist and inclusive organization. The organization offers its employees a competitive compensation package which includes base pay, comprehensive benefits plan and equitable, hybrid, family friendly work environment and practices.
This means that starting salaries are based on the requirements of each job and are non-negotiable, that the organization is not favoring people who are comfortable asking for a salary/hourly rate increase. The starting hourly/ annualized salary rate for this position is $86,965.
The benefits plan includes comprehensive Medical and HRA, Dental and Vision coverage, as well as a choice of 4 FSA plans and an employee paid Legal benefit. BHSB offers employer paid life insurance, short-term and long-term disability as well as a 403(b) plan with employer contribution, generous PTO and 13 days paid holiday. Medical plan participants receive a $5,000/$10,000 debit card to cover eligible deductible and copay expenses, depending on chosen coverage.
Culture:
BHSB is a nonprofit organization that provides leadership in advancing behavioral health and wellness. We advocate for and help guide innovative approaches to prevention, early intervention, treatment and recovery to help build healthier individuals, stronger families and safer communities. We work to demonstrate cultural competence and a commitment to the infusion of equity and inclusion principles into all areas of our work.
BHSB respects and values diversity and is committed to creating a culture that is inclusive. BHSB is proud to be an Equal Opportunity Employer. BHSB strives to embody Integrity, Equity, Innovation, Collaboration and Quality in all of our work. We work to demonstrate cultural competence and a commitment to the infusion of equity and inclusion principles into all areas of our work.
BHSB - About Us
This position works within the Accountability Department. Accountability works collaboratively with behavioral health provider organizations to support high-quality behavioral health services in Baltimore City. This department provides oversight and support for providers in various ways, including training and technical support, compliance audits, and the facilitation of consumer quality improvement activities. The team also manages the investigation of provider complaints and critical incidents and facilitates a data-driven approach to BHSB's work