Business Intelligence & Reporting Analyst

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 has an opportunity available for a Full-Time Business Intelligence & Reporting Analyst. This position has a starting salary range of $75,000.00 - $95,000.00 annually. The workweek for this position is full-time, Monday-Friday, on-site at our facility near I-70 and Monaco in Denver, CO. You will own and maintain datasets in SQL Server and lead initiatives in reporting, analytics, and exploring AI integrations.

Compensation And Benefits

• Competitive starting pay
• $75,000.00 - $95,000.00 annually, depending on experience.
• Stable, full-time, and reliable position
• Monday – Friday, 7:00am – 4:30pm, keep your weekends and evenings free.
• Comprehensive benefits package
• Medical, dental, vision, short term and long-term disability plans, 401(k), paid holidays, and vacation.
• Great work environment
• This is an excellent opportunity to work with an established, dynamic, and growing data-driven company while leveraging your expertise in Power BI and SQL server.

Job Duties And Responsibilities

Acme Manufacturing is a well-established manufacturing company focused on making advancements through automation, advanced analytics, data-driven insights, and innovative integration of legacy systems into modern architectures. As we embrace this digital transformation, we are looking for a Business Intelligence & Reporting Analyst to lead our initiatives in reporting, analytics, and exploring potential AI integrations. In this position you’ll own and maintain datasets in SQL Server, build and publish Power BI reports and dashboards, manage Power BI workspaces/permissions, and deliver insights and tools that help our teams act faster and smarter. You will work closely with our internal programming team that handles the functions and data exports from our ERP—no specific programming experience is required. Primary duties include but are not limited to:

• 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.

Required Skills & Experience

• 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.

Preferred Qualifications

• 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).
• Exposure to HR/time systems (e.g., UKG) and common sales/operations data sources.

What Success Looks Like (6–12 Months)

• Certified, documented datasets for core functions (e.g., sales, inventory, production, labor).
• Reliable refreshes with alerting and quick resolution of failures.
• A clear intake/prioritization process and SLA for report requests.
• Widely adopted dashboards that leadership references in weekly/monthly reviews.
• Fewer ad-hoc data fires because the right data is available, trusted, and easy to use.

Who We Are

Acme Manufacturing is a Denver-based company located at I-70 and Monaco, about 5 miles east of Downtown Denver. We manufacture and distribute metal products used mainly in the building trades. We employ a diverse range of people from all walks of life. Our team members are passionate about what they do, and we are in turn dedicated to our talented personnel. We believe a company is as successful as its employees, and we strive to provide a positive, inclusive, and engaging work environment. We work collaboratively as a team to achieve our goals and offer great employee perks to attract top talent, leading to life-long careers. Over the past 30 years the Acme Manufacturing family of brands has grown to include a wide variety of quality products – this includes metal shapes and sheet, garage door parts, landscape products, decorative door hardware, chain, and threaded products. A career at Acme includes advancement opportunities, cross-training between roles, employee enrichment programs and a great workplace community. We offer competitive salaries and benefits packages, as well as bonus opportunities.