Associate Data AnalystCPS Solutions, LLCHome-based/Remote As a full time, exempt
Associate Data Analyst on the Data Products teamyou will play a critical role in data extraction process from different pharmacy systems and build dashboards in Power BI. You will work within Agile framework and utilize Jira ticketing system. Salary Range: $60,000-$80,000 based on experience. MUST be able to work in the United States without restrictions Required Qualifications:
- Bachelor's Degree in a related field
- Understanding of relational database concepts
- Understanding of HIPAA requirements and able to strictly follow them to avoid data breaches
- Able to query database utilizing MySQL and SQL Server
- Proficient in Microsoft office products: MS Word, Outlook, Visio, Excel, PowerPoint and Teams
- Familiar with system version control
- Experience with PowerBI
- Experience with ELT process
- Familiar with AWS and/or Azure cloud.
- Experience with clinical and/or pharmacy domains is nice to have
- Understanding of pharmacy dispensing systems and/or Electronic health record systems preferred
- Familiar working in Agile framework
- MUST be able to work for any employer without restrictions or sponsorship
RESPONSIBILITIES: - Extract data from pharmacy systems.
- Troubleshoot data pull process if required.
- Locate and define new process improvement opportunities.
- Work efficiently within Agile framework and deliver data in timely manner.
- Cooperate with the team members, assist in code troubleshooting, review pull requests of team members if required.
- Work closely with manager and product director to understand and maintain focus on business analytics needs.
- Perform assigned internal and/or external cadence reporting.
- Perform other related duties as assigned.
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 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-DNI