Solutions Architect - Revo Health

Requires strong full stack engineering skills and a deep emphasis on data engineering and data architecture. This role requires someone who can design scalable, integrated platforms across applications, data systems, and cloud environments. You will work closely with business, clinical, and technical teams to map problems, architect end to end solutions, and guide them through implementation. Healthcare experience is helpful but not required.

Full-time role, Monday - Friday 8:00 AM - 5:00 PM out of our Bloomington location.

Revo Health is a professional services company that partners with multiple healthcare groups to deliver exceptional patient care. This position will be employed through Revo Health, working closely with Infinite Health Collaborative (i-Health) and its operating divisions.

Essential Job Functions:

Data Architecture & Engineering

• Design and optimize data models (OLTP, OLAP, star schema, wide tables, normalized and denormalized structures).
• Architect and manage SQL Server instances, including schema design, indexing strategy, query optimization, stored procedures, SSIS/ETL/ELT frameworks.
• Develop scalable data ingestion pipelines using batch, micro‑batch, and streaming patterns.
• Implement data governance, lineage tracking, quality rules, metadata management, role‑based access, and retention.
• Integrate data across EHRs, practice management systems, operational databases, and cloud services.

Application & Integration Architecture

• Architect full‑stack solution designs involving APIs, message queues, microservices, and cloud-native components.
• Oversee the development of custom applications, dashboards, analytic tooling, and automated workflows.

Collaboration & Problem Solving

• Translate ambiguous business needs into technical architectures and solution roadmaps.
• Facilitate process mapping, gap analysis, and workflow design.
• Provide technical leadership to engineers, analysts, and external vendors.
• Communicate technical concepts clearly to clinicians, administrators, and non‑technical staff.
• Work independently with minimal supervision.
• Other duties as assigned.

Education and Experience:

• Advanced SQL development and performance tuning (SQL Server required; PostgreSQL, Python optional)
• Data modeling (star schema, medallion architecture).
• ETL/ELT design patterns and integration best practices.
• API architecture and integration best practices.

Preferred

• Experience in healthcare data workflows (EHR/PM, HL7/FHIR, claims, quality metrics).
• Experience creating semantic models for Tableau or Power BI.
• Experience in system modernization or data platform transformation.

Benefits & Compensation:

• Actual starting pay will vary based on education, skills, and experience.
• We offer a comprehensive benefits package - to learn more click here.
• Employees working 30+ hours per week (60 hours per pay period) are eligible for our Medical (w/Maternity Bundle), Dental & Vision plans, as well as Tuition Reimbursement.
• All employees, regardless of hours, are eligible for 401(k) Profit Sharing, Employee Assistance Program, Lifetime Fitness Subsidy, Car Rental discounts, Home, Auto, & Pet insurance savings programs & more.

Working Conditions:

• Ability to sit for extended periods (up to 8 or more hours per day).
• Frequent use of hands and fingers for typing, writing, and handling documents.
• Occasional standing, walking, bending, or reaching within the office environment.
• Ability to lift and carry office supplies or files weighing up to 20 pounds.
• Visual acuity to read electronic and paper documents.
• Auditory ability to participate in phone or video calls clearly.
• Manual dexterity to operate standard office equipment (e.g., computer, phone, printer).

Setting:

• Office

Essential Requirements:

Ability to:

• Comply with company policies, procedures, practices, and business ethics guidelines.
• Comply with all applicable laws and regulations, (e.g. HIPAA, Stark, OSHA, employment laws, etc.)
• Demonstrate prompt and reliable attendance.
• Work at an efficient and productive pace, handle interruptions appropriately, and meet deadlines. Prioritize workload effectively.
• Communicate respectfully and professionally in face-to-face, phone and email interactions. Apply principles of logical thinking to define problems, establish facts, and draw valid conclusions.

Notes

• Revo/ i-Health is an Equal Opportunity Employer. We are committed to fostering an inclusive and accessible workplace. Reasonable accommodation may be provided to enable individuals with disabilities to perform essential job functions. Applicants or employees who wish to request an accommodation may do so by emailing HR@RevoHealth.com. For more information, please review the Know Your Rights notice from the U.S. Equal Employment Opportunity Commission.
• We participate in the federal E-Verify program to confirm the identity and employment authorization of all newly hired employees. For further information about the E-Verify program, please click here: https://www.e-verify.gov/employees/employee-rights-and-responsibilities
• Please note: This job description is intended to describe the general nature and level of work being performed by individuals assigned to this position. It is not an exhaustive list of all duties, responsibilities, and qualifications required. Revo/ i-Health reserves the right to modify job duties or descriptions at any time, with or without notice, in accordance with applicable laws.