What are the responsibilities and job description for the .NET Developer position at STEM Search Group?
What you'll do...
-
Write complex SQL from scratch including multi-table joins, subqueries, CTEs, window functions, and performance-conscious filtering, and build and maintain stored procedures with real business logic inside them, not just simple selects.
-
Know when Entity Framework is the right call and when raw SQL is what the job needs, with a strong default toward raw SQL when complexity or performance demands it.
-
Work across the full stack when needed, from Angular UI components to C# controllers and RESTful API endpoints, but expect to live mostly in the data layer.
-
Write unit tests that cover real scenarios, not just happy paths, and be able to explain why each test exists.
-
Use AI tools like GitHub Copilot as a multiplier in your daily workflow, not a crutch.
What we're looking for...
-
Deep raw SQL skills, someone who can write a complex multi-table query from scratch without hesitation, has built or significantly modified stored procedures with real logic inside them, and understands query performance and execution plans.
-
Hands-on experience working with large or complex datasets where writing efficient, readable SQL is the core of the work.
-
Full stack competence across Angular, C#, and SQL Server, with SQL Server being your strongest layer.
-
A self-starter who moves with pace and confidence, gets things done, and does not get stuck in analysis.
-
A testing mindset with a real framework behind it and specific examples to back it up.
-
Azure is always a plus, as is any experience with GitHub Copilot.
-
A computer science degree preferred or equivalent technical foundation coupled with a Bachelor's degree.