Data Analyst

Aarista Technologies; Houston (TX); Hybride; USD 65 000 - 95 000; Plein temps

Résumé du poste

Aarista Technologies is seeking a Data Analyst to transform clinical, billing and operational data into actionable dashboards and insights in a hybrid Houston/Burnaby setting. You will build dashboards, answer ad hoc questions and ensure data is accurate and secure within HIPAA and SOC 2 controls.

You will define metrics, automate reporting, and communicate findings to both technical and non-technical stakeholders while maintaining data quality and governance across reporting sources.

Qualifications

• 1+ year of experience in data analytics or BI.
• Strong SQL including joins, window functions, and performance tuning.
• Hands-on experience with Power BI, Tableau or Looker.
• Proficiency in Excel with PivotTables, lookups, and modeling.
• Experience handling sensitive data per access-control procedures.
• Clear written and verbal communication to non-technical audiences.
• Bachelor's degree in data analytics, statistics, computer science, health informatics or related field, or equivalent experience.

Responsabilités

• Build and maintain dashboards and recurring reports for leadership, operations, clinical and revenue cycle teams.
• Define metrics and KPIs with stakeholders and document how each one is calculated.
• Automate manual reporting so recurring numbers refresh without hand work.
• Answer ad hoc business questions with clear, well-supported findings.
• Analyze billing, coding and claims data to spot revenue leakage, denial trends and compliance risk.
• Analyze product usage and operational data to inform roadmap and process decisions.
• Present results in plain language, with charts and recommendations, to technical and non-technical audiences.
• Write and maintain SQL queries, views and data models that feed reporting.
• Validate data accuracy, investigate discrepancies and work with Engineering to fix root causes.
• Maintain a data dictionary and document data sources, lineage and report logic in SharePoint.
• Handle PHI under HIPAA minimum-necessary standard; use de-identified or limited datasets wherever possible.
• Follow SOC 2 access-control and change-management procedures for data and reports.
• Support audits and compliance reporting with accurate, reproducible data pulls.
• Take requests through a defined intake process and set clear priorities and timelines.
• Train users on self-service reports and dashboards.

Connaissances

SQL

Data visualization

Excel

Communication

Regulatory compliance

Formation

Bachelor's degree or equivalent

Outils

Power BI

Tableau

Looker

Description du poste

Location: Houston TX or Burnaby BC - hybrid (4 days in 1 day from home)

The Data Analyst turns Aarista's clinical, billing and operational data into reporting and insight the business can act on. You will build dashboards, answer ad hoc questions, and keep the data behind them accurate and secure. Because our data includes protected health information (PHI), every part of the role runs inside our HIPAA and SOC 2 controls.

Key responsibilities

Reporting and dashboards

• - Build and maintain dashboards and recurring reports for leadership, operations, clinical and revenue cycle teams.
• - Define metrics and KPIs with stakeholders and document how each one is calculated.
• - Automate manual reporting so recurring numbers refresh without hand work.

Analysis

• - Answer ad hoc business questions with clear, well-supported findings.
• - Analyze billing, coding and claims data to spot revenue leakage, denial trends and compliance risk.
• - Analyze product usage and operational data to inform roadmap and process decisions.
• - Present results in plain language, with charts and recommendations, to technical and non-technical audiences.

Data quality and governance

• - Write and maintain SQL queries, views and data models that feed reporting.
• - Validate data accuracy, investigate discrepancies and work with Engineering to fix root causes.
• - Maintain a data dictionary and document data sources, lineage and report logic in SharePoint.

Security and compliance

• - Handle PHI under the HIPAA minimum-necessary standard; use de-identified or limited datasets wherever possible.
• - Follow Aarista's SOC 2 access-control and change-management procedures for data and reports.
• - Support audits and compliance reporting with accurate, reproducible data pulls.
• - Take requests through a defined intake process and set clear priorities and timelines.
• - Train users on self-service reports and dashboards.

Required qualifications

• - 1+ years of experience in a data analyst or business intelligence role.
• - Strong SQL skills, including joins, window functions and query performance tuning.
• - Hands-on experience with a BI tool such as Power BI, Tableau or Looker.
• - Proficiency in Excel, including pivot tables, lookups and modeling.
• - Experience working with sensitive or regulated data and following access-control procedures.
• - Clear written and verbal communication, including explaining findings to non-technical audiences.
• - Bachelor's degree in data analytics, statistics, computer science, health informatics or a related field, or equivalent experience.

Preferred qualifications

• - Experience with healthcare data: EHR/EMR records, claims, CPT/ICD-10 coding or revenue cycle data.
• - Familiarity with skilled nursing or post-acute care settings.
• - Working knowledge of HIPAA, including de-identification and minimum-necessary practices.
• - Python or R for data cleaning, automation and statistical analysis.
• - Experience with FHIR or HL7 data structures.
• - Experience with cloud data warehouses and modern data tools (e.g., DataBricks, Microsoft Fabric).

About Aarista

Aarista Technology builds healthcare software used by clinical teams every day. Our data shapes patient care, revenue and product decisions, and we protect it as carefully as we use it.

Aarista Technology LLC is an equal opportunity employer. We consider all qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, veteran status or any other protected characteristic.