The Business Intelligence and Reporting Analyst (Analyst) is responsible for managing the Office of College Advancement’s (OCA) databases, including data warehousing, integration, in-depth data analysis reporting, and dashboard development. Reporting directly to the Director of Advancement Services, the Analyst is responsible for the overall lifecycle management of the Advancement Data Warehouse and reporting infrastructures. The Analyst is responsible for building, implementing, and maintaining data integrations between various databases within Advancement and throughout Harvey Mudd College. Under direction of the Director, the Analyst aids in the effort to create, implement, integrate, assess, and improve—on an ongoing basis—the College’s infrastructure and strategies required to conduct successful overall advancement efforts.
In the Summer of 2019, OCA completed a database conversion to Blackbaud Raiser’s Edge NXT. The Analyst will be instrumental in the next phase of the project by creating and implementing a data warehouse and associated reports/dashboards.
The Analyst must be a highly collaborative, customer centric individual who has a proven track record of effective communication skills, both verbal and written, that will thrive in a fast-paced team environment. By defining realistic timelines and goals, the Analyst must be able to advance multiple projects with competing priorities and deadlines with minimal supervision.
About Harvey Mudd College:
Located in the heart of Claremont, California, 35 miles east of Los Angeles, Harvey Mudd College is a highly selective undergraduate liberal arts college offering degrees in science, technology, engineering and mathematics. HMC enrolls about 800 students and is a member of The Claremont Colleges, which comprises five undergraduate colleges and two graduate institutions. According to students, professors, and alumni, what makes Harvey Mudd distinctive is its collaborative, cross-disciplinary nature. The working environment is built on collaborative relationships between and among all members of the campus community and a deep commitment to the College’s mission to educate students “so that they may assume leadership in their fields with a clear understanding of the impact of their work on society.”
sUMMARY OF ESSENTIAL Duties and Responsibilities
Lead the design and implementation of a a data warehouse, ensuring departmental data is easily accessible for reporting and analysis, while safeguarding the data’s security. Maintain the data warehouse after implementation.
Gain expert level knowledge of source system tables, application business rules, and data challenges facing OCA.
Support members of the Advancement Services Team and other subject-matter experts to clean, transform, aggregate, and summarize data as needed to populate the data warehouse.
Develop and maintain clear documentation on OCA’s data warehouse, ensuring staff members can effectively support the data warehouse in Analyst’s absence.
Monitor the OCA data warehouse to ensure nightly population processes complete successfully and identify errors.
Through coordination with HMC’s IT Department (Computing and Information Services or CIS), lead the effort to develop and deploy optimal solutions that support the OCA data warehouse. Perform routine administration of system maintenance activities.
Reporting & Analysis
Collaborate with fellow OCA team members and interpret their requests to design, program, and deliver customized reports and dashboards tailored to fit their needs, ensuring data accuracy and consistency.
In collaboration with the Director, design solutions to improve workflows and streamline processes.
Develop and maintain clear and complete documentation on all reports and dashboards.
Engage with the Advancement Services team and key stakeholders to ensure regular data validation scripts and queries are executed.
Train power-users to be able to pull ad-hoc queries and/or reports.
Develop integrations in Dell Boomi, or when necessary other techniques, to allow for fast and consistent data flow between various OCA databases (Blackbaud Raiser’s Edge NXT, iModules, Salesforce Marketing Cloud, etc.) and, through partnership with CIS resources, other HMC databases (Workday, Identity Access Management, etc.)
Develop and maintain clear and complete documentation on integrations to be shared throughout the campus, ensuring clarity between departments around data flows and system of record details.
In coordination with CIS, pass data from Advancement to other College databases.
Manage security and access for all users within Blackbaud Raiser’s Edge NXT, Power BI, and other OCA databases/reporting tools.
Assist end-users with issues utilizing Blackbaud Raiser’s Edge NXT, coordinating with Blackbaud Support or HMC CIS when necessary.
In collaboration with the Director, aid in the creation and implementation of departmental policies and procedures to ensure compliance with the College’s policies regarding data security and privacy, document retention, and other relevant policies.
Maintain strong working relationships with OCA’s various vendors, ensuring awareness of upcoming enhancements, maintenance windows, etc.
Maintain a close working relationship with both HMC’s CIS and the IT departments throughout The Claremont Colleges and The Claremont Colleges Services (TCCS) through effective communication and collaboration on common data projects.
Through in-person or virtual training, classes, conferences, or similar, keep current with the latest trends in data management and analysis technology. Partner with the Director to roll out new features/enhancements to the department.
As required, participate in the assessment, evaluation, and selection of vendor products related to OCA and HMC data to support the department’s and College’s mission.
Represent OCA on various data-related committees throughout HMC, including the HMC Data Governance and Standards Team (DGST).
Perform other responsibilities and tasks as assigned.
Required Qualifications and Experience
Education & Experience:
Bachelor’s degree in Computer Science, Information Systems, Business System Administration or related field. Or any combination of relevant education, training, and experience that provides the required knowledge, skills, and abilities of the position.
Minimum five years’ experience with data analysis and reporting.
Minimum three years’ experience designing, implementing, and maintaining data warehouses.
Minimum three years’ experience building and maintaining data integrations and APIs.
Minimum two years’ experience database administration.
Advanced degree in Computer Science, Information Systems, Business System Administration or related field.
Dell BOOMI Developer Certification or equivalent experience with other integration tools such as Snaplogic, Informatica, or Workato; familiarity with RESTful Web Services and APIs.
Experience in higher education and/or fundraising/advancement, including an understanding of the advancement processes and terminology.
Familiarity with Workday, Salesforce Marketing Cloud, Import-O-Matic, and/or iModules.
Experience with maintaining Windows Server 2012/2016 systems.
Knowledge of Microsoft Flow and Power Apps.
Required Knowledge, Skills and Abilities:
Proven experience with data warehouse design and implementation, data warehousing life cycle and dimensional modeling.
Advanced SQL programming experience.
Extensive experience with Microsoft Power BI, Query Editor, M, Report Builder (paginated reports), etc.
Advanced experience writing and troubleshooting issues with SQL queries, scripts, or stored procedures to perform ETL (Extract, Transform, and Load) processes.
Excellent information technology skills with aptitude to learn and effectively utilize a variety of software tools at a “power user” level.
Demonstrated experience building and maintaining APIs. Experience in data systems integrations involving multiple data sources of varying complexities.
Project management experience with demonstrated ability to estimate, plan, prioritize, and deliver projects on time.
Extremely high level of attention to detail and proven ability to problem solve.
Ability to communicate in a clear and concise manner whether verbally, in writing, or in person.
Experience communicating with a wide variety of audiences, tailoring the level of technical detail in explaining complex ideas accordingly.
Frequent sitting for extended periods of time. Constant use of keyboard. Specific vision requirements include close vision, distance vision, and the ability to adjust focus. Occasional moderate lifting of 10-20 lbs.
Hours: The regular office hours of this position are 8:00 a.m. to 5:00 p.m. including a one-hour meal period, Monday-Friday. Hours may vary due to the needs of the College or department. Occasional evening and weekend hours may be required.
Classification & Status: This is a full-time, regular, 12-months per year, benefits-eligible, exempt position.
Reports to: Director of Advancement Services.
Please visit www.hmc.edu/employment to view a complete job description for this position and obtain information about how to submit an application. Information about HMC’s competitive benefits package is available at www.hmc.edu/hrbenefits.
Deadline to apply:
Position will remain open until filled.
This job description defines the essential job duties of the position. Harvey Mudd College expects that employees hired for this position can perform the essential functions of the job without imposing risk of substantial harm to the health or safety of themselves or others. It may also include marginal functions, generally defined within Title I of the Americans with Disabilities Act.
Regular employment at the College is for no specified period of time; conditions and status of employment (hours, pay, title, duties, etc.) are subject to change at any time. Employment is at-will and employees, and likewise the College, are free to end the employment relationship at any time, for any reason, with or without notice or cause, unless otherwise prohibited by law.
The Claremont Colleges, a consortium of five undergraduate liberal arts colleges, two graduate institutions, and Claremont University Consortium, which provides shared institutional support services, is reminiscent of the Oxford-Cambridge model. The undergraduate colleges include Pomona College, Scripps College, Claremont McKenna College, Harvey Mudd College, and Pitzer College. The two graduate institutions include Claremont Graduate University and Keck Graduate Institute.
BACK TO TOP
MPA Career Center is Just One of the Benefits.
Discover what else MPA has to offer!
The job you are trying to reach from was originally posted at MPA Career Center.