BI & Reporting Analyst — Power BI, SQL & AI Enablement

Ultipro; Denver (CO); On-site; USD 75,000 - 95,000; Full time

Benefits offered by this job

Medical, dental, vision

401(k)

Paid holidays

Vacation

Job summary

Acme Manufacturing, a Denver-based company near I-70 and Monaco, seeks a Business Intelligence & Reporting Analyst to own datasets in SQL Server and publish Power BI reports. You will lead analytics initiatives, manage Power BI workspaces, and deliver insights that help teams act faster and smarter.

The role emphasizes data quality, ad hoc analysis, and collaboration with our ERP programming team. Strong SQL and Power BI skills are essential for success.

Qualifications

• 3–5 years in a reporting/BI, data analyst, or similar role (manufacturing or multi-site environment a plus).
• 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.

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.
• Be the reporting Point-of-Contact: Intake requests, triage, prioritize, and communicate timelines/status with stakeholders.
• 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.
• Process improvement: Propose changes to make reporting faster, clearer, and more reliable.

Skills

SQL

Power BI

Data modeling

Communication

Prioritization

Education

Bachelor's degree

Tools

Power BI Workspace

Job description

Acme Manufacturing, a Denver-based company near I-70 and Monaco, seeks a Business Intelligence & Reporting Analyst to own datasets in SQL Server and publish Power BI reports. You will lead analytics initiatives, manage Power BI workspaces, and deliver insights that help teams act faster and smarter.

The role emphasizes data quality, ad hoc analysis, and collaboration with our ERP programming team. Strong SQL and Power BI skills are essential for success.