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.
We are seeking a skilled and motivated Business Intelligence Developer with a strong background in healthcare data and SQL development. In this role, you will design, develop, and maintain enterprise BI solutions that transform complex healthcare data into actionable insights for clinical, operational, and financial stakeholders. You will collaborate closely with stakeholder and cross-functional teams to understand business needs and deliver high-quality dashboards, reports, and data pipelines that drive decision-making across the organization.
Responsibilities:
Data Development & SQL Engineering
- Write, optimize, and maintain complex SQL queries, stored procedures, views, and functions against large healthcare datasets
- Design and develop ETL/ELT pipelines to extract, transform, and load data from clinical, claims, and administrative systems (EHR, EMR, ADT, billing)
- Ensure data integrity, accuracy, and consistency across all reporting layers
- Perform data profiling, root cause analysis, and data quality remediation
Business Intelligence & Reporting
- Build and maintain interactive dashboards and reports using BI tools such as Tableau, Power BI, or similar platforms
- Translate business requirements from clinical and operational teams into scalable, self-service BI solutions
- Develop KPI frameworks and performance metrics aligned with healthcare quality, utilization, and financial goals
- Support ad hoc analysis requests and present findings clearly to non-technical stakeholders
Healthcare Data & Compliance
- Work with standard healthcare data models and terminologies including ICD-10, CPT, SNOMED, LOINC, and HL7/FHIR
- Ensure all BI solutions comply with HIPAA and organizational data governance policies
- Partner with clinical informatics and IT teams on data architecture and master data management initiatives
Collaboration & Documentation
- Gather and document business and technical requirements from stakeholders across clinical, finance, and operations
- Maintain thorough documentation of data definitions, data dictionaries, report logic, and development standards
- Participate in Agile/Scrum ceremonies and contribute to sprint planning and backlog grooming
- Mentor junior analysts and provide guidance on SQL best practices and BI development standards
Skills & Qualifications:
Candidates must demonstrate proficiency in the following areas:
- Advanced SQL (T-SQL, PL/SQL, or PostgreSQL)
- Healthcare data systems (EHR, EMR, Claims
- BI tools: Apache Superset, Tableau, Power BI, or equivalent
- ETL/ELT development and data pipelines
- Data warehousing concepts (star/snowflake schemas)
- ICD-10, CPT, SNOMED, LOINC coding standards
- Stored procedures, views & query optimization
- HL7/FHIR data standards
- HIPAA compliance and data privacy regulations
- Data quality and validation methodologies
- Excel and pivot table analysis
- Strong analytical and problem-solving skills
- Stakeholder communication and requirements gathering
- Agile/Scrum development methodology
- X12 HIPAA transactions (837, 835, 270/271, 999, 277CA) and file structure (ISA/GS/ST, loops)
- Claims lifecycle expertise (submission → adjudication → remittance) and lineage tracking
- Duplicate & resubmission handling (frequency codes, idempotency, cross-source detection)
- Companion guide interpretation and payer-specific rule implementation
- EDI validation & reconciliation (999 vs 277CA, error handling, root cause analysis)
- EDI pipeline operations (batch/real-time processing, monitoring, data integrity controls)
Preferred Qualifications:
- Bachelor's degree in computer science, Health Informatics, Data Science, Mathematics, or a related field
- 3+ years of experience in a BI developer, data analyst, or similar role within a healthcare setting
- Experience with cloud platforms such as AWS
- Familiarity with Javascript, Python or R for data analysis and automation
- Knowledge of Epic, Cerner, or other major EHR platforms and their reporting modules (e.g., Epic Clarity/Caboodle)
- Experience with SSRS, SSAS, or Microsoft SQL Server Integration Services (SSIS)
- Healthcare analytics certifications (e.g., CHDA, RHIA) or BI tool certifications (e.g., Tableau Desktop Specialist)
- TRICARE Experience
- Apache SuperSet experience
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 personally and professionally. 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 work and 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.
Similar Jobs
What you need to know about the Seattle Tech Scene
Key Facts About Seattle Tech
- Number of Tech Workers: 287,000; 13% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Amazon, Microsoft, Meta, Google
- Key Industries: Artificial intelligence, cloud computing, software, biotechnology, game development
- Funding Landscape: $3.1 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Madrona, Fuse, Tola, Maveron
- Research Centers and Universities: University of Washington, Seattle University, Seattle Pacific University, Allen Institute for Brain Science, Bill & Melinda Gates Foundation, Seattle Children’s Research Institute
