onsite
Senior Financial Data Analyst - AEM Corporation
Data Analyst
Senior Financial Data Analyst driving accurate federal financial data integration and reporting using Momentum, ARC, and advanced analytics tools to ensure compliance, transparency, and audit readiness.
About the role
Key Responsibilities
- Lead data integration projects for federal clients, extracting, transforming, and loading financial data from Momentum and Treasury’s ARC into unified reporting systems.
- Develop and maintain automated ETL pipelines using Python, SQL, and AWS services to ensure data accuracy and timeliness.
- Design and produce interactive dashboards and visualizations in Tableau to support financial transparency and audit readiness.
- Collaborate with cross‑functional teams to validate data against federal financial reporting standards and resolve discrepancies.
- Document data models, processes, and best practices to support knowledge transfer and regulatory compliance.
Requirements
- 5+ years of experience in financial data analysis within a federal or regulated environment.
- Proficiency in Python, SQL, and AWS (S3, Glue, Redshift).
- Strong knowledge of federal financial systems, general ledger accounting, and reporting standards.
- Experience building Tableau dashboards and performing data quality checks.
- Excellent communication skills and ability to translate complex data into actionable insights.
Skills
pythonsqltableauaws