Operations Reporting Business Analyst - Spectrum Reach

Spectrum • Dallas, TX

89d

About The Position

This role requires the ability to work lawfully in the U.S. without employment-based immigration sponsorship, now or in the future. Spectrum Reach grows businesses of all sizes with custom, multiscreen advertising solutions, backed by the power of TV, data, innovation, community experts, and unforgettable creative. This is an intermediate position, under general supervision, responsible for gathering data requirements and building comprehensive analysis while utilizing data tools such as Excel, Tableau, etc. The role involves a greater understanding of the business, workflows, and handoffs as well as backend systems and databases. The candidate will actively and consistently support all efforts to simplify and enhance the customer experience. Responsibilities include developing reports and deliverables for management and communicating with all levels of stakeholders, pulling and integrating data from multiple sources such as vendor sites, production systems, CRM, and order management tools to produce requested metrics and data elements. The candidate will develop and maintain dashboards utilizing visualization tools such as Excel, Tableau, Looker, MicroStrategy or other reporting tools, and utilize PowerPoint to create graphs and charts to present data. The role also requires developing dashboard connections with visualization tools, creating advanced graphs and calculations, ensuring compliance with deliverable reporting requirements, and working with technical analysts to provide clear data requirements. The candidate will independently lead and take ownership of project/reporting efforts from concept to completion, provide adhoc reports as needed, capture, develop, and document data definitions, ETLs, business rules, and data quality requirements, and work closely with end users and stakeholders to proactively recommend reporting solutions. Additionally, the candidate will identify gaps in workflow to ensure data integrity, participate in data governance related efforts, and make recommendations to uphold strong data standards.

Requirements

• Ability to prioritize and organize effectively.
• Ability to work independently and in a collaborative team environment.
• Ability to analyze and interpret data.
• Ability to quickly identify business problems/opportunities.
• Ability to communicate orally and in writing clearly.
• Ability to communicate with all levels of management and personnel.
• Ability to manage multiple projects simultaneously.
• 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.

Responsibilities

• Gather data requirements and build comprehensive analysis using data tools such as Excel and Tableau.
• Support efforts to simplify and enhance the customer experience.
• Develop reports and deliverables for management and communicate with stakeholders.
• Pull and integrate data from multiple sources to produce requested metrics.
• Develop and maintain dashboards utilizing visualization tools.
• Utilize PowerPoint to create graphs and charts for data presentation.
• Create advanced graphs and calculations for data analysis.
• Ensure compliance with deliverable reporting requirements through quality data audits.
• Work with technical analysts to provide clear data requirements.
• Independently lead and take ownership of project/reporting efforts.
• Provide adhoc reports as needed.
• Capture, develop, and document data definitions, ETLs, and business rules.
• Recommend reporting solutions to end users and stakeholders.
• Identify gaps in workflow to ensure data integrity.
• Participate in data governance efforts.

Benefits

• Comprehensive pay and benefits package that rewards employees for their contributions.
• Support for all aspects of employee well-being at every stage of life.

What This Job Offers

• Career Level: Mid Level
• Industry: Telecommunications
• Education Level: Bachelor's degree