Job description The Business Intelligence Developer is responsible for performing data discovery and analysis activities in order to identify specific information required to support client decisions and then present these results in a meaningful and intuitive format, using a variety of BI tools and techniques. This is not a Data Science role and does not require the use of statistical techniques to analyze data. Responsibilities: Creates simple to complex Business Intelligence deliverables, including reports, dashboards, scorecards and presentations. Develops and maintains OLAP structures (cubes) to support client reporting needs. Acts as the first line of support for data questions and issues and strives to become data subject matter expert for client. Creates and executes unit tests and documents results. Supports functional, integration or system testing, and UAT. Supports implementation of solution into production. Creates and maintains design and production system documentation. Able to provide group or one-on-one training for BI tool and reports/dashboards Interacts directly with client stakeholders who are in business and/or technical roles. Follows and champions BI tool best practices. Provides effort estimates for report creation or changes performed by this role Manages BI tool vendor relationship for assigned clients, including escalation of issues, review of upcoming releases etc. Requirements (Technical): Proficient in use of SQL Proficiency using Tableau, knowledge of other Business Intelligence Tools a plus, (e.g. Business Objects, Cognos, Qlikview, Microstrategy) including: Creation/enhancement of reports and dashboards Use of calculated variables Use of custom formatting Report scheduling, including event-based triggers Automation of refreshes and delivery Proficient in BI tool administration functions including: Management of user security/access Data mapping/catalog changes (semantic layer) Archive and purge activities Performance tuning assessment and implementation Other tool maintenance, including installation of patches Familiar with data warehousing concepts and constructs, including star schema data models to be able to recommend aggregated data structures or calculated data elements in order to optimize report/dashboard performance. Familiar with accessing data stored on Big Data platforms (e.g. Hadoop, NOSQL) for data analysis and presentation purposes. Familiarity with performance tuning SQL, including use of explains plans, partitions, hints etc. OPTIONAL: Familiarity working with website analytics and social media data sources Requirements ( Non-Technical): Able to work independently and within small IT teams (5-10 IT professionals). Self-motivated and self-managing. Proficient in participating in design and code reviews. Proficient in identifying and communicating scope changes. Proficient in creating reasonable and accurate time estimates for assigned tasks. Strong interpersonal and verbal communications skills; proven experience with direct client interaction is preferred. Strong documentation skills; must have experience writing technical design documents
Key Skills: