Data Developer - #7931841

Horizon Media, Inc.


Date: May 3, 2021
City: New York, NY
Contract type: Full time
Horizon Media, Inc.



As the Data Developer, Software Solutions you will use your talent for data focused development to support the architectures and procedures of Horizon Media’s institutional data warehouse. This may include ETL procedures for data sources, development of the core data lakes, data marts, or the data warehouse itself. Knowledge of data pre-aggregated data structures (OLAP) and unstructured data (NoSQL) is required. Previous experience with AdTech or MarTech data sources is desirable



Responsibilities:



Strategy/Business:


  • Knowledge of Complex Event Processing (CEP) models for streaming and/or Near Real Time (NRT) data updates

  • Experience with topic creation using stream processing tools such as Kafka and/or Map R Streams

  • Development expertise with Lambda architecture models including Hadoop, Apache Flink, Apache Spark, or similar

  • Ability to provide batch processing direction when coupled with Lambda NRT processing

  • Deep knowledge of coding SQL RDBMS structures including Functions (Tabular & Scalar), Stored Procedures, in-memory processing objects, etc

  • Knowledge of MDX OLAP query language and familiarity with processing with tuples

  • Expert in query path and execution analysis with focus on performance optimization

  • Ability to logically troubleshoot existing routines quickly and resolve identified issues



  • Adhere to defined structure policies including naming conventions, population of
routine headers, code comments, etc

  • Collaborate with Software Solution team members and other staff to validate
desired outcomes for code prior to, during, and post development


  • Provide unit testing on any/all deliverables

  • Propose innovations to existing procedures to provide better user experiences

with data routine

Communications:



  • Communicate with Integrations Analysts, Business Consultants, and the AD, Media Technology & Data, Software Solutions to update status on current projects, convey issues encountered, and educate them on determined issue resolutions

  • Communicate material enhancements to data structures or processes and convey the value of these changes to the business users



Qualifications:


  • 5+ years experience working with large volume “Big Data” storage and processing
challenges


  • Well versed in Lambda architecture design and implementation

  • Proficient in the object oriented programing concept and design patterns

  • Familiar with SOAP and REST (full) protocol

  • Experience with multi thread/process programming

  • Works well in a continuous build and unit testing model

  • BS/BA degree in Computer Science, Statistics, Mathematics, or related field; or

equivalent experience. Masters degree preferred

  • (Desired not required) Knowledge of the media transactional process, order of
operations, financial procedures, and dependencies across all media channels


Desired Technology:


Office



  • MS Excel

  • MS Powerpoint

  • MS Project

  • MS Visio


Database



  • MS SQL Server

  • mySQL

  • Kafka

  • AWS RedShift

  • Hadoop/Flink


OLAP



  • SSAS/SSIS

  • BIDS

  • MDX



Visualization


(one or more)



  • Tableau Desktop

  • Qlikview

  • JasperSoft



Media



  • Sizmek

  • DoubleClick

  • STRATA

  • CoreMedia

  • Omniture



Certificates, licenses and registrations:


None



Physical Activity/Work Environment:


None



Additional Information:


Infrequent travel may be required (<10%)



The statements herein are intended to describe the general nature and level of work being performed by employees, and are not to be construed as an exhaustive list of responsibilities, duties and skills required of personnel so classified. Furthermore, they do not establish a contract for employment and are subject to change at the discretion of the employer.



How to apply

To apply for this job you need to authorize on our website. If you don't have an account yet, please register.

Post a resume