Business Intelligence (BI) Developer

Job Address:

10123 Alliance Road, Suite 320, Blue Ash, OH 45242

CommuniCare Advantage , a Medicare Advantage plan affiliated with CommuniCare Health Services, is currently recruiting a Business Intelligence (BI) Developer .

Purpose/Belief Statement

The BI Developer will be responsible for the building of reports, dashboards, and KPI’s. This role will also lead projects to improve the usability, scalability, efficiency, and security of BI tools.

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 to ensure they are clean, accurate, and ensure data security.
• Collaborate with stakeholders.
• 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 in 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.).

Knowledge/Skills/Abilities

• Excellent customer service skills

• High level of curiosity

• Strong knowledge of industry standards and guidelines.

• Attention to detail.

• Outstanding written and verbal communication abilities

• Familiarity with computer and necessary software

• Strong proficiency with SQL and its variation among popular databases

• Experience with some of the modern relational databases.

• Skilled at optimizing large, complicated SQL statements.

• Knowledge of best practices when dealing with relational databases

• 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 prospective enrollees with respect and dignity.