SQL Developer

Washington, DC
Avascent Analytics
Avascent Analytics is looking for a SQL Developer to join the Product Development team and contribute to exciting data analytic products. The Product Development team at Avascent Analytics is a fast-paced environment with a fun, collaborative culture.

** Please note that we will not sponsor applicants for visas for this position. **

Avascent Analytics is a research & analytics team within Avascent, a leading strategy and management consulting firm serving Fortune 500 companies in aerospace, defense, and technology. Headquartered in Washington, DC, Avascent uses sophisticated fact-based analysis, informed strategic insight, and pragmatic solutions to identify opportunities and develop winning strategies in markets characterized by constant change, customer complexity, and intense competition. Avascent Analytics products support senior industry leaders in making data-driven decisions about their business. 


    • Manage and administer the Avascent Analytics databases 
    • Develop scripts, perform database support activities, conduct performance tuning and database design
    • Extract, organize and integrate different datasets in SQL
    • Provide creative and efficient solutions to challenging data management and data reporting tasks
    • Investigate and apply new tools and solutions
    • Improve existing processes through automation and scripting using T-SQL (e.g., Stored Procedures, SSIS packages, etc.)
    • Support ad hoc data reporting, data analysis, and other troubleshooting activities
    • Work in an agile development environment, leveraging sprints to develop proof-of-concepts for new data products
    • Contribute in product brainstorming sessions (e.g. strategy development, business models, user engagement)


    • Bachelor’s degree in computer science, engineering, or another quantitative field
    • 2-3 years of relevant work experience
    • Ability to work locally in our Washington, D.C. office
    • Fluent in relational databases and Data architecture concepts (including schema design principles and best practices for scalable systems)
    • Strong SQL Server skills (including ability to write a script to do almost anything and strong systems-level debugging)
    • Ability to maintain and update existing SQL Scripts and SSIS packages 
    • Knowledge of database server administration (including managing users, permission, backups, recovery, monitoring, and replication)  
    • Excellent analytical and problem-solving skills


    • Strong Excel and VBA skills
    • Proficiency in various scripting languages (VB, PHP, Python, Perl, R)
    • Solid grasp of statistics and data analysis techniques (including clustering, hypothesis testing, regression)
    • Familiarity with BI tools such as Qlikview or Tableau 
    • Familiarity with Scrum/Agile 
    • Familiarity with front-end data visualization techniques (e.g. JavaScript, D3.js, .NET)
About Avascent
Avascent is the leading strategy and management consulting firm serving Fortune 500 companies in aerospace, defense, and technology. We pair together 30 years of experience in the industry with the critical curiosity of recent graduates in order to advise C-suite-level executives on high-level strategy decisions. With 100+ employees headquartered in downtown Washington, DC, as well as offices in London, Paris, and Ottawa, Avascent provides in-depth research, analysis, and strategy for global leaders in aerospace, defense, and technology. Avascent consulting engagements and Avascent Analytics products provide insight on everything from international market expansion to future warfare systems to industry-shaping mergers and acquisitions to billion-dollar strategic investments.