Role Description Aretum is seeking a skilled and highly motivated Data Engineer. As a Data Engineer, you will build and manage all data ingestion, transformation, reconciliation, and analytics pipelines. Due to the nature of our work as a federal consulting organization, employees may be expected to handle Controlled Unclassified Information (CUI) and must adhere to applicable safeguarding and compliance requirements. Responsibilities - Ingest data from FHIR APIs, CDW, and other VA sources - Normalize and reconcile medication and patient data - Build transformation pipelines for risk scoring inputs - Support batch and near-real-time processing - Ensure data quality, consistency, and traceability - Programming: Python (primary), SQL (advanced), optional Scala - Data Processing Frameworks: Apache Spark, AWS EMR, Databricks (preferred) - ETL/ELT Design: Pipeline orchestration, incremental vs full loads, data validation - API Integration: REST APIs, JSON parsing, pagination, authentication (OAuth2) - FHIR Data Handling: Patient, MedicationRequest, Observation, etc. - Data Modeling: Relational and semi-structured schema design - Data Quality & Validation: Deduplication, reconciliation logic, anomaly detection - Streaming vs Batch Processing: Understanding tradeoffs and implementation patterns - Storage Technologies: S3, relational DBs, NoSQL basics - Performance Optimization: Partitioning, parallelization, query tuning - Versioning & Lineage: Data version control, reproducibility of datasets Travel Requirements This is a remote position; however, occasional travel may be required based on project needs, client meetings, team collaboration events, or training sessions. Travel is expected to be less than 10% and will be communicated in advance whenever possible. Requirements - Due to federal contract requirements, only U.S. citizens are eligible for this position. - This position supports a federal government contract and requires the ability to obtain and maintain a Public Trust or Suitability Determination, depending on the agency’s background investigation requirements. Benefits - Health Care Plan (Medical, Dental & Vision) - Retirement Plan (401k) - Life Insurance (Basic, Voluntary & AD&D) - Paid Time Off - Family Leave (Maternity, Paternity) - Short Term & Long-Term Disability - Training & Development Company Description Aretum is a mission-driven organization committed to delivering innovative, technology-enabled solutions to our customers across defense, civilian, and homeland security sectors. Our teams work at the intersection of strategy, technology, and transformation, helping agencies solve their most critical challenges. We believe in investing in our people and creating a culture where collaboration, inclusion, and professional growth are at the forefront.

TREND Health Partners is a tech-enabled payment integrity company. Our mission is to facilitate collaboration between payers and providers for mutual benefit and waste reduction, ultimately improving access to healthcare. We achieve this by aligning the common goals of payers and providers and fostering collaboration through a shared technology platform and seamless workflows. Joining TREND Health Partners means becoming part of a dynamic, growing organization that promotes a collaborative and innovative work environment. Our comprehensive compensation package includes competitive salaries, highly valued health insurance, a 401(k) plan with employer match, paid parental leave, and more. The primary responsibility of the Data Engineer I is supporting the design, development, and maintenance of data pipelines and workflows. This position assists in data integration and transformation processes using tools like Python, T-SQL, SSMS, and Databricks. They collaborate with other Data Engineers to understand technical aspects and architecture design, work with large and complex healthcare data sets, help in translating business requirements into technical specifications, participate in code reviews, and contribute to team knowledge sharing. They also assist in developing and maintaining documentation for data engineering processes and systems. Role and Responsibilities - Support the design, development, and maintenance of data pipelines and workflows - Assist in the data integration and transformation processes using Python, T-SQL, SSMS, and Databricks - Collaborate with other Data Engineers to understand the technical aspects of the stack and the architecture design - Work with large and complex healthcare data sets to identify business needs and provide data-driven solutions - Help in translating business requirements into technical specifications - Participate in code reviews and contribute to team knowledge sharing - Assist in the development and maintenance of documentation for data engineering processes and systems - Create ad-hoc reports requested by internal and external partners - Work as a team to support and troubleshoot errors for 100+ data pipelines - Work closely with the application development team to update data and data structures - Provide analysis, recommendations, and feedback to business process owners, leadership team, and the Information Technology department - Propose automated solutions to repeated development tasks Qualifications - Bachelor’s degree with major coursework in Computer Science or Business Administration/related field required. Equivalent work experience in a similar position may be substituted for educational requirements - Knowledge of Python, T-SQL, schema design and relational databases - Familiarity with data integration, transformation, and data warehousing concepts - Proficiency in compiling data, creating reports, and presenting information - Ability to effectively prioritize tasks while working on multiple concurrent projects - Strong written, verbal, and customer service skills - Attention to detail - Active learning mindset, understanding the implications of new information for both current and future problem-solving and decision-making - Skilled in critical thinking, using logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions, or approaches to problems - The ability to come up with unusual or clever ideas about a given topic or situation, or to develop creative ways to solve a problem Preferred Skills - Some experience working with data in a professional setting - Understanding of data privacy and security regulations - Strong problem-solving skills and attention to detail - Experience with healthcare data - Experience using Agile framework - Experience with software development life cycle tools such as Red-Gate, Bitbucket, or JIRA Mental and physical demands - This position will be exposed mainly to an indoor office environment and will be expected to work in or around computers and printers - The nature of the work is sedentary, and the employee will be sitting most of the time - Essential physical functions of the job include typing and the repetitive motion to utilize computer software and hardware continuously throughout the day - Essential mental functions of this position include concentrating on analytical tasks, reading information, and verbal/written communication to others continuously throughout the day Related duties as assigned - This job description documents the general nature and level of work but is not intended to be a comprehensive list of activities, duties, or responsibilities required for this position. Consequently, employees may be asked to perform other duties as required - Employees may also be asked to complete certain compliance requirements set forth by our Business Partners in the performance of their jobs including but not limited to requests for background and drug screenings and disclosures of personal health information or personally identifiable information - Exemptions as provided under the ADA and TITLE VII of the Civil Rights Act will be observed and followed - Reasonable accommodations may be made to enable individuals with disabilities to perform the functions outlined above $90,000 - $110,000 a year

Company Description REMAX Hawaii (formerly Better Homes and Gardens Real Estate Advantage Realty) provides comprehensive residential real estate services across Oahu and Maui. Celebrating 20 years of doing business in Hawaii, locally owned REMAX Hawaii has 6 offices across Oahu and Maui in Kahala, Kailua, Kakaako, Haleiwa, Kapolei and Wailuku with over 200 employees and licensed agents. They have created a clear strong corporate culture which has been a key to the growth and success of our company. Their agents and support staff are client centric and put the clients’ needs ahead of their own. Their core values of honesty, transparency, collaboration, commitment, charity, innovation and strong work ethic are communicated to the agents and employees from the initial interview and throughout every company interaction Voted Hawaii’s Best Real Estate Firm the past 13 years and a Best of Honolulu Company for 11 years. The company was also recognized as one the Best Places to Work by Hawaii Business magazine for the 6th year in a row. Learn more at http://remaxhawaii.com Job Description In your role as a real estate data entry operator, you will play a crucial role in upkeep and updating our database. In order to maintain correct and current records, you will be responsible for accurately entering a variety of data. The ideal candidate for this role will have strong organizational skills, a sharp eye for detail, and the capacity to work independently in a remote setting. Pay: $26.81 - $29.97 per hour Responsibilities - Update and add transactions, client information, and real estate data to the database. - Examine and amend data to make sure it is accurate and comprehensive. - Collaborate with your teammates to resolve any discrepancies found in the data. - Be mindful of privacy and abide by data security regulations. - Assist in creating reports and presentations using the data acquired. - Performing secretarial duties entails filing, monitoring office supplies, scanning, and printing as needed. Qualifications - A high school certificate or its equivalent; a bachelor's degree is ideal but not necessary. - Solid background in data entry or a related field. - Strong command of the language and procedures used in real estate. - A strong command of computers, including the MS Office suite and data input programs. - Remarkable precision and attention to detail. - The capacity to operate autonomously with little guidance. - Outstanding organizing and time management skills. - Good communication abilities, particularly while working in a remote team. Additional Information REMAX Hawaii is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, national origin, ancestry, sex, sexual orientation, gender identity, national origin, genetics, disability, marital status, age, veteran status, domestic partner status, medical condition or any other characteristic protected by law. All your information will be kept confidential according to EEO guidelines.

Role Description The Data Modeler will work with the Data Engineers, Data Architects, and Application Development teams to translate business needs into practical data models. They are responsible for designing and building highly complex data models and data architecture that improve accessibility, efficiency, governance, and data quality that directly impact business results. - Understand and translate business needs into data models supporting long-term solutions. - Create logical and physical data models using best practices to ensure high data quality and reduced redundancy. - Work with the Application Development team to implement data strategies, build data flows, and develop conceptual data models. - Optimize and update logical and physical data models to support new and existing projects. - Analyze data-related system integration challenges and propose appropriate solutions. - Create and maintain Conceptual, Logical, and Physical Data Models for our reporting layer and Data Marts. - Define and communicate data standards, industry best practices, technologies, and architecture. - Support development teams with application database design and mentoring. - Contribute policies and guidelines for the governance of Data Management standards and best practices. - Create complex SQL statements to profile data, optimize performance, and perform data analysis for database design input. - Create DDL/DML to deploy database structures and perform data loads. Qualifications - 6+ years experience with at least 4 years designing data models for Enterprise Data Warehouses & Data Marts. - Knowledge of relational databases, NoSQL, and data architecture. - Database design experience across data warehousing and analytic data stores. - Bachelor’s degree in computer science, data science, information technology, or data modeling. - Experience with ER modeling, big data, enterprise data, and physical data models. - Experience developing and maintaining Enterprise Canonical Models. - Familiarity with data modeling software such as Microsoft Visio or Erwin Data Modeler. - Excellent presentation, communication, and organizational skills. - Ability to work in a fast-paced environment. - Experience translating Conceptual models into Logical and Physical Data Warehouse models leveraging Canonical standards. - Ability to work independently and collaboratively on large-scale data projects. - Ability to lead sessions with stakeholders to determine data rules and review data models. - Ability to coach and mentor members of the data engineering team. Requirements - Exposure to Business Intelligence tools such as PowerBI and Tableau. - Exposure to messaging solutions such as Kafka. - Software Development experience with Python or JavaScript. - Experience in Enterprise Reference and Master Data Management strategies. - Experience with AWS Cloud. Benefits - Salary range: approximately $100,000 to $125,000, based on experience, skills, and qualifications. - Eligible for annual performance-based bonuses. - Comprehensive benefits package includes individual and family health, vision, and dental coverage. - 401(k) plan with employer-matching. - Paid Time Off (PTO) and holidays.