BI Engineer

Advantage Solutions•Boise, ID

23d•$61,000 - $100,800•Remote

About The Position

BI engineer that will expand upon their foundational knowledge and develop an understanding of best practices for writing code and developing computer software. These people are familiar with multiple coding languages and are comfortable with software development tools. They can work independently and regularly assist level one or level two engineers with task-related or troubleshooting problems. Develops, ships, and maintains product features with guidance from their manager and senior engineers. Understands and makes well-reasoned design decisions on large or complex product features. This individual will act as a multiplier on the team. Often prioritizes, and values, unowned or undesirable tasks that enable others to move faster.

Requirements

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

Nice To Haves

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.
Experience with Graphic design concepts and UI/UX fundamentals is a plus.

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.