Pharma Logistics logo
Salary
$113K–$127K
Hiring from
United States
Work type
Hybrid
Posted

626,236 remote jobs, straight from company career pages

100% free · New jobs every minute

Show 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.

Apply for this job100% free