Associate Data Analyst

Wealth management, mortgage and treasury services each operate as separate lines of business. Founded in 2000, we now have 680 employees. Business casual all week, jeans on Fridays.

Job summary

The previous person in this role moved to another team. Black Hills Bank & Trust is hiring for the Associate Data Analyst role to answer business questions with data and turn the answers into reports people actually use. Remote position. Most of the team is in New York City, but nobody is required to come in. Hours are flexible, with one short team call each morning.

Duties

• Field ad hoc requests through a ticket queue and prioritize them with your manager.
• Support A/B test readouts with basic statistical checks.
• Prepare weekly and monthly KPI reports for department leads.
• Automate recurring Excel reports with Power Query, Python or scheduled SQL.
• Build and maintain dashboards in Tableau, Power BI or Looker.

What you need

• Experience with at least one BI tool such as Tableau, Power BI or Looker.
• Able to juggle several requests and say when a deadline isn't realistic.
• Basic statistics: averages vs. medians, distributions, significance.
• Habit of checking your own numbers before anyone else sees them.
• Strong SQL (joins, CTEs, aggregations, window functions)

Nice to have

• Google Analytics 4 or Adobe Analytics.
• Salesforce or NetSuite reporting.
• Dbt or Snowflake.
• Industry background in retail, healthcare or logistics.

The salary range for this role is $38.50 to $46.00/hr. This range reflects base salary only.

Pay and benefits

• Health savings account (HSA) with employer contribution.
• 401(k) with 4% match.
• 11 paid holidays.

We are an equal opportunity employer. If you need an accommodation during the application process, let us know.

We are unable to sponsor visas for this position.

Start: Immediately.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Black Hills Bank & Trust.