Infinium Spirits, Inc. is hiring a hands-on Full Stack Data Analytics Engineer in San Diego, CA (onsite). In this role, you will design and enhance enterprise data and analytics solutions, build data pipelines and BI reporting, automate workflows with the Microsoft Power Platform, and support AI-powered applications using RAG and MCP.
Responsibilities
- 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 loading, and pipeline monitoring.
- Identify and resolve data inconsistencies, duplicate records, and processing errors.
- Optimize query performance and maintain existing data infrastructure.
- Develop and maintain Power BI reports, dashboards, and semantic models.
- Create and optimize SQL queries, DAX measures, and Power Query transformations.
- Deliver reporting solutions for Finance, Sales, Supply Chain, and other business functions.
- Support migration of existing reports and datasets to Microsoft Fabric.
- Investigate reporting discrepancies and reconcile outputs with source data.
- Standardize KPIs and business metrics.
- 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.
- Troubleshoot and improve existing applications and integration workflows.
- Automate repetitive data processing, validation, and reporting tasks.
- Support 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.
- 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.
- Understand business reporting requirements and translate them into practical technical solutions.
- Participate in solution design discussions and technical reviews.
- Maintain clear documentation of processes, code, dependencies, technical decisions, and business rules.
- Communicate project progress, technical challenges, dependencies, and potential delays.
- Collaborate with team members to improve solutions and support business continuity.
Required Qualifications
- Bachelor’s degree in Computer Science, Data Science, Business Analytics, Information Systems, or a related discipline, or equivalent practical 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.
- 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.
- Ability to sit and work at a computer for extended periods.
Technologies
SQL, Python, Microsoft Fabric, Microsoft Power Platform, Power BI, DAX, Power Query, Power Apps, Dataverse, Copilot-assisted development tools, Power Automate, Retrieval-Augmented Generation (RAG), Model Context Protocol (MCP), Lakehouse environments, ERP systems, ETL/ELT, REST APIs, JSON, Microsoft Dynamics 365 Business Central, Azure Data Factory, PySpark, Git, CI/CD, DevOps practices, R, Copilot Studio, Azure OpenAI, AI agents, LLM APIs, RAG
Compensation
$100,000 - $120,000 per year. Final offer is based on experience.
Benefits
- Competitive benefits package including medical, dental, vision, 401k with 100% vesting, company-paid life insurance, and flexible vacation.
- Monthly wellbeing stipend.
- Professional development opportunities.
- Employee assistance program.
Preferred Qualifications
- 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).
Location and Work Model
San Diego, CA (onsite)
