Specific Responsibilities:
Data Analysis and Reporting:
- Create, maintain, and enhance reports and dashboards that leverage Association data to support internal operations and offerings to members.
- Collaborate with stakeholders to gather reporting requirements and to refine inquiries, ensuring the right questions are being asked of Association data to get meaningful and actionable answers.
- Query, aggregate, format, and analyze data in a way that is consistent with best practices and creates the opportunity for meaningful analyses and conclusions.
- Create data visualizations in Salesforce and Tableau for internal and external audiences.
- Assist staff in interpreting/using reports, routinely engaging in iterative refinement to arrive at finished products that meet business needs.
Data Quality and Documentation:
- Ensure Association’s data is in alignment with its data model and as complete, accurate, and robust as possible.
- Conduct regular, systematic assessments to ensure data quality within PAEA’s data structures, particularly the Salesforce ecosystem.
- Assist staff in troubleshooting and remedying identified issues in the Association’s databases (e.g., incorrect Contact information or Affiliation errors), educate staff on, and implement, where possible, mechanisms to uphold data quality.
- Document own work and processes and contribute to PAEA’s overall documentation efforts by routinely revisiting and revising documentation to support a shared understanding of PAEA’s data model.
Salesforce Administration Support:
- Contribute to proper Salesforce data governance and integrity by supporting PAEA efforts in appropriately defining user access and ensuring data is complete and accurate.
- Support colleagues’ management of Association data and Salesforce processes, including, but not limited to, maintenance and governance of data and fields, groups, flows, and security-related components (permissions, roles/profiles).
- Facilitate data literacy and usage across the Association and across various user proficiency/comfort levels, including monitoring/promoting user adoption, curating/creating training materials, and providing education/training, as needed.
- Stay abreast of the platform’s new tools, capabilities, and updates, and recommend data management solutions to improve existing practices or achieve business requirements.
Other Duties
The duties and responsibilities listed above are representative of the nature and level of work assigned and are not necessarily all-inclusive. Duties, responsibilities, and activities may change at any time with or without notice.
Qualifications, Knowledge, Skills, and Abilities:
Required
- Minimum of 3-5 years of experience as a Data Analyst, Business Analyst with analytical and reporting experience, Administrator, Tableau Data Analyst, or similar position.
- Deep understanding of Salesforce.
- Experience with SQL, SOQL, and/or SOSL.
- Strong communication and interpersonal skills, with the ability to communicate with stakeholders to identify data and analytical business requirements.
- Excellent analytical and problem-solving skills, with ability to communicate with audiences of varying technical skill levels and across different mediums (i.e., live virtual interactions and written communication).
- Strong time management and organizational skills, with the ability to work independently and prioritize tasks
- Strong proficiency in Microsoft Office, including Teams, Outlook, Excel, and Word.
Preferred:
- Experience/Expertise in Tableau is highly preferred.
- Proficiency in R, Python, Java, or other programming languages well-suited for data analysis and reporting.
- Bachelor’s or advanced degree in Computer Science, Business Analytics, Data Science, Information Systems, Statistics, or related field.
- Salesforce Administrator, Business Analyst, Tableau Certified Data Analyst, or similar Salesforce/Tableau certification.
- Demonstrated success at working within a remote team.
- Experience in project management and/or PMP certification.
ADA Specifications
- The ability to remain in a stationary position (sitting or standing) as well as to occasionally move about the office.
- Proficiency in operating office equipment, such as a computer, keyboard, mouse, and telephone.
- The ability to communicate information and ideas so others will understand and must be able to exchange accurate information in these situations.
Travel Requirements
Periodic travel will be required for this role to all-staff meetings, PAEA events, and/or professional development opportunities.
Essential Functions:
Reasonable accommodation may be made to enable individuals with disabilities to perform these essential functions.
Work Environment & Benefits
This position can be performed in a fully remote location within the United States and will require occasional travel. The individual in this position must be authorized to work in the United States.
PAEA offers a competitive salary and benefits that considers external market compensation and maintains internal equity. The salary range for this position is $88,000-95,000 annually. The benefits package includes health, life, and disability insurances; paid time off and holidays; a 403(b) retirement plan with an 8% employer contribution; monthly wellness stipend, professional development funding, tuition assistance, and other benefits.
EEO Statement
PAEA is committed to equity, diversity, and inclusion in all areas of its business activities, including employment, management, procurement and contracting. As such, it is the policy of PAEA to afford equal opportunity in employment and contracting without regard to race, color, national origin, sex, religious preference, age, sexual orientation, genetic information, gender identity, status as a parent, disability, veteran or any other status protected by applicable US law.