Job Address:

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.