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:
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
Blockchain • Fintech • Payments • Financial Services • Cryptocurrency • Web3
Provide hands-on IT administration and white-glove support for Circle’s New York office and remote workforce. Maintain macOS devices, MDM, networks, security systems, conference rooms, and audio-visual equipment. Manage incidents, business continuity, disaster recovery, and security collaboration. Support executives, employees, events, and visiting customers while improving troubleshooting, documentation, and IT operations.
Top Skills:
Ai ToolsAnsibleCisco MerakiFirewallsGoGoogle MeetGoogle WorkspaceIruLinuxMacbooksmacOSManaged SwitchesOktaPythonRoutersServicenowShellSlackTerraformVlansWindows ServerWorkspace OneZoom
What you need to know about the Seattle Tech Scene
Home to tech titans like Microsoft and Amazon, Seattle punches far above its weight in innovation. But its surrounding mountains, sprinkled with world-famous hiking trails and climbing routes, make the city a destination for outdoorsy types as well. Established as a logging town before shifting to shipbuilding and logistics, the Emerald City is now known for its contributions to aerospace, software, biotech and cloud computing. And its status as a thriving tech ecosystem is attracting out-of-town companies looking to establish new tech and engineering hubs.
Key Facts About Seattle Tech
- Number of Tech Workers: 287,000; 13% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Amazon, Microsoft, Meta, Google
- Key Industries: Artificial intelligence, cloud computing, software, biotechnology, game development
- Funding Landscape: $3.1 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Madrona, Fuse, Tola, Maveron
- Research Centers and Universities: University of Washington, Seattle University, Seattle Pacific University, Allen Institute for Brain Science, Bill & Melinda Gates Foundation, Seattle Children’s Research Institute
