Sr. Cloud Data Warehouse Engineer

**Sr. Cloud Data Warehouse Engineer** at Twin Health

Remote ( USA - CA,NV,WA,AZ)

Founded in 2018, Twin Health invented the Whole Body Digital Twin (WBDT) to help reverse and prevent chronic metabolic diseases. Powered by artificial intelligence, the WBDT is a dynamic representation of each individuals unique metabolism, built from thousands of data points collected in real-time via wearable sensors and self-reported preferences. The WBDT is a precise predictive model that provides individualized nutrition, sleep, activity and breathing guidance to patients and their healthcare providers to reverse and prevent a variety of chronic metabolic diseases, including type 2 diabetes, cardiovascular disease, and liver disease. Our Twin team is passionate, intelligent, motivated, and driven by our collective purpose -- to improve the health and happiness of our members. We have deep expertise in IoT, AI, data and medical science, healthcare management, and health policy. Our executive team is composed of individuals who have dedicated their careers to building and growing multiple leading global digital health companies. Our culture is one that empowers, and through our revolutionary technology and our dedicated partnership with our patients, Twin team members have the opportunity to improve the health of patients every day. We recently announced the closing of our $140M Series C funding round, including leading global investors ICONIQ Growth, Sequoia, Perceptive Advisors, Corner Ventures, LTS Investments, Helena and Sofina, enabling our team to scale its service and help solve the global chronic metabolic disease health crisis. We are building the company you always wished you worked for. Join us in building the most impactful digital health company in the world Twin Heath is expanding rapidly across health providers nationwide in the US as well as India. We are seeking an experienced Data Warehouse Engineer to join our growing team to own the entire process of building data warehouse from scratch and managing ETL pipelines, working collaboratively with internal business stakeholders and customers. **Responsibilities** * Drive analysis, architecture, design, and development of Cloud based data warehouse and business intelligence solutions * Design and develop data flows and models for data warehousing and self-serve reporting * Design and build extensible data acquisition and integration solutions to meet business reporting and analytics needs. * Own and develop architecture supporting the translation of analytical questions into effective reports that drive business action * Automate and optimize existing data processing workloads to integrate with the enterprise data warehouse * Understand and translate business needs into data models to support long-term, scalable, and reliable solutions * Create data models for self-serve reporting. * Build data pipelines from systems such as CRM, ERP and internal applications with the emphasis on scalability and reliability * Partner with business users, senior architects, and infrastructure engineers to form complete end-to end-solutions * Drive data quality across the organization; develop best practices for standard naming conventions and coding practices to ensure consistency of data models and tracking * Prepare to respond to ad hoc reporting needs of business functions. * Work in a fast-paced environment and perform effectively in a sprint based agile development environment. * Collaborate with developers and analysts on technical and functional designs * Analyze query performance and perform query tuning to assist development engineers in designing and optimizing queries **Qualifications** * Bachelors degree in computers Ince or related field. * At least 8 year of overall experience building data warehouse solutions with solid data modeling skills * At least 3 years of hands-on experiencein building Cloud Data Warehouses in Snowflake or Redshift * At least 2 years of experience creating DBT models andin a cloud, data Warehouses platform * Knowledge of advanced SQL scripting and ability to write complex queries * Experience using new age ETL tools like Fivetran, Matillion etc. * Experience in developing data pipelines using Python or Java * Experience designing highly scalable ETL/ELT processes with complex data transformations, data formats including error handling and monitoring. * Excellent analytical, problem solving, and troubleshooting skills to manage complex process and technology issues * Strong verbal and written communication skills **Voluntary Self-Identification** For government reporting purposes, we ask candidates to respond to the below self-identification survey. Completion of the form is entirely **voluntary**. Whatever your decision, it will not be considered in the hiring process or thereafter. Any information that you do provide will be recorded and maintained in a confidential file. As set forth in Twin Healths Equal Employment Opportunity policy, we do not discriminate on the basis of any protected group status under any applicable law. Gender Gender

Gender Please identify your race Please identify your race

Please identify your race If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection. As a government contractor subject to the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measure the effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categories is as follows: A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability. A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service. An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense. An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985. Veteran Status Veteran Status

Veteran Status Form CC-305 OMB Control Number 1250-0005 Expires 05/31/2023 **Voluntary Self-Identification of Disability** We are a federal contractor or subcontractor required by law to provide equal employment opportunity to qualified people with disabilities. We are also required to measure our progress toward having at least 7% of our workforce be individuals with disabilities. To do this, we must ask applicants and employees if they have a disability or have ever had a disability. Because a person may become disabled at any time, we ask all of our employees to update their information at least every five years. Identifying yourself as an individual with a disability is voluntary, and we hope that you will choose to do so. Your answer will be maintained confidentially and not be seen by selecting officials or anyone else involved in making personnel decisions. Completing the form will not negatively impact you in any way, regardless of whether you have self-identified in the past. For more information about this form or the equal employment obligations of federal contractors

#J-18808-Ljbffr