Report Writer

Pharma Logistics

Libertyville (IL)

On-site

USD 75,000 - 110,000

Full time

3 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Pharma Logistics in Libertyville, IL is seeking a Report Writer to design, build, and maintain reports and dashboards on Sigma Computing atop Snowflake. This role leads modernization of the company's reporting to answer key business questions and empower users to explore data independently.

The ideal candidate has 3–5 years in BI/reporting, strong SQL, and experience with modern data stacks. You will collaborate with IT and business teams, establish standards, and train users on self-service

Qualifications

  • 3–5 years of experience in BI/reporting or data analytics.
  • Experience migrating reports to modern BI platforms.
  • Strong SQL and data modeling skills.
  • Familiarity with Sigma Computing and Snowflake.
  • Excellent communication and teamwork.

Responsibilities

  • Partner with stakeholders to define reporting needs and KPIs.
  • Design and maintain reports and dashboards in Sigma Computing.
  • Build self-service workbooks and curated datasets.
  • Write and optimize SQL queries in Snowflake.
  • Define and document business metrics and KPI definitions.

Skills

SQL
Sigma Computing
Data visualization
Communication
Analytical thinking

Education

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

Tools

Sigma Computing
Snowflake
dbt
Fivetran
Tableau

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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Report Writer / Data Analyst (Sigma)
Report Writer / Data Analyst (Sigma)

Zipdev • United States

Remote
USD 90,000 - 130,000
Remote work
Vacation: 10 business days a year
Holidays: 5 National Holidays a year
+7
Remote Sigma BI Report Architect
Remote Sigma BI Report Architect

Zipdev LLC • United States

Remote
USD 90,000 - 130,000
Remote work
Vacation: 10 business days a year
Holidays: 5 National Holidays a year
+7
Business Intelligence Analyst
Business Intelligence Analyst

The Phoenix Group • New York (NY)

On-site
USD 85,000 - 125,000
Report Writer / Data Analyst (Sigma)
Report Writer / Data Analyst (Sigma)

Zipdev • United States

Remote
USD 90,000 - 140,000
Remote work
Vacation days: 10 business days a year
Holidays: 5 National Holidays a year
+9
Power BI / Business Intelligence Analyst
Power BI / Business Intelligence Analyst

Qtsolv • Snowflake (AZ)

On-site
USD 95,000 - 135,000
Data Architect / Engineering Lead
Data Architect / Engineering Lead

Pharma Logistics • Libertyville (IL)

On-site
USD 140,000 - 190,000
BI Report Designer - Self-Service Dashboards
BI Report Designer - Self-Service Dashboards

Pharma Logistics • Libertyville (IL)

On-site
USD 75,000 - 110,000
Omm2967J
Omm2967J

Omm IT Solutions • Rancho Cordova (CA)

Remote
USD 120,000 - 160,000
Remote work
Senior Data Engineer - Snowflake Expert
Senior Data Engineer - Snowflake Expert

The Timberline Group • St. Louis (MO)

On-site
USD 130,000 - 170,000
Medical, Dental & Vision insurance
401(k) with company match
PTO
+5
Business Intelligence Architect
Business Intelligence Architect

nymbusinc • United States

Remote
USD 135,000 - 150,000
Health insurance
Dental insurance
Vision insurance
+5