SQL Developer (Data Analyst)

» SQL Developer (Data Analyst)
Information Technology
in Sarasota
, FL
Reference: 19-02215

Description: 

The SQL Developer (Data Analyst) position is responsible for working within the information technology group, participating in a team responsible for report generation and data analysis utilizing database management software/tools against various database platforms. In this role you will assist in the development of automated reports, analytical and management reports, and data definitions across multiple computing environments. You will develop technical expertise in data mining and report development methodologies, techniques and tools to ensure deliverables meet the needs of both internal and external business customers.

Key Requirements:

  • Bachelor’s degree in Information Systems or related discipline required
  • 1-3 years of experience or equivalent knowledge in mastering database management software/tools, including proficiency in SQL query building and report writing
  • Must be proficient with MSSQL stored procedure creation, job creation, and general report automation
  • Familiarity with advanced MSSQL features (linked servers, dbmail, bcp) to use in automating data delivery, file creation, notifications
  • Must be proficient with MSSQL server tools (SSIS/Integration SVCS, SSRS/Reporting SVCS)
  • Must be proficient with creating and modifying Crystal Reports
  • Familiarity with business objects/Crystal Reports Enterprise Server, scheduling reports
  • Familiarity with Open Database Connectivity (ODBC) creation/usage
  • Familiarity with Microsoft Access table creation, queries, macros, forms and reports, Visual Basic for Applications (VBA)
  • Familiarity with MSSQL (2000/2005/2008) and Oracle (10G/11G) databases
  • Familiarity with ticketing systems used to assign and track work amongst multiple team members
  • Must be resourceful, industrious, and willing to take on new tasks and proactively learn new technologies to keep up with business needs
  • Must be able to work under tight deadlines efficiently and with high quality
  • Must possess strong organizational skills with demonstrated attention to detail
  • Must be flexible and able to adapt in a changing business environment
  • Must possess a positive attitude and strong work ethic
  • Property and casualty insurance experience is preferred

Special Skills/Must Be Proficient In The Following Or Willing To Improve Proficiency In These Areas:

  • Structured Query Language (SQL)
  • Cursory knowledge of programming and scripting languages (.Net C#, C++, VBS, etc.)
  • Microsoft Office 2007/2010 (Excel, Access, Word, PowerPoint)
  • Database structure and design
  • Excellent written and oral communication skills