IT Business and Data Analyst

CoreTechs

San Francisco, CA

Apply

JOB DETAILS

SALARY

$95,000–$125,000 Per Year

SKILLS

Acceptance Testing, Analysis Skills, Apple, Auditing, Business Administration, Business Analysis, Business Intelligence, Business Processes, Business Solutions, Customer Experience, Customer Relationship Management (CRM), Data Analysis, Data Management, Data Processing, Data Quality, Data Visualization, Database Administration, Diversity, Documentation, ERP (Enterprise Resource Planning), English Language, Finance, Financial Analysis, Financial Trend Analysis, Functional Analysis, Functional Testing, Global Branding, HRIS/HRMS, Identify Issues, Information Systems/Technology IS/IT Administration, Looker, Microsoft Dynamics, NetSuite, Power BI, Problem Solving Skills, Procedure Development, Query Optimization, Reporting Dashboards, SAP, SQL (Structured Query Language), SQL Server Reporting Services (SSRS), Sales, Sales Operations, Salesforce.com, Software Administration, Standard Operating Procedures (SOP), Stored Procedures, Sustainability, Systems Administration/Management, Tableau, Team Player, Test Plan/Schedule, Test Requirements, Testing, Vlookups

LOCATION

San Francisco, CA

POSTED

30+ days ago

IT Business & Data Analyst
Location: San Francisco, CA or Remote

Salary: $95,000-125,000

THE COMPANY:

We are 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, we have provided products that are simple, enjoyable, and trusted by millions. We have been recognized for our brand, culture, and products by The New York Times' Wirecutter, TIME, Fast Company, GQ, Gear Patrol, mg Magazine, High Times, and many more. We are committed to making a positive impact through our 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 are 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. We have raised over $430MM in capital from leading consumer and technology investors and are 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
At least 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's 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

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.

We are an equal opportunity employer, and we are an organization that values diversity. We welcome applications from all qualified candidates, including minorities and persons with disabilities.

req26-00246

IT Business and Data Analyst

CoreTechs

San Francisco, CA

About the Company

CoreTechs

Similar Job Searches