Business Intelligence Data Analyst

Job Title: Business Intelligence Data Analyst Department: Information Systems Reports To: Director of Data Analytics Classification: Full-time, Non-Exempt

Summary The Business Intelligence Data Analyst is responsible for providing meaningful business intelligence reports to various operational departments within the institutions served by Ember Education. This professional will develop and publish effective reports to support data-based decision making and provide insight on institutional strategy.

Essential Duties and Responsibilities

• Collaborate with professional staff to identify organizational reporting and analysis needs
• Develop and maintain a detailed knowledge of data systems and workflow processes in assigned department functions
• Acquire data from primary or secondary sources and develop integrated data sets
• Design and publish reports that enable users to interpret complex data and inform action
• Document and maintain data definitions and reporting methodologies

• 
  Other duties as assigned

Supervisory Responsibilities This position has no direct supervisory responsibilities.

Competency

Knowledge in DAX, PowerQuery, PowerPivot, TSQL, SQL Server and PowerBI

To perform the job successfully, an individual should demonstrate the following competencies:

Analytical Thinking - Synthesizes complex or diverse information; collects and researches data; uses intuition and experience to complement data; designs work flows and procedures. Problem Solving - Identifies and resolves problems in a timely manner; gathers and analyzes information skillfully; develops alternative solutions; works well in group problem-solving situations; uses reason, even when dealing with emotional topics. Manages Multiple Priorities - Handles multiple assignments and priorities yet still fulfills all commitments; readily accepts new responsibilities and adapts well to changes in procedures; gives appropriate priorities to various work demands. Quality Management - Demonstrates accuracy and thoroughness; looks for ways to improve and promote quality; monitors own work to ensure quality. Technical Job Skills - Possesses sufficient job skills and knowledge to perform the job in a competent manner; is able to demonstrate skills and knowledge in day-to-day situations.

Qualifications To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Education and/or Experience Bachelor's Degree from four-year college or university; or 4 years related experience and/or training; or equivalent combination of education and experience. Extensive knowledge and proficiency in: data management, workflow analysis, and business intelligence reporting.

Language Skills Ability to write and edit clear, succinct reports; ability to read, analyze and interpret common business process documents; ability to respond to common inquiries from staff, faculty, and external stakeholders; ability to write presentations and present information to top management.

Computer Skills To perform this job successfully, an individual should have 1) proficient knowledge of Microsoft Office Suite; 2) advanced technical capabilities with Excel, PowerPivot, DAX, and PowerBI; and 3) possess the ability to learn and adapt to multiple, evolving systems for customer relationship management, student information, learning management, and related technical platforms.

Physical Demands The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this job, the employee is regularly required to sit, use hands to finger, handle, or feel; reach with hands and arms; talk and hear. The employee is frequently required to walk. The employee is occasionally required to stand; climb or balance and stoop, kneel, crouch, or crawl. The employee must regularly lift and/or move up to 10 pounds, frequently lift and/or move up to 25 pounds and occasionally lift and/or move up to 50 pounds.

Work Environment The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this job, the employee is occasionally exposed to wet and/or humid conditions and outside weather conditions. The noise level in the work environment is usually moderate.