Database Developer

Database Developer

Job ID: 1837
Location: San Francisco, CA
Type: Permanent
Status: Closed
Key Skills: SQL Server, Transact-SQL, T-SQL, SQL-CLR, Relational Database Developer, Stored procedures, looping, branching, functions, Big Data, marketing

Description:
The Database Developer is responsible for building, debugging, maintaining, and enhancing the marketing databases we create and manage for our clients. Responsibilities will include ETL development, business rules implementations and automation, and data quality stewardship. This person will develop deep domain expertise with our clients' data and must learn to use their domain knowledge to assemble complex data sets from our relational models.

Databases are primarily built using Microsoft SQL Server, Transact-SQL code, and SQL-CLR.

RESPONSIBILITIES:

1. Create batch processes (ETL) for conversion of operational and transactional data into relational marketing databases, leveraging existing agency components/code library.
2. Develop and debug SQL stored procedures that translate business rules/needs into appropriately scoped, well-documented code.
3. Data hygiene as necessary to load/unload data. Responsible for handling referential integrity exceptions and data outliers.
4. Apply effective problem-solving skills: try different approaches to solve a problem, demonstrate tenacity to complete challenging tasks.
5. Proactively report progress. Know when to ask questions. Recognize urgency of requests and accommodate change requests. Able to manage multiple tasks/priorities.
6. Interest in marketing is essential.

Requirements:

1. 3 - 5 years relational database design and development
2. Strong SQL (multiple table joins, correlated sub-queries, aliasing, etc.)
3. Strong T-SQL (stored procedures, functions, temp tables, variable declaration, looping, branching, error trapping, logging, common table expressions, etc.)

ADDITIONAL EXPERIENCE A PLUS:

1. Direct marketing or advertising/media
2. Experience with Big Data / VLDBs (our database tables frequently exceed millions of rows)

ENVIRONMENT:

1. Fast-paced environment with short delivery times
2. Excellent verbal and written communication skills required
3. Able to interact with our agency project
4. Self-starter
5. Ability to manage projects independently and with minimal supervision

Benefits: Health, dental, vision, 401k, and stock purchase plan.
Salary: 80-100K
To apply for this position please submit an MS Word doc of your resume and put in the subject "Job ID # 1837".

#J-18808-Ljbffr