Acme Manufacturing is looking for a Business Intelligence & Reporting Analyst to lead initiatives in reporting, analytics, and exploring potential AI integrations as part of their digital transformation.
Requirements
- Solid SQL skills (CTEs, window functions, performance-aware querying; ability to build views).
- Hands-on Power BI experience: data modeling, DAX, Power Query (M), report design, and workspace management.
- Understanding of dimensional modeling/star schemas and KPI design.
- Comfort working with CSV/flat-file exports and turning them into clean, reliable tables.
- Familiarity with the current AI environment and potential use cases.
- Experience with SQL Server Agent jobs, SSIS/ETL, or data gateways.
- Familiarity with manufacturing metrics (throughput, OEE, scrap, lead times) and financial KPIs (sales, margin, variance).
Responsibilities
- Own the reporting stack: Maintain curated SQL Server tables/views for analytics; document data definitions and lineage.
- Build useful reports: Design, develop, and support Power BI dashboards/reports for Finance, Operations, Sales, and HR.
- Data quality & refreshes: Monitor scheduled refreshes, troubleshoot failures, and ensure data is timely and accurate.
- Workspace administration: Manage Power BI workspaces, datasets, gateways, row-level security, and access controls.
- Self-service enablement: Create certified datasets, templates, and how-tos that enable power users.
- Partner with Programming Team: Align on data export schedules/formats from the ERP; validate and reconcile loads.
- Ad hoc analysis: Run analyses that explain trends (e.g., margins, variances, productivity) and recommend actions.
Other
- 3–5 years in a reporting/BI, data analyst, or similar role (manufacturing or multi-site environment a plus).
- Education: Bachelor’s degree in a quantitative, technical, or business-related field.
- Strong communication: translate business questions into datasets, metrics, and visuals.
- Organized and service-oriented with good judgment on prioritization and trade-offs.
- Full-time, Monday-Friday, on-site at our facility near I-70 and Monaco in Denver, CO.
