ArchWell Health aims to transform healthcare for seniors and focuses on quality care, empathy, and community outreach. The company fosters a collaborative culture that prioritizes
IT - Data Engineer
Location
United States
Posted
61 days ago
Salary
0
Seniority
Mid Level
Job Description
IT - Data Engineer
ArchWell Health
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.
Related Guides
Related Categories
Related Job Pages
More Data Engineer Jobs
Overview We are seeking to fill the role of MERS and Data Integrity Support Specialist. The ideal candidate enjoys collaborating with clients, industry partners and internal teams to maximize outcomes for homeowners. Responsibilities • Oversee and assist with the daily processes and operations of all MERS-related functions and responsibilities for organization’s current and future loan portfolio, to include the full reconciliation of the organization’s loan portfolio as it compares to all registered and deactivated Mortgage Identification Numbers (“MIN”) in the MERS OnLine database.• Responsible for leading, monitoring and reviewing daily processes and operations of MERS and Data Integrity areas, to include the full reconciliation of all data elements within the organization’s servicing platform to ensure data quality and correctness.• Assists supervisor with managing department staff to ensure instructions are being followed, standards are being met and operational issues are being addressed in a timely fashion.• Report to senior management regularly using various data models and statistical analysis methodologies, to include the creation of reports and metrics with an emphasis on quality control and root cause reconciliation solutions.• Ensure that the teams meet/exceed established metrics/SLA standards provided to clients.• Assist when necessary with all client interaction to ensure proper notification, tracking and resolution of MERS and data integrity exceptions are reported timely, and action plans are developed to correct any ongoing trending that may impact the quality of MERS or servicing platform data elements.• Assist in the creation of or updating of all departmental policies and procedures and ensure revisions are made timely and in accordance with MERS standards and processes.• Communicate clearly and timely to all applicable departments on matters related to MERS data reconciliations, exceptions and errors and ensure all items are resolved in a timely fashion.• Research process gaps (intra/inter departmental) and close gaps timely, ensuring that proper methods for tracking gaps or trending can be presented to senior management for review and approval.• Train, coach and develop staff to ensure department efficiencies are maintained and consistently improved upon• All other duties as assigned. Qualifications Required Skills and Qualifications• High School Diploma or equivalent required.• Excellent analytical, organization and communication (verbal/written) skills required. • Ability to work collaboratively with peers, departments, and clients in a fast-paced, team-centric environment to attain common goals. Desired Skills and Qualifications• 2 to 3 years of experience in mortgage servicing, financial or banking field preferred.• Proficient use of Microsoft Excel, Access, and Word is preferred. Total Rewards LoanCare’s Total Rewards Package offers a comprehensive blend of health and welfare, financial, lifestyle and learning benefits to support employee well-being and engagement. Highlights include: - Health & Welfare Coverage: Optional medical, dental, vision, life, and disability insurance - Time Off: Paid holidays, vacation, and sick leave - Retirement & Investment: Fidelity National Financial matching 401(k) and employee stock purchase plans - Wellness Programs: Access to mental health resources, including free Calm memberships, and initiatives that promote physical and emotional well-being - Employee Recognition: Programs that celebrate achievements and milestones - Lifestyle & Learning Perks: Enjoy discounts on gym memberships, pet insurance, and employee purchasing programs, plus access to a tuition reimbursement program that supports your continued education and professional growth. Compensation Range: $19.33-$28.89 hourly. Actual compensation may vary within the range provided, depending on a number of factors, including qualifications, skills and experience. Build Your Future with LoanCare® At LoanCare, we don’t just service mortgage loans—we serve people. As a leading full-service mortgage loan subservicer, we deliver excellence to banks, credit unions, independent mortgage companies, investors, and the homeowners they support. Backed by the strength and stability of Fidelity National Financial (NYSE: FNF), a Fortune 500 company, we offer a career foundation built on integrity, innovation, and collaboration. Here, you’ll find: - A culture that helps you thrive, with resources and support to fuel your growth - Flexibility to work remotely, while staying connected through virtual engagement - Opportunities to make a real impact in an industry that touches millions of lives - If you're ready to grow your career in a place that values your contributions and empowers your success, we invite you to join our team. About Remote Employment We provide the necessary equipment; all you need is a quiet, private place in your home and a high-speed internet connection with a minimum network download speed of 25 megabits per second (MBPS) and a minimum network upload speed of 10 MBPS WHO WE AREAbout us …LoanCare is a leading national provider of full service subservicing and interim subservicing to the mortgage industry and has offered its expertise and best practices in providing servicing solutions for others since 1991. At the present time, LoanCare subservices over 1.8 million loans in 50 states. LoanCare has a seasoned loan servicing team with senior managers averaging nearly 30 years of experience in the mortgage and financial services industry.LoanCare, its affiliates and subsidiaries, is an Equal Opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, disability, protected veteran status, national origin, sexual orientation, gender identity or expression (including transgender status), genetic information or any other characteristic protected by applicable law. WORK CONDITIONSWorking conditions are normal for an office environment. Ability to attend work and be productive during normal business hours and to work early, late or weekend hours as needed for successful job performance. Over time required as necessary. Essential functions are the basic job duties that an employee must be able to perform, with or without reasonable accommodation. EQUAL EMPLOYMENT OPPORTUNITY LoanCare, its affiliates and subsidiaries, is an Equal Opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, disability, protected veteran status, national origin, sexual orientation, gender identity or expression (including transgender status), genetic information or any other characteristic protected by applicable law.
• Gather and refine data requirements with business stakeholders and technical teams • Design end-to-end data architectures (ingestion, processing, storage and consumption) • Evaluate technical alternatives considering cost, risk, complexity and time-to-market • Build and evolve the Data Map (domains, sources, pipelines and consumers) • Define data modeling standards and taxonomy • Participate in data classification and governance (including LGPD — Brazilian Data Protection Law) • Produce architecture artifacts (HLD, LLD, ADRs and diagrams) • Lead Architecture Review sessions • Work closely and collaboratively with Engineering, Platform, Security, Analytics and Product teams • Support the evolution of data architecture standards and governance
• Design, build, and maintain robust data pipelines to ensure reliable data flow across the enterprise. • Maintain data pipeline schedules, orchestrate workflows, and monitor the overall health of data pipelines to ensure continuous data availability. • Create, update, and optimize data connections, datasets, and transformations to align with business needs. • Troubleshoot and resolve data sync issues, ensuring consistent and correct data flow from source systems. • Collaborate with cross-functional teams to uphold data quality standards and ensure accurate data is available for use. • Utilize Palantir Foundry to establish data connections to source applications, extract and load data, and design complex logical data models that meet functional and technical specifications. • Develop and manage data cleansing, consolidation, and integration mechanisms to support big data analytics at scale. • Build visualizations using Palantir Foundry tools and assist business users with testing, troubleshooting, and documentation creation, including data maintenance guides.
Role Overview We are seeking a Data Engineer I to support the development and maintenance of our modern data platform. This is an entry-level role ideal for someone looking to grow their career in data engineering. You will work closely with senior data engineers, analytics teams, and business stakeholders to help deliver reliable and high-quality data. This role focuses on learning best practices in data engineering while contributing to building scalable data pipelines and supporting analytics use cases. What You’ll Do - Assist in building and maintaining batch data pipelines - Support data ingestion from internal and external sources - Write and optimize SQL queries for data transformation and validation - Help develop and maintain workflows using orchestration tools like Apache Airflow - Support data modeling and transformation efforts using DBT - Monitor data pipelines and assist in troubleshooting issues - Contribute to data quality checks and validation processes - Work with structured and semi-structured datasets - Collaborate with analytics and business teams to support reporting needs - Document data processes, pipelines, and best practices - Learn and apply modern data platform tools and technologies Required Qualifications - Bachelor’s degree in Computer Science, Engineering, or related field (or equivalent experience) - Basic knowledge of SQL and Python - Understanding of data structures and databases - Familiarity with ETL/ELT concepts and data pipelines - Strong problem-solving and analytical skills - Willingness to learn new tools and technologies - Good communication and collaboration skills Nice to Have - Exposure to tools like Apache Airflow, DBT, or Databricks - Basic understanding of cloud platforms (AWS preferred) - Familiarity with data warehousing or Lakehouse concepts - Internship or project experience in data engineering or analytics - Understanding of data quality and testing concepts Where This is a fully remote, US based position with minimal to no travel required. The EverCommerce team is distributed globally, with teams in the U.S., Canada, the U.K., Jordan, New Zealand, and Australia. With a widely distributed team, we are used to working remotely across different time zones. This role can be based anywhere in the United States or Canada – if you’re close to one of our offices, we can set you up in-office or you can work 100% remotely. Please note that you must be eligible to work without sponsorship to qualify for this position, and this role may require travel to our Corporate Headquarters in Denver, Colorado, or to other office locations around North America. Benefits & Perks - Flexibility to work where/how you want within your country of employment – in-office, remote, or hybrid - Continued investment in your professional development - Day 1 access to a robust health and wellness benefits package, including an annual wellness stipend. - 401k with up to a 4% match and immediate vesting - Flexible and generous (FTO) time-off - Employee Stock Purchase Program Compensation: The target base compensation for this position is $85,000 to $95,000 USD with an annual bonus plan in most US locations. Final offer amounts are determined by multiple factors including location, local market variances, and candidate experience and expertise, and may vary from the amounts listed above. EverCommerce is an equal opportunity employer and we value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, gender identity, sexual orientation, age, marital status, veteran status, or disability status. We look forward to reviewing your credentials and getting to know more about your experience!



