BI Developer / Business Intelligence Analyst

CommuniCare Health Services
Blue Ash, United States of America
1 month ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Intermediate

Job location

Blue Ash, United States of America

Tech stack

Microsoft Excel
Artificial Intelligence
Data analysis
Information Systems
Databases
Data Cleansing
Data Files
Data Security
Data Warehousing
Relational Databases
Database Queries
Lookup Table
Microsoft Business Intelligence
Pivot Tables
Power BI
SQL Databases
SQL Server Reporting Services
SQL Server Integration Services
Database Engines
Tableau
Information Technology
Software Version Control

Job description

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., * 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.

Requirements

Do you have experience in VLOOKUP function?, Do you have a Bachelor's degree?, * 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.

Apply for this position