Philanthropic Analytics DeveloperUniversity of Colorado DenverDescriptionWho We Are:Position Summary:Where You Will Work:Diversity and Equity:Duties & 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
What We Offer:Salary: $94,000-$98,600Benefits:
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://apptrkr.com/getredirect.php?id=5309419&targetURL=https://advantage.cu.edu/) .
Qualifications:Minimum Qualifications:Please ensure your resume includes any and all relevant experience to be accurately assessed against these qualifications. You must meet all minimum requirements listed at the time of application to be considered for this role.
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
How to Apply:
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.
When to Apply:June 21stSponsorship Statement:Background Check Statement:ADA Statement:
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
How to Apply:
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.
When to Apply:June 21stSponsorship Statement:Background Check Statement:ADA Statement:
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
How to Apply:
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.
When to Apply:June 21stSponsorship Statement:Background Check Statement:ADA Statement:
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
How to Apply:
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.
When to Apply:June 21stSponsorship Statement:Background Check Statement:ADA Statement:Job CategoryPrimary LocationSchedulePosting DateUnposting DateTo apply, please visit: https://cu.taleo.net/careersection/2/jobdetail.ftl?job=33808&lang=en (https://apptrkr.com/5309419)Copyright 2024 Jobelephant.com Inc. All rights reserved.Posted by the FREE value-added recruitment advertising agency (https://www.jobelephant.com/)Philanthropic Analytics Developer - 33808 University StaffSystem 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://apptrkr.com/getredirect.php?id=5309419&targetURL=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.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.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.The University of Colorado System Administration Office is committed to recruiting and supporting a diverse workforce. The university strives to promote a culture of inclusiveness, respect, communication and understanding. We encourage applications from women, ethnic minorities, persons with disabilities, persons within the LGBTQ+ community and all veterans.Duties and responsibilities of the position include, but are not limited to:The anticipated hiring range has been established at .CU System Administration takes into consideration a combination of the selected candidate's education, training and experience as it relates to the position, as well as the position's scope and complexity, internal pay equity and external market value when determining a salary level for potential new employees. 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. Additional taxable fringe benefits may be available. For more information on benefits programs, please review our Comprehensive Benefits Guide (https://apptrkr.com/getredirect.php?id=5309419&targetURL=https://www.cu.edu/node/183087) . Access our Total Compensation Calculator (https://apptrkr.com/getredirect.php?id=5309419&targetURL=https://www.cu.edu/node/153125) to see what your total rewards could be at CU. (This position is a University Staff position)To be successful in this position, candidates will need the following:For full consideration, please attach the following as separate documents to your application: Please ensure you check the "Job Specific Attachments" box next to each document on the "Required Documents" page of the application for the appropriate documents to be attached.For full consideration completed applications must be submitted by . Reference checking is a standard step in our hiring process. You may be asked to provide contact information, including email addresses, for up to five references as part of the search process for this position. Please note: All application materials must be submitted through CU Careers; emailed materials will not be considered.We are unable to sponsor applicants for work visas for this position.The University of Colorado is committed to providing a safe and productive learning and living community. To achieve that goal, we conduct background investigations for all final applicants being considered for employment. Background investigations include a criminal history record check, and when appropriate, a financial history, motor vehicle history and/or fingerprinting background check. The Immigration Reform and Control Act requires that a verification of employment eligibility be documented for all new employees by the end of the third day of work. The University of Colorado is committed to diversity and equality in education and employment.We are committed to an inclusive and barrier-free search process. We provide accommodations for applicants requesting accommodation through the search process such as alternative formats of this posting. Individuals with disabilities in need of accommodations throughout the search process should contact the ADA Coordinator at: https://apptrkr.com/getredirect.php?id=5309419&targetURL=Oral, written, and listening communication skills to accurately interpret what others are saying and convey messages, information, concepts, and details clearlyFor full consideration, please attach the following as separate documents to your application: Please ensure you check the "Job Specific Attachments" box next to each document on the "Required Documents" page of the application for the appropriate documents to be attached.For full consideration completed applications must be submitted by . Reference checking is a standard step in our hiring process. You may be asked to provide contact information, including email addresses, for up to five references as part of the search process for this position. Please note: All application materials must be submitted through CU Careers; emailed materials will not be considered.We are unable to sponsor applicants for work visas for this position.The University of Colorado is committed to providing a safe and productive learning and living community. To achieve that goal, we conduct background investigations for all final applicants being considered for employment. Background investigations include a criminal history record check, and when appropriate, a financial history, motor vehicle history and/or fingerprinting background check. The Immigration Reform and Control Act requires that a verification of employment eligibility be documented for all new employees by the end of the third day of work. The University of Colorado is committed to diversity and equality in education and employment.We are committed to an inclusive and barrier-free search process. We provide accommodations for applicants requesting accommodation through the search process such as alternative formats of this posting. Individuals with disabilities in need of accommodations throughout the search process should contact the ADA Coordinator at: https://apptrkr.com/getredirect.php?id=5309419&targetURL= to accurately interpret what others are saying and convey messages, information, concepts, and details clearlyFor full consideration, please attach the following as separate documents to your application: Please ensure you check the "Job Specific Attachments" box next to each document on the "Required Documents" page of the application for the appropriate documents to be attached.For full consideration completed applications must be submitted by . Reference checking is a standard step in our hiring process. You may be asked to provide contact information, including email addresses, for up to five references as part of the search process for this position. Please note: All application materials must be submitted through CU Careers; emailed materials will not be considered.We are unable to sponsor applicants for work visas for this position.The University of Colorado is committed to providing a safe and productive learning and living community. To achieve that goal, we conduct background investigations for all final applicants being considered for employment. Background investigations include a criminal history record check, and when appropriate, a financial history, motor vehicle history and/or fingerprinting background check. The Immigration Reform and Control Act requires that a verification of employment eligibility be documented for all new employees by the end of the third day of work. The University of Colorado is committed to diversity and equality in education and employment.We are committed to an inclusive and barrier-free search process. We provide accommodations for applicants requesting accommodation through the search process such as alternative formats of this posting. Individuals with disabilities in need of accommodations throughout the search process should contact the ADA Coordinator at: https://apptrkr.com/getredirect.php?id=5309419&targetURL=Salesforce ascend applications, or similarFor full consideration, please attach the following as separate documents to your application: Please ensure you check the "Job Specific Attachments" box next to each document on the "Required Documents" page of the application for the appropriate documents to be attached.For full consideration completed applications must be submitted by . Reference checking is a standard step in our hiring process. You may be asked to provide contact information, including email addresses, for up to five references as part of the search process for this position. Please note: All application materials must be submitted through CU Careers; emailed materials will not be considered.We are unable to sponsor applicants for work visas for this position.The University of Colorado is committed to providing a safe and productive learning and living community. To achieve that goal, we conduct background investigations for all final applicants being considered for employment. Background investigations include a criminal history record check, and when appropriate, a financial history, motor vehicle history and/or fingerprinting background check. The Immigration Reform and Control Act requires that a verification of employment eligibility be documented for all new employees by the end of the third day of work. The University of Colorado is committed to diversity and equality in education and employment.We are committed to an inclusive and barrier-free search process. We provide accommodations for applicants requesting accommodation through the search process such as alternative formats of this posting. Individuals with disabilities in need of accommodations throughout the search process should contact the ADA Coordinator at: systemhr@cu.edu (https://apptrkr.com/getredirect.php?id=5309419&targetURL=systemhr@cu.edu) .Application Materials Required: Cover Letter, Resume/CV : Information Technology : Denver Department: S0001 System Administration - 50206 - Advancement Operations : Full-time : Jun 5, 2024 : Ongoing Posting Contact Name: systemhr.recruiting@cu.edu (https://apptrkr.com/getredirect.php?id=5309419&targetURL=systemhr.recruiting@cu.edu) Posting Contact Email: systemhr.recruiting@cu.edu (https://apptrkr.com/getredirect.php?id=5309419&targetURL=systemhr.recruiting@cu.edu) Position Number: 00823320jeid-e226cab8707e4e4dbd33b34f2373622aThe University of Colorado does not discriminate on the basis of race, color, national origin, sex, age, pregnancy, disability, creed, religion, sexual orientation, gender identity, gender expression, veteran status, political affiliation, or political philosophy. All qualified individuals are encouraged to apply.
Full-time