Business Intelligence Engineer; CPG industry​/Circana

Join to apply for the Data Engineer II role at Advantage Solutions
.

This range is provided by Advantage Solutions. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

$61,000.00/yr - $/yr

Level II engineers, or mid‑level software engineers, expand upon their foundational knowledge and develop an understanding of best practices for writing code and developing computer software. They are familiar with multiple coding languages and comfortable with software development tools. They can work independently and regularly assist Level I or Level II engineers with task‑related or troubleshooting problems. They develop, ship, and maintain product features with guidance from their manager and senior engineers, understand and make well‑reasoned design decisions on large or complex product features, and prioritize tasks that enable others to move faster.

• 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, and uses 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.
• Manages and maintains existing dashboards and semantic models as required.
• Leads client meetings to gather and define business requirements, ensuring alignment with project goals and stakeholder expectations.

• 3-6 years of experience as data analyst.
• Experience using Databricks and writing Spark SQL 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‑SQL 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.
• SSAS experience is a plus.
• Basic to intermediate experience with Python (Pandas).
• Experience using Copilot chat for analytics, research, proofing, etc.
• Experience with graphic design concepts and user interface elements.

Travel up to 5% for this position.

Direct reports:
This position does not have supervisory responsibilities for direct reports.

Indirect reports:
Does not have direct reports, but may delegate work of others and provide guidance, direction and mentoring to indirect reports.

Job will remain open until filled.

Associate

Full‑time

Human Resources, Administrative, and Customer Service

Manufacturing

Referrals increase your chances of interviewing at Advantage Solutions by 2×.