Senior Data Analyst - Insurance

PMA Companies; Allentown (Lehigh County); Remote; USD 70,000 - 90,000; Full time

Job summary

A leading company in the insurance sector seeks a Data Analyst to define and create analytical reports that meet business needs. The role involves collaborating with various stakeholders and utilizing tools such as SQL and Power BI for data visualization and communication. Candidates should possess substantial experience in the insurance industry and demonstrate strong analytical skills.

Qualifications

• 2+ years’ experience as a data analyst in Insurance preferred.
• Proficient in SQL, Power BI, and data visualization tools.
• Strong analytical skills and high-level communication abilities.

Responsibilities

• Develops advanced analytical reports and dashboards.
• Collaborates with stakeholders to define data requirements.
• Utilizes SQL for data collection and preparation.

Skills

Data Visualization

Data Storytelling

Analytical Skills

SQL

Attention to Detail

Education

BS in Mathematics, Economics, Business, Computer Science, Information Management, Statistics

Tools

Power BI

SQL Database

Microsoft Excel

Microsoft Power Platform

Tableau

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