Senior Business Analytics & Metrics Specialist - Remote Opportunity
PMA Companies
Blue Bell Pennsylvania
United States
Consulting & Corporate Strategy
(No Timezone Provided)
Collects, evaluates, and designs complex statistical data/reports for claims, sales, service, and operations. Prepares statistical and narrative reports and recommendations, and participates in the analysis and interpretation of data as appropriate. Develops, maintains, and ensures quality control of data queries and may assist in development and implementation of measurement systems.
Responsibilities:
- Defines, designs, and creates advanced analytical reports and dashboards to meet business needs
- Utilizes advanced graphic features to effectively illustrate data trends and patterns
- Develops and implements strategies to translate business requirements and models into feasible and acceptable data warehouse designs to ensure that business needs are met
- Develops and implements data mining techniques that optimize statistical efficiency and data quality
- Works with structured and unstructured data to prepare in-depth analysis. This may include cleansing and normalizing of data or development of internal control reporting to ensure data validity going forward.
- Quickly identifies, troubleshoots, and remediates issues that are produced from anomalies in the database environment
- Provides feedback and recommendations on data storage structures, data mining and data cleansing
- Assist in the testing and implementation of new or upgraded software
- Creates user-defined functions and automation processes by using VBA code to build scripts based on organizational needs
- Design and develop Office 365 applications and solutions (Power Automate, Power Apps, and Sharepoint Online)
- Provides data consulting in support of business and information technology initiatives to stakeholders to improve database systems
- Assists in the application and implementation procedures of data standards and guidelines on data ownership, coding structures, and data replication to ensure access to and integrity of data sets.
- Demonstrated experience in handling large datasets and relational databases
- Excellent visual design sense regarding clear and accurate presentation of data
- Adept at queries, report writing and presenting findings
- Ability to effectively communicate complex technical concepts to both technical and non-technical audiences
- Demonstrate commitment to Company's Code of Business Conduct and Ethics, and apply knowledge of compliance policies and procedures, standards and laws applicable to job responsibilities in the performance of work
Job Requirements:
- Bachelor's degree (or higher) in Statistics, data analysis, actuarial, mathematics, Computer Science, Information Systems, or data-driven computation
- 3+ years of experience as a data analyst in commercial casualty insurance industry, with emphasis in workers compensation preferred
- Advanced technical expertise regarding data models, database design development, data mining and segmentation techniques
- Strong analytical skills with the ability to collect, organize, analyze, and communicate significant amounts of information with attention to detail and accuracy
- Experience working in Excel Macro utilizing VBA required
- Experience working in SQL query and SQL DB is a plus
- Microsoft Access 2007 or higher developer experience, including advanced form creation
- Experience writing procedures and business requirements
- Highly desirable experience building Power Automate, Power Apps, Sharepoint Online
- Expert knowledge of building web parts, apps, page layouts using O365
- Working familiarity with tools like QlikSense, Hyperion, Microstrategy preferred
- Exposure to the commercial casualty/workers compensation insurance industry preferred
- Experience using HTML
- Excellent interpersonal and customer facing skills
Senior Business Analytics & Metrics Specialist - Remote Opportunity
PMA Companies
Blue Bell Pennsylvania
United States
Consulting & Corporate Strategy
(No Timezone Provided)
Collects, evaluates, and designs complex statistical data/reports for claims, sales, service, and operations. Prepares statistical and narrative reports and recommendations, and participates in the analysis and interpretation of data as appropriate. Develops, maintains, and ensures quality control of data queries and may assist in development and implementation of measurement systems.
Responsibilities:
- Defines, designs, and creates advanced analytical reports and dashboards to meet business needs
- Utilizes advanced graphic features to effectively illustrate data trends and patterns
- Develops and implements strategies to translate business requirements and models into feasible and acceptable data warehouse designs to ensure that business needs are met
- Develops and implements data mining techniques that optimize statistical efficiency and data quality
- Works with structured and unstructured data to prepare in-depth analysis. This may include cleansing and normalizing of data or development of internal control reporting to ensure data validity going forward.
- Quickly identifies, troubleshoots, and remediates issues that are produced from anomalies in the database environment
- Provides feedback and recommendations on data storage structures, data mining and data cleansing
- Assist in the testing and implementation of new or upgraded software
- Creates user-defined functions and automation processes by using VBA code to build scripts based on organizational needs
- Design and develop Office 365 applications and solutions (Power Automate, Power Apps, and Sharepoint Online)
- Provides data consulting in support of business and information technology initiatives to stakeholders to improve database systems
- Assists in the application and implementation procedures of data standards and guidelines on data ownership, coding structures, and data replication to ensure access to and integrity of data sets.
- Demonstrated experience in handling large datasets and relational databases
- Excellent visual design sense regarding clear and accurate presentation of data
- Adept at queries, report writing and presenting findings
- Ability to effectively communicate complex technical concepts to both technical and non-technical audiences
- Demonstrate commitment to Company's Code of Business Conduct and Ethics, and apply knowledge of compliance policies and procedures, standards and laws applicable to job responsibilities in the performance of work
Job Requirements:
- Bachelor's degree (or higher) in Statistics, data analysis, actuarial, mathematics, Computer Science, Information Systems, or data-driven computation
- 3+ years of experience as a data analyst in commercial casualty insurance industry, with emphasis in workers compensation preferred
- Advanced technical expertise regarding data models, database design development, data mining and segmentation techniques
- Strong analytical skills with the ability to collect, organize, analyze, and communicate significant amounts of information with attention to detail and accuracy
- Experience working in Excel Macro utilizing VBA required
- Experience working in SQL query and SQL DB is a plus
- Microsoft Access 2007 or higher developer experience, including advanced form creation
- Experience writing procedures and business requirements
- Highly desirable experience building Power Automate, Power Apps, Sharepoint Online
- Expert knowledge of building web parts, apps, page layouts using O365
- Working familiarity with tools like QlikSense, Hyperion, Microstrategy preferred
- Exposure to the commercial casualty/workers compensation insurance industry preferred
- Experience using HTML
- Excellent interpersonal and customer facing skills