ArchWell Health is a new, innovative healthcare provider devoted to improving the lives of our senior members. We deliver best-in-class care at comfortable, accessible neighborhood clinics where seniors can feel at home and become part of a vibrant, wellness-focused community. Our members experience greater continuity of care, as well as the comfort of knowing they will be treated with respect by people who genuinely care about them, their families, and their communities.  Duties/Responsibilities: - Build data integrations from internal and external sources to centralize data into a Data Warehouse environment. - Monitor data integration operations, data quality, troubleshoot, and resolve problems. - Profile data sources and map to target table formats. - Develop and monitor data quality processes and address problems. - Develop, unit test and system test integration components. - Create support documentation describing the functionality of the integrations. - Participating in technical design & requirements gathering meetings. - Participate in planning and implementing data integration and data migration activities. - Perform QA tests to ensure data integrity and quality. - Research data issues between source systems and the data warehouse. Required Skills/Experience: - Bachelor’s degree required; Master's degree (in data science, computer science or MIS, mathematics, engineering, or related field) preferred. - 5+ years of prior experience in Data Management / ETL / ELT / Data Warehousing - Experience in writing Data Quality routines for cleansing of data and capturing confidence score - Experience with master data management - Strong knowledge of Structured Query Language (SQL) and Transact-SQL (T-SQL) - Experience using scripting languages such as JavaScript or Python - Experience Healthcare data models, datasets, and source systems (e.g. EHR, claims, labs, etc.) - Experience with healthcare reference data (ICD, CPT etc.) - Experience with agile delivery methodologies - Data Modeling experience preferred. - Strong organizational, administrative, and analytical skills required. - Experience managing and working in cloud environments such as Amazon Web Services or Azure - Knowledge of HIPAA; ability to implement systems and processes in accordance with regulations - Excellent interpersonal communication skills, both written and verbal ArchWell Health is an equal opportunity employer. Qualified applicants will receive consideration for employment without regard to their race, color, religion, age, sex, sexual orientation, gender identity, national origin, disability, veteran status, or any other protected classification.

• Leverage your expertise to design and maintain data transformation pipelines • Manage databases and cloud infrastructure • Ensure data is accessible and efficiently processed • Focus on performance, scalability, and security for data systems • Collaborate closely with the product team to document business needs and transform them into clear, actionable technical requirements • Build and maintain scalable ELT pipelines for reliable data ingestion, transformation, and delivery • Design, optimize, and manage data models in Snowflake for performance, scalability, and clarity • Create and maintain DAGs to define pipeline tasks, dependencies, and schedules for automated workflows • Collaborate with DevOps to configure and manage AWS infrastructure supporting data storage, pipelines, and transformations • Monitor pipelines to resolve failures and improve stability and data quality • Document pipelines, DAGs, and models to support onboarding and knowledge sharing

• Own and operate our data warehouse, pipelines, and transformation layer • Design, build, and maintain scalable, reliable data pipelines that ingest data from across our platform and third-party sources, ensuring data is always available and trustworthy for downstream consumers • Partner with data scientists and analysts to deliver clean, well-documented datasets and optimize query performance so teams spend less time wrangling data and more time generating insights • Incrementally improve and modernize our existing data systems - you won't build everything from scratch, but you'll know how to assess what we have, prioritize what matters, and migrate thoughtfully • Implement data quality monitoring, alerting, and documentation practices that build trust across the organization

Job Description: Position Summary The Data Science intern will assist with AI adoption into our business practice. Collaborating with Formex Global Product Management and Marketing, this role will create a Virtual Assistant (Chatbot) for the ITW Formex website to automate website inquiry responses with accurate, consistent responses and increase website visitor dwell time. This job will interact with ITW teams in US Central, Shanghai China, and Taiwan time zones and will be a remote position. Key Responsibilities: - Develop an intelligent chatbot capable of responding to website inquiries using accurate, consistent, authorized information - Expand the chatbot’s capability by incorporating client’s evolving requirements - Launch the chatbot on http://itwformex.com in English and ideally on https://www.itwformex.com/zh-CN in Simplified Chinese Education and Skills: - Must be pursuing a Bachelor’s Degree in a quantitative discipline (Computer Science, Data Science, Data Engineering, Artificial Intelligence, Applied Mathematics, Statistics, or related) from an accredited university - Proficient experience in data science focused on data for client studies, modeling, data wrangling, and/or ML/AI - Fluency in Python, R, Java and other computing languages - Able to work directly with clients in complex analysis and presenting deliverables to non-technical personnel - Able to travel as necessary to meet project and client requirements - Must be able to work autonomously and be self-directed - Able to work within a collaborative team environment and coordinate activities between program components - Excellent communication skills, both written and verbal - Strong analytical skills, critical thinking, and attention to detail - Bilingual in Mandarin preferred Compensation Information: $25/hour ITW is an equal opportunity employer. We value our colleagues’ unique perspectives, experiences and ideas and create workplaces where everyone can develop their careers and perform to their full potential. As an equal employment opportunity employer, ITW is committed to equal employment opportunity and fair treatment for employees, beginning with the hiring process and continuing through all aspects of the employment relationship. All qualified applicants will receive consideration for employment without regard to race, color, sex, gender identity, sexual orientation, religion, national origin, age, disability, protected Veteran status or any other characteristic protected by applicable federal, state, or local laws.