Job Location: Philadelphia, PA
Job Detail:
Philadelphia Gas Works
Business Intelligence Developer
Looking for a challenge and ready to power up your career?
Free Health Insurance Options– Free Dental Insurance – Flex Spending – Commuter Benefits – Pension Plan – Free Parking – Wellness Programs – Onsite Gyms – Tuition Assistance- PSLF Eligible Employer- Parental Leave
Responsibilities:
The Business Intelligence Developer I (BID-I) is a member of a team responsible for the technical functions associated with creating and maintaining data visualizations. The incumbents will build charts, create custom calculations, requirement gathering and providing data insights. Incumbents perform data loading, connects to multiple data sources, must be knowledgeable of SQL scripts, and follow defined best practices to produce a data visualization and provide valuable insights.
The Business Intelligence Developer Il (BID-2) performs all the functions of a BID-I independently plus the incumbent writes SQL scripts, understands data relationships, and ensures defined best practices are being utilized. Primary objective is to complete a project and supply the deliverable that meets the requirements provided.
Responsibilities Include:
Developer I, II
Key responsibilities include:
Using the company’s Bl platform and other reporting tools to assist with operational and analytical reporting solutions consistent with the vision and direction of the Director, Analytics Development and the VP, Data Analytics.
Collaborating with end users, Bl developers, data analysts, and business analysts in business units as well as both local and enterprise technology units to meet reporting needs of stakeholders and grow Bl capabilities.
Assist customers with submission request, server navigation and understanding the framework and concepts of Tableau Server.
Escalate verified issues and failures to the Tableau team.
Assisting in data analysis for data quality issues by identifying data integration errors and working with data integration teams to provide solutions and improve data quality.
Supporting holistic business analysis and reporting of vital KPls.
Assisting in identifying business rules and requirements for data integration processes, providing guidance and support to data integration developers by documenting rules and procedures required to transform, process and load data into reporting solutions.
Using and maintaining the business glossary, data dictionary, and source-to-target data mapping documentation as necessary.
Identify business opportunities or expand ideas obtained from management to conceptualize and define and model operational problems to assess feasibility and impact.
Identify performance improvement opportunities via data analysis and develop decision support tools to ensure most cost conscience, efficient use of company resources that supports service objectives.
Develop concepts into business plans utilizing appropriate research techniques, methodologies, and experience and present them to the department with recommendations for implementation.
Perform extensive analysis of the problem, model, and resources available and alternative solutions.
Identify, analyze, interpret, and visualize trends or patterns in complex data sets.
Builds dashboards, based on identified metrics, to support business decisions for both strategic and operational needs.
Senior Developer
Key responsibilities include:
All essential functions of Business Intelligence Developer Il (BID-2) plus the following:
Working with OLTP/data warehouse modeling and play key role in multiple projects and act as knowledge expert (Technical, Functional).
Support complex discussions and engagements that may involve multiple project teams from multiple departments.
Collaborate with Solution & Enterprise Architects, Business analysts, DBAs, and others to understand business requirements.
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.
Work with ETL methodologies for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution.
Working with a team in information architecture, data architecture, data modeling, data governance, ETL design, data quality and Bl analytics.
Working with a team designing relational data models, analytical data models and non-relational data models for OLTP and advanced analytic applications.
Coach and mentors’ lower level and newly hired BIDS assisting them in developing essential skills to be successful with
PGW by providing first level guidance on policies, procedures and practices of the department and company in areas including customer relationship management, data analysis, report writing.
Performs other special projects and assignments as directed.
Qualifications:
(I) BS/BA degree in Computer Science, Information Technology, or other relevant field of study. Coursework in Data Analysis, Information Management or Information Technology preferred.
Database Experience – Knowledge and understanding of networking and distributed computing concepts with the ability to utilize software tools, languages and scripts required for effective data presentation
Information Technology Knowledge of the concepts of database testing processes, design and delivery including sufficient knowledge of PGW database environments and Tableau Servers to be able to effectively diagnose and resolve problems.
Organization/Project Management – Ability to handle multiple tasks simultaneously, under pressure and within specified deadlines Customer Service – Knowledge and understanding of customer satisfaction basics with the ability to apply concepts in the process of serving the customer.
Developer I– Three (3) to five (5) years of experience working in Business Intelligence and reporting solutions (preferably Tableau), demonstrate capabilities with database management software such as Oracle and SQL Server. The ability to design visualizations using Tableau Desktop
Developer II – Five (5) to seven (7) years’ experience working with Tableau. Must demonstrate advanced capabilities to create complex visualizations using custom calculations and dashboard actions. Proficient using software such as Oracle and SQL Server and writing SQL scripts.
Familiarity with Tableau Prep, Web Data Connectors and API’s
Leadership — Ability to lead, take charge, and offer opinions to provide guidance to lower-level peer group and assist director in identifying the best people for special assignments and advancement.
Customer Service — Knowledge and understanding of customer satisfaction basics with the ability to apply concepts in the process of servicing the customer.
Communications/interpersonal — Verbal and written communication skills with the ability to effectively speak across department lines to interpret and convey technical information in clear terms for non-technical staff of all business disciplines.
Computer Literacy — Knowledge of Microsoft Office, E-Helpdesk, SSRS report creation, maintenance, and deployment.
Must read, write, and edit Oracle SQL.
Sr. Developer- Ten (10) plus years’ experience including working with Tableau Desktop, Tableau Prep and Tableau Server. Must demonstrate advanced capabilities to create complex visualizations using custom calculations. Proficient using software such as Oracle and SQL Server and writing complex SQL scripts.
Proficient with Tableau Server (VizQL, Backgrounders, Storage Utilization, HTTP Request Performance and HTTP Stability)
Database Administration — Knowledge of the basics networking skills, including indexes, database links, scheme management and table creation.
Information Technology – Knowledge of the concepts of database testing processes, design and delivery including sufficient knowledge of PGW Tableau Servers, server analyses visualizations, cataloging and upgrade and maintenance deployments cycles. Leadership — Ability to lead, take charge, and offer opinions to provide guidance to lower-level peer group and assist the department head with all matters pertaining Analytics Development and server stability.
Submit CV To All Data Science Job Consultants Across United States For Free