What are the responsibilities and job description for the Associate Software Engineer position at Emerald Resource Group?
Associate Software Developer
Hybrid | Northeast Ohio
Salary Up to 100k
Why this role is interesting
- Real Product Impact: Work on a revenue generating product rather than internal tools.
- SQL Focus: Strong emphasis on performance, optimization, and scalability.
- Collaborative Team: Join a small, experienced dev team where your voice carries weight.
- Full-Stack Scope: Includes frontend, backend, and database responsibilities without being siloed.
- Stability: Long-term product roadmap in a stable environment.
- Leadership: Opportunity to influence architecture and mentor junior developers.
What you will be doing
- Feature Development: Build and enhance features in a modern ASP.NET MVC application.
- SQL Optimization: Improve SQL Server performance and scalability.
- Database Design: Design, optimize, and maintain stored procedures, views, indexes, and queries.
- Performance Tuning: Analyze slow queries and improve execution plans and indexing strategies.
- Collaboration: Work with product and business stakeholders to turn requirements into working features.
- Problem Solving: Troubleshoot and resolve bugs across the entire stack.
- Mentorship: Guide and mentor junior developers as needed.
What will help you succeed
- Frontend Expertise: Strong experience with JavaScript, jQuery, AJAX, and JSON.
- Database Mastery: Solid hands-on experience with Microsoft SQL Server, including stored procedures, views, functions, indexing strategies, and query optimization.
- Backend Knowledge: Experience with ASP.NET MVC and C#.
- Web Standards: Proficiency in HTML5, CSS, and Bootstrap.
- Ownership: Comfort working independently and owning deliverables.