Power BI Data Analyst Job at Orlando Utilities Commission in Orlando

OUC - The Reliable One is presently seeking a Power BI Data Analyst 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 and maintain the PowerBI reports and continue modernizing and improving them. You will also handle any PowerBi requests and questions and assist with any data analytics projects 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 of diverse experiences in powering creativity and industry transformation.At OUC, each position contributes to the success and achievement of our goals.Click here (https://youtu.be/s_ZnGjX_Sas) to learn more about what we do. The ideal candidate will have: Bachelor’s degree in Data Science/Analytics, Statistics, Applied Math, Computer Science, Business, or related field of study 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, to include: Experience in data analysis techniques and data visualization tools (PowerBI); Completed the Microsoft Certification: Power BI Data Analyst and pass the PL-300: Microsoft Power BI Data Analyst exam (highly preferred) Proficient in SQL or Python OUC offers a very competitive compensation and benefits package. Our Total Rewards package includes to cite a few: Competitive compensation Low-cost medical, dental, and vision benefits and paid life insurance premiums with no probationary period. OUC’s Hybrid Retirement Program includes a fully-funded cash balance account, defined contribution with employer matching along with a health reimbursement account Generous paid vacation, holidays, and sick time Paid parental leave Educational Assistance Program, to include tuition reimbursement, paid memberships in professional associations, paid conference and training opportunities Wellness incentives and free access to all on-site OUC fitness facilities Access to family-oriented recreational areas Paid Conference and Training Opportunities Free downtown parking Hybrid work schedule Click here to view our Benefits Summary. (https://www.ouc.com/docs/human-resources-documents/benefits_summary.pdf) Salary Range: $34.82 - $43.52 hourly - commensurate with experience Location: Gardenia 3800 Gardenia Ave. Orlando, FL. 32839 Please see below a complete Job description for this position. Job Purpose: Performs routine and ad-hoc data analysis to identify actionable business insights and performance gaps to enable data -driven strategic decisions across the organization. Performs research across a variety of data sources to determine current performance and identify trends and improvement opportunities. Primary Functions: 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, Assist in transforming 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 all, but not limited to, the following: Processes for leveraging data from data warehousing, data mart, data lake environments; Visualization Development - Generate analysis through data visualizations from multiple data sets using standard best-in-class analytics software; Query routine data structures and derive information for reporting, visualizations, and statistical analysis; Requirements gathering, analysis, and documentation; Data Analytics - Perform routine data analysis to include data profiling, data quality, joining of data tables, graphing, basic trend analysis, data segmentation; Ad Hoc Query Development - Quickly develop, test, and provide ad hoc (one-time) information based on a business request leveraging internal or external data and using standard querying toolsets; Report Development - Create reports from multiple data sets using standard best-in-class reporting software; SQL - basic query and data manipulation skills including selects, inserts, updates, table joins, and grouping; Visualization (Qlik, PowerBI, Cognos, Tableau) - intermediate level skills in a best-in-class data visualization tool to include data preparation, rationalization of visualization type, standard charting (time series, Pareto, bar, area, multi-axis, geospatial, scatter plots, etc.), filtering, drill-downs, drill-throughs, navigation, dashboard creation, deep understanding of user interface and effective presentation; Excel – intermediate to advanced skills including graphing, Pivot Tables, VLOOKUP, and multi-sheet references; Experience working with a best-in-class DBMS (Oracle, SQL Server, etc.) to extract and transform data for reporting, analysis, or data science; Familiarity with all, but not limited to, the following: Familiar with a data warehouse / data mart OLAP environment leveraging data in star schemas, snowflake schemas, and similar data structures; Familiar with data modeling in the context of transforming data from an OLTP system to an OLAP or other data warehouse related structure.Familiar with the importance of how data is modeled to support the needs of a data reporting and analysis environment; Familiarity with generally accepted data and information privacy standards (GDPR, PCI, PII, HIPAA, etc.); Familiarity with leveraging large data sets for data science, machine learning and related analysis; Dashboard Development - Gather requirements, identify metrics and goals, leverage data sources, select appropriate dashboard objects, and implement a dashboard using a best-in-class tool; Project Support- Facilitate, create, implement, and support a project or projects using MS Project or a similar project tracking tool; ability to define, document, and communicate a project charter, resource assignments, risks, issues, and status over the course of a project; Query Optimization – ability create / modify SQL or other query code to ensure request has minimal impact on the target database and executes in the most efficient manner possible; Knowledge / application of related industry, organizational, and departmental policies, practices and procedures, legal guidelines, ordinances and laws; Predictive Model Development - Leverage historic internal and external data to generate predictive business models forecasting trends and providing insights with relevant statistical confidence measures and using appropriate statistical methods; Process flow documentation; Related industry, organizational and departmental policies, practices and procedures; legal guidelines, ordinances and laws. Ability to: To apply data quality assurance and troubleshooting to data profiling, analysis, and reporting; To apply appropriate data cleansing and transformation techniques to prepare data for reporting and analysis; Demonstrate strong analytical ability to identify appropriate analysis, data anomalies, trends, etc.; Presentation skills leveraging appropriate software, adapting to audience, and excellent written and grammatical skills; Work with minimal supervision; self-directed; seeks assistance when needed; Excellent written and verbal communications skills; Use advanced Microsoft Office Suite (Excel, PowerPoint, Word, Outlook, etc.) and standard office equipment (telephone, computer, copier, etc.); Make arithmetic computations using whole numbers, fractions and decimals, rates, ratios, and percentages; Strong attention to detail; MS Access - advanced skills including relational table joins, data transformation through joins, filtering, updates, and summarization, reporting (preferred); Reporting (Cognos, OBIEE, Crystal) - intermediate level skills in standard columnar reporting, requirements gathering, data preparation requirements, report creation, testing, scheduling, and deployment. (preferred) Education/ Certification/ Years of Experience Requirements: Bachelor’s degree in Data Science/Analytics, Statistics, Applied Math, Computer Science, Business, or related field of study 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, to include: Experience in data analysis techniques and data visualization tools; Utility industry experience (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