Senior Data Warehouse Architect

Founded in 1995, The Cobalt Group is North America’s leading provider of automotive marketing services, offering automotive dealers and manufactures the industry’s best online retailing, CRM, fixed operations and search engine marketing solutions. For more than a decade, Cobalt’s exclusive mission has been to help automobile dealers and manufacturers increase their retailing effectiveness and profits. Cobalt provides marketing services to more than half the automotive dealerships in the United States, Canada and Mexico and is endorsed by more than two-thirds of the world’s major automotive manufacturers. Cobalt is endorsed by the American International Automobile Dealers Association (AIADA).This Sr. Data Warehouse Architect role is to strategically design and implement data warehouses, data marts, and data stores, in a manner that ensures high levels of data availability. This individual is also responsible for participating in the definition of data standards and models for warehouse architectures. In addition, the Sr. Data Warehouse Architect will participate in the evaluation of infrastructure components including software, hardware, database management systems and networking capabilities. This person will work in conjunction with other IT/development and business groups to understand functionality, scalability, performance, security and integration requirements from the database perspective, and to translate these requirements into functional, scalable and reusable components that meet the business need.Essential Functions Analyze and determine information needs, data relationships and attributes, data flow and storage requirements, and data output and reporting capabilities in a complex data warehousing environment
Design and implement dimensional data models
Analyze data acquisition needs and access requirements
Participate in the development of an ETL strategy, provide ETL design and implementation
Design and implement integrations with new data sources in a manner that ensures consistency with existing data warehouse structures and processes
Review and support business requests for data and data usage, research and recommend tools that will make those requesting data more self-sufficient.
Contribute to the establishment of an architectural roadmap for business intelligence reporting, including analysis of solution alternatives, architectural design, and system integration needs.Develop/review technical documents to ensure consistency, accuracy and compliance with architectural directions as they relate to the warehouse environment.
Provide support to development team through tuning, indexing, sizing and debugging to ensure that quality and standards meet customer expectations
Analyze performance statistics, tune SQL queries, recommend database and application changes to improve performance and scalability.
Provide guidance and mentoring to less-experienced staff membersRequired Skills5+ years experience working as a Data Warehouse Architect in a warehousing environment
5+ years experience in SQL development and tuning in an Oracle environment
3+ years experience working with ETL tools (Informatica tool suite preferred)
3+ years experience with dimensional modeling
Proven track record in building scalable, database-driven web applications
Experience working with MS Office Suite (including MS Excel and Visio)
Experience with Informatica Power Analyzer strongly desired
Familiarity with Unix/Linux environment, scripting skills strongly desired
Excellent written and verbal communication skills required
Automotive market experience preferred, but not requiredBased in Seattle, Cobalt has offices in Detroit; Columbus, Ohio; Redwood City, California; and Bangalore, India. In addition, Cobalt hires all over the US for positions in the field. Automotive retailing solutions continue to be a growth industry as more and more dealerships and manufacturers recognize the operational efficiencies and the extraordinary marketing potential of Cobalt’s technology. Accordingly, Cobalt’s customer base and its need for talented, creative and hardworking individuals continue to grow.The Cobalt work environment is fast-paced, energized, informal and fun, but with a serious focus on quality, customer service, innovation, and an ongoing commitment to excellence. Benefits include medical, dental, and vision for employee and dependents (including domestic partners), life insurance, paid vacation time, personal days, sick leave and paid holidays, 401K with match, employee referral bonuses, stock option plan, subsidized parking and free bus pass, onsite gym, and more. For more information, go to www.cobaltgroup.com.
REQUIREMENTS
See Description