To Apply for this position, please visit WWW.COMSCORECAREERS.COM or feel free to call Peter Radloff at 703-438-2372 with questions.
comScore has an opening for a Database Services Analyst in our Reston, VA office. If you are interested in learning about the Market Research field from the ground up, then you need to be here, learning from the best and brightest.
Title: Database Services Analyst
Location: Reston, VA
The Database Services Analyst role would be to facilitate the availability of database servers in the production environment. Perform some administration, import and export of data from external servers, automate DB and data jobs and do code enhancements. Implement and stick to DB standards defined and be an integral part of the production server management team.
ESSENTIAL DUTIES AND RESPONSIBILITIES
Hand-on experience of T-SQL programming skills.
Successful candidate will spend at least 70% of work time developing structured T-SQL code with high-performance requirements
Manage continuity and stability of production SQL Server databases
Knowledge of stored procedures, analysis of search plans, and techniques to extract, transform and load data, for hundreds of files and layouts.
Design, Develop, and Maintain ETL processes using SQL DTS, stored procedures and Job scheduler
Design and implement reports and data analysis queries for internal operations and executive decision makers
Proactively identify areas where efficiencies can be made through automation and produce metrics to represent system optimization
T-SQL programming to support ongoing database development and ability to maintain proprietary T-SQL coding standards and documentation.
Bachelors degree in a technical field (such as Computer Science, Information Systems, or Engineering)
At least two years professional experience
Extensive experience with very large SQL databases using Microsoft SQL server.
Requires a thorough knowledge of options and techniques for standardizing, copying and synchronizing multiple versions of large databases across many servers.
Knowledge of relational databases and methods for efficiently retrieving data from them
Exceptional understanding of the client-server concepts and related challenges. A flavor of web based client architecture would be a plus.
Ability to handle jobs in parallel
comScore Networks is a global leader in measuring the digital age. This capability is based on a massive, global cross-section of more than 2 million consumers who have given comScore permission to confidentially capture their browsing and transaction behavior, including online and offline purchasing. comScore panelists also participate in survey research that captures and integrates their attitudes and intentions. Through its proprietary technology, comScore measures what matters across a broad spectrum of behavior and attitudes. comScore consultants apply this deep knowledge of customers and competitors to help clients design powerful marketing strategies and tactics that deliver superior ROI. comScore services are used by global leaders such as AOL, Microsoft, Yahoo!, Verizon, Best Buy, The Newspaper Association of America, Tribune Interactive, ESPN, Fox Sports, Nestlι, MBNA, Universal McCann, the United States Postal Service, Merck and Expedia. For more information, please visit www.comscorecareers.com