Summary The Senior Data Integration Engineer is responsible for the design, development, and operation of the data integration and ingestion processes that deliver partner and internal data into our analytics environment. The role owns the flow of data from source acquisition through the curated data warehouse tables consumed by reporting platforms, operational systems, and business analysts. This is a senior, hands-on engineering position spanning the full integration lifecycle: acquiring data from a wide range of external partner and internal systems, validating and conditioning that data on arrival, transforming it into the structures that support analysis and operations, and operating those processes reliably in production. The role is concerned equally with building new integrations and with the continued performance, accuracy, and timeliness of those already in service. A central objective of the position is to advance reusable, well-instrumented integration patterns that shorten the time required to onboard new data sources and that improve the reliability and transparency of data delivery to the business. The Senior Data Integration Engineer will also contribute substantially to the planned modernization of our data platform, evaluating and recommending tooling, architecture, and migration approach for leadership consideration. The role sets technical direction and development standards for data integration work and collaborates closely with data architects, business analysts, stakeholders across the organization, and the technical contacts of our external data partners. Essential Duties and Responsibilities This list of duties and responsibilities is not all inclusive and may be expanded to include other duties and responsibilities as management may deem necessary from time to time. Design, develop, and maintain data integration processes that acquire data from partner and internal sources, including flat file transfers over SFTP, REST API endpoints, and direct database connections. Develop reusable, configuration-driven ingestion patterns that reduce the effort and elapsed time required to onboard new partner data feeds. Develop and maintain the T-SQL transformation logic that carries data from landing and staging layers through to the curated warehouse tables supporting reporting, operational systems, and analyst queries. Design ingestion processes to be idempotent and safely re-runnable, incorporating automated retry and restart behavior for failed executions. Implement automated validation and quarantine processes so that records failing business-defined quality rules are isolated, reported, and prevented from reaching downstream consumers. Implement data quality rules defined by the business, including schema validation, reconciliation, row count and threshold checks, and anomaly detection. Establish monitoring, logging, and alerting for pipeline execution state, data freshness, and load completion, and automate the communication of ingestion status to stakeholders. Diagnose and resolve production data incidents, determine root cause, coordinate remediation, and document preventive measures through runbooks and post-incident review. Contribute to dimensional data model design in collaboration with the data architect and senior team members. Establish and maintain version control, code review, and repeatable deployment practices for database and pipeline code. Define and uphold development standards for data integration work through code review and technical guidance. Evaluate and recommend tooling, architecture, and sequencing for the platform modernization effort for leadership consideration. Migrate established integration workflows to modernized patterns incrementally and without disruption to production operations. Maintain documentation of data feeds, dependencies, lineage, ownership, and escalation paths. Perform all work involving protected health information in accordance with HIPAA requirements, including least-privilege access, secure transmission and storage of partner data, and the exclusion of PHI from logs and non-production environments. Coordinate with partner technical contacts, as needed, to resolve file format, schema, and connectivity questions. Provide occasional off-hours support for critical data load failures or production support rotations as needed to support timely response to critical data issues. Support AI and machine learning initiatives by maintaining reliable, secure, and well-governed data pipelines and datasets used for model development, testing, deployment, monitoring, and ongoing performance evaluation. Maintain confidentiality of information processed & follow company policies and procedures. Qualifications Requires six (6) or more years of professional data engineering, data operations, data platform operations, or related experience. Bachelor's degree in Computer Science, Engineering, Information Systems, or related field, or equivalent professional experience preferred. Experience leading teams and developing supervisory staff preferred. To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions. Other qualifications include: Advanced T-SQL development skills, including: Set-based rewriting of row-by-row and cursor-based logic. MERGE, upsert, and slowly changing dimension load patterns. Window functions and complex analytic queries. Execution plan analysis, index strategy, statistics management, and resolution of performance issues such as parameter sniffing. Transaction management and structured error handling within stored procedures, including correct rollback behavior on partial failure. Demonstrated proficiency in Python for data engineering applications, including API-based data acquisition, file parsing and format handling, data validation, and the development of packaged, scheduled jobs. Familiarity with common data libraries such as requests and pandas is expected. Demonstrated experience acquiring and integrating data from heterogeneous sources, including delimited, fixed-width, JSON, and XML file formats; REST APIs requiring authentication, pagination, and rate-limit handling; and direct database connectivity. Proficiency with Git and collaborative development workflows, including branching, pull requests, and code review. A code-first development approach, with integration logic authored and maintained in T-SQL and Python under source control. Ability to analyze pipeline and query performance and to improve the reliability, scalability, and cost efficiency of data workloads. Strong written communication skills, with the ability to produce runbooks, technical documentation, and incident reports, and to convey the business impact of technical issues to non-technical stakeholders. Strong problem-solving skills, attention to detail, and demonstrated ownership of production systems. Experience with Microsoft Azure data services such as Azure Data Factory or Microsoft Fabric, or comparable cloud orchestration platforms. Experience migrating on-premises SQL Server integration workloads to a cloud platform. Experience with dimensional modeling and data warehouse design. Experience designing and rationalizing SQL Server Agent job dependencies and scheduling. Experience establishing version control, code review, and repeatable deployment practices for database code. Experience implementing CI/CD pipelines for database projects. Experience handling protected health information under HIPAA, or comparably regulated data under an equivalent framework preferred. Experience with healthcare or pharmacy data, including claims, eligibility, prescription, or delivery data preferred. Familiarity with data governance, metadata management, and data lineage practices. Physical Demands The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions. (The phrases "occasionally," "regularly," and "frequently" correspond to the following definitions: "Occasionally" means up to 1/3 of working time, "regularly" means between 1/3 and 2/3 of working time, and "frequently" means 2/3 and more working time.) While performing the duties of this job, the employee is frequently required to sit; talk or hear; and use hands to handle, or touch objects or controls. The employee is regularly required to stand and walk. On occasion the incumbent may be required to stoop, bend or reach above the shoulders. The employee would rarely need to lift up to 25 pounds. Specific vision abilities required by this job include close vision, distance vision, color vision, peripheral vision, depth perception, and ability to adjust focus. Work Environment The position is a hybrid position with 2 - 3 days office presence in Milwaukee, WI required. The colleague may perform work-related travel on rare occasions (less than 10%) with an emphasis on travel for impact. . click apply for full job details
09/23/2026
Full time
Summary The Senior Data Integration Engineer is responsible for the design, development, and operation of the data integration and ingestion processes that deliver partner and internal data into our analytics environment. The role owns the flow of data from source acquisition through the curated data warehouse tables consumed by reporting platforms, operational systems, and business analysts. This is a senior, hands-on engineering position spanning the full integration lifecycle: acquiring data from a wide range of external partner and internal systems, validating and conditioning that data on arrival, transforming it into the structures that support analysis and operations, and operating those processes reliably in production. The role is concerned equally with building new integrations and with the continued performance, accuracy, and timeliness of those already in service. A central objective of the position is to advance reusable, well-instrumented integration patterns that shorten the time required to onboard new data sources and that improve the reliability and transparency of data delivery to the business. The Senior Data Integration Engineer will also contribute substantially to the planned modernization of our data platform, evaluating and recommending tooling, architecture, and migration approach for leadership consideration. The role sets technical direction and development standards for data integration work and collaborates closely with data architects, business analysts, stakeholders across the organization, and the technical contacts of our external data partners. Essential Duties and Responsibilities This list of duties and responsibilities is not all inclusive and may be expanded to include other duties and responsibilities as management may deem necessary from time to time. Design, develop, and maintain data integration processes that acquire data from partner and internal sources, including flat file transfers over SFTP, REST API endpoints, and direct database connections. Develop reusable, configuration-driven ingestion patterns that reduce the effort and elapsed time required to onboard new partner data feeds. Develop and maintain the T-SQL transformation logic that carries data from landing and staging layers through to the curated warehouse tables supporting reporting, operational systems, and analyst queries. Design ingestion processes to be idempotent and safely re-runnable, incorporating automated retry and restart behavior for failed executions. Implement automated validation and quarantine processes so that records failing business-defined quality rules are isolated, reported, and prevented from reaching downstream consumers. Implement data quality rules defined by the business, including schema validation, reconciliation, row count and threshold checks, and anomaly detection. Establish monitoring, logging, and alerting for pipeline execution state, data freshness, and load completion, and automate the communication of ingestion status to stakeholders. Diagnose and resolve production data incidents, determine root cause, coordinate remediation, and document preventive measures through runbooks and post-incident review. Contribute to dimensional data model design in collaboration with the data architect and senior team members. Establish and maintain version control, code review, and repeatable deployment practices for database and pipeline code. Define and uphold development standards for data integration work through code review and technical guidance. Evaluate and recommend tooling, architecture, and sequencing for the platform modernization effort for leadership consideration. Migrate established integration workflows to modernized patterns incrementally and without disruption to production operations. Maintain documentation of data feeds, dependencies, lineage, ownership, and escalation paths. Perform all work involving protected health information in accordance with HIPAA requirements, including least-privilege access, secure transmission and storage of partner data, and the exclusion of PHI from logs and non-production environments. Coordinate with partner technical contacts, as needed, to resolve file format, schema, and connectivity questions. Provide occasional off-hours support for critical data load failures or production support rotations as needed to support timely response to critical data issues. Support AI and machine learning initiatives by maintaining reliable, secure, and well-governed data pipelines and datasets used for model development, testing, deployment, monitoring, and ongoing performance evaluation. Maintain confidentiality of information processed & follow company policies and procedures. Qualifications Requires six (6) or more years of professional data engineering, data operations, data platform operations, or related experience. Bachelor's degree in Computer Science, Engineering, Information Systems, or related field, or equivalent professional experience preferred. Experience leading teams and developing supervisory staff preferred. To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions. Other qualifications include: Advanced T-SQL development skills, including: Set-based rewriting of row-by-row and cursor-based logic. MERGE, upsert, and slowly changing dimension load patterns. Window functions and complex analytic queries. Execution plan analysis, index strategy, statistics management, and resolution of performance issues such as parameter sniffing. Transaction management and structured error handling within stored procedures, including correct rollback behavior on partial failure. Demonstrated proficiency in Python for data engineering applications, including API-based data acquisition, file parsing and format handling, data validation, and the development of packaged, scheduled jobs. Familiarity with common data libraries such as requests and pandas is expected. Demonstrated experience acquiring and integrating data from heterogeneous sources, including delimited, fixed-width, JSON, and XML file formats; REST APIs requiring authentication, pagination, and rate-limit handling; and direct database connectivity. Proficiency with Git and collaborative development workflows, including branching, pull requests, and code review. A code-first development approach, with integration logic authored and maintained in T-SQL and Python under source control. Ability to analyze pipeline and query performance and to improve the reliability, scalability, and cost efficiency of data workloads. Strong written communication skills, with the ability to produce runbooks, technical documentation, and incident reports, and to convey the business impact of technical issues to non-technical stakeholders. Strong problem-solving skills, attention to detail, and demonstrated ownership of production systems. Experience with Microsoft Azure data services such as Azure Data Factory or Microsoft Fabric, or comparable cloud orchestration platforms. Experience migrating on-premises SQL Server integration workloads to a cloud platform. Experience with dimensional modeling and data warehouse design. Experience designing and rationalizing SQL Server Agent job dependencies and scheduling. Experience establishing version control, code review, and repeatable deployment practices for database code. Experience implementing CI/CD pipelines for database projects. Experience handling protected health information under HIPAA, or comparably regulated data under an equivalent framework preferred. Experience with healthcare or pharmacy data, including claims, eligibility, prescription, or delivery data preferred. Familiarity with data governance, metadata management, and data lineage practices. Physical Demands The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions. (The phrases "occasionally," "regularly," and "frequently" correspond to the following definitions: "Occasionally" means up to 1/3 of working time, "regularly" means between 1/3 and 2/3 of working time, and "frequently" means 2/3 and more working time.) While performing the duties of this job, the employee is frequently required to sit; talk or hear; and use hands to handle, or touch objects or controls. The employee is regularly required to stand and walk. On occasion the incumbent may be required to stoop, bend or reach above the shoulders. The employee would rarely need to lift up to 25 pounds. Specific vision abilities required by this job include close vision, distance vision, color vision, peripheral vision, depth perception, and ability to adjust focus. Work Environment The position is a hybrid position with 2 - 3 days office presence in Milwaukee, WI required. The colleague may perform work-related travel on rare occasions (less than 10%) with an emphasis on travel for impact. . click apply for full job details
Exemption Status: United States of America (Non-Exempt)$29.32 - $38.85 - $48.38 "Pay scale information is not necessarily reflective of actual compensation that may be earned, nor a promise of any specific pay for any selected candidate or employee, which is always dependent on actual experience, education, qualifications, and other factors. A full review of our comprehensive pay and benefits will be discussed at the offer stage with the selected candidate." This position is not eligible for Sponsorship. MedImpact Healthcare Systems, Inc. is looking for extraordinary people to join our team! Why join MedImpact? Because our success is dependent on you; innovative professionals with top notch skills who thrive on opportunity, high performance, and teamwork. We look for individuals who want to work on a team that cares about making a difference in the value of healthcare. At MedImpact, we deliver leading edge pharmaceutical and technology related solutions that dramatically improve the value of health care. We provide superior outcomes to those we serve through innovative products, systems, and services that provide transparency and promote choice in decision making. Our vision is to set the standard in providing solutions that optimize satisfaction, service, cost, and quality in the healthcare industry. We are the premier Pharmacy Benefits Management solution! Job Description Summary The Testing & Validation Analyst II is responsible for ensuring the quality, accuracy, and reliability of systems, applications, and business processes through structured testing and validation. This role designs and executes test strategies, develops test cases, and analyzes results to identify defects, risks, and gaps against defined requirements and regulatory standards. Working cross-functionally with business stakeholders, developers, and project teams, the analyst validates that solutions meet both functional and non-functional requirements, supports defect resolution, and ensures readiness for deployment, while maintaining detailed documentation, tracking testing progress, and contributing to continuous improvement of testing methodologies, tools, and overall quality assurance practices. Essential Duties and Responsibilities include the following. Other duties may be assigned. Leverage Configuration Services best practices to validate design objectives, processes, and procedures, including development of data sets, test scenarios, expected results, and acceptance criteria. Design, standardize, and maintain testing scenarios, use cases, and expected outcomes to improve testing efficiency, consistency, and repeatability. Collaborate with business partners and cross-functional teams to validate configuration accuracy for ongoing maintenance, new client implementations, and special projects. Ensure high levels of customer satisfaction by confirming that business requirements-particularly benefit change requests-are clearly understood, accurately documented, thoroughly tested, and effectively communicated. Execute testing scenarios and analyze claims adjudication outcomes to identify discrepancies, inaccuracies, anomalies, and unintended impacts; provide recommendations and implement solutions to improve configuration accuracy and performance. Support and mentor team members by assisting in the development and analysis of complex test plans, design validations, and execution strategies. Contribute to continuous quality improvement by adhering to departmental standards and proactively identifying opportunities to enhance processes, tools, and overall testing efficiency. Validate adjudication configurations and support the promotion of approved changes from test environments to production in accordance with established governance and best practices. Supervisory Responsibilities No supervisory responsibilities Client Responsibilities This is an internal and external client facing position that requires excellent customer service skills and interpersonal communication skills (listening/verbal/written). One must be able to; manage difficult or emotional client situations; Respond promptly to client needs; Solicit client feedback to improve service; Respond to requests for service and assistance from clients; Meet commitments to clients. Qualifications To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions. Education and/or Experience BS/BA and 3+ years' experience or equivalent combination of education and experience Computer Skills Intermediate to advanced knowledge of MS Office / Word, Excel PowerPoint, and Outlook. Experience as an advanced user of multiple business software applications and working knowledge of key technical applications such as SQL, Oracle based platforms, and Golden 32. Experience in SQL queries and writing test plans/ cases required. Certificates, Licenses, Registrations Pharmacy Technician License or National Certification preferred but not required. Other Skills and Abilities Strong knowledge of software testing methodologies (UAT, integration, regression, end-to-end testing) Ability to design complex test scenarios, use cases, and acceptance criteria Ability to clearly translate business requirements into testable conditions Ability to gather and document business requirements and client specifications Advanced ability to analyze claims adjudication results and interpret discrepancies Strong stakeholder engagement skills across business, IT, and operations Excellent written and verbal communication, especially for documenting test results and issues Capability to present findings and recommendations to leadership or non-technical stakeholders Knowledge of healthcare/Medicaid/FFS and MCO program structures Understanding of data validation and environment promotion processes Ability to manage multiple priorities in a fast-paced environment Detail-oriented with a high degree of accuracy and accountability Reasoning Ability Ability to solve practical problems and deal with a variety of concrete variables in situations where only limited standardization exists. Ability to interpret a variety of instructions furnished in written, oral, diagram, or schedule form. Mathematical Skills Ability to apply concepts such as fractions, percentages, ratios, and proportions to practical situations. Ability to work with mathematical concepts such as probability and statistical inference, and fundamentals of plane and solid geometry and trigonometry. Language Skills Ability to read, analyze, and interpret general business periodicals, professional journals, technical procedures, or governmental regulations. Ability to effectively present information and respond to questions from groups of managers, clients, customers, and the general public. Competencies To perform the job successfully, an individual should demonstrate the following competencies: Composure Decision Quality Organizational Agility Problem Solving Customer Focus Drive for Results Peer Relations Time Management Dealing with Ambiguity Learning on the Fly Political Savvy Physical Demands The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this job, the employee is regularly required to sit and talk or hear. The employee is regularly required to stand; walk; use hands to finger, handle, or feel and reach with hands and arms. The employee must occasionally lift and/or move up to 25 pounds. Ability to maintain clear near visual acuity at approximately 20 inches or less (i.e., "close vision") to accurately read fine print, view computer screens, and handle small objects. Requires adequate color vision and depth perception to support safety and precision in detail-oriented tasks. Work Environment The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions. This position may regularly be exposed to or encounter moving mechanical parts, high, precarious places, fumes or airborne particles, toxic or caustic chemicals, outdoor weather conditions, risk of electrical shock or vibration. The noise level in the work environment is usually moderate (examples: business office with computers and printers, light traffic). Work Location This position works on-site at the San Diego Headquarters or other company location (or from a remote location with management approval based on business requirements). Must provide adequate support to internal clients; be available for regular interactions and coordination of work with other employees, colleagues, clients . click apply for full job details
09/23/2026
Full time
Exemption Status: United States of America (Non-Exempt)$29.32 - $38.85 - $48.38 "Pay scale information is not necessarily reflective of actual compensation that may be earned, nor a promise of any specific pay for any selected candidate or employee, which is always dependent on actual experience, education, qualifications, and other factors. A full review of our comprehensive pay and benefits will be discussed at the offer stage with the selected candidate." This position is not eligible for Sponsorship. MedImpact Healthcare Systems, Inc. is looking for extraordinary people to join our team! Why join MedImpact? Because our success is dependent on you; innovative professionals with top notch skills who thrive on opportunity, high performance, and teamwork. We look for individuals who want to work on a team that cares about making a difference in the value of healthcare. At MedImpact, we deliver leading edge pharmaceutical and technology related solutions that dramatically improve the value of health care. We provide superior outcomes to those we serve through innovative products, systems, and services that provide transparency and promote choice in decision making. Our vision is to set the standard in providing solutions that optimize satisfaction, service, cost, and quality in the healthcare industry. We are the premier Pharmacy Benefits Management solution! Job Description Summary The Testing & Validation Analyst II is responsible for ensuring the quality, accuracy, and reliability of systems, applications, and business processes through structured testing and validation. This role designs and executes test strategies, develops test cases, and analyzes results to identify defects, risks, and gaps against defined requirements and regulatory standards. Working cross-functionally with business stakeholders, developers, and project teams, the analyst validates that solutions meet both functional and non-functional requirements, supports defect resolution, and ensures readiness for deployment, while maintaining detailed documentation, tracking testing progress, and contributing to continuous improvement of testing methodologies, tools, and overall quality assurance practices. Essential Duties and Responsibilities include the following. Other duties may be assigned. Leverage Configuration Services best practices to validate design objectives, processes, and procedures, including development of data sets, test scenarios, expected results, and acceptance criteria. Design, standardize, and maintain testing scenarios, use cases, and expected outcomes to improve testing efficiency, consistency, and repeatability. Collaborate with business partners and cross-functional teams to validate configuration accuracy for ongoing maintenance, new client implementations, and special projects. Ensure high levels of customer satisfaction by confirming that business requirements-particularly benefit change requests-are clearly understood, accurately documented, thoroughly tested, and effectively communicated. Execute testing scenarios and analyze claims adjudication outcomes to identify discrepancies, inaccuracies, anomalies, and unintended impacts; provide recommendations and implement solutions to improve configuration accuracy and performance. Support and mentor team members by assisting in the development and analysis of complex test plans, design validations, and execution strategies. Contribute to continuous quality improvement by adhering to departmental standards and proactively identifying opportunities to enhance processes, tools, and overall testing efficiency. Validate adjudication configurations and support the promotion of approved changes from test environments to production in accordance with established governance and best practices. Supervisory Responsibilities No supervisory responsibilities Client Responsibilities This is an internal and external client facing position that requires excellent customer service skills and interpersonal communication skills (listening/verbal/written). One must be able to; manage difficult or emotional client situations; Respond promptly to client needs; Solicit client feedback to improve service; Respond to requests for service and assistance from clients; Meet commitments to clients. Qualifications To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions. Education and/or Experience BS/BA and 3+ years' experience or equivalent combination of education and experience Computer Skills Intermediate to advanced knowledge of MS Office / Word, Excel PowerPoint, and Outlook. Experience as an advanced user of multiple business software applications and working knowledge of key technical applications such as SQL, Oracle based platforms, and Golden 32. Experience in SQL queries and writing test plans/ cases required. Certificates, Licenses, Registrations Pharmacy Technician License or National Certification preferred but not required. Other Skills and Abilities Strong knowledge of software testing methodologies (UAT, integration, regression, end-to-end testing) Ability to design complex test scenarios, use cases, and acceptance criteria Ability to clearly translate business requirements into testable conditions Ability to gather and document business requirements and client specifications Advanced ability to analyze claims adjudication results and interpret discrepancies Strong stakeholder engagement skills across business, IT, and operations Excellent written and verbal communication, especially for documenting test results and issues Capability to present findings and recommendations to leadership or non-technical stakeholders Knowledge of healthcare/Medicaid/FFS and MCO program structures Understanding of data validation and environment promotion processes Ability to manage multiple priorities in a fast-paced environment Detail-oriented with a high degree of accuracy and accountability Reasoning Ability Ability to solve practical problems and deal with a variety of concrete variables in situations where only limited standardization exists. Ability to interpret a variety of instructions furnished in written, oral, diagram, or schedule form. Mathematical Skills Ability to apply concepts such as fractions, percentages, ratios, and proportions to practical situations. Ability to work with mathematical concepts such as probability and statistical inference, and fundamentals of plane and solid geometry and trigonometry. Language Skills Ability to read, analyze, and interpret general business periodicals, professional journals, technical procedures, or governmental regulations. Ability to effectively present information and respond to questions from groups of managers, clients, customers, and the general public. Competencies To perform the job successfully, an individual should demonstrate the following competencies: Composure Decision Quality Organizational Agility Problem Solving Customer Focus Drive for Results Peer Relations Time Management Dealing with Ambiguity Learning on the Fly Political Savvy Physical Demands The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this job, the employee is regularly required to sit and talk or hear. The employee is regularly required to stand; walk; use hands to finger, handle, or feel and reach with hands and arms. The employee must occasionally lift and/or move up to 25 pounds. Ability to maintain clear near visual acuity at approximately 20 inches or less (i.e., "close vision") to accurately read fine print, view computer screens, and handle small objects. Requires adequate color vision and depth perception to support safety and precision in detail-oriented tasks. Work Environment The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions. This position may regularly be exposed to or encounter moving mechanical parts, high, precarious places, fumes or airborne particles, toxic or caustic chemicals, outdoor weather conditions, risk of electrical shock or vibration. The noise level in the work environment is usually moderate (examples: business office with computers and printers, light traffic). Work Location This position works on-site at the San Diego Headquarters or other company location (or from a remote location with management approval based on business requirements). Must provide adequate support to internal clients; be available for regular interactions and coordination of work with other employees, colleagues, clients . click apply for full job details
City/State: Yonkers, New York Grant Funded: Yes Department: CMO - Technical Services Work Shift: Day Work Days: MON-FRI Scheduled Hours: 8 AM-4:30 PM Scheduled Daily Hours: 7.5 HOURS Pay Range: $82,400.14-$103,000.17 Position Summary The Data and Process Quality Analyst will be responsible for ensuring the accuracy, integrity, and quality of data and business processes supporting Montefiore's Health Home program. This role is part of a technical team supporting a complex system including web applications, data interfaces, billing and finance processes, claims and remittance workflows, and reporting solutions. The successful candidate will develop deep knowledge of both the NYS Medicaid Health Home program and the underlying technology platform, including large relational databases, complex stored procedures, and business rules. A key responsibility of this role is proactively identifying data quality issues, process breakdowns, and operational gaps through advanced SQL analysis, root cause investigation, and reporting. This is a hands-on analytical role requiring strong technical skills, curiosity, and the ability to connect business processes with underlying data. ON-SITE WORK REQUIRED Responsibilities Monitor and analyze data quality across multiple systems and processes. Write advanced SQL queries to identify data anomalies, discrepancies, and trends. Perform root cause analysis to determine sources of data and process issues. Develop reports and monitoring tools that enable operational teams to identify and correct issues. Analyze business workflows and data flows to identify process gaps and improvement opportunities. Support daily file exchanges and data reconciliation activities with NYS DOH MAPP. Collaborate with developers, analysts, and operational teams to implement corrective actions and improve quality. Qualifications Education Bachelor's degree required; Master's degree preferred. Experience 5+ years in data quality, data analytics, business intelligence, or a related analytical role. Healthcare experience strongly preferred. Technical Skills Advanced SQL proficiency with demonstrated ability to write complex queries against large relational databases. Strong understanding of relational database structures, data relationships, and data quality principles. Experience analyzing complex business processes, data flows, and system logic. Ability to understand and troubleshoot stored procedures, interfaces, and batch processes. Experience developing analytical reports and exception monitoring solutions. General Skills Exceptional analytical, investigative, and problem-solving abilities. Strong attention to detail and commitment to data accuracy. Excellent written and verbal communication skills. Understanding of SDLC concepts and practices. Preferred Experience with Medicaid, healthcare operations, claims, billing, or NYS Health Home programs. Familiarity with NYS Medicaid policies and regulations. Montefiore Medical Center is an equal employment opportunity employer. Montefiore Medical Center will recruit, hire, train, transfer, promote, layoff and discharge associates in all job classifications without regard to their race, color, religion, creed, national origin, alienage or citizenship status, age, gender, actual or presumed disability, history of disability, sexual orientation, gender identity, gender expression, genetic predisposition or carrier status, pregnancy, military status, marital status, or partnership status, or any other characteristic protected by law.
09/23/2026
Full time
City/State: Yonkers, New York Grant Funded: Yes Department: CMO - Technical Services Work Shift: Day Work Days: MON-FRI Scheduled Hours: 8 AM-4:30 PM Scheduled Daily Hours: 7.5 HOURS Pay Range: $82,400.14-$103,000.17 Position Summary The Data and Process Quality Analyst will be responsible for ensuring the accuracy, integrity, and quality of data and business processes supporting Montefiore's Health Home program. This role is part of a technical team supporting a complex system including web applications, data interfaces, billing and finance processes, claims and remittance workflows, and reporting solutions. The successful candidate will develop deep knowledge of both the NYS Medicaid Health Home program and the underlying technology platform, including large relational databases, complex stored procedures, and business rules. A key responsibility of this role is proactively identifying data quality issues, process breakdowns, and operational gaps through advanced SQL analysis, root cause investigation, and reporting. This is a hands-on analytical role requiring strong technical skills, curiosity, and the ability to connect business processes with underlying data. ON-SITE WORK REQUIRED Responsibilities Monitor and analyze data quality across multiple systems and processes. Write advanced SQL queries to identify data anomalies, discrepancies, and trends. Perform root cause analysis to determine sources of data and process issues. Develop reports and monitoring tools that enable operational teams to identify and correct issues. Analyze business workflows and data flows to identify process gaps and improvement opportunities. Support daily file exchanges and data reconciliation activities with NYS DOH MAPP. Collaborate with developers, analysts, and operational teams to implement corrective actions and improve quality. Qualifications Education Bachelor's degree required; Master's degree preferred. Experience 5+ years in data quality, data analytics, business intelligence, or a related analytical role. Healthcare experience strongly preferred. Technical Skills Advanced SQL proficiency with demonstrated ability to write complex queries against large relational databases. Strong understanding of relational database structures, data relationships, and data quality principles. Experience analyzing complex business processes, data flows, and system logic. Ability to understand and troubleshoot stored procedures, interfaces, and batch processes. Experience developing analytical reports and exception monitoring solutions. General Skills Exceptional analytical, investigative, and problem-solving abilities. Strong attention to detail and commitment to data accuracy. Excellent written and verbal communication skills. Understanding of SDLC concepts and practices. Preferred Experience with Medicaid, healthcare operations, claims, billing, or NYS Health Home programs. Familiarity with NYS Medicaid policies and regulations. Montefiore Medical Center is an equal employment opportunity employer. Montefiore Medical Center will recruit, hire, train, transfer, promote, layoff and discharge associates in all job classifications without regard to their race, color, religion, creed, national origin, alienage or citizenship status, age, gender, actual or presumed disability, history of disability, sexual orientation, gender identity, gender expression, genetic predisposition or carrier status, pregnancy, military status, marital status, or partnership status, or any other characteristic protected by law.
Geronimo Hospitality Group Description: JOIN A TEAM THAT VALUES PEOPLE At Hendricks Commercial Properties, we value people who value people. We believe in creating environments where communities thrive, and we encourage our team to embrace the freedom to do amazing things. We didn't come this far to only come this far-join us in making a real impact. OUR COMMITMENT TO YOU We offer more than just a job. Our benefits include flexible work hours, Employee Discounts, Paid Time Off, Training & Development Opportunities, 401K Match, Medical Benefits, 24/7 Online Care, Pet Insurance, and many other company perks. You'll also enjoy working in beautifully designed offices, situated in dynamic downtown areas with access to great amenities that enhance your day-to-day experience. At Hendricks, you'll have the opportunity to teach what you know and learn what you don't-and community matters here. BE THE CEO OF YOUR JOB As the Risk Management Analyst, you are responsible for effectively coordinating and recording policy compliance and assisting with management of property, general liability, automobile, work comp, cyber and crime policies and incident/claims for Hendricks Commercial Properties, Geronimo Hospitality and their affiliated companies' internal & external partners. Your ability to own your work and drive success will make a direct impact on the communities we serve. YOUR KEY RESPONSIBILITIES Executes well-defined work assignments that are subject to a moderate level of control and review. Comprehensive knowledge of insurance concepts & utilization. Basic understanding of construction. Review of contracts for proper indemnity and certificate requirements. Tracks the collection, distribution and management of tenants, contractor & vendor COI and EOPs. Provides quarterly updates on certificate compliance to SVP of REM, Risk Management and Sr Contracts Administrator. Responsible for premium/claim allocation and premium/claim invoice submissions. Gathers Incident & Claim information, conducts investigation while in tandem identifying applicable policy, coverage, deductible and potential subrogation recovery. Communicates and Coordinates with Claimant(s), Field partners, Broker, TPA and all other interested parties regarding incident/claims to obtain best possible outcome Coaching internal partners for productive incident reporting, management and process. Manages claims In-house and reports claim, as necessary, to Insurance Carrier and manages expectations Analysis of invoices/estimates for proper support and cost detail in relationship to scope of covered damage. Data & Loss Trend Analysis Obtain valuations for acquisitions while managing & maintaining the SOV. Conducts BPP review with all Grey Collar Enterprise entities. Aids in budget creation and analysis. Participation within REM & Safety monthly meetings. Collaborate with internal & external partners for collection necessary for insurance programs and potential needs. Assist with the annual policy renewal process. Understands our entity structure and interdependency. COMPENSATION This position offers a competitive starting salary, with opportunities for growth based on performance and tenure. Hard work matters, and we reward it. HCP24 Requirements: QUALIFICATIONS REQUIRED Education High School Diploma, GED, or equivalent skills Experience and/or Training Document review experience in insurance related policies and/or commercial contracts. Work within a fast paced, deadline driven environment with little supervision that seeks support when required. Ability to multi-task and prioritize assignments. Attention to detail and accuracy. Self-starter, naturally intuitive with detective like skills Capable of building strong internal and external relationships. Robust analytical and communication skills Licenses Possess a valid driver's license. Technology/Equipment Advanced level of proficiency in Word, Outlook, and Excel PREFERRED QUALIFICATIONS Education Associate degree or BA/BS from a two or four-year technical college or university. AIC certification. Experience and/or Training Commercial real estate and/or Insurance experience preferred. Licenses/Certificates Real Estate and/or Insurance license. MANDATORY REQUIREMENT U.S. Work Authorization CHALLENGE ACCEPTED? At Hendricks Commercial Properties, we don't just keep our word, we make an impact. If you're ready to be the CEO of your job, embrace the freedom to do amazing things, and take your career to the next level, we'd love to have you on our team. PI4b73d1bcb56b-3818
09/23/2026
Full time
Geronimo Hospitality Group Description: JOIN A TEAM THAT VALUES PEOPLE At Hendricks Commercial Properties, we value people who value people. We believe in creating environments where communities thrive, and we encourage our team to embrace the freedom to do amazing things. We didn't come this far to only come this far-join us in making a real impact. OUR COMMITMENT TO YOU We offer more than just a job. Our benefits include flexible work hours, Employee Discounts, Paid Time Off, Training & Development Opportunities, 401K Match, Medical Benefits, 24/7 Online Care, Pet Insurance, and many other company perks. You'll also enjoy working in beautifully designed offices, situated in dynamic downtown areas with access to great amenities that enhance your day-to-day experience. At Hendricks, you'll have the opportunity to teach what you know and learn what you don't-and community matters here. BE THE CEO OF YOUR JOB As the Risk Management Analyst, you are responsible for effectively coordinating and recording policy compliance and assisting with management of property, general liability, automobile, work comp, cyber and crime policies and incident/claims for Hendricks Commercial Properties, Geronimo Hospitality and their affiliated companies' internal & external partners. Your ability to own your work and drive success will make a direct impact on the communities we serve. YOUR KEY RESPONSIBILITIES Executes well-defined work assignments that are subject to a moderate level of control and review. Comprehensive knowledge of insurance concepts & utilization. Basic understanding of construction. Review of contracts for proper indemnity and certificate requirements. Tracks the collection, distribution and management of tenants, contractor & vendor COI and EOPs. Provides quarterly updates on certificate compliance to SVP of REM, Risk Management and Sr Contracts Administrator. Responsible for premium/claim allocation and premium/claim invoice submissions. Gathers Incident & Claim information, conducts investigation while in tandem identifying applicable policy, coverage, deductible and potential subrogation recovery. Communicates and Coordinates with Claimant(s), Field partners, Broker, TPA and all other interested parties regarding incident/claims to obtain best possible outcome Coaching internal partners for productive incident reporting, management and process. Manages claims In-house and reports claim, as necessary, to Insurance Carrier and manages expectations Analysis of invoices/estimates for proper support and cost detail in relationship to scope of covered damage. Data & Loss Trend Analysis Obtain valuations for acquisitions while managing & maintaining the SOV. Conducts BPP review with all Grey Collar Enterprise entities. Aids in budget creation and analysis. Participation within REM & Safety monthly meetings. Collaborate with internal & external partners for collection necessary for insurance programs and potential needs. Assist with the annual policy renewal process. Understands our entity structure and interdependency. COMPENSATION This position offers a competitive starting salary, with opportunities for growth based on performance and tenure. Hard work matters, and we reward it. HCP24 Requirements: QUALIFICATIONS REQUIRED Education High School Diploma, GED, or equivalent skills Experience and/or Training Document review experience in insurance related policies and/or commercial contracts. Work within a fast paced, deadline driven environment with little supervision that seeks support when required. Ability to multi-task and prioritize assignments. Attention to detail and accuracy. Self-starter, naturally intuitive with detective like skills Capable of building strong internal and external relationships. Robust analytical and communication skills Licenses Possess a valid driver's license. Technology/Equipment Advanced level of proficiency in Word, Outlook, and Excel PREFERRED QUALIFICATIONS Education Associate degree or BA/BS from a two or four-year technical college or university. AIC certification. Experience and/or Training Commercial real estate and/or Insurance experience preferred. Licenses/Certificates Real Estate and/or Insurance license. MANDATORY REQUIREMENT U.S. Work Authorization CHALLENGE ACCEPTED? At Hendricks Commercial Properties, we don't just keep our word, we make an impact. If you're ready to be the CEO of your job, embrace the freedom to do amazing things, and take your career to the next level, we'd love to have you on our team. PI4b73d1bcb56b-3818
Liviniti (formerly Southern Scripts) seeks a Workforce Analyst to support its transparent PBM solutions. In this role, you will analyze pharmacy and operational data to optimize staffing, service levels, and RxC/VCP program performance. You'll build reports and dashboards, forecast volumes, and identify trends impacting drug costs and member experience. Partnering closely with clinical, operations, and client teams, you'll translate complex data into actionable insights that improve access, efficiency, and outcomes in a collaborative, mission driven environment focused on lowering prescription costs nationwide. Responsibilities Analyze pharmacy and claims data to identify utilization, cost, and trend drivers across Rx C/VCP programs Develop reports, dashboards, and KPIs to support internal stakeholders and health plan clients Translate complex data into clear insights and recommendations to lower drug spend and improve outcomes Support forecasting, performance tracking, and variance analysis for pharmacy benefit programs Collaborate with clinical, account management, and operations teams to optimize benefit design and member experience Ensure data accuracy, integrity, and compliance with internal standards and healthcare regulations Participate in continuous improvement initiatives, recommending process and analytic enhancements Present findings to non technical audiences through concise summaries and visualizations Required Skills Workforce management analytics Healthcare or PBM data analysis Advanced Excel SQL or similar query languages Business intelligence tools (e.g., Power BI, Tableau, Looker) Forecasting and capacity planning KPI and dashboard development Data validation and quality assurance Statistical analysis and reporting Presentation and data storytelling
09/22/2026
Full time
Liviniti (formerly Southern Scripts) seeks a Workforce Analyst to support its transparent PBM solutions. In this role, you will analyze pharmacy and operational data to optimize staffing, service levels, and RxC/VCP program performance. You'll build reports and dashboards, forecast volumes, and identify trends impacting drug costs and member experience. Partnering closely with clinical, operations, and client teams, you'll translate complex data into actionable insights that improve access, efficiency, and outcomes in a collaborative, mission driven environment focused on lowering prescription costs nationwide. Responsibilities Analyze pharmacy and claims data to identify utilization, cost, and trend drivers across Rx C/VCP programs Develop reports, dashboards, and KPIs to support internal stakeholders and health plan clients Translate complex data into clear insights and recommendations to lower drug spend and improve outcomes Support forecasting, performance tracking, and variance analysis for pharmacy benefit programs Collaborate with clinical, account management, and operations teams to optimize benefit design and member experience Ensure data accuracy, integrity, and compliance with internal standards and healthcare regulations Participate in continuous improvement initiatives, recommending process and analytic enhancements Present findings to non technical audiences through concise summaries and visualizations Required Skills Workforce management analytics Healthcare or PBM data analysis Advanced Excel SQL or similar query languages Business intelligence tools (e.g., Power BI, Tableau, Looker) Forecasting and capacity planning KPI and dashboard development Data validation and quality assurance Statistical analysis and reporting Presentation and data storytelling
Geronimo Hospitality Group is seeking a Risk Management Analyst to help safeguard our distinctive hotels, restaurants, and entertainment venues. In this role, you'll analyze operational, financial, safety, and compliance risks, interpret incident and claims data, and recommend practical mitigation strategies. You'll support insurance renewals and claims, maintain risk policies and controls, and prepare clear reports for leadership. You'll collaborate closely with operations, HR, and finance to embed risk awareness into daily hospitality practices while contributing to a fun, people-first culture focused on memorable guest experiences and long-term growth. Responsibilities Identify, assess, and monitor operational, financial, safety, and compliance risks across hotels, restaurants, and venues Analyze incident, claims, and loss data to spot trends and recommend mitigation strategies Support development and maintenance of risk policies, procedures, and internal controls Assist with insurance renewals, certificates of insurance, and claims coordination Conduct risk assessments for new projects, vendors, and events Prepare risk reports and dashboards for leadership and property managers Partner with operations, HR, and finance to implement risk-reduction initiatives and training Ensure adherence to applicable health, safety, and hospitality regulations Required Skills Risk assessment and analysis Data analysis and reporting Insurance and claims coordination Regulatory and compliance knowledge Internal controls and policy development Incident and loss trend analysis Risk reporting and dashboarding Hospitality operations familiarity Excel and data visualization tools Presentation and stakeholder communication
09/19/2026
Full time
Geronimo Hospitality Group is seeking a Risk Management Analyst to help safeguard our distinctive hotels, restaurants, and entertainment venues. In this role, you'll analyze operational, financial, safety, and compliance risks, interpret incident and claims data, and recommend practical mitigation strategies. You'll support insurance renewals and claims, maintain risk policies and controls, and prepare clear reports for leadership. You'll collaborate closely with operations, HR, and finance to embed risk awareness into daily hospitality practices while contributing to a fun, people-first culture focused on memorable guest experiences and long-term growth. Responsibilities Identify, assess, and monitor operational, financial, safety, and compliance risks across hotels, restaurants, and venues Analyze incident, claims, and loss data to spot trends and recommend mitigation strategies Support development and maintenance of risk policies, procedures, and internal controls Assist with insurance renewals, certificates of insurance, and claims coordination Conduct risk assessments for new projects, vendors, and events Prepare risk reports and dashboards for leadership and property managers Partner with operations, HR, and finance to implement risk-reduction initiatives and training Ensure adherence to applicable health, safety, and hospitality regulations Required Skills Risk assessment and analysis Data analysis and reporting Insurance and claims coordination Regulatory and compliance knowledge Internal controls and policy development Incident and loss trend analysis Risk reporting and dashboarding Hospitality operations familiarity Excel and data visualization tools Presentation and stakeholder communication
Job Description Job Description Analytics Engineer, Care Operations Full Time - Exempt Columbus, Ohio AndHealth is on a mission to radically improve access and outcomes for the most challenging chronic health conditions, with the goal of making world-class specialty care accessible and affordable to all. We partner with health systems, community health centers, and independent practices to remove barriers to care to ensure all people have access to the care they deserve. None of that happens without good data. Every model we build, every intervention we design, and every conversation our care teams have with a partner is only as strong as the data behind it. That's where you come in. About the role We're looking for an Analytics Engineer to be the dedicated data partner to our Care Delivery team - the people on the front lines of getting patients into care and keeping them there. You'll take raw clinical and operations data and turn it into something a care leader can actually use: a trusted number on a dashboard, a governed metric everyone agrees on, a model that surfaces a problem before it becomes a crisis. This is an embedded data partner role that sits close to Care Delivery. You'll be just as comfortable deep in a dbt model or a gnarly SQL query as you are in a room with a VP, translating what the data means and what to do about it. If you like owning a domain end to end - from the metric definition in the semantic layer to the dashboard a leader checks every morning - this role is for you. Impact The dashboards and data products you build will directly shape how AndHealth delivers care to thousands of patients managing chronic, often life-altering conditions. When you catch a data quality issue before it reaches a report, you're protecting the integrity of decisions that affect real people's access to care. When you build the semantic layer that lets an analyst self-serve a trusted metric instead of waiting on you, you're multiplying the entire team's ability to act. This isn't dashboards for dashboards' sake - it's the infrastructure that lets Care Operations see what's working, fix what isn't, and prove the value we bring to the partners and patients who depend on us. What you'll do: Translate business decisions into metrics - work with stakeholders to understand the decision they're trying to make, help them articulate what they need, and define the governed metric that answers it. Partner with stakeholders from several teams to generate actionable insights that improve AndHealth's value to our partners and patients. Build internal and external reporting and dashboards that visualize what's happening, why it's happening, and what we should do next across pharmacy and care operations. Develop the semantic layer in dbt - defining governed metric definitions, curated datasets, and self-service data products that analysts and stakeholders can consume directly. Partner with Data and Software Engineering as a key consumer of the raw data - flagging upstream data quality issues and gaps, and helping shape staging transformations so data arrives in a usable form. Build a thorough testing suite across the data platform: schema tests, data quality checks, anomaly detection, and SLA monitoring so stakeholders can trust what they see. Partner with the client management team to build the value story for quarterly business reviews. Become a domain expert in your assigned area (care operations), translating business logic into accurate, scalable dbt data models. Proactively identify data quality issues, gaps in coverage, and opportunities to improve the reliability and usability of the data platform. Education & Licensure Requirements: Bachelor's degree in Computer Science, Economics, Engineering, Mathematics, or a related quantitative field, or equivalent practical experience. Other Skills or Qualifications: 6+ years of data analysis or related experience with significant experience partnering directly with business stakeholders. Proven ability to turn ambiguous business questions into concrete, governed metric definitions - comfortable leading the discovery conversation with stakeholders rather than just executing a spec. Strong analytical instincts - able to interrogate data, identify anomalies, trace them to their source, and communicate findings clearly to technical and non-technical audiences. Strong SQL proficiency - complex queries, CTEs, window functions, and performance-optimized transformations across large datasets. Hands-on experience with dbt (Core or Cloud) - preferred. Comfortable working within a dimensionally modeled warehouse - facts and dimensions, mart layers, and why transformations are separated into staging, intermediate, and mart layers - even if you haven't owned that architecture from the ground up. Experience creating reporting systems and visualizations; advanced experience with Excel and other data systems. Comfort working alongside ETL/ELT pipelines and partnering with data or software engineers on ingestion. Experience with a BI tool (Omni, Looker, Metabase, or similar), especially defining governed metrics and data products - preferred. Familiarity with healthcare data (clinical, pharmacy, billing, or claims from EHRs, TPAs, or pharmacy operating systems) - preferred. Advanced data modeling experience - designing non-trivial dbt/SQL models that encode real business logic. Experience with R or Python or another scripting language in data analysis work - preferred. Comfort working in ambiguous, fast-moving environments with competing priorities. Here's what we'd like to offer you: Equal investment and support for our people and patients. A fun and ambitious growing environment with a culture that takes on important things, takes risks, and learns quickly. The ability to demonstrate creativity, innovation, and conscientiousness, and find joy in working together. A team of highly skilled, incredibly kind, and welcoming employees, every one of whom has something unique to offer. We know that the overall success of our business is a collaborative effort, and we strive to provide ongoing opportunities for our employees to learn and grow, both personally and professionally. Full-time employees are eligible to participate in our benefits package which includes Medical, Dental, Vision Insurance, Paid time off, Short- and Long-Term Disability, 401k match and more. We are an equal opportunity and affirmative action employer. We embrace diversity and are committed to creating an inclusive environment for all employees. Applicants will be considered for employment without regard to race, religion, gender, gender identity, sexual orientation, national origin, age, disability, or veteran status. Powered by JazzHR 2lXGu4dNqn
09/16/2026
Full time
Job Description Job Description Analytics Engineer, Care Operations Full Time - Exempt Columbus, Ohio AndHealth is on a mission to radically improve access and outcomes for the most challenging chronic health conditions, with the goal of making world-class specialty care accessible and affordable to all. We partner with health systems, community health centers, and independent practices to remove barriers to care to ensure all people have access to the care they deserve. None of that happens without good data. Every model we build, every intervention we design, and every conversation our care teams have with a partner is only as strong as the data behind it. That's where you come in. About the role We're looking for an Analytics Engineer to be the dedicated data partner to our Care Delivery team - the people on the front lines of getting patients into care and keeping them there. You'll take raw clinical and operations data and turn it into something a care leader can actually use: a trusted number on a dashboard, a governed metric everyone agrees on, a model that surfaces a problem before it becomes a crisis. This is an embedded data partner role that sits close to Care Delivery. You'll be just as comfortable deep in a dbt model or a gnarly SQL query as you are in a room with a VP, translating what the data means and what to do about it. If you like owning a domain end to end - from the metric definition in the semantic layer to the dashboard a leader checks every morning - this role is for you. Impact The dashboards and data products you build will directly shape how AndHealth delivers care to thousands of patients managing chronic, often life-altering conditions. When you catch a data quality issue before it reaches a report, you're protecting the integrity of decisions that affect real people's access to care. When you build the semantic layer that lets an analyst self-serve a trusted metric instead of waiting on you, you're multiplying the entire team's ability to act. This isn't dashboards for dashboards' sake - it's the infrastructure that lets Care Operations see what's working, fix what isn't, and prove the value we bring to the partners and patients who depend on us. What you'll do: Translate business decisions into metrics - work with stakeholders to understand the decision they're trying to make, help them articulate what they need, and define the governed metric that answers it. Partner with stakeholders from several teams to generate actionable insights that improve AndHealth's value to our partners and patients. Build internal and external reporting and dashboards that visualize what's happening, why it's happening, and what we should do next across pharmacy and care operations. Develop the semantic layer in dbt - defining governed metric definitions, curated datasets, and self-service data products that analysts and stakeholders can consume directly. Partner with Data and Software Engineering as a key consumer of the raw data - flagging upstream data quality issues and gaps, and helping shape staging transformations so data arrives in a usable form. Build a thorough testing suite across the data platform: schema tests, data quality checks, anomaly detection, and SLA monitoring so stakeholders can trust what they see. Partner with the client management team to build the value story for quarterly business reviews. Become a domain expert in your assigned area (care operations), translating business logic into accurate, scalable dbt data models. Proactively identify data quality issues, gaps in coverage, and opportunities to improve the reliability and usability of the data platform. Education & Licensure Requirements: Bachelor's degree in Computer Science, Economics, Engineering, Mathematics, or a related quantitative field, or equivalent practical experience. Other Skills or Qualifications: 6+ years of data analysis or related experience with significant experience partnering directly with business stakeholders. Proven ability to turn ambiguous business questions into concrete, governed metric definitions - comfortable leading the discovery conversation with stakeholders rather than just executing a spec. Strong analytical instincts - able to interrogate data, identify anomalies, trace them to their source, and communicate findings clearly to technical and non-technical audiences. Strong SQL proficiency - complex queries, CTEs, window functions, and performance-optimized transformations across large datasets. Hands-on experience with dbt (Core or Cloud) - preferred. Comfortable working within a dimensionally modeled warehouse - facts and dimensions, mart layers, and why transformations are separated into staging, intermediate, and mart layers - even if you haven't owned that architecture from the ground up. Experience creating reporting systems and visualizations; advanced experience with Excel and other data systems. Comfort working alongside ETL/ELT pipelines and partnering with data or software engineers on ingestion. Experience with a BI tool (Omni, Looker, Metabase, or similar), especially defining governed metrics and data products - preferred. Familiarity with healthcare data (clinical, pharmacy, billing, or claims from EHRs, TPAs, or pharmacy operating systems) - preferred. Advanced data modeling experience - designing non-trivial dbt/SQL models that encode real business logic. Experience with R or Python or another scripting language in data analysis work - preferred. Comfort working in ambiguous, fast-moving environments with competing priorities. Here's what we'd like to offer you: Equal investment and support for our people and patients. A fun and ambitious growing environment with a culture that takes on important things, takes risks, and learns quickly. The ability to demonstrate creativity, innovation, and conscientiousness, and find joy in working together. A team of highly skilled, incredibly kind, and welcoming employees, every one of whom has something unique to offer. We know that the overall success of our business is a collaborative effort, and we strive to provide ongoing opportunities for our employees to learn and grow, both personally and professionally. Full-time employees are eligible to participate in our benefits package which includes Medical, Dental, Vision Insurance, Paid time off, Short- and Long-Term Disability, 401k match and more. We are an equal opportunity and affirmative action employer. We embrace diversity and are committed to creating an inclusive environment for all employees. Applicants will be considered for employment without regard to race, religion, gender, gender identity, sexual orientation, national origin, age, disability, or veteran status. Powered by JazzHR 2lXGu4dNqn