Build and maintain data pipelines, SQL queries, data models, database structures, and centralized data warehouse capabilities. Clean and validate data, develop reporting datasets and solutions, support KPI tracking and historical analysis, and collaborate with Finance and Revenue Operations. Investigate data gaps, troubleshoot integrations, and independently deliver reliable technical solutions.
About Our Company:
At Patch My PC, we exist to improve lives. What started as a free tool to keep apps updated has grown into a trusted enterprise solution that helps IT and Security teams automate, manage, deploy, and report on third-party updates in Microsoft ConfigMgr, Intune, and WSUS. Our fully remote crew of 150 GIF-loving humans supports over 10,000 customers and more than 32 million devices. We make patching easier, boost security, and give IT teams their time back.
Our core values guide how we work, how we treat each other, and how we grow. They keep us focused on what matters most. We're here to improve the lives of our customers, our team members, and our communities.
About this Role:
Patch My PC is looking for a hands-on Business Intelligence Specialist to help build and maintain our enterprise data infrastructure and reporting capabilities.
In this role, you will work with data from multiple business systems, develop reliable data structures and support the creation of a centralized data warehouse. You'll play an important role in making business data accessible, accurate and useful for reporting and decision-making.
We're looking for someone who enjoys solving complex data challenges, takes ownership of technical deliverables and is excited to help build a new business intelligence function from the ground up.
What You'll Do:
- Build and maintain data pipelines that extract, transform and integrate information from multiple business systems.
- Develop SQL queries, data models and database structures to support enterprise reporting.
- Support the implementation and ongoing development of a centralized enterprise data warehouse.
- Organize, clean and validate data to improve accuracy, consistency and reliability.
- Develop datasets and reporting solutions that support historical analysis, business performance tracking and operational KPIs.
- Partner with Finance, Revenue Operations and other teams to understand data requirements and troubleshoot integration or reporting challenges.
- Independently investigate data gaps, recommend solutions and deliver technical work with strong ownership and accountability.
What You'll Bring:
- 3+ years of hands-on experience in business intelligence, data integration, database development or related technical data roles.
- Strong SQL skills and experience working with relational databases, data models and large datasets.
- Experience building data pipelines and integrating information from multiple systems.
- Familiarity with cloud data platforms such as Snowflake, Databricks, Azure-based data solutions or similar technologies.
- Experience with data transformation, data quality and historical data management.
- Working knowledge of reporting tools such as Power BI or Tableau.
- Strong analytical thinking, troubleshooting skills and the ability to independently solve technical problems.
- A proactive, ownership-driven mindset with strong communication and collaboration skills.
Nice to Have
- Experience working with Salesforce, financial systems or other enterprise SaaS applications.
- Familiarity with recurring-revenue metrics and operational reporting.
- Experience helping build or improve data infrastructure in a growing organization.
Compensation & Benefits:
- 401k Match: Match 200% of contributions up to the first 5% of salary, resulting in a total potential match of 10%.
- Medical, Dental, and Vision Coverage: Patch My PC covers 99% of premiums for both team members and dependents.
- FSA/HSA.
- Fertility benefits.
- Parental leave.
- Paid-time off (PTO).
- Volunteer leave.
- Charitable donation matching.
- Tuition reimbursement.
- Gym membership reimbursement.
- Internet stipend.
- Pet insurance.
Competitive Base Salary: $100,000 - $125,000 based on experience and location.
Benefits:
Other Benefits:
Learn more about our benefits here: https://patchmypc.com/careers#we-care.
What to Expect in the Interview Process
Curious about what comes next? Learn more about our hiring process here: http://patchmypc.com/careers#hiring-process
Equal Opportunity Employer:
Patch My PC is an Equal Opportunity Employer and is committed to a policy of equal treatment and opportunity in every aspect of its recruitment and hiring process. We encourage women, racial and ethnic minorities, individuals with disabilities, and veterans to apply.
Work Authorization:
To be eligible for consideration, candidates for fully remote positions must reside in one of the following U.S. states at the time of hire:
AL, AK, AR, AZ, CA, CO, CT, DE, FL, GA, HI, IA, ID, IL, IN, KS, KY, LA, ME, MI, MN, MO, MS, MT, NC, ND, NE, NH, NJ, NM, NV, OH, OK, PA, RI, SC, SD, TN, TX, UT, VA, WA, WI, WV, WY.
Patch My PC Castle Rock, Colorado, USA Office
864 W Happy Canyon RD Suite 110, Castle Rock, Colorado, United States, 80108
Similar Jobs
Healthtech • Pharmaceutical
Supports the development and maintenance of Qlik dashboards, reports, and data visualizations. Performs data analysis, validates reporting outputs, identifies trends and anomalies, translates business requirements into reporting solutions, troubleshoots data issues, and helps maintain metrics and KPIs. Collaborates with business stakeholders and develops knowledge of organizational data sources, business intelligence practices, and data governance standards.
Top Skills:
Power BIPythonQlikRSASSQLTableau
Agency • Healthtech • Professional Services • Pharmaceutical
Designs, develops, tests, and maintains BI reports, dashboards, data models, data warehouses, and ETL processes using Microsoft BI tools. The role analyzes source data, resolves data integrity issues, supports stakeholders and end users, implements data protection solutions, and maintains documentation. This is a fully remote position with approved-location restrictions.
Top Skills:
.NetAzure Data FactoryAzure DevopsCsvInformaticaLogic AppsAzurePower BISQLSQL ServerSsisSsrsT-SqlXML
Information Technology • Consulting
Manages a portfolio of B2B technology customers, guiding onboarding, adoption, value realization, retention, renewals, and growth. Develops customer success plans, monitors account health, conducts business reviews, coordinates cross-functional teams, escalates issues, and supports expansion opportunities. Maintains customer documentation and success metrics while contributing to process improvements and exceptional customer experiences.
Top Skills:
AWSCRMCustomer Success PlatformsCybersecurityGCPAzureSaaSVMware
What you need to know about the Colorado Tech Scene
With a business-friendly climate and research universities like CU Boulder and Colorado State, Colorado has made a name for itself as a startup ecosystem. The state boasts a skilled workforce and high quality of life thanks to its affordable housing, vibrant cultural scene and unparalleled opportunities for outdoor recreation. Colorado is also home to the National Renewable Energy Laboratory, helping cement its status as a hub for renewable energy innovation.
Key Facts About Colorado Tech
- Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3
- Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech
- Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook)
- Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures
- Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute
