Position SummaryThe 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.
- U.S. citizenship.
- 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 CertificationsThe certification requirement must be current and verifiable:
- Salesforce Certified Platform Administrator.
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.
Benefit OfferingsTripoint 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