Philanthropic Analytics DeveloperPrint (https://www.governmentjobs.com/careers/colorado/jobs/newprint/4535071) Philanthropic Analytics DeveloperSalary$94,000.00 - $98,600.00 AnnuallyLocation Denver, COJob TypeFull TimeJob NumberCU33808DepartmentUniversity of Colorado - System AdministrationOpening Date06/06/2024Closing Date6/21/2024 11:59 PM MountainFLSADetermined by PositionPrimary Physical Work Address1800 Grant St Denver, CO 80203FLSA StatusExempt; position is not eligible for overtime compensation.Department Contact InformationSystemHR.Recruiting@cu.eduType of AnnouncementThis announcement is not governed by the selection processes of the classified personnel system. Applications will be considered from residents and non-residents of Colorado.How To ApplyOnline applications through the Colorado Jobs portal will not be accepted. Please follow instructions on the job announcement for submitting an application.
Description
Benefits
Department InformationTo apply, please go to:https://cu.taleo.net/careersection/2/jobdetail.ftl?job=33808Who We Are:System Administration, which also houses the Office of the President, is located in the uptown neighborhood of Denver with a few smaller offices located on the campuses. Many of our departments support the educational and research missions of the four University of Colorado campuses, but System Administration is not considered a campus. We provide diverse opportunities for professional development, innovation, and collaboration with talented staff and faculty. Learn more about CU System Administration (https://www.cu.edu/cu-careers/cu-system) .The CU System Office of Advancement provides excellent customer service, strategy, expertise, and efficiency to our partners on CU’s campuses and at the University of Colorado Foundation. We support CU’s fundraising and engagement goals through advancement operations that include constituent research and development, data management, business intelligence, technical architecture, annual giving, planned giving, gift administration, marketing and communications, IT, budget and finance, and more. We believe that a healthy office culture is foundational to our success. We create this by bringing together a diverse team of colleagues and infusing our core values—Work Together, Think Big, Be Good and Have Fun—into our work every day. Position Summary:The Philanthropic Analytics Developer at the University of Colorado Office of Advancement reports to the Assistant Director of Advancement Technical Architecture and is responsible for providing superb customer service and application support to internal partners, campus partners, and the President’s office for business intelligence, reporting, and data analysis needs. The Analytics Developer will turn data into critical information and knowledge that can be used to advise sound business decisions.This position reports to the Assistant Director of Advancement Technical Architecture and is exempt from the State of Colorado Classified staff system.Where You Will Work:The CU System Office of Advancement follows a “flexibility first” approach to work that defines how we manage and make use of in-person time. As a fully remote position, this role will work remotely with the exception of four separate callback weeks per year— when all our colleagues are expected to be together in the office. During callback weeks, this role is expected to work from the CU System office at 1800 Grant St. in Denver, Colorado. Any additional in-office time will be determined by this roles direct manager. Description of JobDuties and Responsibilities: Philanthropic Segmentation Support
Understanding philanthropic giving data and data structure within the CU Ascend CRM or similar CRM
Designs, develops, implements, and maintains campus partner and vendor related data integrations for Campus Annual Giving and Grateful Patient program efforts with vendors such as Ruffalo, Noel, Lovitz (RNL) and others as identified and advised by the campus philanthropic teams based on their needs
Implements standard processes for philanthropic related reporting and segmentation efforts
Performs philanthropic data segmentation pulls and related ad-hoc data pulls
Assists in extraction, transformation, and loading (ETL) of data into usable data format for reporting
Builds and maintains data marts or other reporting structures within the Oracle Operational Data Store (ODS) to be used for reporting and segmentation efforts
Translates business requirements into specifications used to drive a data mart/data model design and configuration
Makes responsible recommendations regarding reporting and information system issues and exercises judgement and discretion in resolving work requests of varying complexity
Analytic Application Support
Develops and maintains documentation of standard and customized data structure and application administration needs
Researches, implements, and develops future state tools and software useful for additional reporting and segmentation capabilities
Collaborates with BI Analysts in developing and detailing specifications for data structure improvements and modifications
Assists with environment upgrades and migrations as needed
Actively participates as a member of the team in project initiatives and decision-making opportunities
Project Management
Conducts technical feasibility for projects, working multi-functionally as needed
Works with Central Advancement leadership and partners to manage and complete projects for the Advancement Data Council and Advancement System Work Plans
Crafts and maintains project management documentation, including standard project summaries and goal timelines
Assists enterprise data readiness by crafting, developing, and deploying solutions within the various data platforms
Collaborates with Central Advancement teams on initiatives related to enterprise reporting, sophisticated analysis, and ad hoc reporting
Uses Agile project management methodologies to help ensure timely, quality results
Partner Success
Engages with campus, foundation, and central partners and builds collaborative working relationships
Consults with clients to determine specifications for data requests, project design, and data application needs
Works closely with clients to build, test, craft, and implement data structure and connection solutions including sophisticated table creation and automated extraction processes
Collaborates with clients to translate data needs into actionable objectives and outcomes
Provides technical assistance and cross training of end users and technical support staff in use of internal and external data technologies
Professional Development & Training
Engages in technical training and professional development opportunities to maintain innovative industry skills and deepen business knowledge
Participates in presentations, trainings, and workshop sessions related to platform/application navigation and configuration
Minimum Qualifications, Substitutions, Conditions of Employment & Appeal RightsMinimum Qualifications:
Bachelor’s degree from an accredited institution of higher education, or equivalent professional experience (the educational requirement may be substituted with professional experience on a year-for-year basis)
Three (3) years’ experience PL/SQL developer in an Oracle or similar coding environment
Preferred Qualifications:
Bachelor’s degree in Business Analytics, Decision Sciences, Statistics, Information Systems, or other related field of study. (professional experience may be substituted for the educational requirement on a year-for-year basis)
Five (5) years’ experience as detailed above
Three (3) years’ experience utilizing Analytic Applications to develop, maintain, and update business intelligence reports
Experience in the following:
Working in a higher-education, healthcare, non-profit, and/or advancement setting
Customer relationship management (CRM) software, particularly Salesforce or other higher education constituent database software
Development programming languages (such as Java, JavaScript, Python, Salesforce Apex etc.)
Relational databases in an Oracle client/server environment
SQL and writing queries against complex database structures
Logical and physical data modeling concepts
Cognos or other common standard BI tools
Annual Giving fundraising
Data segmentation and identifying data trends
Knowledge, Skills, and Abilities:
Knowledge of business intelligence principles and standard processes, including data management and reporting processes
Knowledge of logical and physical data modeling concepts
Knowledge of Web Development programming languages (such as Java, JavaScript, jQuery, PHP, aspx, etc.)
Interpersonal skills, including the ability to facilitate interaction, communication, and teamwork between others
Oral, written, and listening communication skills to accurately interpret what others are saying and convey messages, information, concepts, and details clearly
Analytical, logical, and problem-solving skills to analyze data and trends in order to produce results
Ability to use or demonstrated skills to learning the following:
Microsoft Office Suite
SQL/SOQL Query Tools
Salesforce ascend applications, or similar
Salesforce reports and dashboards
Cognos, Tableau, or similar BI tools
ETL and other integration tools such as Talend, Jitterbit, or others
Familiarity with the practice of Advancement or Philanthropic Giving related programs
Ability to work independently and multi-functionally to meet personal and team goals
Ability to provide technical assistance to key partners to articulate technical information to non-technical users in accessible terms
Ability to discern requirements and perform detailed analysis to determine appropriate design.
Ability to maintain confidentiality of information
Ability to manage multiple concurrent projects, follow-up with partners, meet goals, and bring projects to completion
Ability to quickly learn new technologies and their application environment
Ability to use structured query language (SQL) to write queries against sophisticated database structures
Supplemental Information
How to Apply:
For full consideration, please attach the following as separate documents to your application by June 21st athttps://cu.taleo.net/careersection/2/jobdetail.ftl?job=33808:
A cover letter identifying the job specific minimum qualifications you possess
A resume including any and all relevant experience to be accurately assessed against the qualifications listed in the posting.
Benefits:With our unparalleled range of benefits, including top-notch healthcare, comprehensive wellness programs, enriching professional development, and a dynamic work-life balance, we ensure your holistic growth and happiness.
No-cost or low-cost medical & dental plan options, some inclusive of IVF assistance.
Disability, Life, Vision Insurance options.
Multiple retirement planning options including a mandatory 401(a) plan where CU contributes 10% of your gross pay, a 401k or 403b plan and a 457 deferred compensation plan.
Pre-tax savings plans, such as Health care and Dependent care flexible spending accounts.
Embrace a healthy work-life balance with ample sick and vacation leave, along with at least 12 paid holidays. This includes a dedicated week off for winter break.
4 weeks of parental leave to adjust to the joys of parenthood.
A tuition benefit program for you and/or your dependents.
Free RTD EcoPass and Free Onsite Parking at our 1800 Grant Street Office.
Many additional perks & programs with the CU Advantage (https://advantage.cu.edu/) .
Additional taxable fringe benefits may be available. For more information on benefits programs, please review ourComprehensive Benefits Guide (https://www.cu.edu/node/183087) . Access ourTotal Compensation Calculator (https://www.cu.edu/node/153125) to see what your total rewards could be at CU. (This position is a University Staff position)Please note that each agency's contact information is different; therefore, we encourage all applicants to view the full, official job announcement which includes contact information and class title. Select the job you wish to view, then click on the "Print" icon.AgencyState of ColoradoAddressSee the full announcement by clickingthe "Printer" icon located above the job titleLocation varies by announcement, Colorado, Websitehttps://careers.colorado.gov/Please verify your email addressVerify Email