We are seeking a Data Analyst with expertise in data engineering and Salesforce to design ETL pipelines, enhance data integrity, and support business 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 this Role:
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.
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.
Top Skills
Airflow
Apex
BigQuery
Dbt
ETL
Fivetran
Power BI
Python
Redshift
Salesforce
Snowflake
SQL
Tableau
Similar Jobs
.png)
Food • Software
As a Senior Data Analytics Engineer, you'll manage ChowNow's data platform, build tools for data insights, and collaborate with teams to enhance data availability and accuracy.
Top Skills:
AWSDbtPythonSigma ComputingSnowflakeSQLTableau
Big Data • Fintech • Mobile • Payments • Financial Services
Design and implement data pipelines, maintain ETL processes, and enhance data quality for People Analytics, ensuring reliable reporting solutions.
Top Skills:
AirflowDbtFivetranPythonSigmaSnowflakeSQL
_1.png)
Real Estate • Travel • PropTech
The Staff Analytics Engineer will build foundational datasets, enhance user data quality, mentor team members, and collaborate on data-driven projects.
Top Skills:
AirflowBigQueryClickhouseHbaseMySQLPostgresPythonRedshiftScalaSQLTableau
What you need to know about the Charlotte Tech Scene
Ranked among the hottest tech cities in 2024 by CompTIA, Charlotte is quickly cementing its place as a major U.S. tech hub. Home to more than 90,000 tech workers, the city’s ecosystem is primed for continued growth, fueled by billions in annual funding from heavyweights like Microsoft and RevTech Labs, which has created thousands of fintech jobs and made the city a go-to for tech pros looking for their next big opportunity.
Key Facts About Charlotte Tech
- Number of Tech Workers: 90,859; 6.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lowe’s, Bank of America, TIAA, Microsoft, Honeywell
- Key Industries: Fintech, artificial intelligence, cybersecurity, cloud computing, e-commerce
- Funding Landscape: $3.1 billion in venture capital funding in 2024 (CED)
- Notable Investors: Microsoft, Google, Falfurrias Management Partners, RevTech Labs Foundation
- Research Centers and Universities: University of North Carolina at Charlotte, Northeastern University, North Carolina Research Campus
