Software Engineer (SQL/Athena
Role details
Job location
Tech stack
Job description
Software Guidance & Assistance, Inc., (SGA), is searching for an Sr Software Engineer (SQL/Athena) for a Contract assignment with one of our premier Financial Services clients in Rockville, MD or Tysons, VA ., * Senior role focused on delivering analytics, dashboards, and insights using existing enterprise data. Works across SQL and AWS (Athena, RDS, Hive) to enable business decision-making through reliable and scalable reporting solutions. Not an ETL/data pipeline role. This is not a task execution role-expected to challenge the status quo, question assumptions, and drive better data-driven decisions.
- Build and optimize SQL-based analytics and reporting solutions
- Analyze data using AWS services (Athena, RDS, Hive)
- Develop and maintain dashboards and KPI reports
- Define and refine business metrics and KPIs with stakeholders
- Improve analytics efficiency through reusable queries and views
- Build lightweight automation/tools to reduce manual reporting effort
- Ensure data accuracy and reliability through validation and testing
- Perform testing, including:
- Regression testing of dashboards/reports
- Performance testing of queries
- Unit and end-to-end (E2E) testing
Requirements
- Strong SQL (advanced queries, optimization, performance tuning)
- Experience with AWS analytics services (Athena, RDS, Hive)
- Strong background in data analysis and dashboarding
- Understanding of KPIs, metrics, and reporting logic
- Experience in data validation and testing
Preferred Skills:
- BI tools (QuickSight, Tableau, Power BI)
- AWS ecosystem (S3, EMR, Glue, Lambda)
- Basic Angular/frontend exposure
- Python or scripting for automation
- Experience with CI/CD and testing frameworks Focus