- Страна
- США
- Зарплата
- 95 000 $ – 125 000 $
Откликайтесь
на вакансии с ИИ

IT Business & Data Analyst
Привлекательная вакансия в известном бренде с прозрачной вилкой зарплаты и бонусами. Роль предлагает отличный баланс между техническими задачами и бизнес-аналитикой в быстрорастущей индустрии.
Сложность вакансии
Роль требует сочетания навыков системного администрирования (ERP/CRM) и глубокой аналитики данных (SQL, BI). Средний уровень сложности обусловлен необходимостью работать на стыке бизнеса и IT, а также требованием к опыту от 2 до 5 лет.
Анализ зарплаты
Предложенная зарплата ($95k-$125k) полностью соответствует рыночным ожиданиям для позиции Middle Business/Data Analyst в Сан-Франциско, где средние показатели находятся в этом же диапазоне.
Сопроводительное письмо
I am writing to express my strong interest in the IT Business & Data Analyst position at PAX. With over four years of experience bridging the gap between technical systems and business needs, I have developed a deep mastery of SQL and data visualization tools like Power BI and Tableau. My background in administering ERP and CRM systems, combined with a focus on data integrity, aligns perfectly with your requirement for a functional expert who can also handle complex data pipelines.
Throughout my career, I have excelled at translating stakeholder requirements into technical specifications and building interactive dashboards that drive decision-making for Finance and Operations teams. I am particularly drawn to PAX’s mission of social reform and sustainability through PEACE BY PAX, and I am eager to bring my analytical mindset to a company that values both innovation and community impact. I am confident that my ability to optimize SQL queries and document complex workflows will contribute significantly to your IT team's success.
Составьте идеальное письмо к вакансии с ИИ-агентом

Откликнитесь в paxlabs уже сейчас
Присоединяйтесь к PAX и станьте ключевым звеном между бизнес-процессами и данными в инновационной индустрии!
Описание вакансии
THE COMPANY
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.
ROLE AND 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 / Excel.
- 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.
Qualifications
Technical Skills
- 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.
- Systems Knowledge: Experience administering or configuring ERP, CRM, or HRIS platforms (e.g., Salesforce, NetSuite, Microsoft Dynamics, SAP) is a strong plus.
Analyst Skills
- 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.
Education & Experience
- Bachelor’s degree in Information Systems, Business Administration, or related field.
- 2-5 years of experience in a Business Analyst or Data Analyst role.
COMPENSATION
In addition to the benefits above, the salary for this role is $95,000-125,000, plus the opportunity to participate in the company equity and bonus programs. This represents what we believe, in good faith, this role will pay. The final pay will depend on many factors, including years and depth of experience, level, and location of the employee.
PAX VALUES
- Put Consumers First: We are here to enhance their lives. We put their needs first in everything we do. We work together to deliver unique solutions for their benefit.
- Build a Community: We are active and beneficial builders of a global community. We collaborate together to support sustainability, well-being and social equity efforts—both internally and externally—to establish cannabis as a force for good.
- Innovate with Passion: We are passionate about enhancing the cannabis experience by making it positive, accessible and intuitive. We set the standards, innovate for consumers and find the yes as a team.
- Be the Solution and Collaborate: We work as a team to achieve winning outcomes, knowing we each individually are the solution, but can only succeed together.
- Lead with Humility and Transparency: We stay open and humble in everything we do. We value learning from each other, and cultivate transparency in our culture and products.
We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation.
Создайте идеальное резюме с помощью ИИ-агента

Навыки
- CRM
- Tableau
- SAP
- Excel
- ERP
- Salesforce
- SQL
- Data Visualization
- NetSuite
- Airflow
- Power BI
- Microsoft Dynamics
- UAT
- Boomi
- Celigo
Возможные вопросы на собеседовании
Проверка обязательного навыка владения SQL для работы с базами данных.
Расскажите о самом сложном SQL-запросе или хранимой процедуре, которую вы оптимизировали. С какими проблемами производительности вы столкнулись?
Оценка опыта работы с бизнес-системами, упомянутыми в вакансии.
Был ли у вас опыт настройки или администрирования ERP или CRM систем (например, NetSuite или Salesforce)? Опишите процесс внедрения новой функции.
Проверка способности переводить бизнес-задачи на технический язык.
Как вы подходите к сбору требований у нетехнических стейкхолдеров, когда они сами не до конца понимают, какой отчет или функция им нужны?
Оценка навыков визуализации и работы с данными для принятия решений.
Опишите дашборд, который вы создали и который реально изменил бизнес-процесс или помог принять важное финансовое решение. Какие метрики были ключевыми?
Проверка навыков работы с интеграциями и пайплайнами данных.
Работали ли вы с инструментами интеграции данных, такими как Boomi или Airflow? Как вы обеспечиваете целостность данных при их перемещении между системами?
Похожие вакансии
Middle Product Analyst
Главный аналитик в Центр по управлению технологическими партнерствами
Бизнес/системный аналитик Middle+ Senior
Middle Product Analyst в команду операционной аналитики
Lead Product Analyst
Аналитик AI-агентов
1000+ офферов получено
Устали искать работу? Мы найдём её за вас
Quick Offer улучшит ваше резюме, подберёт лучшие вакансии и откликнется за вас. Результат — в 3 раза больше приглашений на собеседования и никакой рутины!
- Страна
- США
- Зарплата
- 95 000 $ – 125 000 $