Rivian is on a mission to keep the world adventurous forever. This goes for the emissions-free Electric Adventure Vehicles we build, and the curious, courageous souls we seek to attract. 

As a company, we constantly challenge what’s possible, never simply accepting what has always been done. We reframe old problems, seek new solutions and operate comfortably in areas that are unknown. Our backgrounds are diverse, but our team shares a love of the outdoors and a desire to protect it for future generations. 

We operate development centers in Plymouth, Michigan; Southern California (Irvine, Carson & LA); Silicon Valley (San Jose and Palo Alto); Vancouver, British Columbia; and Surrey, England; as well as a manufacturing facility in Normal, Illinois.

Role Summary:

The Information Technology org at Rivian is seeking a Sr. Data Warehouse Architect to join the Data Services team who can provide leadership in working with both technical and business executives in the design and architecture of the AWS Cloud Data Platform as a critical component of their enterprise data architecture and overall ecosystem.

In this role you will work with Supply Chain, Finance, Engineering and Manufacturing teams, Product Management, and Technology Partners to leverage best practices and reference architectures highlighting AWS Cloud Data Platform as a core technology enabling advanced analytics and data science throughout the company.

 

Responsibilities:

  • Lead, architect, design and develop secure, scalable, high-performance and reliable (cost effective) big data and analytics platform software and services
  • Translate big data and analytics user requirements into data models for (Supply Chain, Finance, Engineering and Manufacturing) that will operate at large scale and high performance and guide the data analytics engineers on these data models.
  • Define, deploy and advance processes for: SDC, CI/CD, quality checks, error handling, error notifications, security, extensibility and maintainability of big data and analytics platform software and services
  • Define templates and process for the design and analysis of data models, data flows, and integration patterns for structural deficiencies/soundness to build a robust and complete future state model
  • Lead by example to review code, look for design breaches, provide meaningful and relevant feedback to engineers, stay up-to-date with system changes and latest technologies
  • Comfortably present and acquire consensus using multiple methods: Written diagrams and text, in-person meetings, in-person and remote presentations to both technical and business audiences
  • Provide technical leadership to software developers, data scientists/engineers, and product owners/managers through brainstorming sessions, design reviews, and retrospectives.
  • Own the data management technical roadmap and execution aligning with peer platform organizations and product delivery, Ensure alignment with over-arching enterprise platform initiatives
  • Lead and mentor Rivian’s Data Analytics team members in best practices, processes and technologies in Data platforms

 

Basic Qualifications & Skills:

  • Excellent communication and interpersonal skills, with the ability to break down complex technical problems into simple elegant solutions understandable by non-technical business partners.
  • 15-20 years of hands-on IT experience in Data Warehouse, ETL & Reporting. Extensive experience of executing multiple data warehouse projects in variety of business domain
  • 10+ years of experience in understanding variety of complex business use cases and modelling the data in the data warehouse. Very strong understanding of core data warehouse concepts.
  • 5+ years of hands-on experience in productionizing and deploying Big Data platforms and applications, Hands-on experience working with: Relational/SQL, distributed columnar data stores/NoSQL databases, graph databases, timeseries databases, NiFi, Spark streaming, Kafka, Hive, Impala, Avro, and more
  • 5+ years of deep experience in design and development in AWS Redshift
  • Skilled in Python, Spark. Hands-on experience with AWS Services like S3, Glue, Kinesis, Lambdas
  • Hands-on experience with Airflow and Tableau.
  • Proven experience in building a Custom Enterprise Data Warehouse or implementing tools like Oracle BI Applications/ Oracle Financial Analytics/OBIA. 2-3 end-to-end implementation
  • Strong understanding of Supply Chain and Financials business processes like Order Bookings, Invoicing/Billings, Forecasting, Demand Planning, Financial Planning. Purchasing, Payables etc.

Equal Opportunity

Rivian is an Equal Opportunity Employer and Prohibits Discrimination and Harassment of Any Kind: Rivian is committed to the principle of equal employment opportunity for all employees and to providing employees with a work environment free of discrimination and harassment. All employment decisions at Rivian are based on business needs, job requirements and individual qualifications, without regard to race, color, religion or belief, family or parental status, or any other status protected by the laws or regulations in the locations where we operate. Rivian will not tolerate discrimination or harassment based on any of these characteristics. Rivian encourages applicants of all ages.

Privacy

We take your privacy seriously. For details please see our Candidate Privacy Notice.

Apply for this Job

* Required
  
Attach Dropbox Google Drive Paste
When autocomplete results are available use up and down arrows to review
+ Add Another Education

U.S. Equal Opportunity Employment Information (Completion is voluntary)

Individuals seeking employment at Rivian Automotive are considered without regards to race, color, religion, national origin, age, sex, marital status, ancestry, physical or mental disability, veteran status, gender identity, or sexual orientation. You are being given the opportunity to provide the following information in order to help us comply with federal and state Equal Employment Opportunity/Affirmative Action record keeping, reporting, and other legal requirements.

Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiring process or thereafter. Any information that you do provide will be recorded and maintained in a confidential file.

Race & Ethnicity Definitions

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection. As a government contractor subject to Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measure the effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categories is as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.

Form CC-305

OMB Control Number 1250-0005

Expires 05/31/2023

Voluntary Self-Identification of Disability

Why are you being asked to complete this form?

We are a federal contractor or subcontractor required by law to provide equal employment opportunity to qualified people with disabilities. We are also required to measure our progress toward having at least 7% of our workforce be individuals with disabilities. To do this, we must ask applicants and employees if they have a disability or have ever had a disability. Because a person may become disabled at any time, we ask all of our employees to update their information at least every five years.

Identifying yourself as an individual with a disability is voluntary, and we hope that you will choose to do so. Your answer will be maintained confidentially and not be seen by selecting officials or anyone else involved in making personnel decisions. Completing the form will not negatively impact you in any way, regardless of whether you have self-identified in the past. For more information about this form or the equal employment obligations of federal contractors under Section 503 of the Rehabilitation Act, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

How do you know if you have a disability?

You are considered to have a disability if you have a physical or mental impairment or medical condition that substantially limits a major life activity, or if you have a history or record of such an impairment or medical condition.

Disabilities include, but are not limited to:

  • Autism
  • Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, or HIV/AIDS
  • Blind or low vision
  • Cancer
  • Cardiovascular or heart disease
  • Celiac disease
  • Cerebral palsy
  • Deaf or hard of hearing
  • Depression or anxiety
  • Diabetes
  • Epilepsy
  • Gastrointestinal disorders, for example, Crohn's Disease, or irritable bowel syndrome
  • Intellectual disability
  • Missing limbs or partially missing limbs
  • Nervous system condition for example, migraine headaches, Parkinson’s disease, or Multiple sclerosis (MS)
  • Psychiatric condition, for example, bipolar disorder, schizophrenia, PTSD, or major depression

1Section 503 of the Rehabilitation Act of 1973, as amended. For more information about this form or the equal employment obligations of Federal contractors, visit the U.S. Department of Labor's Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.