Job Purpose:
The Business Intelligence Developer is responsible for design and development of enterprise-wide analytics and reporting solutions using data from multiple internal and external sources delivered using dashboards, scorecards, ad-hoc reports, managed reports and self-service reporting.
This individual is responsible for designing and building and delivering solutions using cubes and self-service BI tools to deliver accurate information to the business in a timely and consistent method.
Responsibilities:
· Design, develop, implement and support enterprise and departmental business intelligence solutions using the Microsoft Business Intelligence (BIDS) tool set (SQL Server)
· BI Semantic model and Analysis Services (SSAS) Cube development and deployment within a Production environment
· PowerBI and Reporting Services (SSRS) Report development against both cubes relational/dimensional data sources
· SQL Tables, Views, Functions and Stored Procedures (SQL Server 2008 R2, 2012, or newer)
· Ensure timely delivery of cubes and reports (daily, weekly, monthly, ad-hoc)
· Provide training and support to business users with ad-hoc analysis as needed
· Troubleshoot and resolve reporting issues as needed to support business users.
Job Dimensions
· Assist with coordinating people and initiatives
· A desire to work on a fun, innovative, company-advancing team
· Work involves several team and customer initiatives
· Understand company goals and applies them to solutions
· Receives only general instructions on new work
· Communicates with all levels of the organization
Specifications
· Education and Experience:
· Bachelor’s degree in Computer Science or related field.
· 1+ years’ experience in Business Intelligence development desired
Skills:
· Experience designing and deploying objects in the MS BI suite (SSIS/SSAS/SSRS)
· Experience using Business Intelligence tool (Power bi)
· Experience with SQL Server (2008 R2, 2012, or newer)