BI Solutions Architect

Introduction:

The BI Solutions Architect will be responsible for end-to-end BI architecture, data modeling, and governance across modern analytics platforms. They will work closely with stakeholders to translate business requirements into scalable dashboards, KPIs, and analytical solutions. This role requires expertise in BI Architecture, Business Intelligence, Data Modeling, ELT, SQL, and CPG.

Responsibilities:

• Develop end-to-end BI architecture, data modeling, and governance across modern analytics platforms.
• Utilize advanced Microsoft BI expertise, including Power BI, Microsoft Fabric, semantic models, DAX, and Power Query.
• Strong SQL and ETL/ELT development with a focus on performance optimization and data reliability practices.
• Translate business requirements into scalable dashboards, KPIs, and analytical solutions.
• Utilize analytics and decision support skills for scenario analysis, forecasting, and insight-driven storytelling.
• Experience in CPG or food manufacturing, with working knowledge of Dynamics 365 Finance & Operations.
• Collaborate with stakeholders to deliver solutions and drive analytics adoption through training and enablement.

Requirements:

Required Skills:

• End-to-end BI architecture, data modeling, and governance across modern analytics platforms.
• Advanced Microsoft BI expertise including Power BI, Microsoft Fabric, semantic models, DAX, and Power Query.
• Strong SQL and ETL/ELT development with proven performance optimization and data reliability practices.
• Ability to translate business requirements into scalable dashboards, KPIs, and analytical solutions.
• Analytics and decision support skills, including scenario analysis, forecasting, and insight-driven storytelling.
• Experience in CPG or food manufacturing, with working knowledge of Dynamics 365 Finance & Operations.
• Strong stakeholder collaboration, solution delivery, and driving analytics adoption through training and enablement.

Preferred Skills:

• Experience with Dynamics 365 Finance & Operations.
• Previous experience in a similar role within the CPG industry.
• Knowledge of data visualization tools and techniques.
• Certifications in BI Architecture or related fields.