Database Architect TrueCar

Day-to-day responsibilities include:
- Rapid development of scalable, accurate, mixed OLTP/OLAP database schemas for a continuously evolving data analysis environment

- Transform statistical and mathematical models into database schemas and stored procedures

- Engage in corresponding analytical activities surrounding pricing modeling, user experience analysis, and web analytics

- Testing, transformation, cleansing and integration of multiple automotive sales transaction data sources

- Liaise with our data partners to facilitate the integration of their data

- Coordination with software engineers and work cross-functionally within the organization to deliver integrated business intelligence solutions

- Research and apply current domain best-practices to solve challenging technical and analytical problems



Required Skills, Education & Attributes
- 3-5 years' experience in information technology primarily focused on database architecting, development, and data processing

- Database administrator with experience with Microsoft SQL Server 2008 Enterprise, MySQL, and other DBMSs

- Fluent in T-SQL and stored procedure languages

- Solid understanding and experience with relational datasets, data warehouses, ETL, and data analysis techniques

- Can bend the Linux shell to your will

- Ability to quickly come up to speed on a wide variety of platforms and toolsets

- Applied Mathematics background a plus

- You can communicate with others using only Regular Expressions

- BS in Computer Science or related field

- You rock, you know it, and you want to work with people you can respect

- Above all: an entrepreneur at heart, self-motivated, with an insatiable can-do mentality


At TrueCar (www.truecar.com) we truly care about our employees. So much so, that WE PAY 100 PREMIUM FOR MEDICAL, DENTAL AND VISION COVERAGE for our employees and their dependents, and we match 75 on 4 of employees' 401(k) contributions.
Also:
Cell phone reimbursement
Gym/fitness reimbursement
Referral bonus
Patent bonus
TrueCar (http://truecar.com) is a fast-growing, car-pricing information service based in Los Angeles. Our mission is to bring full pricing transparency to the car buying process. We level the playing field for consumers and dealers by publishing actual vehicle pricing based on sales transaction data of car purchases across the US. For the right candidate, this will be a simultaneously challenging, exciting, energetic, frustrating, and ultimately rewarding experience in a fun and fast-paced decision making environment.

Local candidates
Must be authorized to work in the United States
TO APPLY:
http://truecar.simplicant.com/job/detail/3858-data-architect

Location:	225 Santa Monica Blvd., 6th floor Santa Monica, CA 90401 United States
Employment Type:	Full Time
Functional Area:	IT
Tags:	OLTP OLAP schemas models modeling user experience ue ux analytics analyze analysis integration transaction