Sr. 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, Business Intelligence, the Senior Data Analyst is responsible for supporting client and Hub operations. This role requires complex analysis of and in-depth understanding of client functional business processes and data that enable the client’s business to be executed.

The Senior Data Analyst will understand the existing database design (logical/physical) that support complex business processes/applications. The incumbent will use advanced SQL skills to effectively query and navigate across multiple data domains to produce data analysis findings. This includes the ability to use complex joins, subqueries, analytical functions to return clean, comprehensive, and relevant datasets. In addition, the Senior Data Analyst will collaborate with project team members and technical/database leads providing insights into data issues driving business decisions and processing events. 

Description

• Generates standard or custom reports using SQL programming to summarize business, financial, or economic data for review by executives, managers, clients, and other stakeholders.

• Synthesizes current business intelligence or trend data to support recommendations for action.

• Identifies, monitors, & analyzes current and potential trends customers, using Business Intelligence tools for strategic implications.

• Creates/updates databases, builds complex stored procedures (SQL), dashboards, systems, or develop process methods.

• Other duties as assigned
• Prepares reports or correspondence concerning project specifications, activities, or status.
  Consults with customers or other departments on project status, proposals, or technical issues, such as software system design or maintenance.

Education/Degree Requirements/Certifications 

• Bachelor’s Degree in Database Management, Data Analytics, or similar field. Master’s Degree a plus.

Experience  for people management jobs, indicate years required managing people

• 3-5 years’ experience in an analytics role working with large data sets
• 3+ years’ experience with Business Intelligence tool design, required
• Experience in the pharmaceutical industry or life sciences strongly preferred
• Previous client facing role preferred

Knowledge 

• Expertise in data interpretation, forecasting, predictive modeling, and executive presentation.
• Advanced proficiency with reporting tools such as SQL (required), SSRS, and Excel Experience building Dashboards and Reports with a Business Intelligence tool such as PowerBI, Tableau, or Looker required. Experience with PostgreSQL, AWS, Salesforce, or Python a plus.
• Wide-ranging experience building interactive Dashboards and Reports with a Business Intelligence tool such as PowerBI, Tableau, or Looker required.

Skills 

• Proficient working with Microsoft SQL Server or Oracle to establish architecture, build stored procedures & write complex queries (using joins & subqueries)
• Written and oral communication - Must be able to explain complex analytics to a non-technical audience. Supervise and assign work to other analysts
• Complex Problem Solving - Identifying complex problems and reviewing related information to develop and evaluate options and implement solutions
• Critical Thinking - Using logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions, or approaches to problems
• Time Management - Ability to prioritize and execute job tasks in a high-pressure, deadline-driven environment with minimal supervision.

Competencies

• Communication (Oral & Written): Ability to listen actively and communicate key issues respectfully. Understand the need to share only relevant information. Ability to adapt to different audiences, ensuring that the message is clearly articulated.
• Service Orientation: Anticipate, identify, and address the needs of customers/clients, sometimes before those needs are voiced. Actively looks for ways to help people; ability to be thoughtful, empathetic to the needs of others. Is prompt and courteous in ensuring that the customer's immediate needs or complaints are satisfied. Focuses on improving the level of service provided to external and internal customers.
• Technical Utilization: Utilizes the technical knowledge and abilities required in the specialist and professional job function to accomplish the desired outcomes. Demonstrates technical proficiency within the scope of responsibilities. Understands the technical difficulty and complexity of the activity and provides appropriate advice to others. Ability to improve or redesign processes by utilizing technical solutions. Ability to comprehend and perform basic arithmetic.
• Process Knowledge: Identifies, documents, and monitors key processes needed to achieve successful business results. Maps and documents processes. Develops framework for process improvement; Identifies and documents processes within area of responsibility. Seeks guidance on aspects of process that are out of immediate scope. Drafts procedures that comply with the process. Implement process improvement recommendations within the context of overall business processes.
• Decision Quality: Ability to make appropriate, informed and timely decisions while ensuring compliance with company policies, practices and core values. Uses a combination of analysis, knowledge, experience, and judgment to make decisions. Makes effective decisions, even in the absence of complete information. Evaluates and prioritizes factors, weighs decisions in order to reach a sound and effective solution to a problem.

Travel or Physical Requirements 

• Occasional travel to New Jersey, PA, or Pittsburgh offices.

Compliance Requirements

Adhere to all Company Policies, Procedures, and other training consistent with ConnectiveRx's Information Security and Compliance Programs, including but not limited to the following compliances and regulations: SOC1, SOC2, PCI, HIPAA

Maintain strict compliance with company and client policies regarding business rules and ethics, as well as applicable local, state and national federal laws