Business Intelligence & Analytics Engineer

Upland Capital Group; United States; On-site; USD 80,000 - 125,000; Full time

Job summary

A leading specialty property/casualty insurer located in Dallas, Texas, is looking for a Business Intelligence & Analytics Engineer to join their data team. In this role, you'll leverage SQL and data visualization tools to transform data into actionable insights while collaborating with stakeholders across various business functions. The position promises long-term growth opportunities and a solid foundation in data analytics.

Benefits

Health insurance including FSA and HSA options

Free access to Teladoc

Vision and dental insurance

Disability and life insurance

Parental leave

Unlimited vacation days

Paid sick time

401(k)

Tuition reimbursement

Employee assistance program

Qualifications

• 2+ years of experience in data analytics, BI, or related field.
• Familiarity with data visualization tools like Power BI or Tableau.
• Strong attention to detail.

Responsibilities

• Write and run SQL to pull, clean, and validate data.
• Build and test dbt models for data pipelines.
• Create and maintain dashboards in Power BI.

Skills

SQL

Problem Solving

Attention to Detail

Clear Communication

Education

Bachelor's degree in a technical or quantitative field

Tools

Power BI

Sigma

dbt

Snowflake

Alteryx

Python

Job description

Upland Capital Group, Inc. is an AM Best rated “A-” VIII specialty property/casualty insurer headquartered in Dallas, Texas. Through its wholly owned insurance carrier, Upland Specialty Insurance Company, the company markets, underwrites and services specialty insurance products in select markets to include excess transportation, construction casualty, excess casualty, primary general liability, excess public entity, professional liability errors and omissions as well as excess cyber liability.

We focus on “old school” underwriting as a craft, add “new school” analytics and technology, and encourage a gritty, growth mindset among people called “we entrepreneurs.”

As an Excess and Surplus (E&S) carrier, we face unique and interesting problems every day. We are seeking a Business Intelligence & Analytics Engineer to join our growing Data team. This hands-on role focuses on developing skills and delivering tangible value through reporting, dashboards, and data pipelines.

Primary Function:
You'll collaborate with senior engineers and business stakeholders to transform raw data into actionable insights. Responsibilities include writing SQL queries, building dbt models, troubleshooting data issues, and supporting reporting across teams such as underwriting, claims, and finance. This early-career position is ideal for individuals with 2+ years of experience in a technical role or those transitioning into data analytics with a solid foundation in analytics and a desire to grow.

The ideal candidate:

• Wants to contribute to and grow within a strong team culture
• Operates with humility, drive, and emotional intelligence
• Excels in a dynamic, collaborative setting where adaptability and innovation are value
• Values high-quality documentation
• Ensures accuracy before delivering work to internal customers

Growth and Development
At Upland Capital Group, we invest in your long-term growth. In this role, you'll:

• Work closely with senior engineers and business stakeholders, gaining exposure to various aspects of data analytics and business intelligence
• Receive coaching and regular feedback to support your professional development
• Access training resources to deepen your skills in tools like dbt, Power BI, and Snowflake
• Have opportunities to take on increasing responsibility as you demonstrate readiness

This position is designed to provide a solid foundation in data analytics, with clear pathways for advancement within our growing team.

DUTIES AND RESPONSIBILITIES:

• Write and run SQL to pull, clean, and validate data
• Build and test dbt models to support data pipelines
• Create and maintain dashboards in Power BI or Sigma Computing
• Support the monthly reporting processes as needed, including data prep and delivery
• Collaborate with engineers and business users to understand reporting needs
• Participate in Agile ceremonies and sprint planning
• Document data logic, definitions, and business rules
• Support ad hoc reporting and data requests from key business functions
• Troubleshoot issues with data quality, dashboards, and pipeline performance
• Contribute to peer reviews and QA processes for analytics work
• Additional responsibilities as needed
• 2+ years of work experience, ideally in data analytics, BI, or a related field
• Insurance industry experience preferred but not required
• Proficiency with SQL
• Familiarity with data visualization tools like Power BI, Sigma, or Tableau
• Experience with data tools like dbt, Snowflake, Alteryx, or Python
• Strong attention to detail and solid problem-solving skills
• Clear communicator who can work with both technical and non-technical teammates
• Bachelor's degree in a technical or quantitative field (or equivalent experience)

EXPERIENCE, EDUCATION, SPECIAL SKILLS REQUIRED:

• 2+ years of work experience, ideally in data analytics, BI, or a related field
• Insurance industry experience preferred but not required
• Proficiency with SQL
• Familiarity with data visualization tools like Power BI, Sigma, or Tableau
• Experience with data tools like dbt, Snowflake, Alteryx, or Python
• Strong attention to detail and solid problem-solving skills
• Clear communicator who can work with both technical and non-technical teammates
• Bachelor's degree in a technical or quantitative field (or equivalent experience

Disclosures:

Pay Estimate: $ 80,000 - $125,000/year

Other compensation: annual incentive program

Benefits: health insurance including FSA and HSA options and free access to Teladoc, vision, dental, disability and life insurance, parental leave, responsible time off (unlimited vacation days without an accrual system), paid sick time as required by law, 401(k), tuition reimbursement and employee assistance program.

Anticipated close date: June 6, 2025