Philadelphia Gas Works is looking to improve its data visualization and business intelligence capabilities to support operational and analytical reporting solutions.
Requirements
- Over 3 years of experience working in Business Intelligence and reporting solutions (preferably Tableau)
- Experience working with Tableau, Oracle, and SQL Server
- Proficient using software such as Oracle and SQL Server and writing SQL scripts
- Familiarity with Tableau Prep, Web Data Connectors and API's
- Must read, write, and edit Oracle SQL
- Proficient with Tableau Server (VizQL, Backgrounders, Storage Utilization, HTTP Request Performance and HTTP Stability)
- Knowledge of database administration, including indexes, database links, scheme management and table creation
Responsibilities
- Build charts, create custom calculations, and provide data insights
- Perform data loading, connect to multiple data sources, and write SQL scripts
- Monitor Business Intelligence Server Performance, backgrounder balance, storage capacity planning, workload modeling and prediction, system tracking and software upgrades
- Assist customers with submission request, server navigation and understanding the framework and concepts of Tableau Server
- Identify business opportunities or expand ideas obtained from management to conceptualize and define and model operational problems to assess feasibility and impact
- Develop concepts into business plans utilizing appropriate research techniques, methodologies, and experience and present them to the department with recommendations for implementation
- Build dashboards, based on identified metrics, to support business decisions for both strategic and operational needs
Other
- BS/BA degree in Computer Science, Information Technology, or other relevant field of study
- Coursework in Data Analysis, Information Management or Information Technology preferred
- Tableau certification a plus
- Ability to handle multiple tasks simultaneously, under pressure and within specified deadlines
- Knowledge and understanding of customer satisfaction basics with the ability to apply concepts in the process of serving the customer
- Must be able to work independently with business units to gather requirements, perform data discovery, come up with data model, and work with developers to design and implement ETL solutions
