Solutions Architect

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.

• 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.

• 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.

• 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.

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

• 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.

• Actual starting pay will vary based on education, skills, and experience.
• We offer a comprehensive benefits package - to learn more .
  • 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.

• 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).

• Office

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…