Curaleaf Holdings, Inc. (CSE: CURA) (OTCQX: CURLF) ("Curaleaf") is a leading international provider of consumer products in cannabis, with a mission to improve lives by providing clarity around cannabis and confidence around consumption. As a high-growth cannabis company known for quality, expertise, and reliability, the company and its brands, including Curaleaf and Select provide industry-leading service, product selection, and accessibility across the medical and adult-use markets. In the United States, Curaleaf currently operates in 23 states with 108 dispensaries, 22 cultivation sites, and over 30 processing sites, and employs over 5,000 team members. Curaleaf International is the leading vertically integrated cannabis company in Europe with a unique supply and distribution network throughout the European market, bringing together pioneering science and research with cutting-edge cultivation, extraction, and production.  Home | Curaleaf | Cannabis with Confidence

Our corporate social responsibility is Rooted In Good  Diversity, Equity, Inclusion + Social Equity + Sustainability Social Responsibility | Curaleaf | Cannabis with Confidence We believe in taking corporate and social responsibility very seriously, from our educational outreach to national partnerships, state-wide initiatives and local causes. Giving back to the communities where we operate is important to us, and helps to change old attitudes by showing the positive impact of cannabis in creating jobs, changing lives, and helping local communities.

We educate. We advocate. We give.

The DB Architect will play a critical role within the IT/IS Department.  The candidate must be experienced but still have a passion for learning, mentoring, and collaboration.  Our teams will be small, but experienced and this role will sit at the epicenter of building and managing a data warehouse, supporting custom application data designs, and developing best practices around data governance. 

Essential Duties & Responsibilities:

  • Interact with Management to determine the organization’s data needs, and translate them into systems design.
  • Act as a technical change agent within the Data & Analytics team by advocating best practices.
  • Responsible for architecting and developing data warehouse and reporting based solutions in a SaaS product.
  • Convert business requirements into technical solutions working with the development team to implement.
  • Oversee the migration of data from legacy systems to new solutions.
  • Examine and identify database structural necessities by evaluating performance, systems monitoring, and environment applications
  • Work with our Network/Security Engineers and Systems Architects on infrastructure projects.
  • Identify and help prioritize functional improvements in the SaaS platforms.
  • Contribute to the technical team to assist in delivering a flexible and scalable solution.
  • Provide oversight and mentorship to other team members.
  • Ensure security and data integrity in a HIPAA, PII Compliant systems infrastructure.
  • Ensure SOC / SOX compliance in data processing, warehousing, and reporting.

Minimum Qualifications & Competencies:

  • BS or MS in Computer Science, Information Technology or related field
  • 10 to 15 years of experience with database development using SQL Server or equivalent (Oracle or Teradata).
  • SQL Server, T-SQL, query optimization tools and techniques, data modeling techniques, and relational database design.
  • Good understanding of the features available in Azure SQL Server to achieve a scalable database solution.
  • Strong understanding of Master Data Management, design and implementation.
  • Experience architecting and building Data Warehouses, Data Marts, Data Lakes and Delta Lakes.
  • Experience with Azure Data Factory and Data Bricks.
  • Experience with Azure Service Bus, Azure Event Grid and Azure Event Hub.
  • Various database development technologies, such as SQL Server, SQL Replication, Azure SQL Database, Azure Data Warehouse, including SSMS, SSRS, SSIS / or ETL tools, and OLTP/OLAP.  
  • Understanding of data modeling, data lakes, delta lakes, data warehousing, data-driven insight, data quality, and governance.
  • Experience designing and coding full database solutions for web applications from development to deployment.
  • Experience in hands-on design, prototyping, development, configurations, testing and other implementation activities.
  • Strong technical background, analytical, and problem-solving skills are required.
  • Experience with reporting tools (Power – Bi, Tableau a plus).
  • Experience with master data management tools (Reltio, Informatica) especially Reltio a plus.
  • Ability to work collaboratively within a team environment and capable of delivering under aggressive timelines.
  • Looking for self-motivated candidates who are hands-on at their current positions and have a hunger to learn new technologies.
  • Able to work in a fast-paced, dynamic environment.
  • Capable of incident resolution during a major incident process.
  • Good time management and prioritization skills; self-starters especially welcome.
  • Maturity and ability to take responsibility for gathering additional information on requirements and design to effectively establish testing for the applications and processes.
  • Dedicated to excellence in quality, reliability, and thoroughness in all work tasks; detail-oriented with consistent follow-through.
  • Knowledge of emerging technologies
  • Subject to background check per state cannabis requirements

Nice to have

  • Experience with Mongo, PostgreSQL, NoSQL, Cassandra, working with distributed data models.
  • Experience with Azure Key Vault, Azure Configuration Manager and Azure Blueprints.
  • Graph database experience a plus.
  • Snowflake experience a plus.
  • Logic Apps flow experience.

Curaleaf is committed to creating a diverse environment and is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status.

 

Apply for this Job

* Required
  
  
When autocomplete results are available use up and down arrows to review
+ Add Another Education


U.S. Equal Opportunity Employment Information (Completion is voluntary)

Individuals seeking employment at Curaleaf are considered without regards to race, color, religion, national origin, age, sex, marital status, ancestry, physical or mental disability, veteran status, gender identity, or sexual orientation. You are being given the opportunity to provide the following information in order to help us comply with federal and state Equal Employment Opportunity/Affirmative Action record keeping, reporting, and other legal requirements.

Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiring process or thereafter. Any information that you do provide will be recorded and maintained in a confidential file.

Race & Ethnicity Definitions

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection. As a government contractor subject to Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measure the effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categories is as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.


Form CC-305

OMB Control Number 1250-0005

Expires 05/31/2023

Voluntary Self-Identification of Disability

Why are you being asked to complete this form?

We are a federal contractor or subcontractor required by law to provide equal employment opportunity to qualified people with disabilities. We are also required to measure our progress toward having at least 7% of our workforce be individuals with disabilities. To do this, we must ask applicants and employees if they have a disability or have ever had a disability. Because a person may become disabled at any time, we ask all of our employees to update their information at least every five years.

Identifying yourself as an individual with a disability is voluntary, and we hope that you will choose to do so. Your answer will be maintained confidentially and not be seen by selecting officials or anyone else involved in making personnel decisions. Completing the form will not negatively impact you in any way, regardless of whether you have self-identified in the past. For more information about this form or the equal employment obligations of federal contractors under Section 503 of the Rehabilitation Act, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

How do you know if you have a disability?

You are considered to have a disability if you have a physical or mental impairment or medical condition that substantially limits a major life activity, or if you have a history or record of such an impairment or medical condition.

Disabilities include, but are not limited to:

  • Autism
  • Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, or HIV/AIDS
  • Blind or low vision
  • Cancer
  • Cardiovascular or heart disease
  • Celiac disease
  • Cerebral palsy
  • Deaf or hard of hearing
  • Depression or anxiety
  • Diabetes
  • Epilepsy
  • Gastrointestinal disorders, for example, Crohn's Disease, or irritable bowel syndrome
  • Intellectual disability
  • Missing limbs or partially missing limbs
  • Nervous system condition for example, migraine headaches, Parkinson’s disease, or Multiple sclerosis (MS)
  • Psychiatric condition, for example, bipolar disorder, schizophrenia, PTSD, or major depression

1Section 503 of the Rehabilitation Act of 1973, as amended. For more information about this form or the equal employment obligations of Federal contractors, visit the U.S. Department of Labor's Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.