Operational Analyst

Operational Analyst

The role with the Joint Use Office Operation team in the Utility Asset Management department is integral to efficiently managing communication equipment on company poles. The dedicated team is tasked with ensuring adherence to operational processes designed to cater to communication companies (licensees) while upholding safety standards mandated by OPUC, OAR, and NESC regulations. Compliance with strict timelines and obligations set forth by these regulatory bodies remains a top priority for the team, reflecting the professionalism and commitment required to effectively execute their responsibilities. In this role, the data analyst plays a crucial part in collecting and analyzing data, maintaining databases, preparing insightful reports, develop visualization and creating interactive dashboards for both leadership and Subject Matter Experts (SMEs). This position requires seamless collaboration with fellow colleagues to pinpoint areas for enhancing existing reports and analyses, underscoring the necessity for strong communication and problem-solving skills alongside a knack for teamwork to comprehend business processes and requirements effectively. Proficiency with tools such as SQL, Snowflake, Tableau Desktop, Tableau Server, Excel, and Outlook is paramount. As typical day-to-day tasks, the data analyst takes on a variety of responsibilities to ensure data-driven decision-making is at the forefront of operational success. This involves Using data in Snowflake, Tableau Extracts, and Excel to extract information from data sets and identify correlations and patterns Using Tableau desktop to visualize data in easy-to-understand formats, such as diagrams, graphs, filters, parameters, creating complex calculated fields, creating LOD expression Using Tableau server to publish workbooks and data extracts Organizing and transforming information into comprehensible structures Performing statistical analysis of data Preparing reports and presenting these to management or SMEs Monitoring data quality and removing corrupt data Validating their analysis results Communicating with stakeholders to understand data content and business requirements