BI Developer / Business Intelligence Analyst

dress: 10123 Alliance Road, Suite 320 Blue Ash, OH 45242 Description and Purpose: The Business Intelligence Analyst will be responsible for the building of reports, dashboards and KPI's. Will lead projects to improve the usability, scalability, efficiency, and security of BI tools. Will lead the analysis of data discrepancies and validation. Will identify the development needs for the purpose of streamlining and improving the operations of the organization for efficiency and profitability. Job duties & responsibilities Design and develop BI reports and dashboards. This involves understanding the business requirements, designing the data model, and developing visualizations that provide actionable insights. Manage data sets, ensuring they are clean, accurate, and ensure data security. Collaborate with stakeholders. Create and maintain documentation that includes the design, requirements, and user guidance for the organization Train end-users Troubleshooting and maintenance Need to stay updated with the latest features, updates, and best practices to leverage them effectively. Qualifications & Experience requirements Requires a BS or MS in computer science or information system. Over five years of experience in data preparation, data gateway, and data warehousing projects Over five years of experience working with the Microsoft Business Intelligence Stack Expertise of SQL queries, SSRS, and SQL Server Integration Services (SSIS) including DAX Three to four years of experience with a self-service tool such as Power BI or Tableau Must be highly proficient with MS Excel (VLOOKUP function, pivot tables, charts, etc.). Over 2 years of experience in the application of AI technologies Knowledge/Skills/Abilities Excellent customer service skills Strong knowledge of industry standards and guidelines. Outstanding written and verbal communication abilities with attention to detail Familiarity with computer and necessary software Experience with some of the modern relational databases. Skilled at optimizing large, complicated SQL statements. Capable of configuring popular database engines and orchestrating clusters as necessary Ability to plan resource requirements from high level specifications. Capable of troubleshooting common database issues Familiar with tools that can aid with profiling server resource usage and optimizing it. Proficient understanding of code versioning tools Must have high ethical standards and treat others with respect and dignity. Work environment May work beyond normal working hours, on weekends and holidays, when necessary. Is subject to frequent interruptions. Time sensitive tasks and responses May require field-based work. May require occasional overnight travel will be required as times with field-based assignments. Since 1984, CommuniCare Family of Companies has been committed to delivering exceptional person-centered care as a national leader in post-acute care for those that are chronically ill or have complex conditions. Our more than 150 skilled nursing, assisted living, and long-term care facilities deliver sophisticated and transformative care to nearly 16,000 residents and patients at any given time. CommuniCare employs more than 19,000 employees across six states (Ohio, Indiana, Maryland, Virginia, West Virginia and Pennsylvania). As a family owned and operated company, family and heart are woven into every aspect of our continuum of care. Our mission, to serve with pride, is evident and a quality residents, families and community partners have come to expect and trust. Dedicated to improving the lives of seniors, we put extraordinary service above all else. We continue to raise the bar and innovate wherever possible to deliver a higher quality of life for those far beyond our facilities. Because of this, our facilities are a better place for residents to live, patients to stay, employees to work and families to heal.