Data Analyst Manager

  • location: Sarasota, FL
  • type: Permanent
  • salary: $110,000 - $115,000 per year

job description

Data Analyst Manager

job summary:
Our client is looking for a Data Analyst Manager for a permanent position in Sarasota, FL.

The Data Analyst Manager position is responsible for being a senior leader of the IT team and 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. This role will assist the AVP in leading the development of automated reports, analytical and management reports, and data definitions across multiple computing environments.

·Completes and oversees regularly scheduled reporting of the team (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, Crystal Reports Enterprise, 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).

·Leads the development of project plans and may assign and monitor tasks.

·Leads the development and generation of new reports to be provided to senior management across functional departments.

·Bachelor's degree in Information Systems or related discipline required.

·Advanced Information Systems degree or certifications / licenses strongly preferred.

·6-10 years of experience or equivalent knowledge required 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.

·Proficiency 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.

·Proficiency 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.

·Must be a team player and able to successfully lead and assist lower level team members on project work.

·Property and Casualty Insurance experience is required.

 
location: Sarasota, Florida
job type: Permanent
salary: $110,000 - 115,000 per year
work hours: 8am to 4pm
education: Bachelors
 
responsibilities:
The Data Analyst Manager position is responsible for being a senior leader of the IT team and 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. This role will assist the AVP in leading the development of automated reports, analytical and management reports, and data definitions across multiple computing environments.

·Completes and oversees regularly scheduled reporting of the team (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, Crystal Reports Enterprise, 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).

·Leads the development of project plans and may assign and monitor tasks.

·Leads the development and generation of new reports to be provided to senior management across functional departments.

·Bachelor's degree in Information Systems or related discipline required.

·Advanced Information Systems degree or certifications / licenses strongly preferred.

·6-10 years of experience or equivalent knowledge required 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.

·Proficiency 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.

·Proficiency 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.

·Must be a team player and able to successfully lead and assist lower level team members on project work.

·Property and Casualty Insurance experience is required.

 
qualifications:
  • Experience level: Manager
  • Minimum 7 years of experience
  • Education: Bachelors (required)
 
skills:
  • MY SQL
  • Crystal Reports Enterprise
  • Oracle SQL
  • Access
  • Excel
  • SSRS
  • Open Database Connectivity

Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

get jobs in your inbox.

sign up
{{returnMsg}}

related jobs

    Production Manager

  • location: Sarasota, FL
  • job type: Permanent
  • salary: $90,000 - $105,000 per year
  • date posted: 7/30/2020


    Sales Tax Accountant

  • location: Sarasota, FL
  • job type: Permanent
  • salary: $50,000 - $60,000 per year
  • date posted: 8/6/2020