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.
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 • Productivity • Professional Services • Software • Business Intelligence
Leads M-Files’ global demand generation and growth engine across North America and EMEA. Owns pipeline strategy, ABM, digital marketing, website performance, SEO, CRO, events, partner marketing, and SDR/BDR alignment. Establishes funnel analytics, attribution, forecasting, ROI measurement, and revenue accountability while partnering with Sales, GTM Operations, and executive leadership. Manages a global growth organization, drives AI adoption, improves pipeline conversion and efficiency, and delivers predictable enterprise B2B SaaS revenue growth.
Top Skills:
Abm PlatformsAIAttribution PlatformsCRMCroData And Intent PlatformsLlm Search OptimizationMap-Crm IntegrationMarketing Automation PlatformsSeoWeb Analytics
What you need to know about the Boston Tech Scene
Boston is a powerhouse for technology innovation thanks to world-class research universities like MIT and Harvard and a robust pipeline of venture capital investment. Host to the first telephone call and one of the first general-purpose computers ever put into use, Boston is now a hub for biotechnology, robotics and artificial intelligence — though it’s also home to several B2B software giants. So it’s no surprise that the city consistently ranks among the greatest startup ecosystems in the world.
Key Facts About Boston Tech
- Number of Tech Workers: 269,000; 9.4% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Thermo Fisher Scientific, Toast, Klaviyo, HubSpot, DraftKings
- Key Industries: Artificial intelligence, biotechnology, robotics, software, aerospace
- Funding Landscape: $15.7 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Summit Partners, Volition Capital, Bain Capital Ventures, MassVentures, Highland Capital Partners
- Research Centers and Universities: MIT, Harvard University, Boston College, Tufts University, Boston University, Northeastern University, Smithsonian Astrophysical Observatory, National Bureau of Economic Research, Broad Institute, Lowell Center for Space Science & Technology, National Emerging Infectious Diseases Laboratories
