Join Avesis for an exciting career as a SQL Developer II. This role involves designing, implementing, and maintaining high-quality solutions, collaborating with team members, and mentoring junior developers.
Requirements
- Develop, test, and deploy SQL solutions based on project requirements.
- Design and implement new features while ensuring system reliability and scalability.
- Collaborate with business analysts and stakeholders to refine requirements and design test scenarios.
- Optimize code for performance and maintainability.
- Participate in peer code reviews and provide constructive feedback.
- Contribute to team adherence to Agile development methodologies.
- Proficiency in a T-SQL programming language.
- Intermediate to Advanced understanding of database systems (SQL Server) Stored Procedures, Triggers, Indexes, Temporary Tables, Execution Plans.
- Experience developing stored procedures and integrating with APIs.
- Design and maintain data models for databases and warehouses.
- Develop and optimize data pipelines and workflows using ETL tools.
- Implement and enforce data governance policies and best practices.
- Knowledge of web programming basics, html, css
- Ability to work independently and manage deliverables.
- Strong debugging and problem-solving skills.
Benefits
- Competitive compensation package.
- Excellent medical, dental, supplemental health, life and vision coverage for you and your dependents with no wait period.
- Life and disability insurance.
- A great 401(k) with company match.
- Tuition assistance, paid parental leave and backup family care.
- Dynamic, modern work environments that promote collaboration and creativity to develop and empower talent.
- Flexible time off, dress code, and work location policies to balance your work and life in the ways that suit you best.
- Employee Resource Groups that advocate for inclusion and diversity in all that we do.
- Social responsibility in all aspects of our work. We volunteer within our local communities, create educational alliances with colleges, drive a variety of initiatives in sustainability.