Reports to:

Director, Data Management

Position Summary

The Programmer-Analyst will be working with large data sets so he/she should be passionate about working with data and conducting some base analysis with it.

The Programmer-Analyst will be responsible for three sets of activities as outlined (but not limited to) below:

• Create data extraction scripts from social media sources such as Facebook, Twitter, blogs, etc. as well as from traditional data sources using APIs and FTPs. This activity set may also include developing data monitoring tools/reports through scripts and third party tools.
• Create reporting tools for internal and external consumption such as automating reports from a relational database or from Hadoop into Excel/web based dashboards
• Support the DBA in the maintenance of the relational database. Will also work closely with engineers on a day to day basis.

Required Knowledge and Skills

• 3-5 years of experience in scripting languages including JavaScript, Python and/or Perl, sh, PHP
• Experience working with structured and unstructured data
• Knowledge of SQL
• Working knowledge of development with complex, high volume non-transactional systems
• Strong analytical skills
• Good written and verbal communication skills
• Ability to set goals, and achieve scheduled deadlines
• Team player with excellent communication and organizational skills

Experience

Required

• Experience in writing scripts to collect data from variety of data sources like Facebook, APIs, FTP, etc.
• Experience working with PostgreSQL or other RDBMS like MySQL and/or Oracle
• Experience working with OLAP tools such as Cognos, Business Object etc.
• Experience working with very large data sets in both structured and unstructured environments
• Strong ETL programming skills and familiarity with database design
• Strong knowledge of Sourcing, ETL, Data Modeling, Infrastructure, BI, Reporting
• Bachelor’s degree or higher in computer science or in related field

Desired

• Direct experience with Map-reduce programming, Hadoop, and Hive
• Understanding of JSON format
• Java programming skills