Role Description Actualmente buscamos un(a) Especialista SQL Server (T-SQL / SSIS) que se integrará directamente a la estructura de nuestro cliente mediante contratación por tiempo indeterminado. La posición tendrá un rol clave en la continuidad operativa de procesos críticos de negocio, participando en el mantenimiento y optimización de bases de datos, Store Procedures y procesos ETL que soportan la operación diaria de la compañía. Objetivo del puesto Garantizar la continuidad operativa de los procesos de negocio desarrollados sobre SQL Server mediante el mantenimiento, soporte y optimización de Store Procedures, procesos ETL e integraciones existentes. Responsabilidades - Desarrollo, mantenimiento y optimización de código en Transact-SQL. - Soporte y corrección de incidencias relacionadas con procesos productivos. - Mantenimiento y monitoreo de procesos ETL desarrollados en SQL Server Integration Services (SSIS). - Administración de usuarios y permisos en SQL Server. - Análisis y resolución de errores en Store Procedures y procesos batch. - Soporte operativo a usuarios internos cuando sea requerido. - Participación en esquema de guardias para atención de incidentes fuera de horario laboral. Qualifications - Mínimo 5 años de experiencia trabajando con Microsoft SQL Server. - Experiencia comprobable desarrollando y manteniendo Store Procedures complejos. - Experiencia en soporte de aplicaciones y procesos productivos. - Experiencia trabajando con SQL Server Integration Services (SSIS). Requirements Conocimientos Técnicos - Transact-SQL avanzado (requisito no negociable). - Desarrollo y mantenimiento de: - Store Procedures. - Funciones. - Triggers. - Consultas complejas. - Procesos batch. - Administración de usuarios y permisos en SQL Server. Deseables - Administración de respaldos SQL Server. - SQL Server Agent. - Administración básica de Integration Services. Benefits - Contratación directa por tiempo indeterminado. - Sueldo aproximado: $25,000 MXN mensuales. - Vales de despensa: $1,300 MXN mensuales. - Fondo de ahorro. - Horario habitual: Lunes a viernes, 9:00 am a 7:00 pm, 1.5 horas de comida. Conditions - Disponibilidad para participar en esquema de guardias rotativas (aproximadamente una vez cada dos semanas). - Disponibilidad para brindar soporte ocasional fuera del horario laboral. - Disponibilidad para atender incidencias en fines de semana cuando sea necesario. - Disponibilidad para rotación de turnos según necesidades operativas. - El tiempo dedicado a soporte fuera del horario habitual se compensa mediante días de descanso.

Role Description We are seeking a proactive and highly organized Loan Coordinator / Lender Liaison to ensure loan files move efficiently from submission through closing. This role serves as the critical bridge between our internal team and lending partners, ensuring consistent communication, timely follow-up, and complete visibility across all active loans. You will be responsible for tracking loan progress daily, coordinating documentation, resolving bottlenecks, and ensuring deadlines are met throughout the loan lifecycle. Responsibilities - Lender Communication - Serve as the primary point of contact between the company and lending partners. - Maintain consistent communication with lenders throughout the loan lifecycle. - Follow up on outstanding lender requests and documentation requirements. - Escalate issues proactively to prevent delays in funding or closing. - Loan Pipeline Management - Monitor active loans from submission through closing. - Maintain accurate status updates and progress tracking across all loan files. - Review loan reports daily and identify delays, bottlenecks, or missing documentation. - Ensure all stakeholders remain informed of loan status and next steps. - Internal Team Coordination - Collaborate with internal team members to gather required documentation. - Coordinate responses to lender requests and underwriting conditions. - Support timely submission of loan packages and required updates. - Ensure all parties remain aligned on timelines and deadlines. - Documentation & File Management - Organize and maintain complete loan files throughout the lending process. - Ensure all correspondence, reports, and documentation are properly recorded and accessible. - Maintain accurate records within CRM and loan management systems. - Verify file completeness before key milestones and closing. - Process Improvement - Identify inefficiencies within loan workflows and communication processes. - Recommend improvements that increase efficiency and reduce loan cycle times. - Assist in building standardized processes for lender communication and pipeline management. Qualifications - Proven experience in loan coordination, loan processing, mortgage operations, lender liaison, or a related role. - Strong understanding of the mortgage or lending process. - Experience managing loan files from submission through closing. - Excellent verbal and written English communication skills. - Exceptional organizational and project management abilities. - Ability to manage multiple active loan files simultaneously. - Experience using CRM systems and Google Workspace (Docs, Sheets, Calendar). - Strong attention to detail and deadline management skills. - Ability to work independently in a remote environment. - Reliable internet connection and availability for 30+ hours per week. Requirements - Experience working with DSCR loans, investment-property financing, or non-QM loan products. - Experience working with real estate investors or investment-property transactions. - Familiarity with Encompass, Salesforce, LendingPad, Jungo, or other loan management platforms. - Background in real estate acquisitions, dispositions, or operations. - Experience supporting U.S.-based mortgage lenders, brokers, or investment firms. What Makes You a Strong Fit - You enjoy keeping multiple moving pieces organized and on schedule. - You proactively solve problems before they become major issues. - You communicate effectively with lenders, underwriters, and internal stakeholders. - You thrive in deadline-driven environments where attention to detail matters. - You can manage multiple loan files simultaneously without sacrificing accuracy. What Does a Typical Day Look Like? Your day begins by reviewing active loan files and lender updates to identify any outstanding conditions, missing documents, or approaching deadlines. Throughout the day, you communicate with lenders, underwriters, and internal stakeholders to keep files moving forward and prevent delays. You coordinate documentation requests, update loan statuses, maintain CRM records, and proactively follow up on pending items. As loans move closer to closing, you ensure all conditions have been satisfied and all parties remain aligned on timelines. Success in this role comes from keeping every loan organized, every stakeholder informed, and every deadline on track. Interview Process - Initial Recruiter Screening - Client Interview - Offer Stage

Role Description You will be the analytical engine of our commercial team — the person who turns complex deals into clean, compelling, accurate submissions and turns data into sharp commercial insight. Reporting directly to strategy leadership, you will own our RFP/RFI library and response process, run competitive intelligence, and partner with Marketing to design the sales collateral that differentiates Ilant in employer, payer, and broker channels. This is a high-detail, internally focused role built for an ex-consultant or data-driven builder who is rigorous about accuracy, comfortable building models, and energized by ambiguity. You won’t carry a quota; you will make the people who do dramatically more effective. You will also help us figure out where AI can make this work faster and better — and then build those workflows. Key Responsibilities - RFP / RFI Ownership - Own the end-to-end RFP/RFI response process — intake, project plan, drafting, cross-functional input, and on-time, accurate submission. - Build and maintain the RFP content library, keeping answers current, version-controlled, and consistent with approved clinical, regulatory, and security positions. - Coordinate input from Clinical, Legal, Product, Security, and Finance, resolving conflicting or stale answers before they reach a buyer. - Financial Modeling & Deal Economics - Build and maintain customized financial models, ROI analyses, and pricing scenarios for prospective employer, payer, and broker clients. - Run utilization-based sensitivity and breakeven analyses using client-specific inputs (population size, demographics, utilization assumptions). - Support proposal economics and ensure financial assumptions used in deals stay aligned with internal financial planning. - Buyer-Facing Insight & Analytics - Partner with the Data team to translate Ilant’s outcomes and analytics into compelling, defensible evidence that advances deals — ROI proof points, population insights, and outcome narratives tailored to employer, payer, and broker audiences. - Communicate outcome and ROI claims so they withstand scrutiny from sophisticated buyers and their actuarial and analytics advisors. - Maintain CRM hygiene and pipeline reporting — keeping rep-level data quality, pipeline accuracy, and stage progression current. - Sales Collateral & Strategic Content - Partner with Marketing to design and maintain pitch decks, ROI summaries, one-pagers, customer-facing FAQs, and internal execution playbooks, on-brand and audience-specific. - Simplify technically dense contracting, clinical, and benefit-design concepts into materials non-technical sales staff can confidently use. - Competitive & Market Intelligence - Track competitors, market shifts, and buyer dynamics across employer, payer, and broker channels; maintain battlecards and positioning guidance. - Translate complex market and competitive data into clear, actionable guidance the sales team can use in live deals. - AI & Process Improvement - Identify and prototype AI-enabled workflows to make RFP response, collateral production, and competitive research faster and higher quality. - Bring a continuous-improvement mindset to the commercial “machinery,” proposing and implementing better ways of working. Qualifications - 3–5 years spanning management consulting, FP&A / financial analysis, strategy, or commercial/revenue operations. - Exceptional attention to detail and accuracy — you catch the inconsistency others miss, and you treat a client-facing number as something to defend. - Strong financial modeling skills (advanced Excel / Google Sheets); comfortable building models from a blank sheet. - Proven ability to manage multi-stakeholder processes under tight deadlines (RFPs, deliverables, cross-functional projects). - Exceptional writing and presentation skills — can build a compelling deck, write a sharp memo, and tailor messaging to different audiences. - An active builder mindset toward generative AI — you don’t just use AI to write text; you understand how to leverage LLMs, prompt frameworks, or automation scripts to streamline knowledge work. Preferred - Experience in healthcare, digital health, health benefits, or enterprise B2B environments; healthcare consulting experience a plus. - Familiarity with employer health benefit economics, capitated/risk-based contracting, or pricing structures. - Startup or high-growth experience; comfort operating without established playbooks. - Experience with Salesforce, BI tools (e.g., Power BI), or similar systems. What Success Looks Like (First 12 Months) - RFP/RFI responses are consistently accurate, on-time, and reusable; the content library is trusted as a single source of truth. - Sales teams walk into meetings better prepared, with stronger collateral and clearer competitive positioning. - At least one AI-enabled workflow is in production and measurably saving time or improving quality. - Commercial decisions are increasingly informed by clean, well-structured data and insight. Benefits - Fully remote environment – work from anywhere while maintaining meaningful collaboration with a distributed team. - Comprehensive health benefits – medical, dental, and vision coverage to support you and your family. - Paid time off – 2 weeks of PTO to rest, recharge, and take the time you need. - Flexible floating holiday – one additional day each year to celebrate what matters most to you. - Paid sick leave – 5 sick days so you can prioritize your health when needed. - 11 paid company holidays throughout the year. - 401(k) retirement plan to help you invest in your future. - Healthcare and Dependent Care FSA options for additional tax-advantaged savings.

• Conducts comprehensive 3–4 hour onboarding calls • Trains providers on EHR systems via screenshare • Manages pre-call setup and credentialing coordination • Maintains a detailed multi-column tracker covering each provider's onboarding journey • Independently runs onboarding within the first month • Proactively manages provider supply so the company is never capacity-constrained