Business Intelligence Analyst

Position Information

University Code 24231 University Title Business Intelligence Analyst 1 University Job Family Information Technology ORP Eligible Yes For more information on ORP, visit: Retirement Plans
Recruitment Pool All Applicants Recruitment Type Single Title Scope of Search Local Working Title Business Intelligence Analyst Position Number 591870 Is this employee on a H1B Visa? No Position Type Staff Job Status Full-Time FLSA Indicator Exempt Employee Group University Employee Department School of Medicine Organizational Overview

At VCU, we Make it Real through learning, research, creativity, service and discovery — the hallmarks of the VCU experience. A premier, urban, public research university nationally recognized as one of the best employers for diversity, VCU is a great place to work. It’s a place of opportunity, where your success is supported and your career can thrive. VCU offers employees a generous leave package, career paths for advancement, competitive pay, and an opportunity to do mission-driven work.

Position Primary Purpose and General Responsibilities

As part of School of Medicine Technology Services (SOMTech) team and Application Services (AS) unit, the Business Intelligence Analyst position leverages data science, data engineering and data analytics to enable an audience of faculty, staff, students, leaders and other stakeholders to derive insights for data-driven decision making.

This position reports to the Senior Business Analyst and performs data acquisition and engineering to build Tableau/Power BI reports and dashboards, design data models, and interface with stakeholders across the enterprise for custom data visualizations and self-service APIs.

The Business Intelligence Analyst will support a broad portfolio of administrative, business intelligence, financial and educational systems for the School of Medicine, MCV Physicians, and the VCU Health Science campus.
• Research, design, develop, and test reports and dashboards for stakeholders across all business units and functions.
• Distill complex data and relationships into clear, concise charts and visualizations.
• Implement key recommendations by identifying cross-functional stakeholders, developing requirements, ensuring accurate implementation, monitoring impact, and optimizing results.
• Design data models and ETL data pipelines from a variety of sources to extract data from operational databases and transform the data to easily understood business views.
• Gather and process raw data into a form suitable user ingestion.
• Work closely with developers and stakeholders to design data warehousing, advanced analytics and appropriate use of BI client tools and technical components within BI client tools, and business intelligence solutions.
● Train end users on dashboards, BI tool usage, features and functionality, maintain and ensure up-to-date instructional materials and documentation repository for faculty, staff and students.

Minimum Hiring Standards

Proven experience with the following:

● Microsoft Technology Stack (C#, ASP . MVC, JavaScript, jQuery, HTML5/CSS3, SQL Server, SSRS, SSIS, Azure DevOps, Bootstrap, . NET /. NET Core).
● Developing Tableau and Microsoft Power BI dashboards and custom reporting.
● Developing Extract, Transform, Load ( ETL ) programs, data processing programs in a specific language for a specific platform.
● Scripting & Automation, Web Services APIs.
● Data integration, data modeling, data warehousing, and business intelligence concepts and technologies.
● Database design and the systems development life cycle ( SDLC ).
● Testing and quality assurance methodologies, automation, and tools.
● Strong systems analysis and design skills. Ability to handle multiple projects and conflicting priorities.
● Ability to listen and understand user needs and requirements.
● Highly motivated, reliable, detailed, and driven to produce high quality work.
● Ability to interpret and communicate information clearly and accurately, translate ideas and instructions both verbally and in writing.
● Superior presentation and communication (written and oral) skills; able to communicate complex concepts to a diverse audience of faculty, staff, students, leaders and other stakeholders.
● Ability to work in a diverse environment.

Preferred Hiring Standards

• Bachelors degree in business information systems, computer science, information technology or related field or equivalent education and experience is highly preferred.
• Experience in systems analysis, requirements gathering and specification documentation.
• Experience in technical writing, Q/A testing and systems training.

Required Licenses/ Certifications Anticipated Hiring Range $50,000 - $55,000 Application Process/Additional Information Campus MCV Campus Hours/Week 40 Normal Work Days/Hours M-F Job Open Date 03/02/2021 Posting will close on or before Open Until Filled Yes Job Category Information Technology Is this a restricted position? No Is this position eligible to participate in alternative work arrangements? No Sensitive Position No Resource Critical Yes Quick Link https://www.vcujobs.com/postings/103962 Posting Specific Questions

Required fields are indicated with an asterisk (*).

1. * Describe your experience translating business requirements into functional requirements.
   
   (Open Ended Question)
   
   
2. * Describe your experience in analyzing complex processes and developing business solutions to complex system issues.
   
   (Open Ended Question)
   
   
3. * Describe your level of knowledge and experience with Agile methodology.
   
   (Open Ended Question)
   
   
4. * Describe your experience and level of knowledge to write and decipher basic SQL statements
   
   (Open Ended Question)
   
   

Optional & Required Documents
Required Documents

1. Cover Letter/Letter of Application
2. Resume

Optional Documents