What are the responsibilities and job description for the SQL Developer position at amerisafe inc?
AMERISAFE is seeking a detail-oriented, productivity driven professional to add to our “Excellence Team” based remotely or in DeRidder, LA. The SQL Developer is a non-exempt position that will perform duties and participate in projects in support of the objectives of the Risk and Information Services Department. The SQL Developer will identify business requirements, analyze business problems, and plan and implement solutions accordingly. Duties will include identifying opportunities for improvements to data analysis, data processing, reporting capabilities, and performance and recommending, developing, and managing projects to improve the flow of data and business intelligence information throughout the company.
Upon an offer and acceptance of employment with AMERISAFE, you will be required to complete our pre-employment screening, which includes a criminal background check, a 10-panel drug test and, if applicable, a review of your motor vehicle report. A 10-panel drug test includes amphetamine/methamphetamine, barbiturates, benzodiazepines, cocaine metabolite (BZE), marijuana metabolite (THCA), methadone, methaqualone, codeine/morphine, phencyclidine, propoxyphene.
Qualifications:
- Bachelor’s degree (preferred Computer Science) or equivalent combination of technology training, certifications, and experience
- Minimum of five years of work experience in MS SQL Server Database Tools
- Preferred experience in Microsoft SSAS, SSRS, or Power BI
- Expert knowledge of and demonstrated work experience with advanced database concepts and technologies, especially MS SQL Server, structured query language, and related development tools and systems
- Strong technology skills including especially data retrieval and analysis tools
- Excellent organizational, reporting, and time management skills
- Knowledge of insurance concepts and insurance operations
- Excellent written, verbal, and interpersonal communication skills
- Demonstrated ability in creative thinking, self-direction, and initiative
- Demonstrated ability to thrive in a dynamic and high-pressure environment
- Demonstrated interest in continued education and pursuit of knowledge
- Excellent organizational and time management skills
- Willing to work extended hours and weekends
Responsibilities:
- Analyze, plan, design, develop, code and debug SQL systems according to specified requirements
- Supports the availability, performance, and integrity of Amerisafe’s Business Intelligence platform
- Provides technical, testing and user documentation in support of SQL solutions
- Responds to and resolves Business Intelligence production issues with appropriate sense of urgency
- Performs ad-hoc data analysis and reporting as requested
- Researches and recommends initiatives to enhance database and BI systems
- Develops project plans and appropriate documentation of activities
- Maintains appropriate expertise to ensure effective service level
- Prepare data, business and risk analyses for internal and external stakeholders as requested by management
- Support the VP of Risk Services in departmental functions as necessary
