Senior BI & Reporting Analyst: Power BI, SQL, AI

Acme Manufacturing Company Inc.; Denver (CO); On-site; USD 75,000 - 95,000; Full time

Benefits offered by this job

Medical benefits

401(k)

Paid time off

On-site

Job summary

Acme Manufacturing Company Inc. in Denver, CO is seeking a Full-Time Business Intelligence & Reporting Analyst to own and maintain datasets in SQL Server, build Power BI reports, and publish dashboards for multiple functions.

This on-site role emphasizes data quality, security, and timely insights to accelerate decision-making. You will collaborate with our programming team and ERP data exports, manage Power BI workspaces, and enable self-service analytics.

Qualifications

• 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.
• 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.
• Strong communication: translate business questions into datasets, metrics, and visuals.
• Organized and service-oriented with good judgment on prioritization and trade-offs.

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

DAX

Power Query

Data modeling

Communication

Analytical thinking

Education

Bachelor's degree

Tools

SQL Server Agent

SSIS

Data gateways

Job description

Acme Manufacturing Company Inc. in Denver, CO is seeking a Full-Time Business Intelligence & Reporting Analyst to own and maintain datasets in SQL Server, build Power BI reports, and publish dashboards for multiple functions.

This on-site role emphasizes data quality, security, and timely insights to accelerate decision-making. You will collaborate with our programming team and ERP data exports, manage Power BI workspaces, and enable self-service analytics.