MANAGER, BUSINESS INTELLIGENCE & DATA ARCHITECTURE

Jushi; Boca Raton (FL); On-site; USD 140,000 - 190,000; Full time

Job summary

Jushi in Boca Raton, FL seeks a Manager, Business Intelligence & Data Architecture to own the data warehouse, ETL pipelines, and executive dashboards. You will work hands-on writing SQL and Python and lead initiatives across Finance, Operations, and leadership.

The ideal candidate builds a data-driven culture, ensures a single source of truth, and partners with executives to translate goals into measurable KPIs and dashboards.

Qualifications

• Bachelor's degree in CS/IS/Finance or related field.
• 7+ years in data architecture, data engineering, or BI, with 2+ years leading teams or projects.
• Design and manage an enterprise data warehouse with dimensional modeling and ETL/ELT pipelines.
• Expert SQL and strong Python for automation/integration.
• Advanced Power BI skills: semantic models, DAX, Power Query, RLS, governance.
• Experience integrating ERP/financial data with POS/inventory sources.
• Translate business/finance requirements into KPIs, dashboards, and executive insights.

Responsibilities

• Own the design, build, and management of the enterprise data warehouse using dimensional modeling and star schemas.
• Build and maintain ETL/ELT pipelines and APIs that integrate POS, ERP, HR, Retail, Cultivation, Manufacturing, and inventory data.
• Write and optimize production SQL and Python, with version control and performance tuning.
• Establish data governance, including data dictionaries, lineage, access controls, and documentation.
• Partner with Finance and Accounting across ERP, GL, and related platforms.
• Reconcile financial data so warehouse aligns with GL and source systems.
• Support month-end/quarter-end close by automating data feeds and reports.
• Support system implementations, audits, and regulatory reporting with accurate data.
• Translate business objectives into KPIs, dashboards, and analyses with executives.

Skills

Bachelor's degree or higher

7+ years data architecture/BI

Enterprise data warehouse design

SQL proficiency

Python automation

Advanced Power BI (DAX, semantic model

ERP/financial data integration

Education

Bachelor's degree in CS/IS/Finance or related field

Tools

Microsoft Fabric

Azure Data Factory / Synapse

Snowflake

Databricks

ERP systems (NetSuite / D365 / Sage)

Job description

Get to Know Jushi

We identify, evaluate, and acquire U.S.-based cannabis operations within each state to vertically integrate, produce, and distribute medical-grade cannabis formulations in the United States, offering patients and customers premium, high-grade cannabis and related products.

The Opportunity

As the Manager, Business Intelligence & Data Architecture at Jushi, you will own the systems and data that tell leadership how the business is performing. The role sits where three areas meet: financial systems, the enterprise data warehouse, and business insights.

You will design and manage Jushi's data warehouse and database structures, keep financial and operational systems connected and reconciled, and build the dashboards and analyses leadership uses to make decisions. You will work hands-on in code, writing SQL, Python, and pipeline logic, while also partnering with Finance, Operations, and executive leadership as a trusted advisor.

The ideal candidate is a technical builder with a finance-minded view of the business. You understand how a general ledger, a point-of-sale system, and an inventory platform fit together, and you can model that data so it produces one consistent version of the truth. Success means more than delivering reports: it means leaders trust the numbers, understand what drives them, and act on what they see.

WHAT YOU WILL DO

• Own the design, build, and management of Jushi's enterprise data warehouse, using dimensional modeling (star schemas, fact and dimension tables) and sound database design.
• Build and maintain ETL/ELT pipelines and APIs that integrate POS, ERP, HR, Retail, Cultivation, Manufacturing, and inventory data.
• Write and optimize production SQL and Python, applying version control, code review, and performance tuning.
• Establish data governance, including data dictionaries, lineage, access controls, and documentation.
• Serve as the primary data and systems partner to Finance and Accounting across the ERP, general ledger, and related platforms.
• Reconcile financial data so the warehouse ties to the general ledger and to source systems such as POS and inventory.
• Support month-end and quarter-end close by automating data feeds, reconciliations, and recurring financial reports.
• Support system implementations, audits, and regulatory reporting with accurate, well-documented data.
• Partner with executives and department heads to translate business objectives into KPIs, dashboards, and analyses.
• Lead Power BI development, including dashboards, semantic models, DAX, and row-level security, with consistent standards and metric definitions.
• Build executive scorecards that show performance by state, location, and function.
• Support forecasting, budgeting, and planning with statistical and predictive analysis.
• Set the data and BI roadmap and priorities in partnership with leadership.
• Lead, mentor, and develop analysts and developers.
• Partner with IT and vendors on integrations and security, and train business users on self-service reporting.
• Automate manual processes and promote data-driven decision-making across the organization.

WHAT WE ARE LOOKING FOR

Required

• Bachelor's degree in Computer Science, Information Systems, Finance, or a related field, or equivalent experience.
• 7+ years in data architecture, data engineering, or business intelligence, including 2+ years leading a team or major projects.
• Proven experience designing and managing an enterprise data warehouse, including dimensional modeling (star schema) and ETL/ELT pipelines.
• Expert SQL (complex queries, stored procedures, performance tuning) and strong Python for automation and integration.
• Advanced Power BI skills: semantic models, DAX, Power Query, row-level security, and workspace governance.
• Experience integrating ERP and financial data (general ledger, chart of accounts, month-end close) with operational sources such as POS and inventory.
• Track record of turning business and finance requirements into KPIs, dashboards, and executive-ready insights.

Preferred

• Experience with Microsoft Fabric, Azure (Data Factory, Synapse, Azure SQL), Snowflake, or Databricks.
• Hands-on ERP experience, such as NetSuite, Microsoft Dynamics 365, or Sage Intacct.
• Microsoft certifications such as PL-300 (Power BI Data Analyst) or DP-600 (Fabric Analytics Engineer).
• Git and CI/CD practices for data and reporting code.
• Experience in cannabis or another highly regulated, multi-location industry.

CORE COMPETENCIES

• Financial acumen: understands how operational activity flows into financial results.
• Communicates technical work and findings clearly to executives and non-technical users.
• Balances hands-on technical work with team leadership and strategy.
• Holds a high standard for data accuracy, security, and documentation.
• Manages competing priorities in a fast-paced, multi-state environment.

Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties, or responsibilities required of the employee for this position. Duties, responsibilities, and activities may change at any time, with or without notice, based on business needs and organizational priorities.

The employee may also be required to support special projects, system implementations, financial reporting initiatives, and other data or analytics activities as assigned.

Equal Employment Opportunity

Jushi is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, sex, sexual orientation, gender identity or expression, religion, national origin or ancestry, age, disability, marital status, pregnancy, protected veteran status, protected genetic information, political affiliation, or any other characteristics protected by local laws, regulations, or ordinances.

We offer benefit packages that may include Medical, Dental, Vision, Life Insurance, Short- and Long-Term Disability, Flexible Spending Accounts, Paid Time Off, Paid Holidays, and 401(k).