Home › Jobs › Pharma Logistics
Report Writer
Pharma Logistics · Libertyville, Illinois · Posted November 19, 2026 (today)
- Libertyville, Illinois
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.