SQL Data AnalystRareMed Solutions offers comprehensive support services for specialty, orphan and ultra-orphan products (medicines used to treat exceptionally rare diseases that are chronically debilitating or life-threatening). Our team has a breadth of experience developing and maintaining therapy specific solutions to ensure compliance. RareMed Solutions is the ideal partner for biotech firms and pharmaceutical manufacturers due to our custom solutions that are unique to each of our partner's needs.A SQL Data Analyst at RareMed Solutions will provide strategic and tactical support to the Analytics team and will report directly to the Lead of Analytics and Reporting.
The SQL Analyst will work to develop and distribute reports on a scheduled basis both internally and externally. In addition, the SQL Analyst will work with external partners to collect and load data into the RareMed data warehouse.Responsibilities:Developing and maintaining stored procedures, functions, views and other scripts as necessary to generate dataUtilizing SSIS to generate packages that will clean and import data from external sources as well as export dataIndependently perform root-cause analysis to identify and resolve issues quicklyIdentifying key trends reports for RareMed management and external partners to drive key decisionsWork with management team to define and collect data needed for specific departments and for contractual obligationsWork with management to format internal data into dashboards before sharing externallyUtilizing an internal scheduling software as well as Windows Task Scheduler to ensure data is distributed at appropriate timesTune and modify existing databases as needed to upgrade functionalityRequirements:1 – 3 years of hands-on experience in a SQL based environmentHighly proficient at writing efficient queries, views, indexes, stored procedures and functions within SQL ServerUnderstanding of advanced concepts in relational database managementCapacity to quickly familiarize themselves with new software and technologiesStrong analytical skills with attention to detailAbility to exercise independent judgement to manage data in a high paced environmentNice to have's:Advanced Excel knowledge, including Pivot Tables, Advanced Charts/Graphs, VBA.Experience writing PowerShell scripts and batch files to move/manipulate files as neededPrior experience with report generating technologies (SQL Reporting Services, Crystal Reports etc.)Experience with documenting technical processesPrevious pharmaceutical and/or healthcare experience