This job has expired, please see additional jobs below
Junior Integrations Analyst
Horizon Media
New York, NY, United States
Job Details - this job has expired, please see similar jobs below
Job Summary
As the Junior Integrations Analyst, you will be an integral part of the Software Solutions team. The Integrations Junior Analyst is tasked with helping to define projects to add data sources into Horizon Media’s institutional data warehouse. For each project, the Junior Analyst must identify the method of data provided (API, flat file, database connector, etc.), frequency of updates, field mappings, normalization needs, data volume, data storage plan, time estimates, and resource requirements. Creating and maintaining project plans and compose detailed functional specifications to serve as the guidance for developers to properly integrate the source into the data structure.
Main Duties and Responsibilities
• 20% - Develop detailed data specifications (whether the deliverable is via API, flat feed etc.) that can be comprehended by Business Intelligence team
• 20% - Own vendor relationships and communication to build and maintain seamless data integrations
• 20% - Manage vendors for timely deliverables and communicate specifics around any data outages and/or API changes
• 20% - Liaise with internal stakeholders to prioritize new features and enhancements
• 20% - Communication with internal stakeholders to manage timing of deliverables
Supervisory Responsibilities
N/A
Knowledge and Skills Required
• 1+ years’ experience working with “Big Data” storage, processing projects, or SDLC
• Ability to define data structure design and implementation of data sources
• Demonstrate ability to gain technical writing experience for API integrations and identify project requirements
• Excellent verbal and written communications skills with the ability to effectively interact with and present to all stakeholders including senior leadership
• Ability to show a history of balancing multiple priorities simultaneously, with the ability to adapt to the changing needs of the business while meeting deadlines.
• Strong attention to detail, problem-solving, and analytical skills.
• BS/BA degree in Computer Science, Statistics, Mathematics, or related field; or equivalent experience.
• (Desired not required) Knowledge of the advertising or technology industry
Desired Technology
Office
• Excel
• PowerPoint
• Project
• 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
N/A
Physical Activity and Work Environment
N/A
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.