Sr. Data Analyst
About The Position
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.
Requirements
- Bachelor’s Degree in Database Management, Data Analytics, or similar field.
- 3-5 years’ experience in an analytics role working with large data sets
- 3+ years’ experience with Business Intelligence tool design, required
- 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.
- 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.
- 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.
Nice To Haves
- Master’s Degree a plus.
- Experience in the pharmaceutical industry or life sciences strongly preferred
- Previous client facing role preferred
- 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.
Responsibilities
- 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.
Benefits
- opportunities for a bonus (or commissions)
- medical, dental, vision, life, and disability insurance.
- 401(k) plan, with employer contributions where applicable.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
