Previous Job
Business Analyst III (6-8 years)
Ref No.: 18-05583
Location: Philadelphia, Pennsylvania
Job Description: Job Summary:
This role will be part of Marketing Strategy&Planning group's ongoing support of the Sales organization – specifically the group's support to door-to-door and multi-dwelling strategies. The role will directly support the development and deployment of strategies, deep dive analytics into specific business requests and perform of diagnostic analytics as required.

Job Responsibilities:
The specific responsibilities of the job include, but are not limited to:
- Analyzing overall effectiveness of overall door-to-door strategy
- Refining and updating targeting logic for door-to-door strategy
- Performing quarterly strategy updates for door-to-door strategy and analyzing changes in strategy; proactively communicating changes and managing expectations accordingly
- Updating on a quarterly basis multi-dwelling segmentation and providing outputs to the team
- Providing data for potential multi-dwelling contract negotiations
- Performing general diagnostic analysis for door-to-door and multi-dwelling strategies
- Performing diagnostic analysis as requested by key stakeholders
Manage data extraction jobs, and build new data pipelines from various structured and unstructured sources

Job Qualifications:
- 4 year college degree or equivalent work experience
- Minimum of 3 years working experience in SQL
- Demonstrated knowledge and hands-on experience with Big Data platforms and software like Hadoop and Hive
- Minimum of 5 years working in an analytical role
- Preferred previous experience working in various programming languages, SAS, Python, R, etc.- Preferred previous experience working or supporting a sales department / organization
- Preferred experience with

Job Skills:
- Ability to work independently with minimal supervision
- Must be a self-starter, detail oriented and possess strong problem-solving skills
- Strong analytical skills – ability to structure problems, generate hypothesis, decide which data to collect in order to drive a recommendation
- Strong communication skills – both oral and written, with a high level of comfort writing presentations in PowerPoint

Position Comments: This role requires a SQL test.