BI Developer

Augeo Affinity Marketing, Inc.•Saint Paul, MN

19h•Hybrid

About The Position

An Encore BI Developer will be responsible for designing, building, and maintaining business intelligence solutions – including interactive dashboards, automated reports, and scalable data models – that empower stakeholders across the organization to make informed, data-driven decisions. This individual will serve as a hands-on builder, developing reporting solutions primarily while writing performant SQL against SQL Server and Snowflake environments. You’ll translate complex business requirements into polished, production-ready BI deliverables and partner directly with business analysts, product owners, and engineering teams to define reporting strategies, surface trends, and proactively deliver insights that drive business outcomes. You’ll also be expected to leverage AI-powered analytics tools and agentic AI assistants to accelerate development, automate data preparation and quality workflows, and continuously improve the speed and depth of insight delivery across the organization.

Requirements

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
Understanding of ETL/ELT processes and data pipeline architecture
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
Demonstrated experience integrating AI-powered analytics and development tools into daily reporting and data analysis workflows

Nice To Haves

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

Responsibilities

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
Embrace Augeo’s CORE values – Collaborative, Objective, Responsive, and Earnest in all areas

Benefits

Medical, Dental and Vision coverage with additional perks through third party vendors offering more virtual and in person care at your fingertips (must be in select locations)
Paid Long-Term disability and Life Insurance
HSA/FSA plans
Varying voluntary benefits such as critical, hospital, pet coverage and much more
Employee benefit education, campaigns and wellness opportunities
401k retirement matching and financial planning resources
Education reimbursement
Several EAP resources
13 paid holidays and PTO time
Rewards, incentives and gamification for birthdays, Work-aversery's, professional and personal milestones, company involvement and kudos
Employee referral bonuses
Employee group opportunities
Fun, casual and flexible working environment that embraces the hybrid workstyle
Career growth opportunities
Summer internship program