Integrity Marketing Group

Scheduled Hours

40

Position Summary

The Salesforce Report Writer is responsible for design, development, configuration, testing, implementation, maintenance, and security of reporting and associated applications to ensure timely and accurate outputs that inform data-driven decisions that align with Advancement’s business strategy and vision. The Report Writer provides support to Advancement teams or leadership by collecting and analyzing data and reporting results based on the needs of end users and collaborates with various functional teams based on their area of focus, and IT to achieve business results.

Job Description

Primary Duties & Responsibilities

Data & Reporting Solutions

• Participates in design sessions to capture requirements for report development. Works with users to understand and document reporting requirements and translates business requirements into completed reports with appropriate security.
• Analyzes and synthesizes complex and diverse information gathered from senior management and end users to develop new reports and reporting systems as needed.
• Develops and enables solutions (reports, visualizations, dashboards) to support the University’s goals.
• Writes ad hoc queries and reports using various reporting/database tools to support Advancement and University initiatives.
• Executes unit tests. Works with application testers on the preparation of test plans, test data and integrated unit testing.
• Carries out data and reporting strategy and providing training and guidance to Advancement staff outside the Advancement Systems teams to build data literacy and understanding.
• Understands the security model associated with various reporting options and is capable of developing with adherence to University Advancement data governance policies.
• Performs other duties as assigned.

Preferred Qualifications

• Experience with report and dashboard development utilizing Salesforce Reports, CRM Analytics, and/or Tableau.
• Experience with reporting architecture, including ETL processes, ODS/EDW, and relational database design and development.
• Experience working in higher education, with strong preference given to candidates with experience in advancement/fundraising.
• Experience in a higher education technology environment, especially with Affinaquest or Salesforce
• Strong knowledge of SQL, especially on SQL Server.
• Experience with declarative development in Salesforce and good understanding of the Salesforce security model.
• Strong knowledge of relational databases and the ability to quickly grasp new data models.
• Excellent organizational, analytical, and independent problem solving skills.
• Ability to critically evaluate information gathered from multiple sources, reconcile conflicts, decompose high-level information into details and discern user needs.
• Ability to contribute and collaborate effectively as a member of a highly-functioning and productive team.
• Ability to work independently and proactively with a high degree of accuracy.
• Ability to collaborate with team members during solution design and build.
• Ability to adjust to abrupt changes in priorities and strategy.
• Ability to learn quickly and adapt to new circumstances.
• High aptitude for learning new technologies.

Required Qualifications

• Bachelor’s degree.
• Four years of experience in data analysis and report development or related field, with strong preference given to candidates experienced at developing reports and dashboards in Salesforce.
• Or equivalent combination of education and experience.

Grade

G13

Salary Range

$64,700.00 - $110,500.00 / Annually

The salary range reflects base salaries paid for positions in a given job grade across the University. Individual rates within the range will be determined by factors including one's qualifications and performance, equity with others in the department, market rates for positions within the same grade and department budget.

Questions

For frequently asked questions about the application process, please refer to our External Applicant FAQ.

Accommodation

If you are unable to use our online application system and would like an accommodation, please email CandidateQuestions@wustl.edu or call the dedicated accommodation inquiry number at 314-935-1149 and leave a voicemail with the nature of your request.

Pre-Employment Screening

All external candidates receiving an offer for employment will be required to submit to pre-employment screening for this position. The screenings will include criminal background check and, as applicable for the position, other background checks, drug screen, an employment and education or licensure/certification verification, physical examination, certain vaccinations and/or governmental registry checks. All offers are contingent upon successful completion of required screening.

Benefits Statement

Personal

• Up to 22 days of vacation, 10 recognized holidays, and sick time.
• Competitive health insurance packages with priority appointments and lower copays/coinsurance.
• Want to Live Near Your Work and/or improve your commute? Take advantage of our free Metro transit U-Pass for eligible employees. We also offer a forgivable home loan of up to $12,500 for closing costs and a down payment for homes in eligible neighborhoods.
• WashU provides eligible employees with a defined contribution (403(b)) Retirement Savings Plan, which combines employee contributions and university contributions starting at 7%.

Wellness

• Wellness challenges, annual health screenings, mental health resources, mindfulness programs and courses, employee assistance program (EAP), financial resources, access to dietitians, and more!

Family

• We offer 4 weeks of caregiver leave to bond with your new child. Family care resources are also available for your continued childcare needs. Need adult care? We’ve got you covered.
• WashU covers the cost of tuition for you and your family, including dependent undergraduate-level college tuition up to 100% at WashU and 40% elsewhere after seven years with us.

For policies, detailed benefits, and eligibility, please visit: https://hr.wustl.edu/benefits/

EEO/AA Statement

Washington University in St. Louis is committed to the principles and practices of equal employment opportunity and especially encourages applications by those from underrepresented groups. It is the University’s policy to provide equal opportunity and access to persons in all job titles without regard to race, ethnicity, color, national origin, age, religion, sex, sexual orientation, gender identity or expression, disability, protected veteran status, or genetic information.

Diversity Statement

Washington University is dedicated to building a diverse community of individuals who are committed to contributing to an inclusive environment – fostering respect for all and welcoming individuals from diverse backgrounds, experiences and perspectives. Individuals with a commitment to these values are encouraged to apply.