Extracts, reports and creates executive summaries on data derived from multiple data sources. Serves as a data expert and is the coordinator of day-to-day methods used to retrieve data and generate reports. 2. Creates and designs complex tables, macros, forms, queries and reports.3. Utilizes querying tools and applicable internal reporting structures and guidelines to develop, design and produce complex reporting and analysis based on constituent and revenue data extracted from primary databases. 4. Enforces rules and procedures for cleaning, integrating, and reconciling information/data from various sources. Identifies and effectively communicates necessary corrections or enhancements to business data and applications that will facilitate reporting needs. 5. Produces high-level analysis and summaries for senior leadership. 6. Maintains, updates, and reconciles complex financial and business information in relevant database records as needed. 7. Researches and investigates revenue-based information using office files and databases to ensure accuracy.8. Maintains a thorough knowledge of, and establishes best practices, particularly as they relate to revenue and financial tracking. Participates in the development of processes and practices and serves as expert data analytics and reporting resource within the unit.9. Builds strategic relationships with staff within and outside the unit and serves as a key contact on questions relating data and reporting needs. 10. Interacts with external stakeholders at the request of leadership and/or frontline staff in response to inquiries, often requiring a comprehensive knowledge of business development. Required Skill/ability 1: Exceptional reporting skills, including extracting and summarizing large quantities of data from database systems. Proven experience with manipulating and reconciling data. Required Skill/ability 2: Demonstrated organizational abilities with strong attention to detail, strong interpersonal skills, and well-developed written and verbal communication skills. Ability to work independently and as part of a team, and to handle multiple projects simultaneously. Required Skill/ability 3: Advanced proficiency with Excel, and strong knowledge of other Microsoft products, such as Word, PowerPoint, and Outlook. Ability and willingness to learn new online tools. Required Skill/ability 4: Commitment to an inclusive workplace. Ability to engage with diverse audiences (age, gender, nationality, race/ethnicity, profession, sexual orientation, etc.). Required Skill/ability 5: Ability to maintain strict confidentiality of information. Preferred Education: Familiarity with university and/or development and alumni affairs programs, processes, and practices. Proven experience in higher education advancement services. Proven experience with Blackbaud CRM or other fundraising and relationship management systems, including query development and marketing efforts. Work Week: Standard (M-F equal number of hours per day) Posting Position Title: Development Analytics and Data Coordinator University Job Title: Senior Analytics and Data Services Coordinator Preferred Education, Experience and Skills: Familiarity with university and/or development and alumni affairs programs, processes, and practices. Proven experience in higher education advancement services. Proven experience with Blackbaud CRM or other fundraising and relationship management systems, including query development and marketing efforts. Eight years of related experience, six of them in the same job family at the next lower level and a high school level education; or six years of related experience and an Associate's Degree; or two years of related work experience and a Bachelor's Degree;

Senior Analytics and Data Services Coordinator | Yale University - Military Veterans

at HERC - Metro New York & Southern Connecticut

New Haven, CT