Finance Data & ETL Analyst II

American Association for the Advancement; Washington (District of Columbia); On-site; USD 99,000 - 127,000; Full time

Benefits offered by this job

Paid vacation

Paid sick leave

Paid holidays

Health insurance

FSA

Dental insurance

Life insurance

Vision insurance

Retirement benefits

Disability insurance

Additional benefits

Job summary

AAAS in Washington, DC seeks a Program Analyst II to join our Information Technology department. The role focuses on data, financial, and reporting processes across AAAS program and platform environments, including maintenance, implementations, and issue resolution of Finance systems.

You will work with IT, Finance, and business stakeholders to ensure data quality, reconciliation, and documentation, while applying ETL and financial control best practices.

Qualifications

• Bachelor’s degree in a technology-related field.
• Experience using Excel, SQL, Power BI to manage, analyze, and validate data.
• Experience identifying and resolving data quality issues across systems.
• Ability to document processes, reconciliations, and findings clearly and accurately.
• Experience with General Ledger (GL) transactions and financial reporting and basic accounting concepts.
• Experience with financial reconciliation and audit best practices.
• Experience working with or supporting integrations involving payment processors and financial vendors.

Responsibilities

• Supports routine Finance system maintenance, configuration changes, and basic administration tasks.
• Meets with Finance system vendors to assist with implementations, updates, and issue resolution.
• Performs limited user access administration for Finance systems following established procedures.
• Acts as a liaison between Finance, vendors, and IT to communicate requirements and coordinate larger technical changes.
• Assists with testing, reconciliation, documentation, and audit support related to Finance including systems implemented by IT.

Skills

Excel

SQL

Power BI

Education

Bachelor's degree in a technology related field

Job description

AAAS in Washington, DC seeks a Program Analyst II to join our Information Technology department. The role focuses on data, financial, and reporting processes across AAAS program and platform environments, including maintenance, implementations, and issue resolution of Finance systems.

You will work with IT, Finance, and business stakeholders to ensure data quality, reconciliation, and documentation, while applying ETL and financial control best practices.