Full Stack Data Analytics Engineer — San Diego Metropolitan Area

WHO IS dmtVgEhK CxjP9aD?

Founded in 2005, we are a family-owned spirits company with an entrepreneurial edge, blending tradition with the drive to build the next generation of iconic brands. At fhWxP6vc 56bfjNP, we live our values of integrity, ownership, unity, curiosity and gratitude. We hold each other accountable for our results and believe that the company success is based on the whole collective of team members, not individual contributors. There is no room for egos. We are building a team of thought-leaders across the entire company with expertise in sales, marketing, supply chain, business analytics and finance to fuel a diverse and distinctive portfolio of award-winning brands such as Templeton Rye, Tears of Llorona, Howler Head, Zaya Rum, Seagram’s Vodka, and Corralejo Tequila, just to name a few. In addition to our core powerhouse brands, we continue to seek new opportunities in the beverage category to innovate and meet regional needs.

COME WORK WITH US

At fhWxP6vc 56bfjNP, success doesn’t happen between the hours of 9 to 5. We are building a team of hard-working, ambitious professionals who are ready to roll up their sleeves, put in the long hours, and create real impact in the marketplace. We want out-of-the-box thinkers who bring new ways to solve problems to the table, if you excel at escape rooms, are energized by logic problems and believe that anything is possible, you have the ingredients we are seeking on our team. We hire people, NOT resumes. If you think you are right for the role, apply now!

Diversity. Equity. Inclusion. We are committed to creating an inclusive and fair workplace that values diversity. We know that when people feel a sense of belonging, they are more creative, innovative, and successful. We welcome the unique contributions you bring in terms of background, education, opinions, culture, and identity.

THE BAR WE SET

Building brands in the spirits industry at our stage means constant change, high expectations, and a healthy dose of chaos. The people who thrive here are those who own their market, push for results, and stay hungry no matter the challenge. This isn’t the right place for everyone.

ABOUT THE JOB

We are seeking a hands-on Full Stack Data Analytics Engineer to develop, maintain, and enhance enterprise data, analytics, automation, and AI solutions.

You will collaborate with business and technical teams to build reliable data pipelines, develop business intelligence solutions, automate processes using Microsoft Power Platform, and improve data quality and governance.

This role offers opportunities to work across multiple technologies and business functions while contributing to practical solutions that improve operational efficiency and decision-making.

You are curious, motivated, and hands-on. You enjoy learning new technologies, understanding business processes, and finding creative, practical ways to solve problems.

We value a strong work ethic, ownership, problem-solving, attention to detail, clear communication, and a willingness to learn more than deep expertise in any single technology.

ESSENTIAL FUNCTIONS/THE DAY-TO-DAY

Data Engineering & Integration

• Develop, maintain, and troubleshoot data pipelines using SQL, Python, and Microsoft Fabric.

• Integrate data from ERP systems, databases, APIs, and external data providers.

• Build and maintain data transformations and structured datasets in Lakehouse environments.

• Support ETL/ELT processes, incremental data loading, and pipeline monitoring.

• Identify and resolve data inconsistencies, duplicate records, and processing errors.

• Optimize query performance and maintain existing data infrastructure.

Business Intelligence & Analytics

• Develop and maintain Power BI reports, dashboards, and semantic models.

• Create and optimize SQL queries, DAX measures, and Power Query transformations.

• Develop reporting solutions for Finance, Sales, Supply Chain, and other business functions.

• Support the migration of existing reports and datasets to Microsoft Fabric.

• Investigate reporting discrepancies and reconcile results with source data.

• Help standardize KPIs and business metrics.

Automation & Power Apps Development

• Develop lightweight business applications using Microsoft Power Apps, Dataverse, and Copilot-assisted development tools.

• Build and maintain automated workflows using Power Automate and related technologies.

• Develop Python scripts and integrations to automate business processes.

• Automate repetitive data processing, validation, and reporting tasks.

• Troubleshoot and improve existing applications and integration workflows.

AI Applications & Agent Development

• Support the development of AI-powered applications and internal knowledge assistants using Retrieval-Augmented Generation (RAG) and Model Context Protocol (MCP).

• Explore and develop AI agents for workflow automation, document processing, data retrieval, and business support.

• Integrate AI applications with approved enterprise data sources, APIs, and business systems.

Master Data Management & Data Governance

• Maintain and improve master data for customers, products, distributors, and other business dimensions.

• Support data mapping, standardization, cleansing, and reconciliation across source systems.

• Develop and maintain data validation rules and automated data quality checks.

• Investigate master data discrepancies and resolve mapping and integration issues.

• Maintain documentation of data definitions, transformation logic, business rules, and source-to-target mappings.

• Support data governance processes, including change tracking, data ownership, and reporting consistency.

• Collaborate with business teams to improve data accuracy, completeness, and reliability.

Collaboration & Documentation

• Work with business users to understand data and reporting requirements.

• Translate business requirements into practical technical solutions with guidance from the team.

• Participate in solution design discussions and technical reviews.

• Maintain clear documentation of processes, code, dependencies, technical decisions, and business rules.

• Proactively communicate project progress, technical challenges, dependencies, and potential delays.

• Collaborate with team members to improve solutions and support business continuity.

*This is not intended to be a comprehensive list of the duties and responsibilities of the position and that the duties and responsibilities may change without notice.

AM I THE RIGHT FIT?

Not everyone can be a Full Stack Data Analytics Engineer. To be seriously considered for the role here is what you’ll bring:

Education/Licenses/Certifications:

Required

• Bachelor’s degree in Computer Science, Data Science, Business Analytics, Information Systems, or a related discipline, or equivalent practical experience.

Experience

• Minimum 3+ years of professional experience in data engineering, BI development, data analytics, or a related technical role.

• Experience developing or maintaining ETL/ELT pipelines.

• Experience with Power BI or a comparable business intelligence platform.

Preferred

• Experience with Microsoft Fabric, Azure Data Factory, Lakehouse environments, or similar cloud data platforms.

• Experience with PySpark, Power Query, and DAX.

• Experience integrating ERP systems such as Microsoft Dynamics 365 Business Central.

• Experience with Microsoft Power Platform, including Dataverse, Power Apps, and Power Automate.

• Experience working with customer, product, distributor, or other enterprise master data.

• Familiarity with data governance concepts such as data lineage, stewardship, validation controls, and certified datasets.

• Exposure to generative AI, Copilot Studio, Azure OpenAI, RAG, AI agents, MCP, or LLM APIs.

• Familiarity with Git, CI/CD, and DevOps practices.

• Experience with R for statistical analysis or data modeling.

• Experience in the alcoholic beverage industry, particularly liquor and spirits.

• Knowledge of the U.S. three-tier distribution system, distributor depletion data, pricing, promotional programs, and distributor allowances (DA).

Skills/Traits:

• Strong SQL skills, including complex queries, stored procedures, and data transformations.

• Proficiency in Python for data processing, automation, and analytical applications.

• Understanding of data quality, master data management, and basic data governance principles.

• Familiarity with REST APIs and JSON data structures.

• Strong analytical thinking, troubleshooting, and problem-solving skills.

• Ability to learn new technologies and understand business processes.

• Effective communication, collaboration, and technical documentation skills.

Physical Demands:

• Ability to sit and work at a computer for extended periods.

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

If after reading through this long list you’re thinking – I’m not sure if I meet 100% of these requirements, should I still apply? YES – if you embody a growth mindset, see challenges as opportunities to develop, and find smarter (not harder) ways to get the real work that matters done, you sound like our kind of candidate. Regardless of where you come from, how you identify, or the path that led you here – we want to talk to you!

Compensation & Benefits:

• Target salary: $100,000– $120,000 per year (final offer based on experience).

• Competitive benefits package including medical, dental, vision, 401k with 100% vesting, company-paid life insurance, and flexible vacation.

• Monthly wellbeing stipend, professional development opportunities, and employee assistance program.

Before you apply, consider if you can:

• Care deeply about turning data into decisions that help build brands and win in the market

• Drive results by delivering reliable data, reporting, and automation solutions

• Keep pace with weekly—not quarterly—goals and deliverables

• Be resilient and resourceful when things don’t go as planned

• Take ownership instead of pointing fingers at systems, data, or other teams

• Bring sharp thinking, strong opinions, and solutions to the table

• Show up for your business partners every week, making an impact where it matters