Data Analyst
Patch My PC
Full-time
Remote
United States
$95,000 - $118,000 USD yearly
Data Science and Analytics
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 125 GIF-loving humans supports over 8,000 customers and more than 25 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 the Job:
We are looking to hire a Data Analyst with strong technical skills in data engineering, analysis, and Salesforce platform development. This role is ideal for someone who thrives in a quickly scaling SaaS environment, understands the importance of reliable revenue data, and can bridge the gap between engineering, analytics, and business stakeholders. The ideal candidate will have hands-on experience building data pipelines, crafting actionable insights, and writing Apex code to optimize Salesforce data workflows.
Responsibilities:
- Design, build, and maintain ETL/ELT pipelines that ingest and transform data from Salesforce and other business systems (e.g., Marketo, Zendesk, Stripe, product databases).
- Write and maintain custom Apex code, triggers, and batch jobs to support data quality and automation within Salesforce.
- Partner with RevOps, Sales, and Customer Success to define KPIs and deliver data models and dashboards supporting go-to-market performance and customer lifecycle analytics.
- Optimize Salesforce data architecture to support scalable reporting and integrations across tools and platforms.
- Develop SQL and Python scripts to perform complex analyses and validate cross-system data consistency.
- Maintain and scale the data warehouse (e.g., Snowflake, BigQuery, Redshift), ensuring well-structured, high-quality datasets for analytics and BI tools (e.g., Tableau, Power BI).
- Ensure data integrity, security, and compliance with internal policies and external regulations (e.g., SOC 2, GDPR).
- Support business teams with ad hoc analysis and provide recommendations through clear visualizations and storytelling.
Required Skills:
- 5+ years of experience in data engineering or data analysis roles, preferably in a SaaS or B2B tech company.
- Deep experience with Salesforce (Sales Cloud, Service Cloud), including Apex, SOQL, Flows, and platform integrations.
- Strong SQL and Python skills, with experience transforming and modeling large datasets.
- Hands-on experience with modern data stack tools: ETL (e.g., dbt, Fivetran), orchestration (e.g., Airflow), and data warehousing (e.g., Snowflake, BigQuery).
- Proven ability to turn complex data into clear, actionable insights for business stakeholders.
- Familiarity with business tools like HubSpot, ClickUp, PowerBI is a plus.
- Strong attention to detail and ability to manage multiple priorities under tight deadlines.
- Effective communication and stakeholder management skills across all organizational levels.
Desired Skills:
- Experience with Salesforce integration APIs and platform event-driven architectures.
- Exposure to revenue intelligence, forecasting models, and GTM funnel metrics.
- Background in agile workflows and tools (Jira, Confluence).
- Experience building and maintaining dashboards in Tableau, Looker, or Power BI.
- Understanding of customer segmentation, ARR/MRR reporting, and cohort analysis.
Compensation & Benefits:
- Competitive Base Salary: $95,000 - $118,000 based on experience and location.
- 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.
Benefits:
Other Benefits:
Learn more about our benefits here: https://patchmypc.com/careers#we-care.
$95,000 - $118,000 a year
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.