onsite
Data Validation & Reporting Analyst - Allocore
Software Engineer
Data Validation & Reporting Analyst responsible for ensuring data integrity and generating actionable insights across high‑volume financial processes using SQL, Python, and AWS-based ETL pipelines.
About the role
Key Responsibilities
- Validate and cleanse large datasets from government loan and grant programs to ensure accuracy and compliance.
- Design, develop, and maintain automated ETL workflows on AWS to extract, transform, and load data into reporting systems.
- Generate and distribute detailed reports and dashboards that track program performance, fraud indicators, and financial metrics.
- Collaborate with cross‑functional teams to define data quality standards and implement continuous improvement initiatives.
- Investigate data anomalies, troubleshoot issues, and provide root‑cause analysis to stakeholders.
Requirements
- Proven experience with SQL and Python for data manipulation and analysis.
- Hands‑on knowledge of AWS services (S3, Redshift, Glue, Lambda) and ETL best practices.
- Strong analytical skills with a focus on data integrity and quality assurance.
- Excellent communication skills and ability to translate technical findings into business insights.
- Experience in a regulated or government‑facing environment is a plus.
Skills
sqlpythondata analysisaws