Data Analyst

Description

The successful candidate will serve as diagnostician and solution provider for data, information and processrelated business challenges.Works with business unit personnel to understand and resolve information and process challenges in a collaborative manner. Provides expertise in the integration of data related to endtoend business processes.Proactively creates hypotheses and defines necessary data extractions to validate hypotheses.Teams with other analysts to extract, interpret, and perform advanced analytics on data findings.a) Data Investigation and Extraction Extracts data from operational systems and reporting databases using advanced SQL through a variety of reporting tools, including Teradata SQL Assistant, SQL Plus, TOAD, Business Objects, and MS Access.Investigates complex table structures to identify data relationships and the location of required data.Validates accuracy of the results. Stratifies results to provide meaningful insights. Optimizes query performance through SQL tuning.b) Advanced Analytics and Technologies performs advanced techniques in analytics and data management, as it pertains to their specific job role. For analytics, this includes statistical analysis, predictive analytics, business process analysis, and transforming data into information with appropriate business context and opportunities.For technologies, this includes advanced ETL, data modeling, and strategic planning for effective information delivery methods including adhoc, standard reports, dashboards, scorecards, and data visualizations.c) Work Management Manages multiple tasks, with the ability to deal with ambiguity and shifting priorities. Communicates status clearly and timely to management and other team members. Provides accurate time reporting and reasonable estimates for work efforts.Documents extraction methods, SQL coding, and reporting criteria to a level consistent with departmental standards.d) Customer Relationship develops strong relationships with business unit personnel to understand the business challenges and forge a partnering relationship for problem solving. Intimately understands the business and/or information challenge within the business unit. Offers suggestions for improvement and/or further research into data findings or process issues.Clarifies customer requirements, manages expectations, and enhances credibility, transparency, and partnership within Xcel and its vendors