What are the responsibilities and job description for the Sr Software Engineer position at Software Guidance & Assistance, Inc. (SGA, Inc.)?
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 .
Responsibilities :
SGA is an Equal Opportunity Employer and does not discriminate on the basis of Race, Color, Sex, Sexual Orientation, Gender Identity, Religion, National Origin, Disability, Veteran Status, Age, Marital Status, Pregnancy, Genetic Information, or Other Legally Protected Status. We are committed to providing access, equal opportunity, and reasonable accommodation for individuals with disabilities in employment, and our services, programs, and activities. Please visit our company EEO page to request an accommodation or assistance regarding our policy.
Responsibilities :
- 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
- 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
- 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
SGA is an Equal Opportunity Employer and does not discriminate on the basis of Race, Color, Sex, Sexual Orientation, Gender Identity, Religion, National Origin, Disability, Veteran Status, Age, Marital Status, Pregnancy, Genetic Information, or Other Legally Protected Status. We are committed to providing access, equal opportunity, and reasonable accommodation for individuals with disabilities in employment, and our services, programs, and activities. Please visit our company EEO page to request an accommodation or assistance regarding our policy.
Salary : $70 - $82