AgreeYa Solutions
Atlanta, Georgia
Position Title Field Services Team Lead / End User Computing (EUC) Lead Locations Atlanta, GA 30329 Job Description: Technology environment: Microsoft-based end-user computing environment supporting Windows desktops/laptops (fat clients), VDI, and IGEL OS. Primary responsibilities: Lead Field Services support for end-user device deployment, break/fix, ticket queue management and resolution, and customer service for clinical and business users. Team/project focus: Lead team performance and service delivery, monitor ticket/SLA performance, and support project deployment objectives.
Position Title Field Services Team Lead / End User Computing (EUC) Lead Locations Atlanta, GA 30329 Job Description: Technology environment: Microsoft-based end-user computing environment supporting Windows desktops/laptops (fat clients), VDI, and IGEL OS. Primary responsibilities: Lead Field Services support for end-user device deployment, break/fix, ticket queue management and resolution, and customer service for clinical and business users. Team/project focus: Lead team performance and service delivery, monitor ticket/SLA performance, and support project deployment objectives.
Raytheon
Tucson, Arizona
Date Posted: 2026-08-18 Country: United States of America Location: US-AZ-TUCSON- E Hermans Rd BLDG 805 Position Role Type: Onsite U.S. Citizen, U.S. Person, or Immigration Status Requirements: Active and transferable U.S. government issued security clearance is required prior to start date. U.S. citizenship is required, as only U.S. citizens are eligible for a security clearance Security Clearance Type: Secret - Current Security Clearance Status: Active and existing security clearance required on day 1 We're growing fast and we want you to grow with us! We're expanding our engineering organization dramatically to meet exciting customer demand, and we're actively looking for engineers who bring strong foundational skills and a passion for solving hard problems. Industry experience in defense? Not required - we'll invest in you. If you meet the minimum qualifications, we want to talk. Apply today and take the next step in your engineering career. At RTX, the world largest aerospace and defense company, 185,000 great minds are united by purpose and inspired to make a difference solving the world's most complex problems. With our three market leading businesses, world-class operations and investments in research and development, we offer capabilities and opportunity no one else can. Together, we push the boundaries of known science and find new ways to connect and protect our world. Raytheon brings the strength of more than 100 years of experience and renowned engineering expertise to meet the needs of today's mission and stay ahead of tomorrow's threat. We deliver solutions that help our nation and allies defend freedoms and deter aggression, creating a safer, more secure world. Join us and help shape the future of aerospace and defense. Our Senior Embedded Software Engineer is a technical position that works in an Integrated Product Team (IPT) environment to architect, design, implement, test, debug, and deploy Software for Firmware (FPGA) and Hardware solutions that meet current and next generation autonomous avionics systems' needs. Working with a cross-discipline team, the candidate must have experience developing, testing, and integrating software for edge or embedded devices and/or subsystems (like telecom, medical, IoT, automotive, or robotics) where hardware operation, time critical function, functional reliability, mission assurance, and safety might be major concerns. The successful candidate will work with Product Owners, Chief Engineers, Management and other IPT members using Lean and/or Agile practices to ensure that embedded software is designed and developed to reliably operate toward the intended functions. This position is within the Effectors Center of the Software organization, and is an onsite role located in Tucson, AZ. What You Will Do Architecting, designing, implementing, testing, and debugging integrated embedded real-time software within heterogenous systems composed of firmware and hardware. Working within a cross-discipline team to define, refine, and improve product concept, implementation, testability, and guaranteed, measurable quality. Teaching, coaching, and mentoring less experienced staff. Contributing to proposals as well as preliminary and critical design reviews. Ability to obtain program access. What You Will Learn Working across a product line in collaboration with other teams. Qualifications You Must Have Typically requires a degree in Science, Technology, Engineering or Mathematics (STEM) and a minimum of 5 years of prior relevant experience. Experience including at least two of the following: Embedded C++ Software, Embedded Software Security, Software Architecture Design and Implementation. Experience using embedded Real Time Operating Systems (RTOS) (e.g., Green Hills, Integrity, Wind River VxWorks, Linux, etc.) Experience developing complex systems involving the integration of hardware, firmware, and software Active and transferrable final Secret U.S. government issued security clearance is required prior to start date with the ability to obtain program access after start. Qualifications We Prefer Familiarity with reading electrical schematics and relating it to software function Familiarity with reading firmware source like VHDL or Verilog Familiarity with assembly language in at least one processor/controller family Experience using lab instruments like power-supplies, digital multi-meters, oscilloscopes, and logic analyzers Experience with developing device drivers for bare-metal and/or OS applications What We Offer Our values drive our actions, behaviors, and performance with a vision for a safer, more connected world. At RTX we value: Safety, Trust, Respect, Accountability, Collaboration, and Innovation. Relocation Offered Based On Eligibility Learn More & Apply Now! Please consider the following role type definition as you apply for this role: Onsite: Employees who are working in Onsite roles will work primarily onsite. This includes all production and maintenance employees, as they are essential to the development of our products. Clearance Information: This position requires a security clearance. DCSA Consolidated Adjudication Services (DCSA CAS), an agency of the Department of Defense, handles and adjudicates the security clearance process. More information about Security Clearances can be found on the US Department of State government website here: Location Information: This position is onsite at our campus in beautiful Tucson, AZ. Tucson has a friendly, caring, and laid-back atmosphere, combined with the innovation and energy of a metropolitan region, and recognized as one of America's 10 Best Small Cities. Surrounded by beautiful mountains, colorful Sonoran Desert landscape and majestic saguaro cacti, Tucson is blessed with some of nature's best work. Tucson is known for its bright blue skies, and with more than 310 sunny days per year, Tucson's fantastic weather lets residents enjoy the outdoors year-round. Virtual Fly Over City of Tucson & Community, YouTube Video Links "Raytheon In Tucson": ,-az-location "Tucson is Awesome": "Winter in Tucson": As part of our commitment to maintaining a secure hiring process, candidates may be asked to attend select steps of the interview process in-person at one of our office locations, regardless of whether the role is designated as on-site, hybrid or remote. The salary range for this role is 86,800 USD - 165,200 USD. The salary range provided is a good faith estimate representative of all experience levels. RTX considers several factors when extending an offer, including but not limited to, the role, function and associated responsibilities, a candidate's work experience, location, education/training, and key skills. Hired applicants may be eligible for benefits, including but not limited to, medical, dental, vision, life insurance, short-term disability, long-term disability, 401(k) match, flexible spending accounts, flexible work schedules, employee assistance program, Employee Scholar Program, parental leave, paid time off, and holidays. Specific benefits are dependent upon the specific business unit as well as whether or not the position is covered by a collective-bargaining agreement. Hired applicants may be eligible for annual short-term and/or long-term incentive compensation programs depending on the level of the position and whether or not it is covered by a collective-bargaining agreement. Payments under these annual programs are not guaranteed and are dependent upon a variety of factors including, but not limited to, individual performance, business unit performance, and/or the company's performance. This role is a U.S.-based role. If the successful candidate resides in a U.S. territory, the appropriate pay structure and benefits will apply. RTX anticipates the application window closing approximately 40 days from the date the notice was posted. However, factors such as candidate flow and business necessity may require RTX to shorten or extend the application window. RTX is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability or veteran status, or any other applicable state or federal protected class. RTX provides affirmative action in employment for qualified Individuals with a Disability and Protected Veterans in compliance with Section 503 of the Rehabilitation Act and the Vietnam Era Veterans' Readjustment Assistance Act. Privacy Policy and Terms: Click on this link to read the Policy and Terms
Date Posted: 2026-08-18 Country: United States of America Location: US-AZ-TUCSON- E Hermans Rd BLDG 805 Position Role Type: Onsite U.S. Citizen, U.S. Person, or Immigration Status Requirements: Active and transferable U.S. government issued security clearance is required prior to start date. U.S. citizenship is required, as only U.S. citizens are eligible for a security clearance Security Clearance Type: Secret - Current Security Clearance Status: Active and existing security clearance required on day 1 We're growing fast and we want you to grow with us! We're expanding our engineering organization dramatically to meet exciting customer demand, and we're actively looking for engineers who bring strong foundational skills and a passion for solving hard problems. Industry experience in defense? Not required - we'll invest in you. If you meet the minimum qualifications, we want to talk. Apply today and take the next step in your engineering career. At RTX, the world largest aerospace and defense company, 185,000 great minds are united by purpose and inspired to make a difference solving the world's most complex problems. With our three market leading businesses, world-class operations and investments in research and development, we offer capabilities and opportunity no one else can. Together, we push the boundaries of known science and find new ways to connect and protect our world. Raytheon brings the strength of more than 100 years of experience and renowned engineering expertise to meet the needs of today's mission and stay ahead of tomorrow's threat. We deliver solutions that help our nation and allies defend freedoms and deter aggression, creating a safer, more secure world. Join us and help shape the future of aerospace and defense. Our Senior Embedded Software Engineer is a technical position that works in an Integrated Product Team (IPT) environment to architect, design, implement, test, debug, and deploy Software for Firmware (FPGA) and Hardware solutions that meet current and next generation autonomous avionics systems' needs. Working with a cross-discipline team, the candidate must have experience developing, testing, and integrating software for edge or embedded devices and/or subsystems (like telecom, medical, IoT, automotive, or robotics) where hardware operation, time critical function, functional reliability, mission assurance, and safety might be major concerns. The successful candidate will work with Product Owners, Chief Engineers, Management and other IPT members using Lean and/or Agile practices to ensure that embedded software is designed and developed to reliably operate toward the intended functions. This position is within the Effectors Center of the Software organization, and is an onsite role located in Tucson, AZ. What You Will Do Architecting, designing, implementing, testing, and debugging integrated embedded real-time software within heterogenous systems composed of firmware and hardware. Working within a cross-discipline team to define, refine, and improve product concept, implementation, testability, and guaranteed, measurable quality. Teaching, coaching, and mentoring less experienced staff. Contributing to proposals as well as preliminary and critical design reviews. Ability to obtain program access. What You Will Learn Working across a product line in collaboration with other teams. Qualifications You Must Have Typically requires a degree in Science, Technology, Engineering or Mathematics (STEM) and a minimum of 5 years of prior relevant experience. Experience including at least two of the following: Embedded C++ Software, Embedded Software Security, Software Architecture Design and Implementation. Experience using embedded Real Time Operating Systems (RTOS) (e.g., Green Hills, Integrity, Wind River VxWorks, Linux, etc.) Experience developing complex systems involving the integration of hardware, firmware, and software Active and transferrable final Secret U.S. government issued security clearance is required prior to start date with the ability to obtain program access after start. Qualifications We Prefer Familiarity with reading electrical schematics and relating it to software function Familiarity with reading firmware source like VHDL or Verilog Familiarity with assembly language in at least one processor/controller family Experience using lab instruments like power-supplies, digital multi-meters, oscilloscopes, and logic analyzers Experience with developing device drivers for bare-metal and/or OS applications What We Offer Our values drive our actions, behaviors, and performance with a vision for a safer, more connected world. At RTX we value: Safety, Trust, Respect, Accountability, Collaboration, and Innovation. Relocation Offered Based On Eligibility Learn More & Apply Now! Please consider the following role type definition as you apply for this role: Onsite: Employees who are working in Onsite roles will work primarily onsite. This includes all production and maintenance employees, as they are essential to the development of our products. Clearance Information: This position requires a security clearance. DCSA Consolidated Adjudication Services (DCSA CAS), an agency of the Department of Defense, handles and adjudicates the security clearance process. More information about Security Clearances can be found on the US Department of State government website here: Location Information: This position is onsite at our campus in beautiful Tucson, AZ. Tucson has a friendly, caring, and laid-back atmosphere, combined with the innovation and energy of a metropolitan region, and recognized as one of America's 10 Best Small Cities. Surrounded by beautiful mountains, colorful Sonoran Desert landscape and majestic saguaro cacti, Tucson is blessed with some of nature's best work. Tucson is known for its bright blue skies, and with more than 310 sunny days per year, Tucson's fantastic weather lets residents enjoy the outdoors year-round. Virtual Fly Over City of Tucson & Community, YouTube Video Links "Raytheon In Tucson": ,-az-location "Tucson is Awesome": "Winter in Tucson": As part of our commitment to maintaining a secure hiring process, candidates may be asked to attend select steps of the interview process in-person at one of our office locations, regardless of whether the role is designated as on-site, hybrid or remote. The salary range for this role is 86,800 USD - 165,200 USD. The salary range provided is a good faith estimate representative of all experience levels. RTX considers several factors when extending an offer, including but not limited to, the role, function and associated responsibilities, a candidate's work experience, location, education/training, and key skills. Hired applicants may be eligible for benefits, including but not limited to, medical, dental, vision, life insurance, short-term disability, long-term disability, 401(k) match, flexible spending accounts, flexible work schedules, employee assistance program, Employee Scholar Program, parental leave, paid time off, and holidays. Specific benefits are dependent upon the specific business unit as well as whether or not the position is covered by a collective-bargaining agreement. Hired applicants may be eligible for annual short-term and/or long-term incentive compensation programs depending on the level of the position and whether or not it is covered by a collective-bargaining agreement. Payments under these annual programs are not guaranteed and are dependent upon a variety of factors including, but not limited to, individual performance, business unit performance, and/or the company's performance. This role is a U.S.-based role. If the successful candidate resides in a U.S. territory, the appropriate pay structure and benefits will apply. RTX anticipates the application window closing approximately 40 days from the date the notice was posted. However, factors such as candidate flow and business necessity may require RTX to shorten or extend the application window. RTX is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability or veteran status, or any other applicable state or federal protected class. RTX provides affirmative action in employment for qualified Individuals with a Disability and Protected Veterans in compliance with Section 503 of the Rehabilitation Act and the Vietnam Era Veterans' Readjustment Assistance Act. Privacy Policy and Terms: Click on this link to read the Policy and Terms
Summit Pharmacy Solutions LLC
Milwaukee, Wisconsin
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
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
Summit Pharmacy Solutions LLC
Milwaukee, Wisconsin
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
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
