Job Directory Mediabrands Data & Technology - Data Developer, Global Reporting (20151902)

Mediabrands Data & Technology - Data Developer, Global Reporting (20151902)
New York, NY

Companies like
are looking for tech talent like you.

On Hired, employers apply to you with up-front salaries.
Sign up to start matching for free.

About

Job Description

Position Summary

We are looking for a Data Developer who will be responsible for the design, development, and creation of complex data schemas that will power data analysis and reporting. They will be responsible for building, maintaining and scaling data solutions across a sizeable number of clients. The ideal candidate must be a self-starter with the desire to build new, efficient solutions that will lead to faster, smarter business optimizations.

Essential Functions

* Identify and help acquire data from a diverse array of sources, map data origin, data movement, interfaces, and analytics, with the goal of establishing the highest degree of overall data accuracy and usefulness.
* Architect, build and maintain database schemas and data warehouses to ensure interoperability with BI solutions.
* Design and code complex automated data pipelines for optimal extraction, transformation, and loading of data from a wide variety of data sources across AWS and Snowflake.
* Develop the semantic layer, metadata, report objects, and configure user/system hierarchies
* Evaluate key interfaces and interdependencies of core application components and systems.
* Participation in all phases of the software development life cycle including requirements gathering, designing, coding, testing, deploying, and providing production support of application solutions.
* Make recommendations for technical designs that align with technology standards and architectural guidelines.
* Include appropriate governance and quality considerations from inception to ensure high quality data.
* Ensure application stability and performance by monitoring existing workflows to ensure they are working correctly and that they reconcile with the source.
* Perform detailed documentation of design, development, testing and deployment activities.
* Develop re-useable processes that can be leveraged and standardized for multiple instances.
* Write complex SQL queries with multiple joins to automate/manipulate - both in SQL Server and Alteryx
* Experience in an enterprise data warehouse environment with large and complex data sets, including systems integrations and ETL

Qualifications

Education:

* Bachelor's degree

Work Experience:

* Data Architect, App Developer and Database Administrator
* Advanced knowledge of data storage theory for both structured and unstructured formats and application to architect data solutions.
* Snowflake, RDMS, data lakes
* SQL Server database design:
* Database and table triggers
* Constraints
* Stored procedures
* Scalar & table-valued functions
* Alteryx Solutions Developer:
* Custom macros
* Advanced tool sets: In-DB tools, Developer Tools, Interface, Reporting
* Application development - both local and on Alteryx Server
* Custom connector design
* Building connections to API via Alteryx or Python

About Us

IPG Mediabrands was founded by Interpublic Group (NYSE: IPG) in 2007 to manage all of its global media related assets. Today, we manage over $37 billion in marketing investment on behalf of our clients, employing over 8,500 marketing communication specialists in more than 130 countries.

PG Mediabrands is a new world agency group designed with dynamic marketing at its core. Our speed, agility and data smarts ensure we continue to create growth for many of the world's biggest brands. IPG Mediabrands' network of agencies includes UM, Initiative, BPN and Orion Holdings as well specialty business units including Magna Global, Cadreon, Ansible, Society, Reprise, Rapport and the IPG Media Lab.

Let your dream job find you.

Sign up to start matching with top companies. It’s fast and free.