Our client, a leading Educational Publisher, is seeking a PNA Database Analyst to work onsite 30 to 40 hours a week at their Boston office. The position will run approximately 6 months with a possible extension.
The PNA Database Analyst is responsible for handling report and query requests, specifically performing list pulls. Working with the PNA Digital Communications & Analytics Team, the PNA Database Analyst works to ensure the efficiency and accuracy of targeted Digital communications campaigns. This person will be doing 90% data mining and data cleansing and will need to have strong experience data mining or ad-hoc reporting from relational database systems.
This position will work with an external vendor database in the following capacity:
Responsibilities: Do list pulls and create accurate reports and metrics for the organization.
Perform SQL queries and inserts an MS SQL databases as needed.
Upload reports to PNA collaborative workspaces for campaign execution.
Create/modify report subscriptions for daily, weekly, monthly and yearly reports.
Perform data integrity reviews for duplicate records, incorrect imports.
Perform technical, quality, and performance testing after every database/reporting related task.
Seek opportunities to improve format, content, and delivery mechanisms for key reports and metrics needed.
Provide and assist in training of new and existing staff as needed.
Track and manage pending campaign projects including: database/system/reports enhancements, modifications, updates, or creation of new product(s).
Provide technical support for any related database/reporting issues.