Senior Business Analyst – EDW & Data Solutions Lead

Western National Group & Umialik Insurance

Edina (MN)

Hybrid

USD 104,000 - 143,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Medical insurance benefits
401(k) plan with match
Paid time off

Job summary

Western National Insurance Group is seeking a Business Analyst IV to join our Enterprise Data Warehouse (EDW) team in Minnesota. The role leads requirements lifecycle across the enterprise, guiding analysts and product teams in best practices and data solutions.

The ideal candidate combines strong SQL, data modeling, and cloud platform experience with excellent communication to translate business needs into technical specifications.

Qualifications

  • Strong SQL skills, including querying, joins, filtering, aggregation, and data validation.
  • Experience with data warehouses, data lakes, relational databases, and reporting environments.
  • Understanding of ETL/ELT processes, APIs, data integration, and data movement.
  • Familiarity with data modeling concepts, including relational, dimensional, and analytical models.
  • Experience with data quality rules, profiling, reconciliation, and validation.
  • Familiarity with cloud data platforms such as Snowflake, AWS, Azure, or Databricks.
  • Experience with tools such as Jira, Confluence, Excel, Power BI, Tableau, Visio, or similar platforms
  • Excellent analytical and problem-solving skills when dealing with ambiguity.

Responsibilities

  • Collaborates in ticket intake analysis and application troubleshooting.
  • Participates in work refinement and estimation processes with Product Team members.
  • Participates in troubleshooting, issue reporting, resolution, and communication of urgent production issues.
  • Partners with product and change control teams to ensure quality deliverables that provide customer value.
  • Creates and maintains documentation defined as important by the Product Team or company, including support processes, team processes, and system documentation.
  • Supports noncore responsibilities as needed to ensure timely delivery of work to customers, including testing, road mapping, and directing deployment.
  • Collaborates across Product Teams and the enterprise to direct requirements activities for transformational business process and software implementation initiatives of higher impact and risk.
  • Applies, develops, and implements a comprehensive toolkit of advanced Business Analyst skills and techniques.
  • Demonstrates Business Analyst competencies and skill sets focused on creating strategic value for new and future applications.
  • Executes Business Analyst best practices as defined in the requirements lifecycle with minimal guidance from management.

Skills

SQL
Data Modeling
Data Warehouses
ETL/ELT
Cloud Platforms
Excel/BI tools
Análisis y resolución de problemas

Education

Bachelor’s degree in a related field

Tools

Jira
Confluence
Power BI
Tableau
SharePoint

Job description

Western National Insurance Group is seeking a Business Analyst IV to join our Enterprise Data Warehouse (EDW) team in Minnesota. The role leads requirements lifecycle across the enterprise, guiding analysts and product teams in best practices and data solutions.

The ideal candidate combines strong SQL, data modeling, and cloud platform experience with excellent communication to translate business needs into technical specifications.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Business Analyst - Data Strategy Lead (Remote)
Senior Business Analyst - Data Strategy Lead (Remote)

Western National Insurance • Edina (MN)

Hybrid
USD 104,000 - 143,000
Medical insurance plan options
401(k) matching benefits
Tuition reimbursement
Business Systems Analyst - EDW
Business Systems Analyst - EDW

Compunnel Inc. • Addison (TX)

On-site
USD 90,000 - 120,000
Senior EDW Business Systems Analyst: Data and Insights
Senior EDW Business Systems Analyst: Data and Insights

Compunnel Inc. • Addison (TX)

On-site
USD 90,000 - 120,000
Business Analyst IV
Business Analyst IV

Western National Insurance • Edina (MN)

Hybrid
USD 104,000 - 143,000
Medical insurance plan options
401(k) matching benefits
Tuition reimbursement
Senior Business Analyst: Data-Driven & Solution Design
Senior Business Analyst: Data-Driven & Solution Design

Jobsbridge • Saint Paul (MN)

On-site
USD 80,000 - 120,000
Business Analyst/Domain Specialist
Business Analyst/Domain Specialist

V4C.ai • United States

On-site
USD 120,000 - 150,000
Hybrid Business Analyst II – Guidewire Claims
Hybrid Business Analyst II – Guidewire Claims

Western National Insurance Group • Edina (MN)

On-site
USD 74,000 - 102,000
Medical insurance
Dental insurance
Vision benefits
+7
Business Systems Analyst - EDW
Business Systems Analyst - EDW

Compunnel Inc. • Columbus (OH)

On-site
USD 110,000 - 150,000
Business Analyst IV
Business Analyst IV

Western National Insurance Group • Edina (MN)

Hybrid
USD 104,000 - 143,000
Medical insurance benefits
401(k) plan with match
Paid time off
EDW Business Systems Analyst – Data & Snowflake Expert
EDW Business Systems Analyst – Data & Snowflake Expert

Compunnel Inc. • Columbus (OH)

On-site
USD 110,000 - 150,000