BUSINESS INTELLIGENCE ANALYST
BUSINESS INTELLIGENCE ANALYST
University Advancement at Virginia Tech is seeking qualified candidates for a Business Intelligence Analyst position in Blacksburg, VA. Reporting to the Data Reporting Manager, the Business Intelligence Analyst will be an integral member of the Advancement Division data reporting team. The analyst will serve the division in the advancement of departmental objectives and strategic development and alumni relations initiatives, with a particular focus on the design, implementation, and support of new reporting capabilities and technologies.
Primary Job Responsibilities Include:
Understand and prepare raw data, apply data models using statistical methods and algorithms, and then extract and communicate useful results in easily digestible formats.
Provide business intelligence, reporting and analytics in support of broader strategic priorities using internal and external data sources via available reporting and analytics platforms.
Use innovative and proactive approaches in reporting, analysis and visualizations.
Develop custom reports and dashboards and researching new and developing business intelligence technologies, tools and techniques.
Independently research and develop proof of concept solutions to demonstrate benefits of new technologies and/or complex forecasting models and constituent behavioral models.
Maintain proficiency in cutting edge analytical techniques and tools.
Oversee the deployment of data to the data warehouse by creating and deploying ETL packages.
Develop and embed dashboards and various visualizations within Blackbaud CRM and work with clients to determine business requirements, priorities and key performance indicators.
Participate in activities related to the integration of Blackbaud CRM with other platforms.
Participate in the work stream planning process including inception, technical design, development, testing and delivery of BI solutions.
Additionally, the Analyst will be assisting with various priorities driven by a technology product initiative within the advancement division, providing the ideal candidate with the opportunity
to solve new challenges and initiating new processes that will result in a broader university
The Business Intelligence Analyst communicates with the Data Reporting Manager and/or Director of Information Systems regarding deliverables, progress and quality and helps spread and share technical skills with others in the organization.
Minimum requirements for the position are: Master's degree in Information Technology, Information Systems, Business Administration or related field. One year experience with the following required: Using Business Intelligence/Analytics tools (E.G. SQL, SAS, R, Python, Microstrategy, Microsoft Power BI, Tableau); Working with complex data in a relational database environment; Creating and managing MS SQL Server Reporting Services (SSRS) reports, SQL Server Analysis Services (SSAS) AND SQL Server Integration Services (SSIS); Data warehousing, data mining, OLAP reporting, and/or predictive analysis; and Programming experience with writing complex T-SQL queries.
Must also: Exhibit robust object oriented programming, scripting and coding experience; Demonstrate ability to work professionally and collaborate effectively as a productive team and/or committee member; Demonstrate ability to work independently, manage multiple priorities concurrently, adhere to project timelines, and exercise confidentiality when working with sensitive issues and materials; Demonstrate success in building and maintaining customer relationships at multiple levels; Possess ability to understand and find appropriate applications for data and analysis results; Possess excellent ability to solve problems efficiently and strong ability to learn quickly and attention to detail; Possess excellent communication, critical thinking, interpersonal, and presentation skills; and Possess an in-depth understanding of the business environment and an interest in going beyond the obvious, delving into the source, the definition, philosophy, and foundational roots of a data element in order to create information.
Criminal conviction check required.
Offered Salary: $81,765/yr
Please apply online:
Virginia Tech is an EOE employer.