Junior Developer — Centennial, CO
Зарплата не указана
ОткликнутьсяTitle: Junior Developer | Database & Website Management
Location: Centennial, CO (Hybrid) · Full-time
About pJE 5fb K4F3m4yN qgY
Since 1989, homeowners have trusted pJE 5fb K4F3m4yN qgY for driveways, patios, and walkways built to last. Today we're a franchisor guiding 130+ territories in 39 states to profitability, and we're still growing. Our franchise owners are local business owners who care about quality work and their communities. Everything we do at the home office is built to help them succeed.
TD2 U92z
We're hiring a junior developer to join our growing data team. You'll learn how a franchise business measures itself, following a lead from the first call or ad click through estimates and proposals in Service Minder to the revenue on a franchisee's dashboard. You'll own small projects early, and you'll have backup while you learn.
What you will work on
• 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.
• 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.
• Automation. Flows in Power Automate and Make that move data between SharePoint, HubSpot, ClickUp, QuickBooks, and Service Minder.
• Internal tools. Small web pages and AI assistant connectors that let the team ask questions of our data.
• Franchisee support. Preparing clean data for territory reviews and coaching meetings.
Responsibilities
• Write, test, and document SQL queries and views in Azure SQL.
• Build and maintain reports, and troubleshoot refresh and connection problems.
• Maintain our shared metric definitions file, and make sure Power BI measures, SQL views, and HTML dashboards all follow it.
• Build and maintain web based portals for vendor interactions.
• Check data quality by reconciling numbers between source systems, and our HTML dashboards, and flag mismatches.
• Review the output of scheduled AI tasks, and fix the instructions when a number comes out wrong.
• Set up, monitor, and fix automations in Power Automate and Make.
• Help configure integrations and fields in HubSpot, Service Minder, and ClickUp.
• Handle routine admin, such as user permission and group updates across franchise territories.
• Document what you build so someone else can pick it up.
Qualifications
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.
• Proficiency with SQL (think SELECT, JOIN, GROUP BY, filtering by date, etc.).
• Basic scripting in Python or JavaScript.
• Comfortability working in Excel.
• Clear writing and the patience to explain technical things to non-technical coworkers.
• Power BI or DAX.
• Azure SQL or another cloud database.
• HTML and JavaScript for simple web pages.
• Experience writing clear instructions for AI assistants such as Claude, or writing in Markdown.
• REST APIs and JSON.
• Power Automate, Make, or Zapier.
• HubSpot or another CRM.
• Git basics.
Why Join Us
• Real ownership of results, with leadership that backs smart, data-driven moves
• A franchise owner-focused and PE-backed growth story with room to build
• Health, dental, vision, and life insurance
• 401(k) with company match
• Paid time off, Monday–Friday schedule
Compensation: $60,000–$70,000 base salary. Final pay depends on experience and qualifications.
Apply by: November 30, 2026
pJE 5fb K4F3m4yN qgY is an equal opportunity employer. We welcome people from all backgrounds, and we don't tolerate discrimination or harassment of any kind.