The 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 & lead 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.
Essential Duties and Responsibilities:
Responsible for regularly scheduled reporting (daily, weekly, monthly) for internal and external purposes, as well as ad-hoc reports for internal departments utilizing various DB reporting tools, such as MSSQL, Oracle SQL Developer, Access, Excel, etc.
Develops processes for reports, creates wiki documentation, and provides training on said processes to satisfy reporting requests and/or to automate manual processes for efficiency and accuracy.
Creates and implements solutions which may include database objects, custom report design (utilizing SSRS for example) and automation of reporting tasks (via a regularly scheduled MSSQL job calling multiple stored procedures for example).
Contributes to the development of project plans and may assign and monitor tasks.
Assists in the development and generation of new reports to be provided to senior management across functional departments.
Performs other duties as required.
This job description has been prepared to indicate the general nature and level of the work that the employees perform within their classification. This description is not and cannot be interpreted as an inventory of all the duties, tasks, responsibilities and qualifications required for the employees assigned to this job.
Education and / or Experience:
Bachelor's degree in Information Systems or related discipline required.
3+ years of experience in mastering database management software/tools, including proficiency in SQL query building and report writing.
Property and Casualty Insurance experience preferred; other insurance experience may be considered.
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.
Familiarity with SSRS and SSIS.
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.
Must be proficient in the following or willing to improve proficiency in these areas:
- Cursory knowledge of programming/scripting (C#, Python, PowerShell, etc.).
- Microsoft Office (Excel, Access, Word, Power Point).
Excellent written and oral communication skills.
Licenses and / or Certifications: