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:
This position is NOT eligible for Visa sponsorship.
To be eligible for consideration, candidates for fully remote positions must reside in one of the following U.S. states:
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
Cloud • Fintech • Software • Business Intelligence • Consulting • Financial Services
The Finance Business Partnership Manager supports practice groups and growth teams through forecasting, profitability analysis, pricing and discount analysis, KPI development, dashboard reporting, and business case support. The role leads monthly financial reviews, partners with data and accounting teams, improves reporting standards, supports planning and staffing decisions, and translates financial insights into operating actions for non-finance leaders.
What you need to know about the Chicago Tech Scene
With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory
