• Maintain, extend, and refactor dbt models, tests, and transformations. • Define and enforce data modeling standards and best practices. • Build new tables, views, metrics, and domain-specific reports. • Ensure data quality, consistency, and availability across Snowflake. • Enable and optimize data consumption for the client’s LLM analytics layer. • Evaluate and support the implementation of a modern BI/metrics tool. • Troubleshoot ETL/ELT issues and update pipelines as source systems evolve. • Support scalable and reliable data foundations for both technical and business stakeholders.

• Design, build, and maintain data pipelines for batch and streaming data processing. • Develop and optimize ETL workflows using Python and SQL. • Build and maintain Airflow DAGs for orchestration of data workflows. • Implement data transformations and data quality checks. • Optimize BigQuery queries and data models for performance and cost efficiency. • Troubleshoot and improve reliability of existing pipelines. • Collaborate with analysts and engineering teams to support data needs.

Description Hart is a healthcare technology company focused on clinical data integration and archiving. We build the infrastructure that connects disparate health systems, providing a unified source of information for providers and patients. Job Summary We are looking for a Data Engineer to build and maintain our data infrastructure. You will be responsible for developing robust ETL/ELT pipelines and managing data workflows within the Databricks ecosystem. We need a builder who values simplicity and pragmatism—someone who can navigate the necessary rigor of a regulated industry without over-engineering technical solutions. While we are open to exceptional remote talent, we have a strong preference for candidates who can work on-site with us in Bozeman, MT. Key Responsibilities - Data Pipeline Development: Design and implement scalable ETL/ELT pipelines to ingest and transform complex healthcare data. - Databricks Development: Build and optimize data models and processing workflows within the Databricks ecosystem. - Pragmatic Engineering: Focus on clean, maintainable code and simple solutions that solve the problem effectively without unnecessary complexity. - Performance Optimization: Write and refine high-signal Python and SQL code to improve system reliability and efficiency. - AI/ML Support: Develop the data foundation for machine learning workflows and assist in moving models into production. - Security & Compliance: Ensure all data flows meet HIPAA and security standards through intentional documentation and validation. Culture We handle high-stakes data where precision is mandatory, but we solve those problems with an engineering-first mindset. This isn’t a "corporate suit" environment—we are a meritocracy where the best idea wins, regardless of title. We value high-signal, direct communication and prioritize technical execution over unnecessary fluff. Our goal is to maintain a disciplined, professional standard for our systems while keeping our team structure lean and focused. If you prefer building foundational technology in a simple, pragmatic, and fluff-free environment, you will fit in here. Requirements - Professional Experience: Proven track record in data engineering or a software engineering role with a heavy focus on data. - Databricks: Hands-on experience with the Databricks platform. - Languages: High proficiency in Python and SQL. - ETL/ELT: Experience building and maintaining production-grade data pipelines. - Cloud Infrastructure: Experience working within AWS environments. Preferred Qualifications - AI/ML: Experience with MLflow, model training, or integrating AI into data pipelines. - Healthcare Data: Familiarity with healthcare standards like HL7 and FHIR. - Software Fundamentals: Strong understanding of version control (Git) and CI/CD practices.

Benefits: - 401(k) - 401(k) matching - Bonus based on performance - Competitive salary - Dental insurance - Donation matching - Health insurance - Opportunity for advancement - Paid time off - Profit sharing - Training & development - Tuition assistance - Vision insurance - Wellness resources Location: Fully Remote (United States) — no onsite work required Employment Type: Contract (Full-Time), multi-year engagement with potential for extension About AKIVA AKIVA is an AI-native engineering firm specializing in enterprise services, domain-specific solutions, and high-performance infrastructure from strategy through deployment. We build innovative systems that drive measurable results for commercial enterprises and government agencies. AKIVA is a certified Service-Disabled Veteran-Owned Small Business (SDVOSB). Position Overview AKIVA is seeking ETL Developers to design, develop, and maintain extract-transform-load (ETL) processes in support of a multi-year public-sector application modernization program. In this role you will build ETL strategies that move structured and unstructured data from legacy source systems into modern target platforms — developing robust data mappings, automated workflows, validation routines, and audit logging. You will collaborate closely with client stakeholders, data architects, and application development teams in a Scrum-based delivery environment. AKIVA-provided AI-assisted pipeline generation, data-profiling, and anomaly-detection tools may be used to accelerate development and improve data quality. Key Responsibilities • Design, develop, test, and maintain ETL processes that move data from source systems to target data stores, data warehouses, and modern applications • Develop and evolve ETL strategies that support the full data lifecycle — ingestion, transformation, validation, loading, and audit • Collect, clean, and integrate structured and unstructured data from diverse source systems, including legacy relational databases, flat files, APIs, and third-party feeds • Build and maintain data models, data mappings, and transformation rules in coordination with data architects and business analysts • Implement automated workflows with performance tuning, error handling, and audit logging • Implement and monitor data-quality controls — profiling, deduplication, standardization, and reconciliation • Develop and maintain API-based integrations between source and target systems • Troubleshoot production ETL jobs, diagnose failures, and implement remediation • Collaborate with client stakeholders to understand source-system semantics, data ownership, and business rules • Support knowledge transfer to client technical staff through documentation, walkthroughs, and pair-work • Participate in Scrum ceremonies (sprint planning, daily stand-ups, reviews, and retrospectives) Required Qualifications • Bachelor's degree in Computer Science, Information Systems, or related field — or equivalent experience • 2+ years of hands-on experience with advanced SQL, including complex joins, window functions, CTEs, stored procedures, and performance tuning • 4+ years of experience in data migration and integration with automated workflows, performance tuning, data cleansing, API integration, and audit logging • Demonstrated experience designing end-to-end ETL pipelines across heterogeneous source and target systems • Strong problem-solving, troubleshooting, and documentation skills • Excellent written and verbal communication skills and ability to work directly with non-technical stakeholders • Ability to work effectively in a fully remote environment • Must be authorized to work in the United States Preferred Qualifications • Experience leading or contributing to full-scale data migrations from legacy systems to cloud, ERP, or CRM platforms • Hands-on experience with one or more ETL/data-integration platforms — Informatica PowerCenter or IICS, Talend, AWS Glue, Azure Data Factory, or SQL Server Integration Services (SSIS) • Proficiency in at least one scripting or programming language — Python, PowerShell, or Java • Experience working on Agile / Scrum delivery teams • Experience supporting public-sector data modernization initiatives • Familiarity with AI-assisted pipeline generation, schema-mapping, and anomaly-detection tools Tools, Technologies & Frameworks ETL / Integration: Informatica PowerCenter, Informatica IICS, Talend, AWS Glue, Azure Data Factory, SSIS | Databases: SQL Server, Oracle, PostgreSQL, MySQL, Snowflake, Redshift | Scripting: Python, PowerShell, Java | APIs: REST, SOAP, JSON, XML | DevOps: Git, CI/CD pipelines, Jira, Confluence | Delivery: Agile / Scrum | AI Assist: pipeline generation, schema mapping, anomaly detection What AKIVA Offers • Professional development and skill-building opportunities • Supportive management team with veteran-owned company values • Opportunity to contribute to impactful public-sector data modernization initiatives • Fully remote engagement with no required onsite travel • AI productivity tools and training provided at no cost to employees Comprehensive Benefits Package • 401(k) with generous company match • Medical Insurance • Dental Insurance • Vision Insurance • Short-Term & Long-Term Disability Insurance • Paid Time Off (PTO) • Profit Sharing Join Our AI Innovation Network Interested in staying connected with AKIVA's AI initiatives, research, and opportunities? Join our AI Innovation Network here: https://www.akiva.com/ai-network Equal Employment Opportunity Statement AKIVA is committed to providing an environment of mutual respect where equal employment opportunities are available to all applicants and teammates without regard to race, color, religion, sex, national origin, age, physical disability, marital status, military and veteran status, or any other characteristic protected by applicable law. We believe that diversity among our teammates is critical to our success as a company, and we seek to recruit, develop, and retain the most talented people within a qualified candidate pool. AKIVA is a certified Service-Disabled Veteran-Owned Small Business (SDVOSB). This is a remote position.