Remote New

Senior ETL Developer

Federal Advisory Partners
United States
Mar 07, 2026
Who we are: Tria Federal delivers digital services and technology solutions that support the health and safety of veterans, service members and civilians. For two decades, federal agencies have relied on Tria companies to advance their critical missions and modernize their systems, so that they can uphold their commitment to the American people. Today, we are pushing the boundaries of possibility through partnerships and investments in artificial intelligence and emerging technologies, developing solutions for the biggest challenges that government will face tomorrow. We are proud to employ and support military veterans who bring mission-first mindset, technical expertise, and leadership qualities that strengthen our work. Veterans, transitioning service members, and military spouses are strongly encouraged to apply. Job Description: Softrams is seeking a strong Senior ETL Developer to join our collaborative and agile team delivering modern, mission-critical data solutions for U.S. federal government health IT programs. This role is central to designing, developing, and maintaining the data pipelines that power our analytics and reporting capabilities - extracting data from diverse sources, transforming it into consistent, reliable formats, and loading it into data warehouses and target systems. Operating within a SAFe Agile framework, the ETL Developer will work alongside data engineers, application developers, and business stakeholders to solve complex data challenges across large-scale Medicaid and Medicare programs. This role is ideal for a data professional who thrives in ambiguity, takes initiative in investigating and dissecting complex datasets, and is ready to own end-to-end pipeline development while contributing to broader data architecture decisions across a cloud-native AWS ecosystem. Basic Requirements: 8+ years ETL / Data Pipeline Development (End-to-End) 5 years of experience with Python & PySpark Experience with AWS Glue & Data Lake Architecture (S3, EMR, LakeFormation) 5+ years of strong PL/pgSQL or PL/SQL experience 6+ years of experience with complex SQL - Data Extraction & Manipulation 3+ years of experience with workflow Orchestration (Airflow, Prefect, NiFi or equivalent) 3+ yeasrs of experience Cloud Data Warehousing (Snowflake, Redshift, or equivalent) 3+ yeasrs of experience working in Agile/Scrum large-scale programs Excellent written, verbal, and interpersonal communication skills Strong time management skills with the ability to quickly triage and escalate issues Strong attention to detail and a focus on task completion Responsibilities: Analyze and understand complex business and engineering challenges to design effective data pipeline solutions Design, develop, and maintain end-to-end ETL/ELT data pipelines using Python, PySpark, and AWS Glue Build and manage data validation pipelines using Great Expectations or equivalent frameworks Implement and maintain workflow orchestration using Apache Airflow, Prefect, Apache NiFi, or equivalent tools Architect and operate Data Lake solutions in AWS, including S3, Glue, EMR, and Lake Formation Write complex SQL queries for data extraction, transformation, and manipulation across multiple database systems Collaborate with cross-functional teams including data engineers, application developers, and business stakeholders Ensure data quality, reliability, and integrity across all pipeline stages Contribute to data architecture decisions and promote best practices across the team Why Tria? What defines the Tria brand is more than just our dedication to excellence in our craft; it's our incredible team of dedicated, talented, and passionate people that make Tria so exceptional. As people powering possible, we are all partners in our team's shared success. As a company that cares about people, we seek to cultivate a culture in which all can thrive personallyandprofessionally. We offer a top-tier benefits package to invest in your physical, mental, and financial health and wellness so that you can be your best self - at workand in life. At Tria, we are growth-minded, entrepreneurial in spirit, and committed to fostering a culture of inclusion and opportunity for all. Whatever your background, your role, your department, or stage in your professional journey, here you will have opportunities to learn new skills, seize new challenges, and advance your career as we grow. California Consumer Privacy Act (CCPA) We are committed to protecting your privacy. As part of our compliance with the California Consumer Privacy Act (CCPA), we want to inform you about how we collect, use, and protect your personal information during the job application process. For more details, please review https://www.oag.ca.gov/privacy/ccpa.