Technical Lead Data EngineerDepartment Research & DevelopmentEmployment Type Full TimeLocation US-California-San JoseCompensation 169400 - 233000 yearDescriptionThis position is ideal for senior-level data engineering professionals to join the Product Analytics team as a Technical Lead Data Engineer. You will drive the design development and management of robust data pipelines investigate data discrepancies and enable research through the creation and maintenance of sandbox databases. Partnering with business owners product engineering managers functional managers and cross-functional teams in R&D IT marketing clinical and operations youll provide technical leadership and hands-on expertise to deliver high-quality reliable data solutions that support business insights metrics and recommendations. You will operate as a power user of the Datalake collaborating with partner teams for administrative support and broader data access.Role expectationsServe as the technical leader and subject matter expert for dashboard development setting best practices for design implementation and monitoring of analytics dashboards.Lead the investigation and resolution of complex data discrepancies collaborating with cross-functional teams to ensure data accuracy consistency and integrity across all reporting platforms.Architect develop and maintain scalable data pipelines and ETLELT processes using Databricks Starburst and Kafka within the teams allocated data catalog and resources.Design and manage sandbox databases enabling rapid prototyping and research for internal stakeholdersDesign and maintain data models and schemas for efficient querying and reporting utilizing Starburst for federated data access.Collaborate with partner teams for data access integration and troubleshooting beyond your teams scope.Oversee the extraction cleaning wrangling and exploratory analysis of data using SQL and programming languages e.g. Python.Document technical processes and mentor team members in best practices for data engineering and dashboard development.Monitor and optimize data infrastructure performance troubleshooting issues as needed within the teams allocated resources.Establish and enforce data governance and usage guidelines to ensure compliance and best practices.Remain current on industry trends and emerging technologies in data engineering BI and analytics.What were looking forEducation BS or MS in Computer Science Engineering Data Science or related technical field.Experience 8-12 years of experience in Data Engineering Data Analytics Business Analytics or related fieldsSkills Strong knowledge of data modeling ETL and dashboard development Hands-on experience with Databricks Starburst and Kafka as a power user Hands-on expertise with dashboard development and monitoring e.g. Power BI Tableau Deep expertise in data discrepancy investigation root cause analysis and resolution Strong analytical and problem-solving abilities Demonstrable experience designing and managing data pipelines and ETL frameworks Proficiency in SQL writing & optimization data modeling and relational database management Proficiency in Python or other programming languages for data engineering tasks Familiarity with cloud data platforms and big data technologies Strong organization and project management skills.Communication Exceptional communication and documentation skills to accurately convey technical requirements and priorities to stakeholdersTeamwork Ability to work cross-functionally with a diverse group of people and functions to drive timely solutionsStrong presentation and documentation skillsSelf-motivated proactive and willing to work through barriers and strive for continuous improvementDesire and willingness to develop clinical understanding of Invisalign product and orthodonticsPay TransparencyIf provided base salary or wage rate ranges are the range in which Align reasonably expects to set a candidates pay for the posted position. Actual placement depends on the individual skills and experience level of a candidate plus the total compensation and equity across team members. For other locations outside of the primary location the base salary range will be adjusted geographically.For Field Sales roles the salary listed is the base pay only and does not include the applicable incentive compensation plan. A cost of living adjustment may be added to base pay for higher cost areas in the U.S.Our internship hourly rates are a standard pay determined based on the position and your location year in school degree and experience.General Description of All BenefitsWe are pleased to provide a general description of the benefits Align offers to full-time employees in this position. Family Benefits. Align offers employees and their eligible dependents medical with a Health Savings Account option for some plan offerings dental and vision in accordance with those plans. Align also offers to employeesDiscounts on Invisalign and Vivera to employees and their eligible dependents after 90 days of employmentBack-up ChildElder Care and access to a caregiving conciergeFamily Forming Benefits - Available to Employees and their spouse or domestic partner covered under one of Aligns health plansBreast Milk Delivery and Lactation Support ServicesEmployee Assistance ProgramHinge Health Virtual Physical Therapy - Available to all employees and eligible dependents age 18 enrolled in an Align medical PlanEmployee benefits. Align offers its employeesShort-term and long-term disability insurance in accordance with those plans.Basic Life Insurance and Accidental Death and Dismemberment. Voluntary Supplemental Life Insurance for Employee SpouseDomestic Partner and Children are available for purchase in accordance with those plans.Flexible Spending Accounts - Employees may be eligible to participate in a health care account including a limited health FSA if enrolled in a HDHP dependent care account and a pre-tax commuter benefit plan.401k plan with a discretionary Company match of 50 up to 6 of eligible earnings up to a maximum match of 3.. Employer match vests after two years - 25 year one and 100 at year two. Align offers traditional Roth and after-tax options.Employee Stock Purchase Program Employees must work 20 hours or more and be employed on purchase date to be eligible.Paid vacation of up to 17 days during the first full year of employment currently accrued at the rate of 5.24 hours each pay-period which carries over to a maximum cap of 30 days. Annual paid vacation time accrual increases based on tenure. Both exempt and non-exempt employees who work 32 hours or more per week receive prorated vacation accrual based on their regularly scheduled work hours and tenure.Sick time is accrued throughout the year at the rate of one hour for every thirty worked. Employees can carry over unused sick leave each year up to a maximum balance of 80 hours.11 Company-designated paid holidays throughout the year.If employed for at least 12 consecutive months Align will grant up to 6 weeks of paid Parental Leave. If employed for less than 12 consecutive months Align will grant up to 4 weeks of paid Parental Leave. All parental leave must be completed within one year of the birth or placement of the child. Parental leave is in addition to any state andor local parental leave benefits. Three days of paid bereavement leave. In some cases due to travel the amount of paid leave may be extended to 5 paid days off. To the extent applicable state or local law offers more generous benefits Align complies with any such law.Non-exempt employees will receive full pay for up to 10 days of jury duty. Exempt employees will receive their full salary during any week they serve and perform any work. Other insurance such as legal critical illness voluntary accident long-term care auto home and pet insurance are available for purchase. To the extent applicable state or local law offers more generous benefits Align complies with any such law.