Business Systems Analyst with Power BI, Snowflake, DAX

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

Job summary

An established industry player is seeking a skilled Business Systems Analyst to bridge the gap between business teams and data engineers. This role emphasizes expertise in SQL and Snowflake, alongside a solid understanding of insurance data. You will engage with stakeholders to gather requirements, optimize queries, and collaborate on Power BI reports. Join a dynamic team where your analytical skills will drive data-driven insights and decision-making in a fast-paced environment. If you thrive in a collaborative space and are passionate about leveraging data for business success, this opportunity is perfect for you.

Qualifications

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

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

DAX

Analytical Thinking

Problem Solving

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

Business Systems Analyst with Power BI, Snowflake, DAX

2 days ago Be among the first 25 applicants

Direct message the job poster from New York Technology Partners

Sr Technical Recruiter at New York Technology Partners

Job Title: Business Systems Analyst with Power BI, Snowflake, DAX

Location: Remote

Position Type: Contract

Job Description:

We are seeking an experienced Business Systems Analyst with expertise in Power BI, SQL/Snowflake, basic knowledge of Power BI DAX, and proven domain experience in insurance. The successful candidate will serve as a key liaison between business teams and data/BI engineers, translating insurance-specific needs into data-driven reporting and analytics solutions.

Responsibilities:

• 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.
• Write and optimize complex SQL queries to analyze data within Snowflake and support report development.
• Collaborate with BI developers to design and validate Power BI reports and dashboards.
• Provide business insights and data analysis to support decision-making and performance tracking.
• Document data sources, logic, and report specifications clearly for technical and business teams.
• Validate and test data for accuracy, completeness, and consistency.
• Participate in UAT cycles, identify data issues, and coordinate resolutions.
• Act as a subject matter expert for insurance-related data and processes.

Required Qualifications:

• Bachelor’s degree in Information Systems / Computer Science, Business, Insurance, or related field.
• 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.
• Basic working knowledge of Power BI DAX, data modeling (not expected to develop complex dashboards).
• Solid understanding of insurance data (e.g., claims, policy, customer, premium).
• Strong analytical thinking and problem-solving abilities.
• Excellent communication skills, both written and verbal.

Preferred Qualifications:

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

If you believe you are qualified for this position and are interested, please email your resume and contact details to [e-mail].

Seniority level

• Mid-Senior level

Employment type

• Contract

Job function

• Information Technology

Industries

• Information Services