BI Developer

Job TypeFull-timeDescriptionHello, we're Augeo - we are a global leader in enterprise-level engagement and loyalty platform technology, delivering compelling experiences and fostering meaningful connections for employees, consumers, members and channel partners across many industries and verticals. We serve hundreds of clients, including 70+ Fortune 500 companies, representing millions of end users. We are thought leaders and disruptors who think differently and creatively, built by entrepreneurs, operators and innovators.At Augeo, we're passionate about providing an inclusive workplace that values diversity and our sustainability initiatives. Everyone is welcome - our employees are comfortable bringing their authentic whole selves to work. Be you, reach your full potential.We work hard, we play hard and, most importantly, we care to our core about our teams and each other. We over-communicate around everything...especially while we navigate our new hybrid world.SummaryAn 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.Who You AreAn innovator who brings ideas to the table, works hard, tells your story, and builds new tech - someone who is a genuine collaborator who contributes to the team and helps accomplish amazing things in a high-energy and dynamic environment.High-level Job RequirementsDesign, develop, and maintain enterprise-grade dashboards, reports, and self-service analytics solutions using Power BI and Domo to support operational, strategic, and executive decision-makingWrite, optimize, and tune complex SQL queries against SQL Server and Snowflake databases to extract, transform, and aggregate data for reporting and analytical purposesDevelop and manage ETL/ELT pipelines and dataflows to integrate data from multiple sources into a cohesive reporting layerPerform thorough data validation and quality assurance to ensure accuracy, consistency, and reliability of all reporting outputs before delivery to stakeholdersIdentify and implement opportunities to use agentic AI assistants for automated data quality checks, anomaly detection, trend analysis, and natural language report generationDocument reporting processes, data sources, data lineage, transformation logic, and business rules for future reference and knowledge sharingEmbrace Augeo's CORE values - Collaborative, Objective, Responsive, and Earnest in all areasCompetenciesStrong written and verbal communication skills with the ability to present data insights clearly to both technical and non-technical audiences, including executive leadershipAnalytical mindset with strong attention to detail and a commitment to data accuracy and integrityOrganized, with the ability to manage multiple concurrent projects and work independently toward project-driven deadlines, in person or remote Desired Technical Skills3-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 tuningExperience with Domo, including building dataflows, creating Beast Mode calculations, designing cards and dashboards, managing connectors, and scheduling data refreshesSolid experience querying and managing data from Microsoft SQL Server, including proficiency with SQL Server Management Studio (SSMS) and familiarity with SSIS or similar ETL toolsExperience working with Snowflake cloud data platform, including writing performant queries, understanding Snowflake architecture, and working with Snow SQL or the Snowflake web interfaceSolid understanding of data warehousing concepts, star and snowflake schemas, dimensional modeling, and slowly changing dimensionsExposure to additional BI platforms such as Tableau, Looker, or Qlik is a strong plusExperience 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 qualityUnderstanding of ETL/ELT processes and data pipeline architecture Education and ExperienceFour-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 responsibilitiesDemonstrated experience integrating AI-powered analytics and development tools into daily reporting and data analysis workflows Work Environment This job operates in a professional office environment. This role routinely uses standard office equipment such as laptop computers and smartphones. Physical Demands The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. While performing the duties of this job, the employee is occasionally required to stand; walk; sit; use hands to finger, handle, or feel objects, tools, or controls; reach with hands and arms; climb stairs; balance; stoop, kneel, crouch, or crawl; talk or hear; and taste or smell. The employee must occasionally lift or move up to 20 pounds. Specific vision abilities required by the job include close vision, distance vision, color vision, peripheral vision, depth perception, and the ability to adjust focus. Travel Travel is primarily local during the business day, although occasional out-of-area and overnight travel may be expected. Benefits of joining team AugeoWe offer 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)We offer paid Long-Term disability and Life InsuranceHSA/FSA plansWe offer varying voluntary benefits such as critical, hospital, pet coverage and much moreEmployee benefit education, campaigns and wellness opportunities401k retirement matching and financial planning resourcesEducation reimbursementSeveral EAP resources13 paid holidays and PTO timeRewards, incentives and gamification for birthdays, Work-aversery's, professional and personal milestones, company involvement and kudosEmployee referral bonusesEmployee group opportunitiesFun, casual and flexible working environment that embraces the hybrid workstyleCareer growth opportunitiesSummer internship program *St. Paul MN Preferred, but open to remote Salary Description $95,000 - $105,000