Manager, Partner Data Systems and Operations

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:

• Develop a strong understanding of medical data feeds for both Medical/Provider Claims Data and Pharmacy Benefit Management/Pharmacy Claims
• Engage with partners, clients, and benefit management vendors to obtain pertinent data files
• Work with technical and non-technical client stakeholders to explain data concepts and enforce data requirements
• Establish strong relationships with partners and clients with a goal of standardizing data file templates
• Partner with Twin Health’s Partner Success and Implementation teams to establish and maintain required data source feeds.
• Design and develop 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.
• Automate and optimize existing data processing workloads to integrate with the enterprise data warehouse and downstream applications
• Understand and translate business needs into data models to support long-term, scalable, and reliable solutions
• Build data pipelines from systems such as CRM, ERP and internal applications with the emphasis on scalability and reliability
• Partner with Implementation team, business users, architects to build end-to end-automations.
• Drive data quality across the partner datasets and related analytics. 
• Develop best practices for standard naming conventions and coding practices to ensure consistency of data models and cross application integrations.
• 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

• 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 Cloud Data Warehouses in Snowflake or Redshift
• At least 2 years of experience in developing data pipelines using Python or Java
• Knowledge of advanced SQL scripting and ability to write complex queries
• Experience using application integration tools like Workato, Dell Boomi etc. 
• 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.

Benefits

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
• A remote and accomplished global team
• 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
• Free membership with One Medical, Carrot Fertility, Aaptiv, Headspace and other perks in line with our focus on employee wellbeing