Business Intelligence Developer
HERO TALENT SOLUTIONS LLC
Saint Paul, United States of America
2 days ago
Role details
Contract type
Permanent contract Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
English Experience level
Intermediate Compensation
$ 146KJob location
Remote
Saint Paul, United States of America
Tech stack
Query Performance
Artificial Intelligence
Data analysis
Business Intelligence
Databases
Data Validation
ETL
Data Warehousing
Programming Tools
Dimensional Modeling
Human-Computer Interaction
Microsoft SQL Server
Power BI
SQL Stored Procedures
SQL Databases
SQL Server Integration Services
Tableau
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