Report this job

---

What is the problem? *

Incorrect company
Incorrect location
Job is expired
Job may be a scam
Other

The Data Analytics & Reporting 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. In this role you will assist the VP of IT in assessing the data and reporting infrastructure, leading to the development of automated reports, analytical and management reports, and data definitions across multiple computing environments. You will further 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 and will be looked to for information / expertise within the department. Essential Duties and Responsibilities: Develop and implement a data analytics strategy that promotes self-service capabilities for the end-users consumption of operational data via reporting and dashboarding mechanisms. Direct and manage regularly scheduled team meetings (daily, weekly, monthly) for internal and external resources, provide guidance on the definition of reports and data extracts for internal departments utilizing various DB reporting tools, such as MSSQL, Access, Excel, etc. Assess the data and reporting infrastructure to improve accessibility and usability of the data as well as consistency in criteria and data queries for specific data sets. Work with management team to establish positive and collaborative team leadership within the organization while building relationships and connections with business stakeholders. Develop processes for reports, documentation, and reconciliation mechanisms, and provide oversight on said processes to satisfy reporting requests and/or to automate manual processes for efficiency and accuracy. Provide structure, clarity, and direction to the Data Analytics and Reporting team by prioritizing reporting requirements. Work with cross-functional teams for translating reporting requirements into working solutions that meet statutory deadlines and financial needs. Create and implement 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. Performs other duties as required. Supplemental Information: 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: Bachelors 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. Prior experience with database architecture, design, modification, and optimization. Proficiency with advanced MSSQL features (2012 and beyond) to use in automating data delivery, file creation, notifications. Must be proficient with MSSQL Server tools (SSIS/Integration Svcs, SSRS/Reporting Svcs Experience using data delivery tools such as PowerBI, Tableau, Crystal Reports or similar. 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 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. Special Skills: Structured Query Language (SQL) Cursory knowledge of programming and scripting languages NET C#, C++, VBS, etc Microsoft Office (Excel, Access, Word, Power Point) Database Structure and Design Excellent written and oral communication skills.