Business Intelligence Analyst

The Johns Hopkins School of Advanced International Studies (SAIS) is a leading graduate school of international relations with a proven reputation for producing influential, innovative, and accomplished graduates with careers in government, business, journalism, international organizations, academia, and non-profits.

For 75 years plus, students have come to Johns Hopkins SAIS to build their professional networks, learn from renowned faculty, train with policy practitioners, and gain hands-on experience in the field of international affairs.

The school delivers cutting-edge graduate programming across its global campus locations in Washington DC; Bologna, Italy;

and Nanjing, China. By connecting the theoretical study of economics, international relations, and regional studies to the work of policymakers, students gain the knowledge, skills, and networks to succeed in a global era of economic instability, security challenges, poverty, inequality, and vulnerability.

To learn more about SAIS, visit www.sais-jhu.edu.

We are seeking a Business Intelligence Analyst who will work within the Data Analytics and Business Intelligence team, which reports up through Finance & Operations.

The Analyst will work on tasks and projects related to data integration, mining, analysis, and reporting, partnering across different facets of the School, including but not limited to : Admissions, Finance, Financial Aid, HR, Operations, Academic Affairs, and Student Billing.

Specific Duties & Responsibilities

• Support strategic data-driven decision-making throughout the school focusing on analytics that improve quality offerings, while optimizing financial returns, and ensuring financial sustainability.
• Extract data from various systems with coding skillset, while structuring the extracted data in useful ways to foster meaningful analysis and decision-making.
• Create graphs, infographics, and other methods to effectively visualize data.
• Design presentations and reports based on findings from data analysis.
• Become expert on the school's IT systems, their integration, and their management.
• Administer data integrity and governance across the school and its departments, helping to create and foster a culture of data sharing & hygiene, while designing and developing rules, processes, and definitions for how data is entered, categorized, stored, and reflected.
• Boost student success and foster institutional intelligence through the use of descriptive, diagnostic, prescriptive, and predictive analytics.
• Serve as a central resource for the school's various departments' ad hoc data analysis needs, with an emphasized focus in supporting senior leadership.
• Work with senior leadership and department leaders to identify opportunities for improvement in using data to drive more informed and optimized decision-making.

Special Knowledge, Skills & Abilities

• Excellent data & financial modeling skills, with an innate propensity for analytical problem-solving.
• Experience with student information systems or university administrative applications a plus.
• Experience with the following products is highly desired but not required : Sungard's MatrixStudent Information System (SIS), Technolutions Slate, College Board's PowerFAIDS, and SAP.

Proficiency in SQL queries and working knowledge of other query tools.

• Demonstrated proficiency in developing reports and models using SSRS, Tableau, Microsoft Power BI, or other similar tools.
• Ability to be resourceful and to work for long periods of time without direction in completing tasks, problem-solving, and project management.

If you are interested in applying for this job, please make sure you meet the following requirements as listed below.

Minimum Qualifications

• Bachelor's Degree.
• Two years of related experience.
• Additional education may substitute for required experience, to the extent permitted by the JHU equivalency formula. Additional experience may substitute for education.

Preferred Qualifications

• Master's Degree - Master's in a related field may substitute for some experience.
• Experience in SQL development, data visualization tools (i.e. Microsoft Power BI, Tableau, etc.), and Business Intelligence tools.
• Experience in Higher Education.

Classified Title : Business Intelligence Analyst

Role / Level / Range : ATP / 03 / PB

Starting Salary Range : $46,200 - $80,800 Annually (Commensurate with experience)

Employee group : Full Time

Schedule : Monday-Friday 8 : 00am-5 : 00pm

Exempt Status : Exempt

Location : Hybrid / District of Columbia

Department name : Finance and Administration

Personnel area : SAIS

J-18808-Ljbffr