Business Systems Analyst (Power BI)

New York Technology Partners; United States; Remote; USD 80,000 - 100,000; Full time

Job summary

Join a forward-thinking company as a Business Systems Analyst specializing in Power BI and SQL. This exciting role involves collaborating with business teams to translate insurance requirements into data-driven insights. You'll optimize SQL queries, validate data accuracy, and design impactful Power BI reports. If you have a strong background in insurance and a passion for analytics, this opportunity is perfect for you. Be part of an innovative team that values your expertise and contributes to meaningful projects in the insurance sector.

Qualifications

• 10+ years of experience as a Business Systems Analyst in the insurance industry.
• Strong hands-on experience with SQL and working with Snowflake or similar cloud data warehouses.

Responsibilities

• Engage with business stakeholders to gather reporting and data analysis requirements.
• Write and optimize complex SQL queries to analyze data within Snowflake.

Skills

SQL

Power BI

Analytical Thinking

Problem-Solving

Communication Skills

Education

Bachelor’s degree in Information Systems

Bachelor’s degree in Computer Science

Bachelor’s degree in Business

Bachelor’s degree in Insurance

Tools

Snowflake

Azure DevOps

Jira

Job description

Get AI-powered advice on this job and more exclusive features.

New York Technology Partners provided pay range

This range is provided by New York Technology Partners. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Base pay range

$55.00/hr - $60.00/hr

Direct message the job poster from New York Technology Partners

Information Technology Recruitment & Staffing

Job Title: Business Systems Analyst (Power BI)

Location: Remote

Position Type: Contract position

Job Description:

We are looking for an experienced Business Systems Analyst with strong hands-on skills in Power BI, SQL/Snowflake, a basic understanding of Power BI DAX, and proven domain expertise in insurance. The ideal candidate will act as a key liaison between business teams and data/BI engineers, translating insurance-specific requirements into data-driven reporting and analytics solutions.

Key Responsibilities:

1. Engage with business stakeholders (Digital / Agile Program Managers, business teams) across insurance functions (e.g., claims, policy, underwriting, reinsurance) to gather reporting and data analysis requirements.
2. Write and optimize complex SQL queries to analyze data within Snowflake and support report development.
3. Collaborate with BI developers to design and validate Power BI reports and dashboards.
4. Provide business insights and data analysis to support decision-making and performance tracking.
5. Document data sources, logic, and report specifications clearly for technical and business teams.
6. Validate and test data for accuracy, completeness, and consistency.
7. Participate in UAT cycles, identify data issues, and coordinate resolutions.
8. Act as a subject matter expert for insurance-related data and processes.

Required Qualifications:

1. Bachelor’s degree in Information Systems / Computer Science, Business, Insurance, or related field.
2. 10+ years of experience as a Business Systems Analyst in the insurance industry.
3. Strong hands-on experience with SQL and working with Snowflake or similar cloud data warehouses.
4. Basic working knowledge of Power BI DAX, data modeling (not expected to develop complex dashboards).
5. Solid understanding of insurance data (e.g., claims, policy, customer, premium).
6. Strong analytical thinking and problem-solving abilities.
7. Excellent communication skills, both written and verbal.

Preferred Qualifications:

1. Experience working in Agile/Scrum environments.
2. Familiarity with Azure DevOps, Jira, or similar project management tools.
3. Exposure to data visualization principles and dashboard usability.
4. Insurance certifications (e.g., CPCU, AINS) are a plus.

Additional Details:

• Seniority level: Mid-Senior level
• Employment type: Contract
• Job function: Information Technology
• Industries: Technology, Information and Media

Referrals increase your chances of interviewing at New York Technology Partners by 2x

Get notified about new Business System Analyst jobs in United States.