Data Analytics & Business Intelligence Manager

About the role

TheData Analytics & Business Intelligence Manager (DA&BIM)is responsible forthe design development management and optimization of organizational data systems reporting solutions and business intelligence tools.As part of the Information Technology Departmentthis position serves as the organizations 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 ensureaccuratetimely 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 NetsmartmyEvolv.

What youll do

• Data WarehouseDevelopment and Management
• Collaborate withinter-departmentalstafftechnical contractors and technology vendors to design implementmaintain and enhance the organizations enterprise data warehouse data architecturedata mining data cleansing and other associated data pipelines.

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

• Monitor andoptimizedatabase performance and data warehouse operations.

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

• Identifyopportunities to expand data aggregation (e.g.data warehousing) to integrate existing disparate data systems (HRISbilling finance) reporting dashboards etc.

Data Management & Administration

• Maintain comprehensive knowledge of organizational data systems including NetsmartmyEvolvREDCap 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.

• Identifyand resolve data quality issues and system inconsistencies.

Reporting & Business Intelligence

• Serve as the organizations subject matter expert for reporting and analytics.

• Design develop andmaintaininteractive dashboards scorecards and data visualizations that support operational decision-makingand communicate complex findings to technical and non-technical audiences

• Develop automate andmaintainuser-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 areaccurate meaningful and aligned with organizational goals and compliance requirements.

Data Integration & Systems Development

• Develop andmaintainintegrationsbetween enterprise systems.

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

• Support upgrades system enhancements andimplementationprojects 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 toidentifyreporting needs and business challenges.

• Assistdepartments 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 andutilizingreports and dashboards.

• Develop documentation data dictionaries and reporting standards.

• Present findings and recommendations to leadership teams and stakeholders.

Qualifications

• Education
• A bachelors degree in Computer Science Information Systems Data Analytics Business Intelligence Information Technology ora relatedfield isrequired.

• Masters 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 andmaintainingCrystal 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 NetsmartmyEvolvElectronic 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: $87000-$90000 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. Thats 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 Esperanzas 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.

Required Experience:

Manager