Database Architect

Tbwa Chiat/Day - Newark, NJ

Full-time - Mid Level

Newark, NJ

About the position

The Data Architect at Lucid is responsible for defining and leading the Data Architecture, Data Quality, and Data Governance for both Vehicle and Operational data. This role involves ingesting, processing, and storing vast amounts of data, solving complex big data problems, and establishing best practices across the company. The position requires hands-on involvement in designing solutions, writing code, and working closely with developers and business analysts to optimize database structures.

Responsibilities

• Define and lead the Data Architecture, Data Quality, and Data Governance for Vehicle and Operational data.
• Gather requirements, conduct feasibility analysis, and perform logical and physical database modeling/design.
• Choose appropriate database types (RDBMS/NoSQL/Graph/JSON/Columnar/Time-series) for various data needs.
• Create and modify database structures in collaboration with developers and business analysts.
• Architect and design database schemas, including indexing and SQL tuning for MySQL.
• Provide solutions for application team requirements and design optimal MongoDB schemas.
• Design and build graph database load processes for Neo4J, including backup and recovery methodologies.

Requirements

• 7+ years of experience in Database Architecture and Design.
• 7+ years of experience in solution design patterns.
• 7+ years of experience with SQL and NoSQL databases such as MySQL, MongoDB, Redis, DynamoDB, Elasticsearch, or Neo4J.
• Experience with at least two coding and scripting languages (e.g., Python, Java, Scala, Shell Scripting).

Nice-to-haves

• Experience defining and evaluating application solution architectures and roadmaps.
• Ability to maintain perspective and establish context as a 'Big Picture' thinker.
• Understanding of the differences between relational and NoSQL database development and access methodologies.
• Experience with LDAP Based Authentication & Authorization.

Benefits

• Medical insurance
• Dental insurance
• Vision insurance
• Life insurance
• Disability insurance
• Vacation
• 401k
• Equity program participation
• Discretionary annual incentive program