Business Intelligence and Data Analyst II

AAAS; Washington (District of Columbia); Hybrid; USD 45,000 - 65,000; Part time

Job summary

AAAS is seeking a Part-time Business Intelligence & Data Analyst II to join the Research & Data Analytics team in Washington, DC. The role focuses on building data pipelines in AWS, curating Power BI datasets, and supporting analysts in creating dashboards.

Responsibilities include data quality monitoring, developing efficient queries, and mentoring others in BI practices. Remote work is possible; initial six-month term with $40 hourly compensation.

Qualifications

• BA/BS with at least two years of experience working with large datasets using SQL and R, or MS degree in data science or related field.
• Proficient with Excel and slide deck software (PowerPoint, Canva, Google Slides).
• Proficient with AWS ETL tools (Glue, Lambda, Iceberg, Athena).
• Proficient with R, Python, SQL, and PySpark.
• Proficient with data visualization software (Power BI, Tableau, Google Data Studio).
• Familiar with data quality, ETL best practices, and data governance concepts.
• Experience summarizing research methods and producing insightful analyses.
• Experience creating visually compelling reports and dashboards.

Responsibilities

• Add data from various sources to the AWS ETL Platform (RAP).
• Write efficient SQL queries to pull data into Power BI datasets.
• Develop fast Power BI reports and PBIX files with reliable data.
• Curate datasets, reports, and dashboards in Power BI.
• Monitor data quality and improve accuracy and completeness.
• Mentor analysts on building Power BI datasets and reports.
• Maintain documentation of data pipelines, datasets, and reports.
• Support lifecycle project management from conception to closeout.

Skills

SQL

R

Python

Pyspark

Excel

PowerPoint

Power BI

Tableau

Google Data Studio

Data Quality

Data Management

Research Methods

Education

BA/BS or MS in data science, statistics, or related field

Tools

AWS Glue

AWS Lambda

Iceberg

Athena

Job description

Business Intelligence and Data Analyst II

Job Category: United States

Requisition Number: BUSIN001871

• Posted : August 4, 2026
• Part-Time

Locations

Showing 1 location

Washington D.C.
1200 New York Ave NW
Washington, DC 20005, USA

Washington D.C.
1200 New York Ave NW
Washington, DC 20005, USA

Remote
1200 New York Ave NW
Washington, DC 20005, USA

Remote
1200 New York Ave NW
Washington, DC 20005, USA

AAAS has an exciting opportunity for a Part-time BI & Data Analyst II to join our Research & Data Analytics (RDA) team!

The Part-time BI & Data Analyst-II (BIDA-II) works cooperatively with other RDA team members, IT, and business unit stakeholders to manage, analyze, interpret, and report on data to contribute to AAAS’s strategic planning, businessgoalsand overall mission.In a team setting, the BIDA-II will implement data and analytics projects. This will include:

• Building data pipelines in AWS that support Power BI datasets and reports
• Curating datasets and reports in Power BI (PBI).
• Supporting business analysts in the development of PBI reports and dashboards.
• Participating in efforts toidentifyand pilot test tools and technology that will advance our data infrastructure and data governance.
• Participate in rotating QC and data pipeline breakage duties.

TheBIDA-II may also be tasked with conducting Internet searches to identify best practices or common policies related to Business Intelligence (BI), data governance, AWS data pipelines, and mentoring analysts in other departments in how to build and modify Power BI datasets and reports.

Help us ignite the next era of science.

What You'll Do

Contribute to Data and Analytics Infrastructure

• 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 .pbixfiles that produceaccurateand reliable data
• Curate PBI datasets, reports, anddashboards
• Continuouslymonitordata 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,datasetsand reports
• Participate in efforts toidentifyand pilot test tools and technology that will advance our data infrastructure and data governance.

Project Implementation

• Plan and implement projects across the lifecycle (conception/initiation, planning, execution, and closeout).
• Create andmaintainproject plans to ensuretimelydelivery to internal customers.
• Manage resources to ensure projects are completed on time and in budget.

Minimum Qualifications

• BA/BS with at least two years of experience working with large, complex datasets using SQL and R, orMS 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 withETL 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.

Location

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 [e-mail] with any questions regarding your eligibility.

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

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.

#LI-DNI

Equal Opportunity Employer
This employer is required to notify all applicants of their rights pursuant to federal employment laws.For further information, please review the Know Your Rights notice from the Department of Labor.

Search Firm and Employment Agency Disclaimer

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.