Home › Jobs › Pharma Logistics

Report Writer

Pharma Logistics · Libertyville, Illinois · Posted November 19, 2026 (today)

Apply on Pharma Logistics’s siteFill the application with AutoFillSee your fit for this role

Job description

Position Title: Report Writer

Job Summary

The Report Writer is responsible for designing, building, and maintaining reports and self-service dashboards in Sigma Computing on the Snowflake data platform. This role leads the modernization of the organization's reporting process, shifting from static, request-driven reports to analytics that answer real business questions and empower team members to find answers on their own.

Job Duties and Responsibilities (Essential Functions)

Partnering with business stakeholders to understand the questions they need answered, the decisions they make, and the KPIs they track, and translating those needs into reporting requirements

Designing, developing, and maintaining reports and interactive dashboards in Sigma Computing

Building self-service workbooks and curated, certified datasets that allow team members to explore data and answer their own questions without IT intervention

Writing and optimizing SQL queries, views, and reporting data models in Snowflake

Assessing the current reporting inventory and leading the retirement, consolidation, and migration of legacy reports into Sigma

Establishing reporting standards, including naming conventions, visual design guidelines, and trusted data sources

Defining and documenting business metrics and KPI definitions to ensure one consistent version of the truth

Validating data accuracy and reconciling report results against source systems

Monitoring dashboard performance and Snowflake query efficiency and cost, tuning as needed

Managing Sigma workspaces, folder structure, and user access and permissions in coordination with IT

Training and supporting end users on Sigma dashboards and self-service reporting

Collaborating with data engineering and development teams on data pipelines and source data improvements

Resolving help desk cases related to reports and data access

Other ad hoc projects & reports

Beneficial Education, Skills and Experience

Bachelor's degree in Information Systems, Business Analytics, Computer Science, or a related field

Experience migrating reports from legacy tools (e.g., SSRS, Crystal Reports, 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 and able to work in a fast-paced environment

Accuracy and attention to detail

Required Education, Skills and Experience

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 (Tableau, Power BI, Looker) with willingness to become proficient in Sigma

Strong SQL skills, with experience querying and modeling data in Snowflake

Demonstrated 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 (star schema, fact and dimension tables)

Strong communication skills, with the ability to present findings to both business and technical audiences

Experience documenting report logic, metric definitions, and data sources

Additional technical skills to include

Sigma Computing (workbooks, datasets, input tables, row-level security)

Snowflake (SQL, views, warehouses, roles and access)

Advanced SQL (CTEs, window functions, performance tuning)

Data visualization and dashboard design best practices

Microsoft Excel (advanced)

Python (Optional)

dbt (Optional)

Git / version control (Optional)

Work Environment

This role operates in an office environment with controlled temperatures. This role routinely uses standard office equipment, such as computer, scanner, printer, telephone, photocopier, and filing cabinets. The noise level in the work environment is usually moderate.

Posting 52 on bamboohr. Source: the employer’s listing. Valid through January 3, 2027 unless closed earlier.