Data Engineer

Location and Schedule:

• On-site at headquarters from 8:00 a.m. to 5:00 p.m. preferred.
• Hiring manager prefers 5 days on-site.
• Remote may be considered for highly qualified candidates on PST hours.

• Establish database management systems, standards, and guidelines.
• Define and document conceptual and logical database designs.
• Plan capacity, external data interfaces, data loading, maintenance, and security.
• Evaluate and install database management systems.
• Code complex programs and design logical processes on target platforms.
• Build windows, screens, and reports for business applications.
• Assist with user interface and application prototypes.
• Participate in quality assurance and develop test application code.
• Define and defend database tables, fields, and data standards.
• Translate business requirements into data models and specifications.
• Define table relationships and field interactions for relational models.
• Determine data suitability and optimal storage organization.
• Work closely with a team of approximately 15 engineers.

• Build reliable, scalable data pipelines.
• Design and optimize data models.
• Perform data analysis to support business needs.

• Minimum 8 years of data engineering experience.
• Bachelor's degree preferred.
• Alternatives may be accepted as follows.
  • PhD or Law plus 6 years of experience.
  • Master's degree plus 7 years of experience.
  • Associate degree plus 9 years of experience.
  • High school diploma plus 10 years of experience.

• Strong proficiency in Python and SQL.
• Hands-on experience with Databricks.
• Experience with Apache Airflow for orchestration.
• Strong knowledge of AWS services including EMR and SQL-based tooling.
• Experience building production systems using AWS EC2, ECS, API Gateway, and Lambda.
• Experience implementing CI/CD and DevOps for deployment and production support.

• Strong documentation and communication skills.
• Ability to work in a collaborative team environment.
• Strong attention to detail and quality.
• Ability to manage priorities and deliver on deadlines.

• Two coding rounds.
• Each round is 1 hour.