Logo
Orlando Utilities Commission

Data Analyst - Power BI

Orlando Utilities Commission, Orlando, Florida, us, 32885

Save Job

Overview

OUC - The Reliable One is presently seeking a Data Analyst – Power BI to join the Transformation division. At OUC, we don’t just work – we’re building a bright future of innovation and transformation for future generations. We are looking for an experienced and analytical professional to support, maintain, and continuously enhance Power BI reports while driving modernization and improvement efforts. In this role, you will serve as a key resource for Power BI requests and inquiries, collaborate with stakeholders to deliver actionable insights, and support a variety of data analytics initiatives as needed. OUC is an industry leader and the second largest municipal utility in Florida, committed to innovation, sustainability, and our community. OUC’s mission is to provide exceptional value to our customers and community by delivering sustainable and reliable services and solutions. Join a team of visionary Change Agents, Strategists, and Community Ambassadors who understand the vital role diverse experiences play in fueling creativity and driving industry transformation. At OUC, every position contributes to the success of our mission and the achievement of our goals. The ideal candidate will have: Responsibilities

Participate in the creation, validation, and implementation of statistical models and analyze performance of models to ensure accuracy, statistical confidence and validity, and alignment to business goals and needs. Translate quantitative and qualitative data into actionable insights and present findings to management and other stakeholders to enable data-driven strategic decisions across the organization. Assist in identifying trends and actionable insights from data analysis and research, draw actionable conclusions, and summarize results; participate in the recommendation, implementation, and auditing of best practices related to data usage, reporting standards, dashboard formats, visualization style, and analysis methods. Assist in communicating the significance of statistical findings using business acumen and terminology common to the utilities industry. Participate in discussions with stakeholders regarding data, analyses, visualizations, conclusions and recommendations in a manner that influences decisions and outcomes. Perform routine data analysis, research, and studies relative to business discovery use cases. Collaborate with cross-functional teams and external consultants in decisions related to data modeling, dimensionality, data granularity, fit-for-use architecture, and overall data governance. Perform routine data mining for new business insights; interpret data; draw conclusions; communicate findings to relevant stakeholders. Develop strong understanding of OUC data sources, relationships, and best practice usage. Perform troubleshooting and debugging. Prepare, update, and present routine visualizations, dashboards, and reporting. Identify and escalate data anomalies that might affect accuracy. Generate routine scheduled and ad hoc reports, dashboards, and analysis. Provide project support; maintain related reporting and analysis documentation and records. Assist in deep data profiling efforts to gain an understanding of the raw data available for analysis; participate in data mining efforts as part of a data science or machine learning exercise to identify themes and trends for further analysis. Assist in identifying trends; transform information into actionable insights. Perform routine research and analysis to identify data trends, anomalies, and actionable insights that are applicable to OUC. Perform other duties as assigned. Technical Requirements

Working knowledge of data warehousing, data mart, and data lake environments; visualization development; and data analysis. Query routine data structures and derive information for reporting, visualizations, and statistical analysis. Requirements gathering, analysis, and documentation. Data analytics including data profiling, data quality, joining data tables, graphing, basic trend analysis, and data segmentation. Ad hoc query development to quickly satisfy business requests using standard querying tools. Report development from multiple data sources using standard reporting software. SQL – basic query and data manipulation skills including selects, inserts, updates, table joins, and grouping. Visualization tools (Power BI, Qlik, Cognos, Tableau) – intermediate level skills including data preparation and dashboard creation. Excel – intermediate to advanced skills including Pivot Tables and advanced functions. Experience with a major DBMS (e.g., Oracle, SQL Server) to extract and transform data for reporting and analysis. Familiarity with data warehouse/data mart OLAP concepts, data modeling, data privacy standards, and dashboard development. Education/ Certification/ Years of Experience Requirements

Bachelor’s degree in Data Science/Analytics, Statistics, Applied Math, Computer Science, Business, or related field from an accredited college or university. In lieu of a degree, equivalent combination of education, certifications, and related experience may be substitutable on a 1:1 basis. Minimum of three (3) years of experience in data analytics and reporting, including data analysis techniques and data visualization tools. Experience in the utility industry is preferred. Working Conditions

This job is performed in an office work environment and is absent of disagreeable working conditions. Physical Requirements

This job consists of speaking, hearing, reading, typing and writing. This job requires frequent sitting, occasional standing and walking and may require lifting up to twenty (20) lbs., bending/ stooping, reaching over head. OUC–The Reliable One is an Equal Opportunity Employer who is committed through responsible management policies to recruit, hire, promote, train, transfer, compensate, and administer all other personnel actions without regard to race, color, ethnicity, national origin, age, religion, disability, marital status, gender, sexual orientation, gender identity or expression, genetic information and any other factor prohibited under applicable federal, state, and local civil rights laws, rules, and regulations EOE M/F/Vets/Disabled

#J-18808-Ljbffr