Title

Data Warehouse Architect

Location

San Diego, CA

Category

Product Development

To apply

Please send resume and cover letter to jobs@covario.com

APPLY NOW
Description

Covario is seeing a Data Warehouse Architect to join our innovative team. We are seeking a well-organized, team oriented individual to provide creative solutions to the design and development of data warehouses, Business Intelligence analytics and real-time dashboards used for internal as well as client facing solutions.  Strong data warehouse, data mart, SQL Server, and cube technology experience are necessary skills.

Responsibilities

  • Design, develop, and maintain:
    • Microsoft SQL Server 2008/2012 Databases
    • Data Warehouses
    • Data Marts
    • OLAP Cubes
    • ETL Processes
  • Provide primary support of all existing interfaces post implementation
  • Provide implementation support and workflow management during the course of all projects
  • Regular interaction with end users, other developers, and the leadership team
  • Provide application and module documentation to a technical writer so that technical and end user documentation can be generated
  • Provide end-user training as needed for all modules

Required Skills & Experience

  • B.S. in Information Technology or Computer Science
  • 3 – 5 years SQL Server database and data warehousing experience
  • Experience in backend Database design using SQL Server 2008 / 2012
  • Solid understanding of fundamental Business Intelligence design and development methodologies and best practices
  • Strong problem-solving skills and ability to work in a fast paced dynamic environment with responsibility for multiple simultaneous projects
  • Excellent written and verbal  communication skills including the ability to discuss project details with technical, non-technical and management team members
  • Strong Expertise in T-SQL and ability to work with data from different subject areas
  • Knowledge and understanding of Dimensional Modeling concepts and principles
  • Experience in the design and development of ETL processes using SQL Server Integration Services (SSIS)
  • Strong OLAP design and development experience using SQL Server Analysis Services (SSAS)
  • Experience with end-user reporting definition, development and platform support using SQL Server  ReportingServices (SSRS) and Performance Point

Preferred qualifications:

  • Microsoft Certifications
  • Hands-on experience in C#.Net and ASP.Net
  • SQL Server administration