Opportunity 

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 a data warehouse from scratch and managing ETL pipelines, working collaboratively with internal business stakeholders and customers. We are looking for candidates physically located in PST. 

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.
•  Implement a comprehensive framework to support logging, profile and audit high volume high frequency file processing supporting multiple formats.
•  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.
• Applicants must be authorized to work for any employer in the U.S. We are unable to sponsor or take  over sponsorship of an employment Visa at this time.
• This remote opportunity is available to US based persons

Qualifications 

• Bachelor’s 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 experience in building Data Warehouses in Snowflake or Redshift
•  At least 4 years of experience in developing data pipelines using Python, PySpark or Scala.
•  Experience with API design and development using RESTful and/or SOAP protocols.
•  At least 2 years of experience creating DBT models and in a cloud, data Warehouses platform.
•  Knowledge of advanced SQL scripting and ability to write complex queries.
•  Experience using Rivery or new age ELT tools like Fivetran, Matillion etc.
•  Understanding of agile methodologies such as CI/CD, Applicant Resiliency, and Security
•  Experience working with various file formats at scale.
•  Experience with AWS. Familiarity with AWS Athena, Glue, Data Pipeline is a plus.
•  At least 2 years of experience with Salesforce Health Cloud, Marketing Cloud and NetSuite Schemas.
•  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, and solid communication skills.

Compensation and Benefits  

The compensation range for this position is $140,000 annually. 

In addition, Twin has an ambitious vision to empower people to live healthier and happier lives, and to achieve this purpose, we need the very best people to enhance our cutting-edge technology and medical science, deliver the best possible care, and turn our passion into value for our members, partners and investors. We are committed to delivering an outstanding culture and experience for every Twin employee through a company based on the values of passion, talent, and trust. We offer comprehensive benefits and perks in line with these principles, as well as a high level of flexibility for every Twin

• A competitive compensation package in line with leading technology companies
• As a remote friendly company we are committed to providing opportunities for all who join to further build relationships, increase cross-functional collaboration, and celebrate our accomplishments.
• Opportunity for equity participation 
• Unlimited vacation with manager approval
• 16 weeks of 100% paid parental leave for delivering parents; 8 weeks of 100% paid parental leave for non-delivering parents
• 100% Employer sponsored healthcare, dental, and vision for you, and 80% coverage for your family; Health Savings Account and Flexible Spending Account options
• 401k retirement savings plan