Havas Edge

Data Warehouse/ETL Developer

US-CA-Carlsbad
3 weeks ago
ID
2017-1261
# of Openings
1
Category
Information Technology

Overview

Build the Business. Build the Brand.

At Havas Edge we influence people to act by combining multi-channel marketing and commerce plus the creative and technology that powers them.  Our work results in profitable growth and lasting relationships between customers and our client’s brands.

We are a full-service, direct response agency, headquartered in Carlsbad, CA with offices in Boston, MA; Los Angeles CA; Portland OR; and London, UK.

 

DESCRIPTION:

Responsible for developing and supporting data warehouse solutions built on the Microsoft SQL Server technology stack (RDBMS,SSIS, SSAS and SSRS).  These solutions include ETL, data modeling, data quality assessment and data delivery. This resource will play a critical role in the development of new data warehouse solutions utilized by internal and external clients.

Responsibilities

  • Create high performance DW and ETL solutions using SSIS.
  • Performance tuning and optimization of SSIS, T-SQL and database structures.
  • Design and develop tables, views, triggers, indexes, constraints and stored procedures.
  • Monitor long running transactions and have the ability to optimize query executions using best practices and methodologies
  • Assist in the design process

Qualifications

REQUIREMENTS:

 

  • Strong understanding of database structures, theories, principles, and practices
  • Strong understanding of ETL and data warehouse principles
  • Extensive experience writing T-SQL
  • Knowledge of reporting and query tools like SSRS and SSAS
  • Good understanding of the organization’s business goals and objectives
  • Good interpersonal, written and oral communication skills
  • Technical documentation skills
  • Ability to present complex ideas in user-friendly language
  • Self motivated and directed, with keen attention to detail
  • Able to prioritize and execute tasks in a high-pressure environment
  • Experience working in a team-oriented, collaborative environment
  • The ability to develop stored procedures, triggers, indexes, and views

 

QUALIFICATIONS:

 

  • BS Degree in one of the following subject areas; Computer Science, Business Administration, Information Technology or related field preferred
  • Minimum of 5+ years of experience developing large scale complex database solutions
  • Demonstrated experience with BI database design
  • Ability to track and resolve database related incidents as well as requests
  • Must have a service oriented mentality, as well as a strong sense of ownership of any incidents or requests assigned

 

Specific Skills Required:

 

  • Microsoft SQL Server 2008 (r2) -2014
  • 3-5 years T-SQL experience including the ability to tune queries.
  • 3-5 years of etl experience.
  • 2-3 years  of SSIS.
  • Strong Data warehouse knowledge.
  • Data modeling experience.
  • Some DBA skills really nice to have.
  • Experience with partitioning a plus

Experience with large data sets.

Options

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed