Senior Database Developer - SQL Server

US-IL-Chicago
5 days ago
ID
20030
# of Openings
1
Category
Software Engineering & Technology

Job Description

comScore is seeking a technical, quality focused Senior Database Developer to provide support to join a team developing robust datamarts that fuel comScore's indsutry leading analytics products. This person will work alongside other If you are an individual that is able to work closely in a collaborative role with other team members, as well as complete tasks individually as assigned, you'll fit in nicely with us.

 

This is a unique opportunity to work alongside talented, innovative engineers solving the unique challenges of transforming over 2 Trillion monthly media interactions into insightful products.  Your work will be used by the world's most prominent Internet and consumer brands to understand consumer behavior and influence their global marketing, media and business strategies.

 

Primary Responsibilities:

  • Advanced knowledge of T-SQL, including transactions, (begin..try, merge, common table expressions, ROW_NUMBER/OVER, bulk insert, filtering and covering indexes, computed columns)
  • Experience working with database architecture and schema for very large databases (think Terabytes!) and very large tables (think Gigabytes)
  • Partitioned Tables/Indexes (Switching/Merging/Splitting)
  • Performance tuning/code debugging
  • Hierarchical datasets
  • Building and maintaining SSIS packages
  • Building and maintaining SSAS cubes
  • Building and maintaining production SQL jobs
  • Building and maintaining SQL reports using SSRS

 Requirements:

  • Bachelor's Degree (or higher) in Computer Science or related field
  • 5+  years of Microsoft SQL Server 2012 (or above) database development experience
  • Excellent statistical analysis skills, ability to research and analyze various different types of data information, and to effectively manage the delivery of that data
  • A passion for, and unyielding pursuit of good, clean and standardized code
  • Ability to make accurate level of effort (LOE) estimates
  • Ability to make decisions under pressure
  • Effective communicators with the ability to maintain honest and open communication at all times with individuals at all levels internally
  • Flexibility to work outside of normal business hours (if necessary) to accomplish business objectives

Preferred Qualifications:

  • Knowledge of replication (transactional) and clustering
  • Experience with Agile development, software and web development technologies (e.g. C#, ASP.NET) is desired
  • Experience with building and maintaining SSAS cubes preferred, but not necessary

About comScore:  comScore, Inc. (OTC: SCOR) is a leading cross-platform measurement company that measures audiences, brands and consumer behavior everywhere. 

 

comScore is a recognized global leader in cross-platform measurement of audiences, advertising and consumer behavior. Built on precision and innovation, comScore combines proprietary TV, digital and movie viewing data with vast demographic details to measure consumers’ multiscreen behavior at scale. With more than 3,200 clients and a global footprint that spans more than 75 countries, comScore is delivering the future of media measurement.

 

EEO Statement: We are an equal employment opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, national origin, sex, disability status, sexual orientation, gender identity, age, protected veteran status or any other characteristic protected by law.

 

*LI-DZ1

Options

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

Connect With Us!

Don't see your ideal role at comScore listed here? That's OK, we still want to stay in touch, because new roles become available frequently. Click below to join our Talent Network, and we'll keep you updated on all the happenings at comScore and alert you when there is a role that might be exactly what you are looking for!

Connect with us to stay informed!