Sql Data Analyst Ii

The SQL Data Analyst II role is fully remote (or work from our luxury offices in Chicago, Indianapolis, Boston, NYC, Gladstone NJ if preferred).

• Unfortunately, we are not able to provide sponsorship assistance at this time or in the future.***

The primary responsibility of the SQL Data Analyst II is to support our clients through consistent delivery of analytic output files, following standard processes and procedures, and ad hoc analytics dependent on client needs. A successful SQL Data Analyst II is expected to import, clean, and integrate complex healthcare data sets and troubleshoot ETL processes as well as identify areas for process improvement and support improvement initiatives.

Essential functions of the job include but are not limited to:

• Understanding the pharmaceutical industry space and becoming a subject matter expert for our clients and internal teams
• Respond to and fulfill client tickets and requests in a timely manner and with quality
• Contribute to client team meetings for client projects and engagements
• Evaluate appropriateness of data for ad hoc requests and client projects, outlining additional requirements and assumptions as necessary
• Follow, update, and create established procedures and standards as outlined by leadership
• Ensure quality of output by submitting work product for quality checks and reviews and performing similar functions for other Healthcare Data Specialists
• Other duties as assigned
• Contribute code that is well-documented, logical, and easy to follow
• Clean and integrate complex healthcare datasets in order to create the data foundation for further analytics, client applications, and the development of key client insights
• Implement advanced ETL processes to acquire and load large datasets

Qualifications

Minimum Required:

• Experience with relational databases
• Undergraduate degree
• 2 to 5 years industry experience in either data analytics or healthcare

Preferred

• 3 to 7 years industry experience in either data analytics or healthcare
• Evident proficiency and hands-on experience using Microsoft SQL Server
• Undergraduate degree with a quantitative focus
• Descriptive statistics and/or Pharmaceutical/Healthcare industry experience

Skills

• Experience in SSIS is a plus but not required
• Willingness and capacity to learn about the Pharmaceutical industry
• Clear and effective communication; presenting/speaking with stakeholders
• Attention to detail
• Owning the outcome of your work; be accountable
• Demonstrated proficiency in Microsoft Office product suite including PowerPoint, Word, and Excel
• Ability to work remotely
• Demonstrated proficiency in Microsoft SQL Server and T-SQL
• Good time management

Precision is required by law in some states or cities to include a reasonable estimate of the compensation range for this role. This compensation range takes into account the wide range of factors that are considered in making compensation decisions including but not limited to: skill sets, experience and training, licensure and certifications, and other business and organizational needs. The disclosed range estimate has not been adjusted for the applicable geographic differential associated with the location at which the position may be filled. At Precision, it is not typical for an individual to be hired at or near the top of the range for their role and compensation decisions are dependent on the facts and circumstances of each case. This role is also eligible for a discretionary annual bonus, health insurance, retirement savings benefits, life insurance and disability benefits, parental leave, and paid time off for sick leave and vacation, among other benefits.

Reasonable estimate of the current range

$75,000 — $105,000 USD

Any data provided as a part of this application will be stored in accordance with our Privacy Policy. For CA applicants, please also refer to our CA Privacy Notice .

Precision Medicine Group is an Equal Opportunity Employer. Employment decisions are made without regard to race, color, age, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status or other characteristics protected by law. © 2020 Precision Medicine Group, LLC

If you are an individual with a disability and require a reasonable accommodation to complete any part of the application process or are limited in the ability or unable to access or use this online application process and need an alternative method for applying, you may contact Precision Medicine Group at [email protected] .