Wanted: Innovators, Visionaries,
Front-Runners and Team Players

JOB PURPOSE

The Digital Media Buyer – Programmatic is responsible for the implementation of daily management and optimization of assigned programmatic campaigns. This position will assist in strategy and planning responsibilities including research and insights derived from past campaign performance and cross client learnings.  A thorough, hands on knowledge of programmatic media, Google’s Double Click Ad Products (DBM & DCM), AdWords and Facebook Power Editor is required. A critical eye for detail and a love for data analysis is a must.  Experience with online video campaigns and accounts that focus on ROI is a strong plus.

ESSENTIAL DUTIES AND RESPONSIBILITIES

• Own the day-to-day management and optimization of assigned programmatic campaigns
• Pulls and analyzes campaign performance reports to inform daily optimizations and testing recommendations
• Ensures that campaign KPIs and objectives are met both near and long term.
• Prepares research and insights to inform ongoing media recommendations
• Manages budget allocations and bid parameters to deliver most efficient results
• Works with Digital Media Assistant to prepare weekly client reporting
• Assists with account reconciliation
• Follows all company health and safety procedures
• Perform other related duties as required or assigned 

EDUCATION AND EXPERIENCE

EDUCATION

Bachelor’s degree (B.A. or B.S.) required

EXPERIENCE

1-3 years related experience required

Must have experience setting up, managing and optimizing programmatic campaigns via Double Click Bid Manager, AdWords or Facebook Power Editor. Must be extremely detail oriented, passionate about data analysis and able to multi task in a fast paced environment.

Must be proficient in Microsoft Office products such as Word, Excel and PowerPoint

Must be experienced in analyzing data and market research

EEO/Minorities/Females/Disabled/Veterans

JOB PURPOSE

The position of Media Negotiator is responsible for negotiating, planning, buying and maintaining media buys in close liaison with their supervisor. This position is continuously developing and creating media strategies based on client objectives. Media Negotiators require attention to detail, organization, and the ability to work collaboratively in a team environment.  Media Negotiators must have the ability to manage multiple projects, communicate effectively, be deadline-driven and have strong negotiation skills.

ESSENTIAL DUTIES AND RESPONSIBILITIES

• Plans, negotiates, buys and maintains media schedules in conjunction with Media Supervisor
• A Media Negotiator will be responsible for smaller billing clients and will negotiate direct response deals on behalf of all Ocean Media clients
• Shadows senior team members on national network negotiations
• Oversee discrepancy resolutions and ensures timely and fair compensation for all assigned accounts
• Maintains and completes makegoods and ADUs for all assigned accounts
• Manages and completes post analysis for all assigned accounts
• Secures and manages added value for clients
• Evaluates new media opportunities and develops POV on key opportunities
• Provides accurate network information for proposal templates and guides Assistant Media Negotiator on completion of data entry
• Supports Assistant Media Negotiator (s) with log duties when necessary
• Works with the account services department to continuously, develop, monitor and adjust media schedules based on performance feedback from the client(s) and the analytics department
• Along with client objectives, utilizes media research tools and resources to aid in campaign development and optimization when making recommendations for media buys
• Develops and maintains media partner relationships
• Trains and mentors Assistant Media Negotiator in conjunction with Media Supervisor
• Tracks the market for trends, opportunities, etc. and uses this information to make recommendations on what is best for the client
• Follows all company health and safety procedures
• Performs other related duties as required or assigned

EDUCATION AND EXPERIENCE

EDUCATION

Bachelor’s degree (B.A. or B.S.) required.

EXPERIENCE

1 – 3 years related experience required

EEO/Minorities/Females/Disabled/Veterans

JOB PURPOSE

The Sr. SQL Developer will work independently to learn, maintain, and enhance existing applications as well as develop new code to accomplish business needs for data analysis and automation. This role directly interfaces with end users and requires both strong communication skills and a strong commitment to UAT and functional testing. The Sr. SQL Developer will work with other developers and business team members in developing and supporting important applications. Developer will be responsible for ongoing development projects and supporting legacy applications, working integrally and very closely with the Director of Software Development and Operations, Business Solutions.

ESSENTIAL DUTIES AND RESPONSIBILITIES

• Attend business requirement discussion meetings, understand and analyze the requirements, confirm functional specification notes/documents before proceeding with the design and development.
• Learn existing critical business application business logic and stored procedures used by the Analytics team. Make code changes in the stored procedures to implement new changes and resolve defects.
• Troubleshoot production issues by debugging and reviewing the log stored procedures. Monitor production jobs, maintain, and enhance legacy processes on a regular basis. Fix defects improve running jobs with the help of redesign, and better ETL processes to meet business needs.
• Work very closely with the existing DBA to design, model, develop, and maintain existing and new SQL databases objects required for all business solutions.
• Support SSIS ETL process and jobs. Learn advanced level of SSIS development and support capabilities to meet organization’s business needs and requirement. Over the course of employment, continue to get better and grow in to a role as a regular SSIS developer.
• Attend regular standup meetings, take direction, follow recommendations, and share status reports to his/her manager.
• Work on more than one projects or tasks in parallel and switch attention between the ongoing development and production support investigation and restoration steps smoothly.
• Confer with relevant team members where necessary. Study systems flow, data usage, and work processes.
• Deliver functional work product that has been thoroughly tested from both unit and functional testing perspectives. End-to-end regression testing will also be required periodically.
• Follow development team’s SDLC process. Accurately estimate time required to complete projects and tasks.
• Meet mutually agreed upon deadlines for completion of modules throughout the program development.
• Works well independently; capable of self-motivating and managing.
• Follows all company health and safety procedures.
• Performs other related duties as required or assigned.

EDUCATION AND EXPERIENCE

EDUCATION

Bachelor’s degree (Science or Engineering.) required, or more than 15 years of professional experience.

EXPERIENCE

7-10 years related experience required

KNOWLEDGE, SKILLS AND ABILITIES

SPECIFIC KNOWLEDGE REQUIRED: 

The Senior SQL Developer will demonstrate:

• More than 7 years of experience in developing various SQL database objects such as tables, views, index, functions, stored procedures, and scheduled jobs in MS SQL Server Relational Database.
• Require a very good working experience of T-SQL. Proficiency in complex stored procedures, writing complex queries with many joins and subqueries, user defined functions (UDF), database triggers, using tools like SQL Profiler and Database Tuning Advisor (DTA).
• Ability to debug long stored procedures and derive business logic from code review of existing applications is important.
• Usage and experience of cursor and CTE inside the stored procedures to process large data sets and apply data modification logic as per the business requirement is required.
• Hands on experience in performance tuning and query optimization including updating statistics, rebuilding and re-organizing indexes. Experienced in normalizing and de-normalizing the tables and maintaining referential integrity by using triggers and primary and foreign keys.
• Must have experience in Database Development, Design, Analysis, Supportof MS SQL Servers 2008, 2005, 2000 in Development, Testing and Production Environments with various business domains.
• Project experience in SSIS ETL technology is preferred and required in future. Implemented incremental load for many SSIS packages. Experience in error handling, debugging, error logging for production support in SSIS. Experience in bulk importing CSV, XML and Flat files data using Bulk copy program (BCP).
• Must have the ability to participate on group discussion with the analytics and business teams to understand the requirement. Analyze the requirements details, prepare functional specification notes to use in design, development, and testing.
• Should have enough experience to perform both UAT and functional testing of developed features. Testing efforts will require preparing test data which may include bringing data from production environment and manipulating to meet the features requirement. Developer is expected to test effectively.
• Ability to work independently and be able to collaborate and guide other team members.
• Strong written and oral communication, experience on improving and presenting new design and solutions to senior leadership.

EEO/Minorities/Females/Disabled/Veterans