Business Intelligence and Data Analyst II

- Add data from various sources to the AWS ETL Platform, named the Reporting & Analytics Platform (RAP)

- Write fast and performant database queries using a flavor of SQL Server to pull data into PBI.

- Develop fast and efficient .pbix files that produce accurate and reliable data

- Curate PBI datasets, reports, and dashboards

- Continuously monitor data quality and develop processes to improve accuracy and completeness.

- Support business analysts in the development of PBI reports and dashboards.

- Maintain documentation of data pipelines, datasets and reports

- Participate in efforts to identify and pilot test tools and technology that will advance our data infrastructure and data governance.

- Plan and implement projects across the lifecycle (conception/initiation, planning, execution, and closeout).

- Create and maintain project plans to ensure timely delivery to internal customers.

- Manage resources to ensure projects are completed on time and in budget.

- BA/BS with at least two years of experience working with large, complex datasets using SQL and R, or MS degree from an accredited college or university in data science, statistics, social science, business administration, or a mathematical discipline.

- Proficient with Excel and slide deck software (e.g., Power Point, Canva, Google Slideshow Maker).

- Proficient with AWS ETL tools (including but not limited to Glue, Lambda, Iceberg, and Athena)

- Proficient with: R, Python, SQL, Pyspark.

- Proficient with data visualization software (e.g., Power BI, Tableau, Google Data Studio).

- Familiar with methods for addressing missing data and other data quality concerns.

- Familiar with ETL best practices.

- Experience with data management, analysis, interpretation; and report writing.

- Experience summarizing research methodologies and results of analyses.

- Experience developing visually compelling reports and dashboards that reveal key trends in the data.

- Knowledge of research design, qualitative, and quantitative research methods.

We have offices in Washington, DC and Cambridge, UK. Remote work is possible. If you are not located in or able to work from a location where AAAS has a business presence, you may not be eligible for this position.

Please contact our Talent Team at jobs@aaas.org with any questions regarding your eligibility.

Submit a resume and cover letter outlining qualifications and interest in the position by August 12, 2026 . Applications are reviewed on a rolling basis. A Recruiter will contact you with next steps if you are selected for an interview.

The anticipated initial rate of compensation for this positions is $40 per hour with a term length of six months.

AAAS is aware of fraudulent messages from individuals and entities falsely claiming to represent our organization. Please note that all official recruitment communications will come from an @aaas.org email address, and all open positions are posted on our Careers page (aaas.org/careers). AAAS will never ask applicants to provide payment, financial information including credit card numbers, or Social Security numbers during the hiring process via an email.

If you receive an email claiming to be from AAAS that looks suspicious, do not click on any links or open any attachments. Instead, please contact us at jobs@aaas.org before responding or sharing any personal information.

Any actual offer of employment, reflecting the total compensation package and benefits, will be made in the sole discretion of AAAS and will be based on a variety of factors, including years of experience, depth of experience, and other relevant factors. AAAS reserves the right to amend or modify its employment benefits and compensation structure at any time.

AAAS is an Equal Opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sexual orientation, gender, gender identity, national origin, age, disability, veteran status, or other protected category. AAAS uses E-Verify to confirm the employment eligibility of all newly hired employees.

No visa sponsorship is available for this position.

Search Firm and Employment Agency Disclaimer The American Association for the Advancement of Science (AAAS) does not accept unsolicited agency resumes. Any unsolicited resumes sent to AAAS from a third party, such as an agency, including unsolicited resumes sent to an AAAS mailing address, fax machine or email address, directly to AAAS employees, or to the AAAS resume database will be considered AAAS property.

Verbal or written communications from any employee of AAAS shall not be considered binding obligations. AAAS Human Resources is the only AAAS representative authorized by AAAS enter into any employment agreements with any third party. AAAS will not pay a fee for any placement resulting from the receipt of an unsolicited resume.

#LI-DNI