Software Engineer

SOFTWARE ENGINEER, BI & DATALOCATION & REPORTINGLocation: Ogden, UT — On-SiteReports To: VP of SystemsTeam: Systems — EngineeringABOUT HYDROJUG, INC.HydroJug, Inc. is a consumer brand headquartered in Ogden, Utah, designing and selling premium hydration and lifestyle products. We sell direct-to-consumer and through major retail channels including Amazon, Target, Costco, Walmart, and TikTok Shop. Our team is lean, fast-moving, and building infrastructure that scales with the brand.ABOUT THE ROLEEvery team at HydroJug — Finance, Operations, Marketing, Sales — depends on reliable, fast data to make decisions. Today that data flows through a set of internal systems that need an owner: someone who can build and maintain the pipelines that bring data in from source platforms, keep the data warehouse current, and ship the dashboard application features that let the business answer its own questions.As the Software Engineer, BI & Data, you own that full stack. You write the Node.js connectors that pull from ecommerce and operations platforms, maintain the BigQuery data models underneath, and build React-based dashboard features that Finance, Ops, and Marketing run their workflows from. This is a builder role — your work ships, gets used, and directly impacts how the company operates.KEY RESPONSIBILITIESData Pipelines & ETLBuild and maintain Node.js data connectors pulling from source platforms including NetSuite, Shopify, Amazon, TikTok Shop, Walmart, and GorgiasDesign and extend pipeline architecture for reliability, observability, and incremental sync patternsManage watermark-based and event-driven sync strategies to keep the data warehouse currentDebug and resolve sync failures, schema drift, and data quality issues across pipeline runsDashboard ApplicationOwn the React frontend and Node.js backend of the internal dashboard applicationBuild new dashboard features and data views from stakeholder specs across Finance, Ops, Marketing, and SalesMaintain and evolve existing dashboards; ensure data loads fast, refreshes on schedule, and stays accurateBuild self-serve tooling so business users can filter, slice, and export data without engineering supportData Warehouse & SQLWrite performant, well-structured BigQuery SQL that serves as the foundation for dashboard queriesPartner with the Data Lead to design and maintain clean, trusted data modelsMonitor query performance and optimize costs; manage partitioning, clustering, and caching strategiesAI Tooling & IntegrationsBuild and maintain Claude API integrations that support the data team’s workflowsDevelop AI-powered utilities for data validation, anomaly detection, and automated reportingExtend AI tooling as new data sources and business needs emergeREQUIRED QUALIFICATIONS3–6 years of professional software development experience in Node.jsDemonstrated React experience building data-heavy or dashboard-style UIsStrong SQL skills; able to write complex analytical queries with CTEs, window functions, and aggregationsExperience building ETL pipelines or data integration systems connecting third-party APIs to a data warehouseComfort working across the full stack: API connectors, backend services, and frontend data visualizationAbility to translate business requirements into working features without heavy handholdingExperience supporting multiple stakeholder teams simultaneously (Finance, Ops, Marketing, etc.)PREFERRED QUALIFICATIONSBigQuery experience specifically (vs. other cloud data warehouses)Familiarity with ecommerce or retail data domains: orders, inventory, marketing attribution, P&LExperience with the Anthropic Claude API or other LLM integrationsdbt, data modeling, or semantic layer experiencePrior experience at a DTC brand, ecommerce operator, or retail companySUCCESS IN THE FIRST 12 MONTHSAll major data source connectors are stable, monitored, and syncing reliably to BigQueryThe dashboard application has shipped meaningful new features adopted by at least three business teamsData quality issues are caught automatically before they reach end usersBusiness teams across Finance, Ops, and Marketing can self-serve their core reporting needs without filing engineering requestsAI tooling is integrated into at least one repeatable data workflow, reducing manual analyst workHOW TO APPLYApply directly via this posting, or send your resume and a brief note about your background to careers@thehydrojug.com. We review applications on a rolling basis.