Data Analytics & Business Intelligence Manager in Malden, Massachusetts at Casa Esperanza

About Casa Esperanza

Casa Esperanza, Inc. is a bilingual/bicultural behavioral health treatment provider serving Boston and the Merrimack Valley. Our mission is to empower individuals and families to recover from addiction, trauma, mental illness, and other chronic medical conditions; overcome homelessness and discrimination; and achieve health and wellness through comprehensive, integrated care.

About the role

The Data Analytics & Business Intelligence Manager (DA&BIM) is responsible for the design, development, management, and optimization of organizational data systems, reporting solutions, and business intelligence tools. As part of the Information Technology Department, this position serves as the organization's subject matter expert for enterprise data management, reporting, analytics, and data warehousing initiatives across clinical, operational, financial, and administrative systems.

The DA&BIM works closely with leadership, program teams, finance, quality improvement, and external software vendors to ensure accurate, timely, and actionable data is available to support strategic decision-making, regulatory compliance, performance measurement, and operational excellence.

This role oversees data architecture, data integration, reporting development, business intelligence solutions, and data governance activities while supporting key enterprise applications, including Netsmart myEvolv.

What you'll do

• Data Warehouse Development and Management
• Collaborate with inter-departmental staff, technical contractors, and technology vendors to design, implement, maintain, and enhance the organization's enterprise data warehouse, data architecture, data mining, data cleansing, and other associated data pipelines.

• Ensure data integrity, consistency, security, and governance across reporting environments.

• Monitor and optimize database performance and data warehouse operations.

• Maintain comprehensive documentation of data structures, business rules, data definitions, and reporting logic.

• Identify opportunities to expand data aggregation (e.g., data warehousing) to integrate existing, disparate data systems (HRIS, billing, finance), reporting, dashboards, etc.

Data Management & Administration

• Maintain comprehensive knowledge of organizational data systems, including Netsmart myEvolv, REDCap, and other business applications.

• Design, develop, and manage data structures, databases, data warehouses, and reporting environments.

• Ensure data integrity, quality, consistency, and security across all systems.

• Develop and implement data governance standards, policies, and procedures.

• Perform data mining, cleansing, validation, and transformation activities.

• Identify and resolve data quality issues and system inconsistencies.

Reporting & Business Intelligence

• Serve as the organization's subject matter expert for reporting and analytics.

• Design, develop, and maintain interactive dashboards, scorecards, and data visualizations that support operational decision-making and communicate complex findings to technical and non-technical audiences

• Develop, automate, and maintain user-friendly reports and reporting solutions from single and multiple data sources that support clinical, operational, financial, quality improvement, compliance, research, and executive decision-making

• Ensure reports are accurate, meaningful, and aligned with organizational goals and compliance requirements.

Data Integration & Systems Development

• Develop and maintain integrations between enterprise systems.

• Work with information systems leadership to design and implement enterprise data warehouse solutions.

• Support upgrades, system enhancements, and implementation projects related to data management and reporting.

• Translate raw EHR data into structured, analysis-ready datasets for research, evaluation, and operational use.

Data Analysis and Outcomes Evaluation

• Collaborate with Research and Evaluation staff to develop analytical datasets and conduct statistical and descriptive analyses.

• Support program evaluation activities through data preparation, validation, interpretation, reporting, and actionable recommendations for leadership and program staff.

Business Analysis & Process Improvement

• Partner with internal stakeholders to identify reporting needs and business challenges.

• Assist departments in defining requirements, documenting processes, and developing data-driven solutions.

• Support quality improvement, compliance, accreditation, and performance management initiatives.

Strategic Planning & Leadership

• Participate in strategic planning related to enterprise data management and analytics.

• Monitor emerging technologies and recommend enhancements to reporting and business intelligence capabilities.

• Train and support end users in accessing, interpreting, and utilizing reports and dashboards.

• Develop documentation, data dictionaries, and reporting standards.

• Present findings and recommendations to leadership teams and stakeholders.

Qualifications

• Education
• A bachelor's degree in Computer Science, Information Systems, Data Analytics, Business Intelligence, Information Technology, or a related field is required.

• Master's degree preferred.

Experience

• Minimum of five (5) years of experience designing, developing, and managing databases, data warehouses, and business intelligence environments.

• Minimum of five (5) years of advanced SQL development experience.

• Minimum of five (5) years of experience creating and maintaining Crystal Reports or comparable enterprise reporting solutions.

• Minimum of three (3) years of business process analysis and improvement experience.

• Experience with statistical software such as SPSS, SAS, R, or Python.

• Experience extracting and transforming data from electronic health record systems

• Experience within healthcare, behavioral health, human services, or nonprofit organizations preferred.

• Experience with Netsmart myEvolv Electronic Health Record strongly preferred.

Technical Skills

• Advanced SQL Server development and database administration.

• Microsoft Power BI development and dashboard creation.

• Crystal Reports development.

• Data warehousing and ETL processes.

• Data modeling and database design.

• Data governance and quality management.

• Microsoft Office Suite, particularly Excel.

• API integrations and cloud-based reporting solutions.

Knowledge, Skills, and Abilities

• Strong analytical and problem-solving skills.

• Ability to translate complex data into meaningful business insights.

• Excellent written and verbal communication skills.

• Ability to manage multiple priorities and deadlines.

• Strong project management and organizational skills.

• Ability to collaborate effectively with technical and non-technical stakeholders.

• Commitment to confidentiality and data security.

• Knowledge of HIPAA, healthcare reporting requirements, and data privacy regulations preferred.

What we offer:

Casa Esperanza Benefits Package:

• Compensation: $87,000-$90,000 annual salary
• 401(k) Retirement Plan: All eligible employees may elect to participate after 1 year of service. Casa Esperanza, Inc. will match a contribution of up to 6% of your annual salary
• Holiday Pay (12 days per year + 1 floating holiday)
• Paid Time Off (PTO) - 18 days year one, 20.5 days at year two, 23 days at year five
• Sick Pay - 10 paid days per year
• Long/Short-Term Disability
• Paid by Company Life Insurance
• Health Insurance (Medical, Dental, Vision)
• Health Reimbursement Arrangement (HRA)
• FSA/DCA (Flexible Spending Account & Dependent Care)
• ComPsych Guidance Resources - EAP
• Educational Opportunities
• Tuition Remission
• Employee Ticket at Work (Discounts for Entertainment, travel, movies, etc.)
• Career Advancement Opportunities
• Increased Salary for Credentials
• and more...

Physical & Mental Requirements

While performing the duties of this job, the employee is regularly required to walk, stoop, kneel, crouch, or crawl and talk or hear. The employee must occasionally lift and/or move up to 20 pounds. Specific vision abilities required by this job include distance vision, peripheral vision, and depth perception.

At Casa Esperanza, Inc., the health and safety of our people is our number one priority. That’s why all offers of employment are contingent on the candidate showing proof of being fully vaccinated against COVID-19 (currently one dose of the Johnson & Johnson vaccine or two doses of the Pfizer or Moderna vaccine and a booster, when eligible) to pass the pre-employment requirements. Individuals with medical issues or religious beliefs that prevent them from getting the vaccine may request an exemption from the vaccine requirement.

Casa Esperanza’s EEO Statement

Casa Esperanza, Inc. values its diverse workplace and encourages women, people of color, LGBTQIA+ individuals, people with disabilities, members of ethnic minorities, foreign-born residents, older members of society, and others from minority groups and diverse backgrounds to apply.

We recruit, hire, employ, train, promote, and compensate individuals based on job-related qualifications and abilities. Casa Esperanza, Inc. also has a longstanding policy of providing a work environment that respects the dignity and worth of each individual and is free from all forms of employment discrimination, including harassment, because of race, color, sex, gender, age, religion or religious creed, national origin, ancestry, citizenship, marital status, sexual orientation, gender identity, gender expression, genetic information, physical or mental disability, military or veteran status, or any other characteristic protected by law. All employees, interns, volunteers, and contractors of Casa Esperanza, Inc. are responsible for maintaining a work culture free from discrimination and harassment by treating others with kindness and respect.

Casa Esperanza, Inc. also provides reasonable accommodation to qualified individuals with disabilities or based on a sincerely held religious belief, in accordance with applicable laws. If you need to inquire about an accommodation or need assistance with completing the application process, please email hr@casaesperanza.org.