Data Analyst: Insights, Forecasts & Dashboards

Spectrum; Greenwood Village (CO); On-site; USD 61,000 - 107,000; Full time

Job summary

Spectrum is seeking a Data Analyst to manage data reporting and deliver forecasts, dashboards and ad hoc analyses that empower teams to maximize resources. You’ll generate insights to drive smarter business decisions and help Spectrum grow by transforming data into actionable information.

Join Spectrum to influence customer service and operations with rigorous data definitions, quality checks, and cross-source data integration. A Bachelor’s degree and 2+ years of experience are required.

Qualifications

• Bachelor’s degree in business or related field or equivalent experience.
• 2+ years of data analysis and reporting or related experience.
• Ability to prioritize and organize effectively, handle multiple projects and priorities, and manage multiple projects at one time.
• Ability to work independently, as well as in a collaborative and dynamic team environment.
• Ability to analyze and interpret data and document, prepare and present data-driven presentations.
• Ability to quickly identify business problems/opportunities.
• Ability to communicate orally and in writing with all levels of management.

Responsibilities

• Conduct data analysis in support of a variety of analytic solutions.
• Capture, develop, and document data definitions, business rules, and data quality requirements.
• Integrate data from multiple sources to produce requested or required data elements.
• Create and produce forecasts, reports, ad hoc requests, dashboards, etc.
• Interpret data, analyze results, and provide insights to determine operational impact, trends, and opportunities.
• Develop reports and deliverables for management and communicate with all levels of stakeholders.
• Identify and define data quality improvements.
• Create and maintain report forms and formats, information dashboards, data generators, canned reports and other end-user information portals or resources.
• Ensure compliance with deliverable reporting requirements by performing quality data audits and analysis.
• May create specifications for reports based on business requests.

Skills

Data analysis

Forecasting

Dashboards

Data interpretation

Communication

SQL

Pivot tables

VLOOKUP/XLOOKUP

Education

Bachelor’s degree in business or related field

Tools

Excel

SAP S/4HANA

Web Intelligence (WebI)

Ariba

SAP BusinessObjects

Job description

Spectrum is seeking a Data Analyst to manage data reporting and deliver forecasts, dashboards and ad hoc analyses that empower teams to maximize resources. You’ll generate insights to drive smarter business decisions and help Spectrum grow by transforming data into actionable information.

Join Spectrum to influence customer service and operations with rigorous data definitions, quality checks, and cross-source data integration. A Bachelor’s degree and 2+ years of experience are required.