Manager, business intelligence developer
Location: Cincinnati, OH
Pay Based on Experience
The Business Intelligence Developer will be responsible for developing, maintaining, testing and implementing BI concepts, data modeling, data warehouse, reporting and dashboards. The Business Intelligence Developer reviews, analyzes and modifies database systems including relational database and installation to support the applications systems of the organization. This role relies on experience and judgment to plan and accomplish goals. A wide degree of creativity and latitude is expected.
ACCOUNTABILITIES
- Work with business process owners to understand the business need and develop technical solutions that integrate existing and future applications into the organization's information systems
- Must have technical experience with SQL, ETL, OLAP and Multi-Dimensional eXpressions (MDX)
- Support various database (including cube) within the data warehouse
- Proven communication and problem-solving skills are critical to successful performance in this role
- Understanding of integration services, Analysis Services, Reporting Services and SQL 2008
- Generate SQL Database reports from existing database using BI tools (Tableau)
- Logical and Physical Data Modeling experience using data modeling tools
- Design, develops, implements all ETL processes
- Maintain and support MS CRM 2013
- Provide data management expertise to the company by evaluating requirements and developing solution
QUALIFICATIONS
- Ability to query and create reports from relational databases using SQL or standard report writing tools such as Business Objects, Microsoft SQL Server Reporting Services, Integration Services and Analysis Services
- Ability to apply business and industry knowledge to internal applications, databases and systems
- Additionally, the position requires developing, reporting from, and integrating existing applications.
- Must have an in-depth knowledge of Microsoft SQL Server Business Intelligence platform tools
- Ability to train users and be resourceful with the ability to work independently
- Minimum of a BS or equivalent in business/computer science
- A minimum of 4-6 years of Data Warehouse and BI/Analytics experience
- Excellent presentation, written and verbal communication skills
- Ability to work effectively with clients and other technical staff
- Experience using data visualization software tools a plus