Senior Business Analyst – EDW & Data Solutions Lead

Western National Group & Umialik Insurance; Edina (MN); Hybrid; USD 104,000 - 143,000; Full time

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.