Job Details

ID #17324254
State Texas
City Dallas / fort worth
Job type Permanent
Salary USD TBD TBD
Source Spectrum
Showed 2021-07-26
Date 2021-07-08
Deadline 2021-09-06
Category Et cetera
Create resume

Data Integration Manager - Media

Texas, Dallas / fort worth, 75215 Dallas / fort worth USA

Vacancy expired!

Spectrum Reach ( www.spectrumreach.com ) grows businesses of all sizes with custom, multiscreen advertising solutions, backed by the power of TV, data, innovation, community experts, and unforgettable creative.

SummaryUnder limited direction, responsible for developing processes that are required to extract, transform, cleanse and manage data in support of the organization's analytics ecosystem.

Principal Responsibilities and Tasks
  • Builds data transformations with SSIS including importing data from files, moving data from one database platform to another; as well JSON format
  • Strong knowledge of relational databases, as well as skills in SQL query design and development
  • Collaborates with business analysts, subject matter experts, and other team members to determine data extraction and transformation requirements
  • Gathers business requirements and works with data analysts on physical database design and modeling
  • Performs code reviews, analyzes execution plans, and re-factors inefficient code
  • Follows data standards, resolves data issues, completes unit testing and system documentation for Extract Transfer Load (ETL) processes
  • Creates technical documentation of design logic and ETL processes based on technology best practices, guidelines and repeatable processes
  • Analyzes day-to-day functions and processes that are flexible and scalable to accommodate future business requirements
  • Strong analytical ability and aptitude to derive and translate data designs from business concepts
  • Ability to conduct research into systems issues and products as required
  • Proven creative problem-solving abilities
  • Ability to communicate ideas to technical and non-technical audiences
  • Created SSIS packages for File Transfer from one location to the other using FTP task.

TECHNICAL SKILLS:
  • Database Expertise: SQL Server 2016, 2014, 2012, MS Access
  • Database Migration: SQL Server to SQL Server, Oracle to SQL Server, MySQL to SQL Server, and MS Access/Excel to SQL Server
  • Operating System: Windows Server 2012, 2008 R2, 2003 R2, 2000, VMware
  • Languages: SQL, T - SQL, PL-SQL
  • Cloud/AWS: Scalable Amazon Relational Database Service (RDS)
  • ETL/Data Warehouse Tools: SSIS/DTS, BCP
  • Reporting: SSRS (SQL Server Reporting Services), Excel, Tableau, Power Pivot

Required Skills and Abilities:
  • Must have 5+ years of experience.
  • Deep understanding of database fundamentals, including relational database design, multidimensional, database design.
  • Ability to quickly stage & shape data from data warehouses into reporting and analytics solutions
  • Proficiency with writing T-SQL queries and stored procedures.
  • Understanding of & experience in Excel PowerPivot models
  • Ability to meet deadlines in a fast-paced environment. Must have the ability to work independently and as a part of a team.
  • Excellent interpersonal and communication skills (written and verbal). You will work with stakeholders to understand reporting needs, design, and implement solutions. You will also have to write clear and concise functional and technical documentation.
  • Expert capabilities with SQL Server, SQL Server Reporting and Analysis Services
  • Exceptional leadership, time management, facilitation, and organizational skills
  • Proactive, strategic mindset, with a desire to work in a fast-paced environment
  • Media industry experience is desired

Desired Skills:
  • Proficiency with generating and consuming RESTful APIs and JSON
  • Experience or understanding of the digital and advanced advertising landscape and experience with digital ad platforms (Google, Freewheel, Cadent, Operative, AppNexus, etc.) a plus.
284827-2 284827BR

Vacancy expired!

Subscribe Report job