CSI is a rapidly growing national Specialty Pharmacy. Whether you work directly with patients or behind the scenes in support of the business and its employees, you will use your expertise, experience, and skills to support our patients and our mission. 

Summary

CSI Pharmacy is seeking a Data Analyst to support and expand the organization’s analytics capabilities across pharmacy operations, HUB services, and clinical reporting. This role is responsible for designing, developing, and maintaining high- quality analytical datasets, dashboards, and KPI-driven reporting solutions that enable data-driven decision-making.

The Data Analyst will work extensively within Snowflake and Sigma, partnering closely with business stakeholders and data engineering leadership to translate business questions into scalable, reliable analytics assets. This role requires a strong analytical mindset, the ability to work independently, and experience delivering production-ready reporting solutions in a modern cloud data environment.

Salary Range: $80,000 - $95,000/hr (DOE)

Schedule: (Remote) Monday - Friday, 8:30am - 5:00pm in your respective time zone

Location: This position would ideally be located in the Plano/Dallas/Ft. Worth, Texas area; however, this is not a hard requirement

Travel: Approximately once per quarter to our Plano, TX headquarters or potentially Colorado for various team get-togethers and meetings

Essential Duties and Responsibilities

include the following. Other duties may be assigned, as necessary.

Analytics & Reporting Development:

• Design, build, and maintain advanced Sigma workbooks, dashboards, and KPI-based reporting solutions for multiple business units.

• Develop analytical data models, curated tables, and views in Snowflake to support enterprise reporting and ad hoc analysis.

• Write and optimize complex SQL queries utilizing joins, CTEs, window functions, aggregations, and other advanced analytical constructs.

• Ensure reporting solutions are performant, accurate, scalable, and aligned with business definitions.

Data Analysis & Business Partnership:

• Partner with stakeholders to gather requirements, clarify metrics, and translate business needs into actionable analytics solutions.

• Proactively identify data gaps, inconsistencies, and opportunities for enhanced reporting or automation.

• Perform independent data discovery, validation, and exploratory analysis to support operational and strategic initiatives.

• Support root-cause analysis and investigative analytics related to operational performance and data quality issues.

Data Quality, Documentation & Standards:

• Uphold data quality standards and participate in continuous improvement of analytics processes and best practices.

• Maintain clear documentation for data models, transformations, KPI definitions, and reporting logic.

• Contribute to the standardization of metrics, naming conventions, and analytical methodologies across the organization.

Collaboration & Growth:

• Collaborate closely with the Director of Data Engineering on analytics strategy, prioritization, and solution design.

• Work cross-functionally with engineering, operations, and leadership teams to ensure analytics deliverables meet organizational needs.

• Serve as a mentor or knowledge resource for junior analysts as the analytics team grows.

Qualification Requirements

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

• Advanced proficiency in SQL, including complex joins, CTEs, window functions, and performance optimization.

• Strong working knowledge of Snowflake concepts such as schemas, roles, warehouses, tables, and views.

• Hands-on experience with BI and analytics tools (Sigma preferred).

• Demonstrated ability to translate ambiguous business questions into well-defined analytical solutions.

• Strong analytical, problem-solving, and critical-thinking skills.

• Excellent verbal and written communication skills, with the ability to present insights to technical and non-technical audiences.

Education and/or Experience

• Bachelor’s degree in Data Analytics, Computer Science, Information Systems, Mathematics, or a related field preferred.

• 3–5 years of professional experience in data analytics, business intelligence, or reporting roles.

• Proven experience designing analytical datasets and production dashboards in a modern cloud data environment.

• Experience working with Snowflake or similar cloud data platforms strongly preferred.

• Exposure to data modeling concepts and analytics engineering best practices.

Physical Demands

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this job, the employee is regularly required to talk or listen. The employee regularly is required to stand, walk, sit, climb stairs, use hand to finger, handle or feel objects, tools, or controls; and reach with hands and arms.

The employee frequently lifts and/or moves up to 20 pounds. Specific vision abilities required by this job include close vision and the ability to adjust focus.

Work Environment

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

This job generally operates in a clerical office setting. This role routinely uses standard office equipment such as computers, phones, photocopiers, filing cabinets, and fax machines. While performing the duties of this position, the employee may travel by automobile and be exposed to changing weather conditions.

Comments

This description is intended to describe the essential job functions, the general supplemental functions, and the essential requirements for the performance of this job. It is not an exhaustive list of all duties, responsibilities, and requirements of a person so classified. Other functions may be assigned, and management retains the right to add or change the duties at any time.