Data Engineer

About LightForce Orthodontics

LightForce Orthodontics is a 3D printing technology company focused on the orthodontic space. Our digital platform empowers orthodontists with 3D-printed tooth-moving tools. In 2019, we launched our first product - the world’s only, fully customized 3D printed bracket system and digital treatment software. We are proud to be one of the fastest growing companies in the industry. Learn more at www.lightforceortho.com

Description 

LightForce Orthodontics is seeking a Data Engineer to join our rapidly expanding team. As a Data Engineer, you will be supporting the entire LightForce organization for its data needs, helping enable the exponential growth of the company. 

As a Data Engineer, you fulfill a critical role that enables the company to make data-based decisions. You will be responsible for building, maintaining and improving data infrastructure. You will make sure that all data within the organization is well managed and accessible. 

LightForce Orthodontics hires committed, self-motivated employees and then gives them the freedom and flexibility to do great work. You will help to grow a fantastic engineering team and industry-changing tech company, to advance the orthodontic profession, and to provide positive health benefits to patients. 

About Our Stack

• Scheduling/Orchestration: Lambda, Airflow
• ETL: Custom Typescript, SQL, DBT 
• Data Warehouse: RDS/PostgreSQL, BigQuery
• Dashboarding: Quicksight 
• Code versioning: Git 
• Preferred languages: SQL, Python, Typescript 

Essential Duties and Responsibilities 

• Build, maintain, and improve the data infrastructure; from architecture to implementation
• Create and maintain data pipelines and data warehouses
• Setup and integrate reporting and business intelligence tools 
• Collaborate with and coach other junior data engineers and analysts 
• Lead development of more complex dashboards 

Education & Experience

• BS/MS in Computer Science, Software Engineering, or a related quantitative field
• 3+ years of experience as a Data Engineer

Required Qualifications

• Strong verbal and written communication skills and the ability to effectively collaborate with other engineers as well as internal/external stakeholders 
• SQL proficiency - must be able to build and performance tune complex transformation, reporting, and validation queries – preferably in PostgreSQL – to ensure accuracy, scalability, and maintainability of code. 
• Analytical and problem-solving skills to take complex business requests and transform them into clean, simple, data driven solutions

Preferred Qualifications: 

• 5+ years of experience as a Data Engineer
• Experience working in an Agile/Scrum environment 
• Professional software development experience 
• Professional hands-on experience with AWS infrastructure 
• Experience using git and Jira

Physical Demands

• Requires the ability to use hands, and reach with hands and arms
• Requires the ability to see, listen, and speak

Work Environment

• Work is generally performed in an open office, sedentary position.

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed above are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

LightForce Orthodontics is an Equal Opportunity/Affirmative Action Employer and does not discriminate on the basis of race, color, religion, gender, age, national origin, disability, Protected Veteran status, sexual orientation, or any other characteristic protected by federal, state, or local law.