Remote

Senior Data Engineer

CPS Solutions, LLC
$120,000-$140,000 depending on experience plus bonus potential
life insurance, vision insurance, 401(k)
United States
Apr 01, 2025
Senior Data Engineer CPS Solutions Home-based/remote The full time, exempt Senior Data Engineer will workwith engineering leadership, clients, and product to ensure deliverable commitments are met. You will serve as a client-facing technical resource responsible for the implementation, support, optimization and/or upgrade of data solutions. You will perform as a Technical Lead resource for your development teams. Salary Range: $120,000-$140,000 depending on experience plus bonus potential Must be able to work in the US without sponsorship or restrictions Primary Responsibilities: * Key member of data engineering team developing and maintaining an Enterprise Outpatient Reporting (EOR) data warehouse. This includes designing and building data ingestion and transformation pipelines using Azure Data engineering tools, performing unit testing and coordinating with QA tester in lower environments (Development, Quality Assurance and Staging * Assisting with building automated test procedures to validate ETL and data alignment between source/target * Ensure best practices for both Data and Systems Engineering processes are followed. * Assisting with troubleshooting production support issues, prioritizing and working to implement fixes. Required Qualifications: Bachelor's degreein computer science or a related field, or in lieu of degreerelated experience and education 5+ years of experience building, running, and deploying systems in a production environment Strong technical Data Engineering leadership experience with onshore and offshore teams Strong SQL skills - Ability to profile data, verify data movement, validate data matches. Experience in working with large enterprise databases. Azure SQL managed instance experience is desired. Strong proficiency with Azure Data Engineering tools and the Data Ingestion process to include Azure Data Factory (ADF), Data Lake Storage, Delta Lake, Databricks Familiar with best practices for data flow patterns for data ingestion into Data warehouse including progression through Staging, ODS and Data Warehouse (Dims/Facts) schemas Experienced handling Production data loads and designing error handling and alerting into all steps to best support Experience with data retention/archiving policies and procedures Experience with both event triggers and schedule triggers to trigger pipeline start Experience ingesting from SQL and file-based sources, with Azure blob storage exp Experience with git version control on projects with multiple developers Experience with the Agile software methodology Specialty Pharmacy and/or Healthcare experience preferred; aptitude for acquiring strong industry knowledge Ability to work under pressure, organize and prioritize responsibilities Ability to quickly grasp complex technical and business concepts and express them in clear language Self-motivated with the ability to work independently as well as part of a team Effective communication skills (both written and verbal) with internal and external clients Benefits: All employees enjoy a competitive salary, eligibility to participate in the 401(k) savings plan with a match. Full Time employees are also eligible for a comprehensive benefits package, including Medical, Dental and Vision Insurance, Time Off Plan, Company Paid Short- and Long-Term Disability, Basic and Supplemental Life Insurance, Medical Flex and Dependent Care Accounts and more. CPS Requirements: All employment offers are contingent upon successfully passing a pre-employment (post offer) background check, drug test and signed onboarding documents. Additionally, you may be required to provide medical records or have additional medical examinations/background checks that are a specific requirement of the location or position in which you are hired. This applies to internal transfers and status changes for internal CPS team members. CPS is also committed to a safe and drug free workplace. The use of marijuana for medical purposes accompanied by a prescription, even if permitted by state law, will not be considered acceptable for purposes of explaining a positive lab test result for marijuana. About CPS: Founded nearly 50 years ago and employing over 2,500 clinical, regulatory, and operational pharmacy professionals, CPS Solutions, LLC, is one of the nation's largest providers of pharmacy services to more than 800 hospitals and healthcare facilities nationwide. CPS helps clients tackle a variety of complex issues, such as operational efficiency, rising drug costs, regulatory & compliance, 340B, and specialty pharmacy strategy. CPS helps healthcare leaders drive best in class pharmacy operations through skill, expertise and proprietary technologies. For more information, visit https://www.CPS.com. We are an Equal Opportunity Employer and do not discriminate against any qualified employee or applicant for employment because of race, color, sex, age, national origin, ancestry, religious creed, sexual orientation, gender identity and/or expression, status as a veteran, mental or physical disability or any other federal, state or local protected class #LI-remote #CA-PC1