The Senior Developer is a key member of the Insights and Analytics (I&A) team and is responsible for the development of business intelligence content for use by the Office of Alumni and Development (OAD) to enable effective decision making across the Alumni and Development community.
Responsibilities include but are not limited to the following:
Lead development of professional quality business intelligence, data visualization and analytics content in support of broader strategic priorities within OAD, primarily using Microsoft Power BI and data modeling via advanced PL/SQL
Co-lead the design, enhancement, and maintenance of high-quality data architectures that align with business requirements and improve data reliability, efficiency, and quality.
Understand and prepare raw data, apply data models using statistical methods and algorithms, and then extract and communicate useful results in easily digestible formats.
Utilize database query and scripting languages (such as PL/SQL) to create data extracts and establish datasets from OAD data sources for use in content delivered to end-users.
Standardize and simplify I&A products and resources, including model outputs and standard metrics, to promote shared data understanding and ease comprehension across OAD.
Consult regularly with colleagues and end-users to identify and resolve gaps in organization's BI offerings and data accessibility. Disseminate use cases and best practices associated with I&A tools and resources to the University's Alumni Relations and Development community.
Maintain proficiency in industry standard reporting and data delivery practices and software tools through self-guided learning, training, coursework, conference attendance, etc.
Ad hoc project assistance, as required.
Bachelor's degree required. Five (5) to seven (7) years of related work experience is required, with a minimum of two (2) years of work related to business intelligence content development and data extraction. Demonstrated proficiency in one or more of the following business intelligence and data visualization platforms (Microsoft Power BI, SSRS, Tableau, Qlik). Demonstrated proficiency in SQL is required, preferably in an Oracle (PL/SQL) environment. Proficiency with the Microsoft Office Suite and other common computer applications required.
Advanced degree is desirable. Additional familiarity with fundraising database applications, especially Advance, highly desirable.
Knowledge of common practices in the fields of alumni relations and development preferred. Ability to conceptualize and develop proactive approaches to support organizational goals, including sophisticated constituent database queries preferred.
Excellent oral and interpersonal skills and strong project management and problem-solving skills. Ability to work both independently and as part of a team in a demanding environment.
This position requires strong attention to detail and the ability to maintain confidentiality and handle sensitive information. Strong customer service skills and an exemplary attitude are required.
Ability to work efficiently in a virtual environment with off-site colleagues.
The successful candidate must be a strategic thinker, effective in moving strategic agendas, politically savvy, flexible in nature, and have a sound judgment with a collaborative style that fosters teamwork and cooperation beyond the immediate team to the broader organization. Must have a passion for excellent customer service, commitment to exceptional quality, and an ability to inspire colleagues toward accomplishing common objectives and goals.
Equal Opportunity Employer / Disability / Veteran
Columbia University is committed to the hiring of qualified local residents.
Internal Number: 505494
About Columbia University
Columbia University is one of the world's most important centers of research and at the same time a distinctive and distinguished learning environment for undergraduates and graduate students in many scholarly and professional fields. The University recognizes the importance of its location in New York City and seeks to link its research and teaching to the vast resources of a great metropolis. It seeks to attract a diverse and international faculty and student body, to support research and teaching on global issues, and to create academic relationships with many countries and regions. It expects all areas of the university to advance knowledge and learning at the highest level and to convey the products of its efforts to the world.