Senior Data Analyst - Insurance

PMA Companies; Whitpain Township (Montgomery County); Remote; USD 70,000 - 90,000; Full time

Job summary

A leading company in the Insurance sector is seeking a Data Analyst to create advanced analytical reports and collaborate with stakeholders to meet business needs. The role involves translating business requirements into efficient data warehouse designs and utilizing various data tools for analysis. This remote position is ideal for those with strong analytical skills and experience in data visualization tools.

Qualifications

• 2+ years’ experience as a data analyst in the Insurance industry, preferably in Workers Compensation.
• Strong analytical skills with a focus on detail and accuracy.
• Ability to organize and balance multiple concurrent tasks.

Responsibilities

• Defines, designs, and creates advanced analytical reports and dashboards.
• Collaborates to document information/data requirements.
• Utilizes data mining languages like SQL to aggregate information.

Skills

Data visualization

Data storytelling

Analytical skills

Problem-solving skills

Attention to detail

Education

BS in Mathematics

BS in Economics

BS in Business

BS in Computer Science

BS in Information Management

BS in Statistics

Tools

SQL

PowerBI

Excel

Access

Power Platform

Tableau

Qlik

Jira

Confluence

Job description

Description

Responsibilities

• Defines, designs, and creates advanced analytical reports and dashboards to meet business needs
• Collaborates with both internal and external stakeholders to clearly define and document information/data requirements
• Develop and implement strategies to translate business requirements and models into feasible and acceptable data warehouse designs to ensure that business needs are met
• Utilize data mining languages, such as SQL, to collect and aggregate information
• Presents data back to stakeholders in digestible format as table or using data visualization tools such as PowerBI
• Builds application workflows to collect and visualize data for non-technical users using Microsoft Power Platform
• Ensures data and findings are accurate and meet highest quality standards
• Develops and implements data mining techniques that are efficient, repeatable, and production-ready
• Works with structured and unstructured data to prepare in-depth analysis. This may include cleansing and normalizing 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
• Supports analytics strategic initiatives by providing feedback and completing testing, as needed
• Works closely with management and other department heads to prioritize business and information needs
• 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.
• 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

#LI-Remote

Qualifications

Qualifications

• 2+ years’ experience as a data analyst in the Insurance industry, with emphasis in Workers Compensation preferred
• Proficiency with relational databases and SQL
• Proficiency with data visualization and analysis using tools such as PowerBI, Tableau, Qlik etc.
• Proficiency with Microsoft Excel/Access
• Proficiency with Microsoft Power Platform including Sharepoint, Microsoft PowerApps and PowerAutomate preferred
• Proficiency in data storytelling, including ability to communicate technical concepts with non-technically oriented people
• Advanced technical expertise regarding data modelling and design
• Strong analytical skills with the ability to collect, organize, analyze, and communicate significant amounts of information with attention to detail and accuracy
• Familiarity with project management tools such as Jira and Confluence preferred
• BS in Mathematics, Economics, Business, Computer Science, Information Management, Statistics or other quantitative discipline
• High level written and verbal communication skills
• Ability to work with little or no supervision
• Ability to organize and balance multiple concurrent timelines and tasks to meet deadlines
• Strong analytical and problem-solving skills