We're hiring for this position at Pomona College in Claremont (Los Angeles greater area). Let me know if you have any questions!
Advancement Business Intelligence & Reporting Specialist
Location: Pomona College, Claremont, CA
Employment Status: Regular Full time
Target Starting Pay: $6,368.33/month
The Advancement Business Intelligence and Reporting Specialist functions in a team environment, working closely with Advancement users throughout the division. This position acts as a business analyst and applies expertise in data warehousing and reporting; investigates and analyzes the feasibility of program requirements and develops data warehouse specifications; analyzes needs, designs, writes and tests dimensional models, dashboards and reports; and is responsible for the overall lifecycle management of the Advancement data warehouse and reporting infrastructure.
Bachelor’s degree in MIS or a related field or equivalent combination of education and experience is required. Experience with Data Warehouse design and implementation, data warehousing life cycle and dimensional modeling; Advanced Structured Query Language (SQL) programming experience including DTS and ETL; solid data warehouse skills and knowledge of data warehouse methodologies; solid business analyst skills; ability to complete complex analysis, design and programming projects; excellent written and oral communication skills; ability to multi-task and set task prioritizations. A minimum of two years of experience with Cognos and/or Tableau is preferred. Experience at an academic institution is preferred
Deploy professional skills in Cognos, Tableau, and language (SQL) programming, in collaboration with colleagues, to best promote the Advancement’s strategic interests. Demonstrate effective, accurate and clear communication with excellent verbal, written, interpersonal, and customer service skills. Operate computers proficiently with basic Microsoft Office software (such as Word, Excel, Outlook) and associated professional software. Use assigned technology/devices/equipment to achieve annual goals and maintain confidentiality. Working knowledge of report design methodology. Experience with Business Analysis and Process redesign. Advanced Structured Query Language (SQL) programming experience including DTS and ETL. Demonstrate solid data warehouse implementation and maintenance skills and methodologies. Must understand and communicate the mission and history of the College’s liberal arts environment.
The regular hours for this full time position are 8:00 a.m. to 5:00 p.m., Monday – Friday. Holiday, weekend and evening work hours may be required. Travel will be required. Regular hours may vary due to needs of the College or division.