| HIRING NOW::SQL Data Analyst(Pharma EXP)::REMOTE at Remote, Remote, USA |
| Email: [email protected] |
| From: Sam, Adventa Tech Inc [email protected] Reply to: [email protected] Job Description - SQL Data Analyst Exp with Health Data and Pharmacy industry needed Duration : 12+ Months Location: Hybrid in Pittsburgh , PA - Need Locals Remote Can be Possible ! Visa: All visa except opt/cpt MOI: Skype Linkedin Is must.(proper with pic and Exp.). Vendor w=May ask for 1 Manager Ref(With Linkedin ID) MUST HAVE : Exp with Health Data and Pharmacy industry needed need someone local to Pittsburgh, PA . Job Title: SQL Data Analyst Location: Pittsburgh, PA OR REMOTE Summary: We are seeking 1-2 skilled SQL Data Analysts to assist in migrating reports from our current Pharmacy Management System to our new Enterprise Data Warehouse (EDW). The ideal candidates will be able to start immediately and possess a strong background in SQL and moderate experience with Databricks and ADO, particularly within the US healthcare/pharma sector. Key Responsibilities: Migrate existing reports to the Enterprise Data Warehouse SQL experience: Query data, build temporary tables, and perform data aggregation (GROUP BY / HAVING) and ranking rows Work within the Databricks environment to manage data and interface with the EDW Use Azure DevOps (ADO) for managing tickets, code promotion, and work items Collaborate closely with team members to ensure data accuracy and report integrity Required Skills: TOP 4 SQL Expertise: Proficient in writing complex queries, building temporary tables, and working with data aggregates and rankings Databricks Experience: Basic working knowledge of Databricks, with a focus on interfacing with the EDW US Healthcare/Pharma Data Experience: Experience working with Protected Health Information (PHI) Azure DevOps (ADO) experience: Familiarity with using ADO for ticket management and code promotion Preferred Skills: Nice to have / Helpful / Differentiators Azure Data Factory (ADF): Experience with ADF for automating report distribution Python: Ability to use Python for complex data manipulation as an alternative to SQL Pharmacy/Specialty Pharmacy Experience: Prior experience in pharmacy data systems is a big plus Relevant Skills: Software/Technology Years of Experience Date Last Used (MM/YYYY) Overall work exp in IT Exp as a SQL Data Analyst / SQL Report Writer Exp with SQL: Query data, build temp tables, aggregates (group by/having), ranking rows Exp with Databricks Exp with Azure DevOps Exp with Azure Data Factory Exp working with US healthcare data - (PHI Protected Health Information) Exp with Python Experience in the pharmacy/specialty pharmacy industry Keywords: materials management information technology Idaho Pennsylvania HIRING NOW::SQL Data Analyst(Pharma EXP)::REMOTE [email protected] |
| [email protected] View all |
| Fri Aug 09 18:44:00 UTC 2024 |