Full Stack Data Analytics Engineer
Analytical Skills
Analytics
Artificial Intelligence
Automation Developer
Azure
Azure Data Engineer
Azure Data Factory
Azure Data Platform
Azure Platform
Big Data
Bigdata
Business Analytics
Business Intelligence
Business Intelligence Tools
Cloud
Cloud Data Engineering
Cloud Data Platform
Cloud Engineer
Cloud Platform
Cloud Platforms
Cloud Platforms Cloud Platforms
Data
Data Analysis
Data Analytics
Data Analytics Tools
Data Engineer
Data Engineering
Data Factory
Data Factory Azure
Data Integration
Data Integration Tools
Data Lakehouse
Data Pipeline
Data Platform
Data Processing
Data Visualization
Data Warehouse
Database
Databases
Databricks Lakehouse
Digital Marketing
ETL
Hr Technology
Informatica
Information Technology (IT)
Integration
Microsoft
Microsoft Azure
Microsoft Excel
Microsoft Fabric
Microsoft Office
Microsoft Power Platform
Office 365
Office Tools
Power BI
Power Platform
Power Query
Product Management
Productivity Tools
Programming
Pyspark
Reporting and Analytics
Software Development
Spreadsheets
SQL
Tools
Visual Design
Job Description
Infinium Spirits, Inc. is seeking a hands-on Full Stack Data Analytics Engineer based in San Diego, CA to help build and improve enterprise data and analytics capabilities. In this onsite role, you will develop data pipelines, deliver BI reporting, and automate workflows using the Microsoft data and Power Platform ecosystem, while supporting AI-enabled applications that connect to approved enterprise sources.
If you focus on turning data into dependable decisions for business teams, and you enjoy troubleshooting data quality, integrations, and reporting discrepancies, this position is designed for you.
What you will do
- Develop, maintain, and troubleshoot data pipelines using SQL, Python, and Microsoft Fabric.
- Integrate data from ERP systems, databases, APIs, and external data providers.
- Create and maintain data transformations and structured datasets in Lakehouse environments.
- Support ETL/ELT processes, including incremental data 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.
- Build reporting solutions for Finance, Sales, Supply Chain, and other business functions.
- Support migration of existing reports and datasets to Microsoft Fabric and reconcile reporting discrepancies back to source data.
- Standardize KPIs and business metrics and help ensure accuracy across reporting.
- 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 and repetitive data tasks, including validation and reporting.
- Troubleshoot and improve existing applications and integration workflows.
- Support AI-powered applications and internal knowledge assistants using Retrieval-Augmented Generation (RAG) and Model Context Protocol (MCP), including AI agent exploration for workflow automation and data/document 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, including data mapping, standardization, cleansing, reconciliation, and automated validation checks.
- Investigate master data discrepancies and resolve mapping and integration issues.
- Maintain documentation for data definitions, transformation logic, business rules, and source-to-target mappings, and support data governance practices such as change tracking and data ownership.
- Collaborate with business teams to improve data accuracy, completeness, and reliability, translate requirements into technical solutions, participate in solution design and technical reviews, and communicate project progress, challenges, dependencies, and risks.
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 BI 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 you may work with
- SQL, Python, Microsoft Fabric, Microsoft Power Platform
- Power BI, DAX, Power Query
- Power Apps, Dataverse, 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-assisted development tools, Copilot Studio, Azure OpenAI, AI agents, LLM APIs
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.
- Employee assistance program.
Preferred experience
- 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 enterprise master data (customers, products, distributors, and similar domains).
- Familiarity with data governance concepts such as data lineage, stewardship, validation controls, and certified datasets.
- Exposure to generative AI tools and concepts including Copilot Studio, Azure OpenAI, RAG, AI agents, MCP, and 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, including distributor depletion data, pricing, promotional programs, and distributor allowances (DA).