Business Intelligence Developer

HERO TALENT SOLUTIONS LLC
Saint Paul, MN, United States
3 months ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Experienced
Experience required
3 years minimum
Compensation
$62,400.0 - $145,600.0
Working hours
Regular working hours
Job source

Tech stack

Query Performance Artificial Intelligence Data Analysis Business Intelligence Development Databases Data Validation Extract Transform Load (ETL) Data Warehousing Programming Tools Dimensional Modeling Human-Computer Interaction Microsoft SQL Server
+17 more
Power BI SQL Stored Procedures SQL Databases SQL Server Integration Services Tableau (Software) Freeform SQL Cloud Platform System Snowflake Information Technology Data Lineage Data Analytics Qlikview Tools for Reporting Domo SQL Server Management Studio (SSMS) Looker Analytics Data Pipelines

Job description

  • Design, develop, and maintain enterprise-grade dashboards, reports, and self-service analytics solutions using Power BI and Domo to support operational, strategic, and executive decision-making
  • Write, optimize, and tune complex SQL queries against SQL Server and Snowflake databases to extract, transform, and aggregate data for reporting and analytical purposes
  • Develop and manage ETL/ELT pipelines and dataflows to integrate data from multiple sources into a cohesive reporting layer
  • Perform thorough data validation and quality assurance to ensure accuracy, consistency, and reliability of all reporting outputs before delivery to stakeholders
  • Identify and implement opportunities to use agentic AI assistants for automated data quality checks, anomaly detection, trend analysis, and natural language report generation
  • Document reporting processes, data sources, data lineage, transformation logic, and business rules for future reference and knowledge sharing

Requirements

Do you have experience in Trend analysis?, Do you have a Bachelor’s degree?, * Strong written and verbal communication skills with the ability to present data insights clearly to both technical and non-technical audiences, including executive leadership

  • Analytical mindset with strong attention to detail and a commitment to data accuracy and integrity
  • Organized, with the ability to manage multiple concurrent projects and work independently toward project-driven deadlines, in person or remote

Desired Technical Skills

  • 3-5 years of hands-on experience building dashboards, reports, and data models in a professional setting including writing complex SQL queries, with strong proficiency in joins, subqueries, window functions, CTEs, stored procedures, and query performance tuning
  • Experience with Domo, including building dataflows, creating Beast Mode calculations, designing cards and dashboards, managing connectors, and scheduling data refreshes
  • Solid experience querying and managing data from Microsoft SQL Server, including proficiency with SQL Server Management Studio (SSMS) and familiarity with SSIS or similar ETL tools
  • Experience working with Snowflake cloud data platform, including writing performant queries, understanding Snowflake architecture, and working with Snow SQL or the Snowflake web interface
  • Solid understanding of data warehousing concepts, star and snowflake schemas, dimensional modeling, and slowly changing dimensions
  • Exposure to additional BI platforms such as Tableau, Looker, or Qlik is a strong plus
  • Experience leveraging AI-powered analytics and reporting tools (e.g., Power BI Copilot, AI-assisted query generation, natural language BI interfaces) to improve productivity and reporting quality
  • Understanding of ETL/ELT processes and data pipeline architecture, * Four-year college degree from a regionally accredited college or university in Computer Science, Information Technology, Data Analytics, Business Intelligence, Statistics, or a related field preferred (or equivalent relevant experience)
  • 3-5 years of experience in a BI development, reporting, or business intelligence role with hands-on dashboard and data model building responsibilities
  • Demonstrated experience integrating AI-powered analytics and development tools into daily reporting and data analysis workflows

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on indeed.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

3:03 min

Career evolution in data engineering and AI platforms

Maria Apazoglou · Coffee With Developers

1:46 min

Traditional data architecture before Microsoft Fabric

Dr. Alexander Wachtel Dr. Alexander Wachtel +1 · WWC 2025

1:31 min

Baseline developer skills for software data science

Markus Harrer Markus Harrer · WWC 2021

3:48 min

Standardizing data access schemas with OData

Florian Bader Florian Bader · WWC Europe 2026

1:44 min

Replacing complex BI dashboards with live LLM queries

Jordan Tigani Jordan Tigani · WWC Europe 2026

3:15 min

Comparing standalone visualization applications with programmatic charting libraries

Johanna Schmidt · LIVE

Videos

See all

Related articles

See all