Data Analyst

Prescient National®; Charlotte (NC); Hybrid; USD 60,000 - 90,000; Full time

Benefits offered by this job

Remote workplace

Competitive salary

Health & Wellness reimbursement

401(k) savings match

Paid time off

Tuition assistance

Job summary

A leading insurance company is looking for a Data Analyst who excels in transforming raw data into actionable insights. In this Mid-Senior level role, you will design and maintain Power BI dashboards and support data governance. Offering a competitive salary and work-from-home options, this position requires expertise in data analysis and business intelligence, alongside strong SQL and communication skills.

Qualifications

• 3+ years of experience in data analysis or business intelligence.
• Strong understanding of data visualization and storytelling.
• Proficiency with Power BI, including dataflows and RLS.

Responsibilities

• Design and maintain Power BI dashboards and reports.
• Extract, clean and analyze data from SQL, Excel and Dataverse.
• Support ad hoc reporting requests and data governance.

Skills

Data analysis

Business intelligence

Data visualization best practices

Problem-solving

SQL querying

Power BI

Communication

Education

Associate degree or higher in a related field

Tools

Power BI Desktop

Power Automate

SQL

Job description

People Ops & Strategy at Prescient National

WHO WE ARE: Prescient National is an AM Best A (Excellent) rated Workers' Compensation insurance company offering national coverage. We provide innovative insurance products and effective loss reduction strategies, tailored to meet both current and future challenges. Our solutions include Guaranteed Cost Policies, Deductible Policies, Retrospective Rating Policies, Excess/Self Insurance, and Captive Options, all designed to align with each employer's unique risk profile and appetite. By leveraging deep analytics and fostering strong relationships with stakeholders, we deliver unparalleled service and creative solutions that distinguish us in the industry.

ABOUT THE ROLE: We’re looking for a data-driven problem solver who thrives on transforming raw information into actionable insights. As a Data Analyst, you’ll play a key role in shaping how our organization visualizes, understands, and leverages data to drive decisions. This is an exciting opportunity to work with cutting‑edge tools in the Microsoft Power Platform—helping streamline processes, enhance reporting efficiency, and make a measurable impact across departments.

HOW YOU WILL MAKE AN IMPACT

• Design, build, and maintain Power BI dashboards and paginated reports tailored to departmental needs.
• Create and manage Power BI dataflows to optimize data management and accessibility.
• Extract, clean, and analyze internal and external data from SQL, Excel, Dataverse, and other sources.
• Leverage Copilot and Power Automate to streamline workflows and minimize manual reporting tasks.
• Support ad hoc reporting requests and contribute to data governance initiatives.
• Implement and maintain row‑level security (RLS) to uphold data privacy and compliance standards.
• Collaborate on cross‑functional projects, ensuring data accuracy and consistency across the organization.
• Other responsibilities and projects as assigned.

WHO YOU ARE

• 3+ years of experience in data analysis or business intelligence.
• Experience in Insurance is a plus.
• Strong understanding of data visualization best practices and storytelling with data.
• Proficiency with Power BI Desktop, Power Query and Power BI Service, including dataflows, RLS, and paginated reports.
• Proficiency in Power Automate.
• Skilled in SQL querying and data transformation.
• Excellent communication, problem‑solving, and collaboration skills.
• Experience with external sharing and embedded analytics is a plus.
• Associate degree or higher in a related or applicable field.

BENEFITS

• Remote Workplace: Enjoy the ability to work from home or hybrid if you live close to our Charlotte, NC office!
• Competitive Salary & Growth: Join a team that thrives on leadership, initiative, creativity, and passion, with a salary that matches your drive.
• Time off & Holidays: 3 weeks of vacation and 13 paid holidays to recharge and relax.
• Health & Wellness: We reimburse up to $25 a month for gym memberships.
• 401(k) Savings: We match up to 6% of your contribution.
• Excellent Health Benefits: Vision + Dental are 100% covered by Prescient and we contribute 80% of medical coverage premiums.
• FSA Healthcare and Dependent Care: Flexible Spending Accounts to support your healthcare needs.
• Employee referral bonuses, Tuition assistance & MORE!

Seniority level

Mid‑Senior level

Employment type

Full‑time

Job function

Product Management and Information Technology

Industries

Insurance

We are an equal‑opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, or any other characteristic protected by law.