Senior Data Warehouse Engineer - Remote
Company
TrueCar
Location
Remote
Type
Full Time
Job Description
TrueCar is a leading automotive digital marketplace and we are on a mission to make car buying and selling easy, transparent and efficient. We work to empower consumers with data, and foster connections with our network of Certified Dealers who share our belief that truth, transparency and fairness are the foundation to a great experience. We forge partnerships to power car buying programs for some of America’s most trusted brands. And we continually innovate to provide useful tools, research, market context and pricing transparency to help consumers feel empowered and confident all throughout their journey.
As consumers’ priorities and shopping habits shifted, so did we. We are building a modern day marketplace and invite you to come join the TrueCar Crew. You can have a real & direct impact on our journey as we continue to evolve and revolutionize the car buying and selling experience. We are seeking talented individuals who are excited by our mission to revolutionize & elevate the car buying & selling experience.
The Opportunity:Â
The Senior Data Warehouse Engineer serves as the technical lead on the Data Warehousing and Business Intelligence team. The lead engineer will be responsible for implementing strategies for the enterprise data warehouse including robust data pipeline design and build as well as data modeling to effectively support enterprise-wide analytics needs using Redshift, PostgreSQL, S3, Airflow, and Python along with data integration and data visualization/analytics tools.Â
How you will contribute to TrueCar’s success:
- Design/develop high-performance, resilient, and reusable data pipeline using ELT/ETL
- Pull and push data streams/structure data with API’s from multiple internal/external sources
- Discover, evaluate, and qualify new technologies to establish and maintain policies, procedures, and operational standards around the ETL/ELT, Redshift, BI, and AI tools for Data warehouse and Business Intelligence.
- Ensure smooth operation to support data warehouse and data pipeline platforms with high availability and efficient performance, while making continuous improvements, leveraging best practices and features the technical stack offers.
- Own Redshift Database Administration responsibilities: workload management, query prioritization, and optimization, capacity planning, designing and creating database objects, and other administration tasks.
- Manage database workloads i.e., Data integration, Workflow orchestration, and Analysis.
- Automates Data warehouse and BI platform administration tasksÂ
- Provide production support on a rotating basis
Your Expertise:Â Â
- Extensive experience in designing and delivering large-scale, 24-7, mission-critical data pipelines and features with at least 3 years of using modern big data architectures
- Hands-on work experience in PythonÂ
- Proven experience working in Redshift/Big Query/Snowflake/AWS Airflow or equivalent
- Strong understanding of ETL processing design with large data stores
- Strong data modeling skills (relational, dimensional, and flattened) and analytical SQL skills, with attention to detail
- Strong knowledge of BI best practices, relational structures, dimensional data modeling, structured query language (SQL) skills, data warehouse and reporting techniques
- DBA experience managing a large data warehouse
- Experience working with analytical presentation layers such as Dashboards, Reporting is a plus.
- Experience integrating data from multiple data sources and file types such as JSON and Avro formats.
- Experience in Tableau or Microstrategy
- Experience working with git or any other version control system
- Experience working in Agile environment
Base salary range: $141,000 - $185,000
Your TrueCar Experience
As a crew member, you’ll be primarily based out of your home as a part of our Dynamic Workplace strategy. We provide additional benefits & perks to assist our crew members in having a sustainable home workstation including monthly internet/mobile phone service reimbursement and furniture & equipment for your space.Â
You will receive excellent benefits that include but aren’t limited to 100% employer-paid health/vision/dental premium, 401k with company contribution, equity, a wellness stipend program, and a learning & development reimbursement program. We recognize that everyone needs an occasional recharge, so we offer a flexible PTO policy for exempt TrueCar Crew along with a generous PTO accrual policy for non-exempt TrueCar Crew, in addition to 14 company-paid holidays and 2 floating holidays. In short, we care deeply about our crew members and build employee-centric programs that prove it.Â
At TrueCar, we believe in the power of diversity to build a deeper understanding of our consumers and partners and drive innovation in our products. We welcome a workforce that reflects all the diversity of car-buying consumers. We encourage everyone interested in our company mission to apply. We do not discriminate on the basis of race, gender, religion, sexual orientation, age, or any other trait that is protected by applicable law. We will consider qualified applicants with arrest and conviction records in accordance with applicable law. In addition, TrueCar will provide reasonable accommodations for qualified individuals with disabilities.
TrueCar does not accept unsolicited agency submissions.
If you are based in California, we encourage you to read this important information for California residents linked here.
#LI-Remote
Date Posted
08/24/2024
Views
0
Similar Jobs
Senior Design Manager (Infrastructure) - Canonical
Views in the last 30 days - 0
Canonical a leading opensource provider seeks a Senior Design Manager to drive innovation in cloud and AI technologies The role offers remote work glo...
View DetailsSenior Product Designer - Org & Security - Typeform
Views in the last 30 days - 0
This job description outlines a role in developing an intelligent contact management system with AI capabilities The position involves designing user ...
View DetailsSenior Business Analyst - Xpansiv
Views in the last 30 days - 0
Xpansiv promotes its role as an energy market innovator with a global platform for environmental commodities The job posting seeks a Business Analyst ...
View DetailsSenior Specialist Senior Accountant Shared Financial Services - Make-A-Wish America
Views in the last 30 days - 0
The text describes Make a Wish Foundations mission to grant childrens wishes and their community efforts It outlines job positions with remotehybrid o...
View DetailsSoftware Engineer Networking Software and Services - xAI
Views in the last 30 days - 0
The text describes xAIs mission to develop AI systems for understanding the universe and advancing human knowledge It outlines a role involving networ...
View DetailsData Scientist - KoBold Metals
Views in the last 30 days - 0
KoBold a leading mineral exploration company using AI seeks a Data Scientist to advance their exploration tech They highlight successful discoveries i...
View Details