August 18, 2005 at 5:42 pm
Avenue A is looking for a solid Database Engineer with strong SQL skills.
This individual’s core responsibility is to develop custom reporting solutions in support of the business intelligence and data mining groups at Avenue A’s Advertising Agency. This person will be responsible for the design and implementation of data warehouse and advanced analytics solutions based on MSSQL, MSOLAP and Excel platforms.
Required Skills
Core Duties/Responsibilities
Participate in gathering of BI related business requirements.
Prepare technical design and specifications, develop routine for data loading and extraction, and develop metadata required for the Data Warehouse.
Design and implement custom analytics solutions under tight deadlines to specification
Optimize and tune database systems to maximize their performance and operation
Manage multiple simultaneous projects with little supervision
Produce ad-hoc and regular metrics and reports according to requirements.
Create and manage production/testing environment.
Special Projects as assigned.
SQL Server 2000 development / T-SQL / Analytics Services (OLAP)
ETL/DTS
ADO/VBA/MDX/JavaScript
Error handling/QA – notification
Logical Modeling experience – star/snowflake schemas
Excel PivotTables
Education and/or Experience
College degree in Computer Science or related field.
5+ years MS SQL/TSQL development experience
2-4 years development experience using MS AS (OLAP)
2-4 years experience within a Data Warehouse/BI group.
Updated with latest trends in Data Warehousing technology and various tools and enhancements.
Experience working in a fast-paced, dynamic environment required.
Digital/Online Direct Marketing experience a plus.
Please apply with us directly at:
Thank you.
August 19, 2005 at 9:58 am
Are you the Avenue A that is constantly putting adware on people's computers?
August 19, 2005 at 10:09 am
We do not put adware on people's computers
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply