Data Analyst

Being on medication is tough enough. We want to make getting it the easy part. Getting prescriptions to patients has become increasingly complex. When things get messy along the prescription journey, pharmaceutical manufacturers rely on us to untangle the process and create a clear path—allowing patients to build trusting relationships with their medication brands. 

We’re not only committed to taking the pain out of the prescription process, but we’re also devoted to bringing the brightest minds together under one roof. We bring together diverse voices—engineers, pharmacists, customer service veterans, developers, program strategists and more—all with one vision. Each perspective and experience makes ConnectiveRx better than the sum of its parts. 

Reporting to the Manager of Business Intelligence, the Data Analyst will support client and operations with a variety of data and analytical services. The Data Analyst should be proficient in data cleansing, statistical analysis, data review and visualization, Candidate will need to be able to aggregate and interpret data sources to create meaningful and impactful visual representations. The candidate participates in client deliverables, ad hoc reporting, research, and resolves technical problems.

1. Builds database queries using SQL (or similar tool) to deliver reports and dashboards using tools such as Tableau, Looker, Salesforce, MS Excel for executives, managers, clients, and other stakeholders
2. Maintain or update business intelligence tools, databases, dashboards, systems, or methods
3. Provide technical support for existing reports, dashboards, or other tools.
4. Conduct tests to ensure that data is consistent with defined needs.
5. Other duties as assigned.

• Bachelor's degree in analytics, computer science, economics, mathematics, statistics, or a related field required.
• 2+ years’ experience in an analytics role using SQL & BI tools (ML)
• Intermediate SQL & Excel skills required. Experience with PostgreSQL, AWS, Salesforce or Python a plus.(ML)
• Must understand the business question, design the analytics solution to answer that question, and explain the answer to the client.
• Experience in analytics; querying and managing large data sets.(ML)
• Experience in the pharmaceutical industry or life sciences strongly preferred
• Strong computer & Excel skills required, with knowledge in database-management systems such as Microsoft SQL Server required.
• Intermediate SQL writing skills required which includes complex joins & sub queries.(ML)
• Identify complex problems and review related information to develop and evaluate options and implement solutions.(ML)
• Experience building interactive Dashboards and Reports with a Business Intelligence tool such as PowerBI, Tableau, or Looker required.
• Strong organizational skills: ability to manage multiple projects simultaneously
• Ability to effectively use communication tools to work within a team that is not all located in the same office
• Mindset to continuously learn and develop

Compensation & Benefits:  This position offers opportunities for a bonus (or commissions), with total compensation varying based on factors such as location, relevant skills, experience, and capabilities.   

Employees at ConnectiveRx can access comprehensive benefits, including medical, dental, vision, life, and disability insurance. The company regularly reviews and updates its health, welfare, and fringe benefit policies to ensure competitive offerings. Employees may also participate in the company’s 401(k) plan, with employer contributions where applicable.   

Time-Off & Holidays:  ConnectiveRx provides a flexible paid time off (PTO) policy for exempt employees, covering sick days, personal days, and vacations. PTO is determined based on an employee’s first year of service. Employees also receive eight standard company holidays and three floating holidays annually, with prorations applied in the first year.   

The company remains committed to providing competitive benefits and reserves the right to modify employee offerings, including PTO, STO, and holiday policies, in accordance with applicable laws and regulations.