CSI Companies-posted 1 day ago
$80,000 - $95,000/Yr
Full-time • Mid Level
Remote
51-100 employees

At CSI Pharmacy (CSI), we are on a mission to provide Specialty Pharmacy services to patients with chronic and rare illnesses in need of complex care. 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

  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service