Data Architect - Data Services & Enterprise Data Warehouse (Remote)

Job Description

Data Architect - Data Services & Enterprise Data Warehouse

Overview:

Weedmaps’ mission is to power a transparent and inclusive global cannabis economy. Through our industry-leading marketplace, we connect the cannabis market’s highest value and intent consumers with the best dispensaries and brands in the world and provide cannabis retailers with the suite of operational tools they need to efficiently run their businesses.

Weedmaps is looking for a hands-on Sr. Data Architect to lead the design, architecture and implementation of our enterprise data warehouse and OLTP databases. You will also assist in database administration, data quality and data governance.

The impact you'll make:

• Lead the design, architecture and implementation of our enterprise data warehouse
• Serve as a hands-on data warehousing, database, OLAP/BI, SQL and ETL subject matter expert and thought leader
• Assist in database administration, data governance, data quality, master data management, metadata management and other database-related tasks.
• Perform technology and product assessments to drive required infrastructure needs to meet scalability, availability, security and concurrency needs.
• Cross team collaboration with Product, Analytics and Engineering teams, participate in all phases of SDLC - product requirement gathering, design, development and support.

What you've accomplished:

• 5+ years experience as a hands-on senior or lead data warehouse architect
• 10+ years of experience in designing and implementing data warehouses.
• 10+ years of combined experience in dimensional modeling, OLAP, SQL, business intelligence, database management, big data, ETL, data engineering, etc.
• Extensive experience in data governance, data quality, master data management, metadata management, data security, data management, etc.
• Experience in database administration, monitoring, tuning, backup and recovery, security, etc.
• Project management and agile software development experience (PMI, Scrum, Kanban, etc.)
• Experience building data integration pipelines, familiarity with ETL, ELT, Change Data Capture (CDC), Streaming and other data processing patterns.
• Experience with Airflow or similar workflow management solutions.
• Coding proficiency in at least one modern programming language, Python preferred.
• Experience with AWS, solid understanding of cloud data services offered and ability to recommend cost effective solutions in and out of the box
• Strong knowledge of various relational and non-relational database systems (Postgres, ElasticSearch, Redshift, MongoDB, Snowflake, etc), experience with structured and semi structured data.
• Familiar with big data frameworks and platforms (Databricks, Apache Spark, Hadoop, etc.)
• Experience with ETL/ELT tools such as Informatica, Talend, Fivetran, Matillion, etc.
• Experience with streams and event driven patterns is a plus.
• Excellent documentation and communication skills.
• Familiar with compliance requirements such as GDPR, CCPA, HIPAA, etc.

Our Benefits:

• 100% paid employee monthly Medical, Dental and Vision premiums AND 80% paid dependent monthly premiums
• HMO (California residents only) and PPO option offered through United Healthcare
• Company-paid $50,000 in Basic Life/AD&D (Accidental Death and Dismemberment) coverage
• 401(k) Retirement Plan: 100% match on the first 1%. 50% match from 2-6% of employee contributions
• 3 weeks PTO (accrued) and 5 sick days (immediate)
• Supplemental, voluntary benefits
• Kindbody (family planning/fertility) including up to $10,000 towards cash-pay services
• Goodly (Student Loan Repayment/529 Education Savings) including a company contribution of up to $1,000/year
• Flexible Spending Accounts (Medical, Dependent, Transit and Parking)
• Voluntary Life Insurance
• Critical Illness
• Accident Insurance
• Short- and long-term disability
• Pet Insurance
• Paid parental leave
• During current work-from-home:
• Reimbursements for home office setup and monthly WiFi

Our Culture:

• 11 company-paid holidays
• Catered lunch and snacks provided when working in the office
• Snack boxes sent straight to your door when you work-from-home
• Casual work environment, read no fancy clothes required, but you are free to dress to the nines!
• Monthly virtual happy hours
• Quarterly all-hands meetings

Weedmaps is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, gender expression, national origin, protected veteran status, or any other basis protected by applicable law, and will not be discriminated against on the basis of disability. We are looking for the smartest and most passionate people who want to join our team and develop the services, systems, and marketplaces that will serve the marijuana industry in the decades to come. Our company uses E-Verify to confirm the employment eligibility of all newly hired employees. To learn more about E-Verify, including your rights and responsibilities, please visit www.dhs.gov/E-Verify .

About Weedmaps:

Founded in 2008, Weedmaps is a leading technology and software infrastructure provider to the cannabis industry. Our suite of cloud-based software and data solutions includes point of sale, logistics and ordering solutions that enable customers to scale their businesses while complying with the complex and disparate regulations applicable to the cannabis industry. In addition, our platform provides consumers with information regarding cannabis products across web and mobile platforms, including listing local retailers and brands, facilitating product discovery and allowing consumers to educate themselves on cannabis and its history, uses and legal status. Headquartered in Irvine, California, Weedmaps employs more than 400 professionals around the world, with offices including Barcelona, Denver, and Toronto.

So what are you waiting for? Join the Weedmaps family!