PHP developer - MA..

PHP developer

Type: Contract 3+ months
Location: Boston, MA

State date: ASAP

Process:

• Phone interview 30 minutes (Wednesday 7/20)
• Face to face OR interview/Skype 2-3 hours (Thursday 7/21)

Overview
My client has created a station analytics system ( "SAS") which stores and displays digital analytics data for stations. This project would add a feature that generates a template based email with station data and member station averages (data pulled from various databases) to go out to station users.

Min Requirements:

• Solid PHP experience in an MVC framework (Kohana, Yii, etc.)
• Comfort doing manual queries and joins in SQL
• Experience with NoSQL queries (preferably specifically MongoDB)
• Experience accessing a remote API as a client is a plus — this project will likely have to use MailChimp's API

Key elements include:

• Email template
• Automated system that aggregates data from data sources to populate email templates and send out to stations ­­ manually or on a cron
• Table to establish primary accounts for stations where multiple accounts or views exist.
• Ability to feed email addresses, name, station metadata and station metrics into a templated email.

Primary usage
For example, station XYZ wants a group of users associated with their station to receive a weekly email summarizing the stations recent performance in digital platforms including web (Google Analytics), streams (Triton Webcast Metrics), On Demand (log data stored in Elasticsearch), Social media (Facebook insights). The email will include visualizations for KPI and a text summary of the recent performance highlights. If the station utilizes multiple GA profiles or accounts, they would require the ability to designate a primary account but only one weekly email will be sent to each station user. All email recipients must create an account in the system in order to receive emails, but system users will be able to opt out by updating a setting in the user details

Tools and Tech Weekly Metrics:

• MySQL tables and queries (user metadata and permission, primary data source for Triton data, primary data source for On Demand summary data)
• Mongo DB queries and storage (raw data from Google Analytics queries, some weekly metrics)
• Redis (raw data from Google Analytics queries, some weekly metrics)
• PHP ­­ Kohana Framework
• 3rd Party Email Management Tool (like Mailchimp)
• Version control using git

Key tasks
UI (End User): Edit user setting to opt in or out of emails via current form the client site
UI (End User): designate a primary Google Analytics profile to be used in emails. Only one profile per station. Only one email to each user.
System: Deliver stored data from Mongo for use in email generation. System: Deliver stored data from MySQL for use in email generation. System: send email to each user with the correctly associated station data. System: Highlights of station performance based on http://bit.ly/1WilA0g
System: Maintain consistency between stations that opt­in/out inside of the Station Analytics System and the mailer's opt­in/out system via periodic API sync.

Email Features:

• Common header/intro text that could be editing by an admin user interface or via text config file
• "Madlibs" style text summary of station performance in human friendly language. Either hard coded according to logical rules for evaluating key metrics or database parameters for % change and corresponding text output. See examples in sample email.
• Individual blocks for each metric ( "Digital Trends") including the following elements:
• Label identifying the metric and platform
• An icon used as a visual indicator of the change and magnitude compared to the average for the past 13 weeks
• Calculation of the % change compared to past 13 weeks
• Absolute value of the metric for the last week
• Summarized metrics for audience and engagement ( "The big picture") follows the same format as individual metric block but populated with summarized data aggregated from the various platforms.
• Links to web­based detailed dashboards for each metric.

 

 

 

Regards,

Manju Shree

Sr IT Recruiter
IDC Technologies, Inc. 1851 McCarthy Boulevard, Suite 116,Milpitas, CA, USA, 95035
Phone: 408-418-5779 ext 252 |Fax: 408-608-6088 |

Email: manju@idctechnologies.com| Web: www.idctechnologies.com

 

--
You received this message because you are subscribed to the Google Groups "SureShotJobs" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sureshotjobs+unsubscribe@googlegroups.com.
To post to this group, send email to sureshotjobs@googlegroups.com.
Visit this group at https://groups.google.com/group/sureshotjobs.
For more options, visit https://groups.google.com/d/optout.