Find Statistical Reporting Analyst Full time Job in Jacksonville, Florida, United States | Snaprecruit

Find Statistical Reporting Full time Job in Jacksonville, Florida, US
  • Snapboard
  • Activity
  • Reports
  • Campaign
Welcome ,

Statistical Reporting Analyst

  • ... Jacksonville, Florida, United States
  • ... Full time
  • ... Salary: 100000 per year
  • Posted on: Feb 05, 2024       Expires on: Mar 21, 2024

Statistical Reporting Analyst   

JOB TITLE:

Statistical Reporting Analyst

JOB TYPE:

Full-time

JOB LOCATION:

Jacksonville Florida United States

JOB DESCRIPTION:

Statistical Reporting Analyst

Jacksonville, FL (Southside)

Direct Hire

Description

The Statistical Reporting Analyst is responsible for reporting financial and statistical data to insurance bureaus, state insurance departments, and other organizations for all lines of insurance.
This position will develop methods and procedures to report quality data timely and efficiently (utilizing best practices of data management.
) This role will work closely with the Product teams to analyze and research new regulatory reporting requirements, including existing and new states, using the project life cycle.
The Successful candidate may also provide business support to the Finance and Accounting team.
The Analyst is responsible for analysis, design, testing, maintenance, and support of statistical reporting solutions.
This individual will work with internal Business Representatives, external customers, and IT Development Staff to analyze requirements and develop solutions using Microsoft SQL Server Management Studio, Toad Data Point, Azure Data Factory, Power BI and/or Excel applications.

Additionally, the Analyst will review data as a means of providing insight into existing data issues and supporting the decisions that need to be made around data remediation, including the development of data cleansing and standardization rules.
The Analyst will assist with the design of logical reporting data models based upon business requirements and will help to define data access parameters.

Minimum Qualifications:


      Bachelor's degree in relevant area of study or equivalent work experience.


1 - 3 years of technical experience in financial report delivery for P&C insurance carriers.

4+ years of advanced knowledge and experience in T-SQL, ANSI SQL, ETL, Data Warehousing, and SQL Server development with SSIS.

4+ experience of advanced knowledge of T-SQL and/or ANSI SQL, ETL and Data Warehousing Create and maintain SQL scripts and Azure Data Factory Pipelines.

Demonstrate ability to pull together a well-designed, end-to-end process with knowledge of the MS-SQL product-stack.

Ability to create complex scripts to identify and address data quality issues correct the mismatched data.

Proficiency in the development of complex technical solutions and scripts using SQL Server, Power BI and Azure Data Factory.

Developing data links and data loading scripts, including data transformations, reconciliations, and accuracies.

Have a participated in all phases of Software Development Lifecycle (SDLC).

Proven experience in building, testing complex SQL queries, stored procedures, and delivering reporting solutions to finance teams.

Ability to perform detailed data analysis (i.
e.
determine the structure, content, and quality of the data through examination of source systems and data samples).

Proficiency with MS Office Suite, SQL Server Management Studio, Toad Data Point, Power BI, Azure Data Factory and related BI Tools.

Delivering solutions using established database technologies such as SQL Server.

Developing strategies and tactics, and in determining the correct prioritization of work items to ensure the best business outcome.

Understanding of insurance financial operations, processes, and insurance data structures.

Knowledge of statutory reporting requirements for P&C lines of business.

Ability to understand and apply applicable rules, regulations, and requirements relating to reporting data

Responsibilities:


      Interview customers to determine requirements for data, reports, analyses, metadata, training, service levels and performance


Document business requirements for development changes necessary to correct data issues or as requested by the Business as they relate to statutory or statistical reporting

Work with stakeholders according to the schedule agreed to resolve data issues

Coordinate and communicate between Business and IT Development Team

Identify, analyze, and remediate data issues related to the operational processing of the monthly, quarterly, and annual statutory/statistical reporting solutions and work with stakeholders according to the schedule agreed to resolve these issues.

Interact with and guide the Developers toward the solution detailed in the specifications

Perform analysis while considering the business implications of the solution to the current and future states

Plan and execute tests to verify that the reporting solutions support the specifications and requirements provided by the Business and are in accordance with business objectives

Provide training on reporting solutions, where applicable, to business users with respect to project materials, delivery methods, and timeframes

Provide support for defining models, data transformation and validation rules within the reporting solution

Develop reports to help conduct data analysis and validation

Understand the various levels of reporting detail required for statistical and statutory reporting

Escalate issues as required for data quality, technology, data mapping issues, and other issues that may arise

Participate in the change control process to determine system impact on statutory and statistical reporting process

Support and/or assist in the QA & UAT when required.

*The above cited duties and responsibilities describe the general nature and level of work performed by people assigned to the job.
They are not intended to be an exhaustive list of all the duties and responsibilities that an incumbent may be expected or asked to perform.

Ascendo is a certified minority owned staffing firm, and we welcome and celebrate diversity.

Ascendo is an Equal Opportunity Employer and does not discriminate on the basis of race, color, religion, sex (including pregnancy and gender identity), national origin, political affiliation, sexual orientation, marital status, disability, genetic information, age, parental status, military service or any other characteristic protected by federal, state or local law.

Ascendo is a certified minority owned staffing firm, and we welcome and celebrate diversity.




Ascendo is an Equal Opportunity Employer and does not discriminate on the basis of race, color, religion, sex (including pregnancy and gender identity), national origin, political affiliation, sexual orientation, marital status, disability, genetic information, age, parental status, military service or any other characteristic protected by federal, state or local law.

Position Details

POSTED:

Feb 05, 2024

EMPLOYMENT:

Full-time

SALARY:

100000 per year

SNAPRECRUIT ID:

S-1707482880-de85df4adb15e9eef2ab068739871793

LOCATION:

Florida United States

CITY:

Jacksonville

Job Origin:

jpick2

Jobcon Logo
A job sourcing event
In Dallas Fort Worth
Aug 19, 2017 9am-6pm
All job seekers welcome!

Similar Jobs

Statistical Reporting Analyst    Apply

Click on the below icons to share this job to Linkedin, Twitter!

Statistical Reporting Analyst

Jacksonville, FL (Southside)

Direct Hire

Description

The Statistical Reporting Analyst is responsible for reporting financial and statistical data to insurance bureaus, state insurance departments, and other organizations for all lines of insurance. This position will develop methods and procedures to report quality data timely and efficiently (utilizing best practices of data management.) This role will work closely with the Product teams to analyze and research new regulatory reporting requirements, including existing and new states, using the project life cycle. The Successful candidate may also provide business support to the Finance and Accounting team. The Analyst is responsible for analysis, design, testing, maintenance, and support of statistical reporting solutions. This individual will work with internal Business Representatives, external customers, and IT Development Staff to analyze requirements and develop solutions using Microsoft SQL Server Management Studio, Toad Data Point, Azure Data Factory, Power BI and/or Excel applications.

Additionally, the Analyst will review data as a means of providing insight into existing data issues and supporting the decisions that need to be made around data remediation, including the development of data cleansing and standardization rules. The Analyst will assist with the design of logical reporting data models based upon business requirements and will help to define data access parameters.

Minimum Qualifications:


      Bachelor's degree in relevant area of study or equivalent work experience.


1 - 3 years of technical experience in financial report delivery for P&C insurance carriers.

4+ years of advanced knowledge and experience in T-SQL, ANSI SQL, ETL, Data Warehousing, and SQL Server development with SSIS.

4+ experience of advanced knowledge of T-SQL and/or ANSI SQL, ETL and Data Warehousing Create and maintain SQL scripts and Azure Data Factory Pipelines.

Demonstrate ability to pull together a well-designed, end-to-end process with knowledge of the MS-SQL product-stack.

Ability to create complex scripts to identify and address data quality issues correct the mismatched data.

Proficiency in the development of complex technical solutions and scripts using SQL Server, Power BI and Azure Data Factory.

Developing data links and data loading scripts, including data transformations, reconciliations, and accuracies.

Have a participated in all phases of Software Development Lifecycle (SDLC).

Proven experience in building, testing complex SQL queries, stored procedures, and delivering reporting solutions to finance teams.

Ability to perform detailed data analysis (i.e. determine the structure, content, and quality of the data through examination of source systems and data samples).

Proficiency with MS Office Suite, SQL Server Management Studio, Toad Data Point, Power BI, Azure Data Factory and related BI Tools.

Delivering solutions using established database technologies such as SQL Server.

Developing strategies and tactics, and in determining the correct prioritization of work items to ensure the best business outcome.

Understanding of insurance financial operations, processes, and insurance data structures.

Knowledge of statutory reporting requirements for P&C lines of business.

Ability to understand and apply applicable rules, regulations, and requirements relating to reporting data

Responsibilities:


      Interview customers to determine requirements for data, reports, analyses, metadata, training, service levels and performance


Document business requirements for development changes necessary to correct data issues or as requested by the Business as they relate to statutory or statistical reporting

Work with stakeholders according to the schedule agreed to resolve data issues

Coordinate and communicate between Business and IT Development Team

Identify, analyze, and remediate data issues related to the operational processing of the monthly, quarterly, and annual statutory/statistical reporting solutions and work with stakeholders according to the schedule agreed to resolve these issues.

Interact with and guide the Developers toward the solution detailed in the specifications

Perform analysis while considering the business implications of the solution to the current and future states

Plan and execute tests to verify that the reporting solutions support the specifications and requirements provided by the Business and are in accordance with business objectives

Provide training on reporting solutions, where applicable, to business users with respect to project materials, delivery methods, and timeframes

Provide support for defining models, data transformation and validation rules within the reporting solution

Develop reports to help conduct data analysis and validation

Understand the various levels of reporting detail required for statistical and statutory reporting

Escalate issues as required for data quality, technology, data mapping issues, and other issues that may arise

Participate in the change control process to determine system impact on statutory and statistical reporting process

Support and/or assist in the QA & UAT when required.

*The above cited duties and responsibilities describe the general nature and level of work performed by people assigned to the job. They are not intended to be an exhaustive list of all the duties and responsibilities that an incumbent may be expected or asked to perform.

Ascendo is a certified minority owned staffing firm, and we welcome and celebrate diversity.

Ascendo is an Equal Opportunity Employer and does not discriminate on the basis of race, color, religion, sex (including pregnancy and gender identity), national origin, political affiliation, sexual orientation, marital status, disability, genetic information, age, parental status, military service or any other characteristic protected by federal, state or local law.

Ascendo is a certified minority owned staffing firm, and we welcome and celebrate diversity.



Ascendo is an Equal Opportunity Employer and does not discriminate on the basis of race, color, religion, sex (including pregnancy and gender identity), national origin, political affiliation, sexual orientation, marital status, disability, genetic information, age, parental status, military service or any other characteristic protected by federal, state or local law.

Loading
Please wait..!!