MANAGER, BUSINESS INTELLIGENCE & DATA ARCHITECTURE

Renew Cannabis Co.; Boca Raton (FL); Hybrid; USD 140,000 - 190,000; Full time

Job summary

Jushi in Boca Raton, FL is seeking a Manager, Business Intelligence & Data Architecture to own the data platforms that guide leadership. You will design the data warehouse, manage pipelines, and write SQL and Python while partnering with Finance, Operations, and executives to deliver trusted insights.

The ideal candidate combines technical building with finance-minded thinking, has 7+ years in data roles, leadership experience, and a track record turning requirements into actionable KPIs and

Qualifications

• Bachelor's degree or equivalent experience in CS/IS/Finance or related field.
• 7+ years in data architecture, data engineering, or BI, with 2+ years leading teams.
• Experience designing/managing an enterprise data warehouse with dimensional modeling.
• Expert SQL and strong Python for automation and integration.
• Advanced Power BI skills: DAX, semantic models, row-level security.
• Experience integrating ERP/GL data with POS and inventory sources.
• Track record turning business and finance requirements into KPIs and dashboards.

Responsibilities

• Own the enterprise data warehouse design using dimensional modeling and solid DB design.
• Build and maintain ETL/ELT pipelines and APIs across POS, ERP, HR, and inventory data.
• Write and optimize production SQL and Python with version control and reviews.
• Establish data governance, dictionaries, lineage, access controls, and documentation.
• Partner with Finance and Accounting across ERP, GL, and related platforms.
• Reconcile data to link warehouse to GL and source systems like POS/inventory.
• Support month-end and quarter-end close with automated data feeds and reports.
• Support system implementations and regulatory reporting with accurate data.
• Translate business objectives into KPIs, dashboards, and analyses with executives.
• Lead Power BI development, dashboards, semantic models, DAX, and security.
• Build executive scorecards by state/location/function; set BI roadmap with leadership.
• Mentor analysts and developers; collaborate with IT and vendors on integrations and security.
• Promote data-driven decision making across the organization.

Skills

SQL

Python

Power BI

ETL/ELT pipelines

Data warehouse design

Leadership

Data governance

Education

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

Tools

Microsoft Fabric

Azure Data Factory/Synapse/Azure SQL

Snowflake

Databricks

NetSuite

Microsoft Dynamics 365

Sage Intacct

Git

CI/CD

Job description

Department: Management

Location: Boca Raton, FL

Commitment: Full-time Exempt

Workplace Type: Hybrid

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