Sr. Data Analyst

Senior Data AnalystBeing 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.ResponsibilitiesGenerates 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 assignedPrepares 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.QualificationsEducation/Degree Requirements/CertificationsBachelor's Degree in Database Management, Data Analytics, or similar field. Master's Degree a plus.Experience for people management jobs, indicate years required managing people3-5 years' experience in an analytics role working with large data sets3+ years' experience with Business Intelligence tool design, requiredExperience in the pharmaceutical industry or life sciences strongly preferredPrevious client facing role preferredKnowledgeExpertise 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.SkillsProficient 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 analystsComplex Problem Solving - Identifying complex problems and reviewing related information to develop and evaluate options and implement solutionsCritical Thinking - Using logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions, or approaches to problemsTime Management - Ability to prioritize and execute job tasks in a high-pressure, deadline-driven environment with minimal supervision.CompetenciesCommunication (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 RequirementsOccasional travel to New Jersey, PA, or Pittsburgh offices.Compliance RequirementsAdhere 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, HIPAAMaintain strict compliance with company and client policies regarding business rules and ethics, as well as applicable local, state and national federal lawsCompensation & 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.Posted Salary RangeUSD $65,000.00 - USD $94,600.00 /Yr.