Bachelor's degree preferred; alternative qualifications include PhD or Law with 6+ years, Master's degree with 7 years, Associate degree with 9 years, or High school diploma with 10 years.
Strong proficiency in Python and SQL.
Hands-on experience with Databricks and Apache Airflow; strong experience with AWS services including EMR, EC2, ECS, API Gateway, and Lambda; and implementing CI/CD and DevOps for deployment and production support.
Requirements:
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.
Translate business requirements into data models and specifications.
Job description
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.
Job Summary:
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.
Core Focus Areas:
Build reliable, scalable data pipelines.
Design and optimize data models.
Perform data analysis to support business needs.
Required Experience:
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.
Technical Skills:
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.
Soft Skills:
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.
