Power BI Report Developer & Analyst

Open Hand Atlanta Inc•Atlanta, GA

14h•Hybrid

About The Position

We are seeking a highly analytical and technical Power BI Report Developer & Analyst to bridge the gap between complex data and actionable business strategy. This role is pivotal to our food manufacturing operations, focusing on the design, development, and maintenance of Power BI ecosystems integrated directly with our ERP. The successful candidate will provide the visibility necessary to optimize inventory, stabilize COGS, and enhance production efficiency. We are looking for a professional who possesses not only the technical rigor of a data developer but also the business acumen to understand the nuances of manufacturing and financial workflows.

Requirements

Analytical Rigor: A natural tendency to question data and seek the underlying truth.
Detail Orientation: An uncompromising commitment to data accuracy and validation.
Translational Skills: The ability to explain complex technical concepts to non-technical stakeholders.
Operational Mindset: A fundamental understanding of how manufacturing floors operate and how data reflects physical movement.
Bachelor’s or Associate degree in a quantitative field (e.g., Data Analytics, Info Systems, Finance, Engineering) or equivalent technical certifications.
3+ years of dedicated experience in Power BI development and data modeling.
Advanced proficiency in DAX and Power Query.
Deep understanding of relational databases and data warehousing concepts.
Hands-on experience with ERP systems (experience with Aptean is a significant advantage).
Advanced Microsoft Excel skills (Power Pivot, VBA, etc.).

Nice To Haves

Experience within the food manufacturing or FMCG sectors.
Strong understanding of standard costing, COGS, and inventory accounting.
Proficiency in SQL for data extraction and manipulation.

Responsibilities

Design, develop, and deploy sophisticated, interactive Power BI dashboards that simplify complex datasets into intuitive KPIs.
Establish a suite of standardized reports focusing on Inventory: Accuracy, turnover rates, and aging.
Establish a suite of standardized reports focusing on Financials: Cost of Goods Sold (COGS) and detailed variance analysis.
Establish a suite of standardized reports focusing on Production: Yield tracking, labor efficiency, and throughput.
Establish a suite of standardized reports focusing on Quality: Waste/shrinkage, rework metrics, and compliance tracking.
Establish a suite of standardized reports focusing on Supply Chain: Vendor performance and procurement lead times.
Build and maintain robust data models utilizing DAX and Power Query (M).
Seamlessly integrate data from Aptean (ERP), SQL databases, SharePoint, and external Excel sources.
Ensure absolute data accuracy and governance across all reporting layers; perform regular audits to troubleshoot discrepancies such as inflated inventory or cost variances.
Identify trends and anomalies to uncover the "why" behind production or financial variances.
Collaborate with Finance, Operations, and Quality teams to interpret data and provide actionable recommendations for cost management and process improvement.
Serve as the subject matter expert for ERP reporting, identifying gaps in system processes that may negatively impact data reliability.
Proactively enhance existing report structures to adapt to evolving business needs.
Translate stakeholder needs into technical specifications.
Conduct training sessions for end-users to promote self-service reporting and data literacy.
Bridge the gap between technical data structures and executive-level business insights.