Job Description

MarkMonitor is looking for a talented Data Warehouse Engineer with solid experience in Microsoft SQL Server technologies and data warehousing. This is an opportunity for a motivated person with the right skill set to become part of a very dynamic international company with a high focus on technology and Internet trends.
Helping some of the largest corporations in the world, MarkMonitor manages their domain portfolios and protects their brand on the internet. MarkMonitor Anti-Piracy is an industry leader in tracking online copyright infringements and piracy trends. With our unique products and services we offer clients the ability to gain detailed insight into how digital media content is being distributed online via various platforms such as websites and p2p file-sharing networks.
In this role you will help develop solid, scalable ETL processes and design and implement databases that support the continuously evolving needs of our clients and internal operational teams. You will join a team focused on maintaining our client databases and reporting interfaces.

Job Responsibilities:

• Help ensure that our business intelligence solutions deliver the information required by our clients and internal operations
  
• Assist in defining the right data structures all the way from the point when we collect the information, through to the Data Warehouse and into our reporting infrastructure
  
• Help write and maintain efficient and accurate ETL processes which can load data in a timely manner, and optimize existing processes to improve load times and support new features
  
• Accommodate new requirements from the business end by building out the data warehouse and surrounding systems, correctly taking into account the full data flow and architecture and making sure the systems are kept stable and scalable
  
• Validate data integrity on all levels of the data warehouse, from source data through to end user reports
  
• Take part in designing and implementing solid backup solutions on critical levels of the database architecture

Requirements

• At least 3 years working experience with MS SQL Server 2005 / 2008 / 2012
  
• In-depth knowledge of and experience with T-SQL
  
• MDX experience
  
• Strong data analysis skills founded in a keen analytical sense
  
• Good understanding of relational and dimensional modelling
  
• At least 1 year experience with MS SQL Server Analysis Service and Integration Services
  
• Attentive to detail and committed to quality
  
• Possess exceptional written/verbal communication and interpersonal
  
• Self-starter who thrives in a fast-paced, team-oriented environment
  
• Ability and desire to rapidly learn new skills and adapt to changing business environment skills
  
• Demonstrated ability to solve complex problems
  
• Professional demeanor
  
• Fluent English;
  

• Building business management systems
  
• Partitioning and index tuning
  
• Experience with Microsoft Reporting services
  
• Experience with C# web development (HTML, CSS, jQuery)

Company offers

-