Junior Developer

SAM, LLC
Centennial, CO, United States
1 day ago
Apply on www.thejobnetwork.com
Prepare application

Role details

Contract type
Franchise
Employment type
Full-time (> 32 hours)
Experience level
Starter
Experience required
2 years minimum
Compensation
$60,000 - $70,000
Working hours
Regular working hours

Tech stack

HTML JavaScript (Programming Language) Microsoft Excel Artificial Intelligence Asana Python (Programming Language) SQL Azure QuickBooks (Software) Microsoft SharePoint SQL Databases Web Pages Microsoft Power Automate
+2 more
Virtual Agents Hubspot

Job description

  • Reporting layer. Azure SQL views that feed our reports, including franchisee territory dashboards and heat maps. You’ll write SQL and help make sure the same metric shows the same number everywhere. \n

  • Dashboards. HTML dashboards, like our Main Franchise Dashboard, that scheduled AI tasks rebuild every day from our data. You’ll help maintain the instruction files behind them and add features such as Excel export. \n

  • Automation. Flows in Power Automate and Make that move data between SharePoint, HubSpot, ClickUp, QuickBooks, and Service Minder. \n

  • Internal tools. Small web pages and AI assistant connectors that let the team ask questions of our data. \n

  • Franchisee support. Preparing clean data for territory reviews and coaching meetings. \n

Requirements

We care more about how resilient you are and how fast you learn than about a perfect checklist, though having experience in these areas will be a great head start in the role, * 2 years of experience or a 4-year degree in a relevant area of study. \n

  • Proficiency with SQL (think SELECT, JOIN, GROUP BY, filtering by date, etc.). \n

  • Basic scripting in Python or JavaScript. \n

  • Comfortability working in Excel.

Benefits & conditions

n \n

  • Write, test, and document SQL queries and views in Azure SQL. \n

  • Build and maintain reports, and troubleshoot refresh and connection problems. \n

  • Maintain our shared metric definitions file, and make sure Power BI measures, SQL views, and HTML dashboards all follow it. \n

  • Build and maintain web based portals for vendor interactions. \n

  • Check data quality by reconciling numbers between source systems, and our HTML dashboards, and flag mismatches. \n

  • Review the output of scheduled AI tasks, and fix the instructions when a number comes out wrong. \n

  • Set up, monitor, and fix automations in Power Automate and Make. \n

  • Help configure integrations and fields in HubSpot, Service Minder, and ClickUp. \n

  • Handle routine admin, such as user permission and group updates across franchise territories. \n

  • Document what you build so someone else can pick it up. \n

\n

\n, * Clear writing and the patience to explain technical things to non-technical coworkers. \n

  • Power BI or DAX. \n

  • Azure SQL or another cloud database. \n

  • HTML and JavaScript for simple web pages. \n

  • Experience writing clear instructions for AI assistants such as Claude, or writing in Markdown. \n

  • REST APIs and JSON. \n

  • Power Automate, Make, or Zapier. \n

  • HubSpot or another CRM. \n

  • Git basics. \n

\n

\n

Why Join Us

\n \n

  • Real ownership of results, with leadership that backs smart, data-driven moves \n

  • A franchise owner-focused and PE-backed growth story with room to build \n

  • Health, dental, vision, and life insurance \n

  • 401(k) with company match \n

  • Paid time off, Monday-Friday schedule \n

\n

Compensation: $60,000-$70,000 base salary. Final pay depends on experience and qualifications.

\n

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.thejobnetwork.com
Prepare application

Good distractions

Loading talks and stories from around this role…