Report Writer

Pharma Logistics•Libertyville, IL
•$113,000 - $127,000

About The Position

The Report Writer designs, builds, and maintains reports and self-service dashboards in Sigma Computing on the Snowflake data platform. The role modernizes the organization’s reporting process by moving from static, request-driven reports toward analytics that address business questions and help team members find answers independently. The position partners with business stakeholders to define reporting needs, develops trusted datasets and reporting standards, and supports users in adopting self-service reporting.

Requirements

  • Minimum of 3–5 years of experience in report development, business intelligence, or data analytics.
  • Understanding of Pharma Logistics services, processes, and systems, or ability to quickly learn them.
  • Hands-on experience building dashboards in Sigma Computing or a comparable cloud BI tool such as Tableau, Power BI, or Looker, with willingness to become proficient in Sigma.
  • Strong SQL skills and experience querying and modeling data in Snowflake.
  • Ability to translate business questions into clear, actionable reports and visualizations.
  • Experience designing self-service reporting solutions for non-technical users.
  • Solid understanding of data modeling concepts, including star schema, fact tables, and dimension tables.
  • Strong communication skills and ability to present findings to business and technical audiences.
  • Experience documenting report logic, metric definitions, and data sources.
  • Technical skills in Sigma Computing, including workbooks, datasets, input tables, and row-level security.
  • Technical skills in Snowflake, including SQL, views, warehouses, roles, and access.
  • Advanced SQL skills, including CTEs, window functions, and performance tuning.
  • Knowledge of data visualization and dashboard design best practices.
  • Advanced Microsoft Excel skills.

Nice To Haves

  • Bachelor's degree in Information Systems, Business Analytics, Computer Science, or a related field.
  • Experience migrating reports from legacy tools such as SSRS, Crystal Reports, or Excel to a modern BI platform.
  • Experience with dbt, Fivetran, or other modern data stack tools.
  • Familiarity with ERP or CRM data structures.
  • Knowledge of pharmaceutical or logistics industry data.
  • Ability to prioritize multiple projects within varying deadlines.
  • Ability to work independently as well as in a team.
  • Self-starter who can work in a fast-paced environment.
  • Accuracy and attention to detail.
  • Python (optional).
  • dbt (optional).
  • Git or version control (optional).

Responsibilities

  • Partner with business stakeholders to understand their questions, decisions, and KPIs, and translate those needs into reporting requirements.
  • Design, develop, and maintain reports and interactive dashboards in Sigma Computing.
  • Build self-service workbooks and curated, certified datasets for independent data exploration.
  • Write and optimize SQL queries, views, and reporting data models in Snowflake.
  • Assess existing reports and lead the retirement, consolidation, and migration of legacy reports into Sigma.
  • Establish reporting standards, including naming conventions, visual design guidelines, and trusted data sources.
  • Define and document business metrics and KPI definitions to ensure a consistent version of the truth.
  • Validate data accuracy and reconcile report results against source systems.
  • Monitor dashboard performance and Snowflake query efficiency and cost, tuning as needed.
  • Manage Sigma workspaces, folder structure, and user access and permissions in coordination with IT.
  • Train and support end users on Sigma dashboards and self-service reporting.
  • Collaborate with data engineering and development teams on data pipelines and source data improvements.
  • Resolve help desk cases related to reports and data access.
  • Complete other ad hoc projects and reports.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service