Operations Reporting Business Analyst - Spectrum Reach

Spectrum Reach (www.spectrumreach.com) grows businesses of all sizes with custom, multiscreen advertising solutions, backed by the power of TV, data, innovation, community experts, and unforgettable creative.

Intermediate position, under general supervision, responsible for gathering data requirements and building comprehensive analysis while utilizing data tools such as Excel, Tableau, etc. Greater understanding of the business, workflows, and handoffs as well as backend systems and databases.

• Actively and consistently support all efforts to simplify and enhance the customer experience.
• Develop reports and deliverables for management and communicate with all levels of stakeholders.
• Pull and integrate data from multiple sources such as vendor sites, production systems, CRM, and order management tools to produce requested metrics and data elements
• Develop and maintain dashboards utilizing visualization tools such as Excel, Tableau, Looker, MicroStrategy or other reporting tool. Utilize PowerPoint to create graphs and charts to present data.
• Develop dashboard connections with visualization tools (PowerPivot, Tableau, etc).
• Create advanced graphs and calculations, month over month, year over year, normalization, and additional trending/pacing to identify and curb negative growth or behaviors.
• Ensure compliance with deliverable reporting requirements by performing quality data audits, validation, and analysis.
• Work with technical analysts to provide clear data requirements including specific fields, tables, or joins.
• Independently lead and takes ownership of project/reporting efforts from concept to completion (work with vendor, technical analysts, and customers.
• Provide adhoc reports as neede
• Capture, develop, and document data definitions, ETLs, business rules, and data quality requirements.
• Work closely with end users and stakeholders to proactively recommend reporting solutions.
• Identify gaps in workflow to ensure data integrity, participate in data governance related efforts and make recommendations to uphold strong data standards.
• Knowledge of CRM/OMS or production system data.
• Perform other duties as requested.

• Ability to prioritize and organize effectively
• Ability to work independently, as well as in a collaborative and dynamic team environment
• Ability to analyze and interpret data
• Ability to quickly identify business problems/opportunities
• Ability to communicate orally and in writing in a clear and straightforward manner
• Ability to communicate with all levels of management and company personnel
• Ability to manage multiple projects at one time
• High attention to detail
• Ability to document, prepare and present data-driven presentations
• Advanced skills in Microsoft suite; Excel (PowerQuery, PowerPivot, PowerBI), Word, PowerPoint
• Knowledge of OMS or CRM data and handoffs (SalesForce and Traffic databases)
• General knowledge of SQL and relational databases

Education:

Bachelor's degree or equivalent experience