IT Business & Data Analyst

PAX Labs•San Francisco, CA

2d•$95,000 - $125,000

About The Position

PAX is a leading global cannabis brand on a mission to enhance people’s lives, delivering well-being through pure products, unique experiences, and an unparalleled passion for the plant. For more than a decade, PAX has provided products that are simple, enjoyable, and trusted by millions. PAX has been recognized for its brand, culture and products by The New York Times’ Wirecutter, TIME, Fast Company, GQ, Gear Patrol, mg Magazine, High Times, and many more. PAX is committed to making a positive impact through PEACE BY PAX, its purpose-driven platform supporting social reform, safe access and sustainability. We are incredibly excited about the progress of the movement, the tremendous growth of the industry, and inspired every day by our opportunity to help change lives through cannabis. Our culture is focused on putting people at the center of everything we do, making an impact together, and having fun along the way. Our team has an unparalleled passion for the plant and has helped build business at the forefront of consumer experience and well-being, including Apple, Google, Uber, Fitbit, Constellation, Honest Company, Beauty Counter, Eaze, Curaleaf, Wyld and more. PAX has raised over $430MM in capital from leading consumer and technology investors and is available for sale in some capacity in more than 40 countries around the world. Summary We are seeking a functional and analytical IT professional to join our team. This role sits at the intersection of business processes, data and business intelligence. You will be an expert on our core business systems, configuring them to meet business needs, testing updates and implementing new features and functionality. You will also be integral to our data and business intelligence stack including building reports and moving data between systems and databases.

Requirements

SQL Mastery: Strong hands-on experience writing SQL queries, Views, and Stored Procedures is mandatory . You must be comfortable working directly with the database.
Data Visualization: Proven experience building reports in Power BI, Tableau, Looker, or SSRS .
Excel: Advanced proficiency (PivotTables, VLOOKUP, XLOOKUP) for quick ad-hoc analysis.
Communication: Ability to explain complex data or system logic to non-technical users in plain English.
Documentation: Experience writing standard operating procedures (SOPs), functional requirements, and test plans.
Problem Solving: A logical mindset for troubleshooting system errors or data discrepancies.
Bachelor’s degree in Information Systems, Business Administration, or related field.
2-5 years of experience in a Business Analyst or Data Analyst role.

Nice To Haves

Systems Knowledge: Experience administering or configuring ERP, CRM, or HRIS platforms (e.g., Salesforce, NetSuite, Microsoft Dynamics, SAP) is a strong plus.

Responsibilities

Data & Business Intelligence Write and optimize SQL queries to extract data from our ERP, CRM, and other business systems.
Design and maintain interactive dashboards using tools like Power BI / Tableau / Exce l .
Analyze data trends to help department heads (Finance, Sales, Ops) make informed decisions.
Ensure data integrity by regularly auditing reports against source systems.
Implement data pipelines using tools such as Boomi, Celigo or Airflow.
Business Analysis & Requirements (The "Ask") Meet with stakeholders to understand their pain points and document requirements for new system features or reports.
Create process flowcharts and documentation to map out current business workflows.
Translate business requests into technical specifications for vendors or database administrators.
System Configuration & Support (The "Software") Serve as the functional expert for our core applications (e.g., managing user permissions, configuring workflows, or adding custom fields).
Perform User Acceptance Testing (UAT) for system upgrades or new implementations to ensure nothing breaks.
Provide support for complex application issues that require data investigation or logic analysis.