Advantage Solutions · 1 month ago
BI Engineer
US-ID-Boise
Full-time
Onsite
Entry, Mid Level
2+ years expAdvantage Solutions is one of North America’s leading sales and marketing agencies specializing in outsourced sales and marketing services. The BI Engineer will be responsible for the entire lifecycle of small-to-medium-sized projects, including design, development, and testing, while also enhancing the development experience for their team and managing existing dashboards.
ConsumerMarketingRetail
Responsibilities
Responsible for the entire lifecycle of small-to-medium-sized projects: engineering design, development, testing, production, and subsequent fixes and improvements
Capable of providing on-call support for features they or their team are responsible for
Designs and builds dashboards that are clear, concise, tested, and easily understood by others
Regularly refactors code to improve error handling, testability, and maintainability
Tracks issues and responds if an external contributor or partner raises a ticket/issue related to their Power BI dashboards
Improves the development experience for their team by enhancing development tools, test coverage, and/or code structure. Uses and understands systematic tools needed to debug and diagnose issues in a CI/CD pipeline
Contributes to code specifications and participates in small-scale code reviews
Mastered understanding of all components of key features and architecture for one product, with a high-level understanding of several other products, integrations, and capabilities
Understands, advocates, and contributes engineering standards and development best practices
Learns, understands, and considers the importance of non-functional requirements
Growing understanding of industry trends and development best practices and is comfortable writing code in an open-source setting
Identifies conflicting requirements across the company and flags them to their manager
Identifies risks in code, features, and design, and communicates these to their team to collaborate on solutions
Effectively communicates the impact and tradeoffs of multiple solutions when presenting solutions to problems
Finds solutions to unsolved, loosely-defined, highly-technical problems
Manage and maintain existing dashboards and semantic models as required
Lead client meetings to gather and define business requirements, ensuring alignment with project goals and stakeholder expectations
Collaboration with the administrative tenant side of Power BI
Qualification
Required
2-4 years of experience as Business Intelligence Analyst
Experience using Databricks and writing Spark Sequel queries into various medallion layers
Power BI Experience
Intermediate DAX
Basic knowledge of M code for Power BI Power Query ETL process
Understanding of modeling concepts
Experience connecting to various data sources
Basic to Intermediate knowledge of analytical concepts
CPG Industry knowledge working with Circana and /or NIQ data (Syndicated, Panel, Custom databases)
Basic to Intermediate knowledge of SSMS and writing T-Sequel statements to query data (Joins, aggregates etc.)
Experience with MS Teams
Experience with Office 365 (Powerpoint, Excel, Outlook etc.)
Strong communication skills
Presentation skills
Understanding of semantic models as it pertains to Power BI
Understanding of Tabular models
Foundations of engineering, programming, software development
Foundations of data structures, algorithms, operating systems, networks, languages
Foundations of concurrent and event-based development
Foundations of development and test frameworks
BSCS…Engineering degrees etc etc…and (optional) MS
Preferred
Experience with Graphic design concepts and UI/UX fundamentals is a plus
SSAS experience is a plus
Basic to intermediate experience with Python (Pandas) is a plus
Experience using Copilot for analytics, research, proofing etc is a plus
Company
Advantage Solutions
Advantage Solutions is a premier sales and committed to building brand value for our clients and customers.
10001+ employees
H1B Sponsorship
Advantage Solutions has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (5)
2024 (7)
2023 (5)
2022 (2)
2021 (3)
2020 (2)
Funding
Current Stage
Public CompanyTotal Funding
$3.35BKey Investors
Juggernaut Capital Partners
2020-10-29IPO
2020-10-28Post Ipo Equity· $855M
2020-10-28Post Ipo Debt· $2.5B
Leadership Team
David Peacock
Chief Executive Officer
Brian G Stevens
Chief Financial Officer & Chief Operating Officer
Recent News
Bizjournals.com Feed (2025-11-12 15:43:17)
2026-01-13
2025-11-08
2025-11-08
Company data provided by crunchbase