Salesforce Data Analyst II

ADP, Inc.

United States

Remote

USD 80,000 - 100,000

Full time

2 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Medical, Dental, Vision benefits
401(k) Retirement Plan
Paid time off
Professional Development Reimbursement
Relocation assistance not provided

Job summary

Tripoint Solutions is seeking a Data Analyst II to manage large-scale Salesforce data exchanges and ensure data accuracy for partner integrations. You will load, validate, and profile feeds, and produce dashboards for leadership from Tableau or CRM Analytics.

The role requires 3+ years of data analysis experience, strong SQL and Excel skills, and hands-on Salesforce data work with SOQL and Data Loader. A federal clearance is not required, but background checks apply.

Qualifications

  • Bachelor's degree in Data Analytics, Information Systems, Statistics, or a related field.
  • 3+ years of data analysis experience.
  • Hands-on experience with Salesforce data within the last 12 months: SOQL, reports, and Data Loader.
  • Advanced SQL and Excel.
  • Experience validating and reconciling data exchanged between organizations.
  • Experience with Tableau, CRM Analytics, or a comparable reporting tool.
  • Active Salesforce Trailblazer account with a public profile.
  • Ability to obtain and maintain a background check; security clearance not required.
  • Ability to handle and safeguard Controlled Unclassified Information.

Responsibilities

  • Receive, validate, and load external partner data feeds against the data dictionary.
  • Profile data, identify quality issues, trace root causes, and correct through to closure.
  • Produce point-in-time counts, lists, and recurring reports on a fixed calendar.
  • Query and update Salesforce data using SOQL, reports, and Data Loader.
  • Build and maintain dashboards and reports in Tableau or CRM Analytics.
  • Support data validation and reconciliation for Education Cloud migration.
  • Communicate data issues and resolutions to external partners per the data dictionary.
  • Estimate work in hours, log time against Jira, document procedures in Confluence.

Skills

Data analysis
Salesforce data experience
SQL
Excel
Communication with partners

Education

Bachelor's degree in Data Analytics, IS, Statistics, or related field

Tools

SOQL
Data Loader
Tableau
CRM Analytics
Reports & dashboards

Job description

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Full Time Professional Remote Location, US

3 days ago Requisition ID: 1132

Salary Range: $80,000.00 To $100,000.00 Annually

Position Summary

The Data Analyst II keeps data accurate, complete, and on time for a large enterprise Salesforce platform that exchanges records with multiple external partners. These positions process and validate incoming data feeds, correct data issues at the source, and produce the counts and reports that leadership relies on. Analysts must already be working with Salesforce data.

Responsibilities

  • Receive, validate, and load external partner data feeds against the data dictionary, and resolve rejected or inconsistent records.
  • Profile data, identify quality issues, trace root causes, and carry corrections through to closure.
  • Produce point-in-time counts, lists, and recurring reports on a fixed calendar.
  • Query and update Salesforce data using SOQL, reports, and Data Loader, following the approved request process.
  • Build and maintain dashboards and reports in Tableau or CRM Analytics.
  • Support data validation and reconciliation for the Education Cloud migration.
  • Communicate data issues and resolutions to external partners in the language of the data dictionary.
  • Estimate work in hours, log time against assigned Jira tickets, and document procedures in Confluence.

Required Qualifications

  • Bachelor's degree in Data Analytics, Information Systems, Statistics, or a related field.
  • 3+ years of data analysis experience.
  • Hands-on experience with Salesforce data within the last 12 months: SOQL, reports, and Data Loader.
  • Advanced SQL and Excel.
  • Experience validating and reconciling data exchanged between organizations.
  • Experience with Tableau, CRM Analytics, or a comparable reporting tool.
  • Active Salesforce Trailblazer account with a public profile.
  • Ability to obtain and maintain a favorably adjudicated federal background investigation. A security clearance is not required.
  • Ability to handle and safeguard Controlled Unclassified Information.

Required Salesforce Certifications

Candidates must list their certifications on their resumes and provide their Trailblazer profile URL. Required certifications will be verified before interviews are scheduled.

Preferred Qualifications

  • Experience with Salesforce Education Cloud or EDA data.
  • Salesforce Certified CRM Analytics and Einstein Discovery Consultant or Salesforce Certified Tableau Data Analyst.
  • Python for data validation and automation.
  • Experience supporting federal government technology programs.
  • Current favorably adjudicated federal background investigation.

Location: Remote.
The selected candidate must be currently located in, or willing to relocate to, a state supported by Tripoint Solutions corporate offices: AL, CO, DC, DE, FL, GA, IL, IN, KS, LA, MD, MN, MS, NC, NJ, OH, PA, SC, TN, TX, or VA. (No relocation assistance provided)

Clearance Requirements:

U.S. Citizenship is required.

A favorably adjudicated (approved) National Agency Check with Inquiries (NACI) or equivalent (Tier 1 Investigation) or ability to obtain a government clearance.

About Tripoint Solutions

We are technology innovators, partnered with state-of-the-art providers, such as AWS, ServiceNow, and UiPath, to drive digital transformation in the federal space. TPS teams are bringing automation and data science into areas of the government that are crying out for fresh tech—making positive impacts felt by tens of thousands of users, countless citizens, and all six branches of the military each day. Our Agile teams are responsible for envisioning, launching, and operating the massive data systems and analytics platforms used to manage $14.5B in government procurements and $200B in military real estate assets globally. At TPS, we apply the power of cloud technologies to help the government think smarter and function better—for everyone.

TPS Company Values

  • We value and respect each employee's dedicated work and unique contributions as they directly impact who we are and what we do.
  • Your talent and innovative thinking bring leading-edge solutions to our customers.
  • Our success is driven by the dedication of our employees.
  • Employee-generated solutions have sustained our continued success and customer satisfaction

Tripoint Solutions builds flexibility into health benefit plan choices, covers most of the monthly premiums, and helps employees build a career with impact through our generous professional development program.

We offer all full-time employees:

  • Medical, Dental, Vision benefits with a national provider network
  • Flexible Spending and Health Savings Accounts (FSA & HSA)
  • Company-paid Life and Disability insurance including Short-Term, Long-Term, and Accidental
  • Supplemental Insurance
  • Paid time off (PTO)
  • 11 paid holidays
  • 401(k) Retirement Plan
  • Professional Development Reimbursement Program to pursue undergraduate, graduate, training, and certifications
  • Monthly transportation, parking, and cell phone service reimbursement

Tripoint Solutions is an Equal Opportunity Employer/Veterans/Disabled

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Salesforce Software Developer II
Salesforce Software Developer II

ADP, Inc. • United States

Remote
USD 115,000 - 135,000
Medical, Dental, Vision benefits witha
FSA & HSA
Company-paid Life and Disability
+4
Salesforce Database Developer
Salesforce Database Developer

ADP, Inc. • United States

Remote
USD 104,000 - 124,000
Medical, Dental, Vision
FSA & HSA
Life and Disability insurance
+4
Salesforce Software Developer I
Salesforce Software Developer I

ADP, Inc. • United States

Remote
USD 95,000 - 115,000
Medical, Dental, Vision benefits
401(k) Retirement Plan
Professional Development Reimbursement
+4
Senior Salesforce Software Developer
Senior Salesforce Software Developer

ADP, Inc. • United States

Remote
USD 144,000 - 164,000
Medical benefits
Dental & Vision
401(k) plan
+3
Salesforce Application Developer
Salesforce Application Developer

ADP, Inc. • United States

Remote
USD 110,000 - 130,000
Medical, Dental, Vision benefits
401(k) Retirement Plan
Professional Development Reimbursement
Salesforce Software Developer
Salesforce Software Developer

Tripoint Solutions • Florida

Hybrid
USD 100,000 - 130,000
Medical, Dental, Vision benefits
401(k) Retirement Plan
Professional Development Reimbursement
+1
Senior Salesforce Software Developer
Senior Salesforce Software Developer

Tripoint Solutions • Florida

Hybrid
USD 144,000 - 164,000
Medical, Dental, Vision benefits
FSA & HSA
Life and Disability insurance
+5
Salesforce Software Developer
Salesforce Software Developer

Tripoint Solutions, LLC • Idaho

Remote
USD 100,000 - 130,000
Medical, Dental, Vision benefits
FSA/HSA
Life and Disability insurance
+5
Salesforce Data Architect
Salesforce Data Architect

ADP, Inc. • United States

Remote
USD 140,000 - 160,000
Health insurance
401(k) plan
Professional development
Salesforce Data Architect
Salesforce Data Architect

Tripoint Solutions • Florida

Hybrid
USD 140,000 - 160,000