Business Intelligence Developer

Hiro Talent Solution seeks an on-site Business Intelligence Developer in Saint Paul, MN to design, develop, and sustain analytics initiatives using Power BI and Domo to support informed decision making.

Responsibilities

• Create and maintain enterprise dashboards, reports, and self-service analytics with Power BI and Domo to support operations, strategy, and executive decisions
• Write, optimize, and tune complex SQL queries against SQL Server and Snowflake to extract, transform, and aggregate data for reporting and analysis
• Build and manage ETL/ELT pipelines and dataflows to merge data from multiple sources into a cohesive reporting layer
• Perform thorough data validation and QA to ensure accuracy, consistency, and reliability of reporting outputs before stakeholder delivery
• Identify and implement opportunities to leverage AI assistants for automated data quality checks, anomaly detection, trend analysis, and natural language report generation
• Document reporting processes, data sources, lineage, transformation logic, and business rules for future reference

Requirements

• Strong written and verbal communication, with the ability to present insights clearly to technical and non-technical audiences, including executive leadership
• Analytical mindset with meticulous attention to data accuracy and integrity
• Organized and capable of managing multiple projects, working independently toward deadlines, in person or remote
• 3–5 years of hands-on experience building dashboards, reports, and data models, including writing complex SQL with joins, subqueries, window functions, CTEs, stored procedures, and performance tuning
• Experience with Domo, including dataflows, Beast Mode calculations, dashboards, connectors, and refresh scheduling
• 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 with the Snowflake cloud data platform, including performant queries, understanding of architecture, and use of SnowSQL or the 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 plus
• Experience leveraging AI-powered analytics and reporting tools (eg, Power BI Copilot, AI-assisted query generation, natural language BI interfaces) to boost productivity and report quality
• Understanding of ETL/ELT processes and data pipeline architecture
• Four-year college degree from a regionally accredited institution in Computer Science, Information Technology, Data Analytics, Business Intelligence, Statistics, or related field preferred, or equivalent experience
• 3–5 years 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 workflows

Technologies

• Power BI
• Domo
• SQL Server
• Snowflake
• SQL Server Management Studio (SSMS)
• SSIS
• SnowSQL
• Snowflake web interface
• Tableau
• Looker
• Qlik
• Power BI Copilot
• Beast Mode calculations

Competencies

• Clear written and verbal communication, capable of translating data into actionable insights for technical and non-technical stakeholders, including executives
• Analytical mindset with strong attention to detail and commitment to data accuracy
• Organized and self-directed, able to manage multiple projects and meet deadlines, whether onsite or remote

Desired Technical Skills

• 3–5 years building dashboards, reports, and data models with advanced SQL (joins, subqueries, window functions, CTEs, stored procedures) and performance tuning
• Hands-on Domo experience: dataflows, Beast Mode, cards, dashboards, connectors, and refresh scheduling
• Proficiency with SQL Server and SSMS, plus familiarity with SSIS or similar ETL tools
• Experience with Snowflake, writing performant queries and using SnowSQL or the web interface
• Solid grasp of data warehousing concepts, dimensional modeling, and slowly changing dimensions
• Exposure to BI platforms such as Tableau, Looker, or Qlik is advantageous
• Experience applying AI-powered analytics and reporting tools to improve productivity and output quality
• Understanding of ETL/ELT processes and data pipeline architecture

Location

Saint Paul, MN onsite

Pay

USD 30.00 - 70.00 per hour