Job Title: Data Integrity Specialist I Duration: 6 months (possible extension) Location/Site: Irvine, CA 92612 (Hybrid On-site, 3 days onsite/2 days remote) - Local candidates only
Reason for Request: Expansion of duties within team requires additional temporary support; possibility for extension beyond Dec
EXCEL Skills Required: Excel Formulas: concatenate, IF statements, VLOOKUPS, Pivot Tables equivalent to intermediate overall knowledge of Excel. General Position Summary/Purpose: The Data Integrity Specialist I will be responsible for monitoring consumer rewards program. Healthcare professionals log consumer treatments performed in-office for points issuance to be used towards discounts on future treatments. Person responsible will compare treatment logs vs. brand sales history for program misuse (excessive participation).
Key Accountabilities / Core Job Responsibilities:
Review consumer Loyalty Monitoring Dashboard for customers out of compliance.
Investigate if actioning required and appropriate level of discipline per defined SOPs.
Investigation requires data validation: sales retrieve, customer name/location via Google search, risk assessment calculation.
Perform actioning process: coordinate with Loyalty Operations team regarding Sales Rep and customer notifications, program pause start and end dates.
Document actioning in online system for audit purposes.
Ad hoc customer analysis requiring a desire to dig into details (use of online query tools and Excel).
Report results and analytics to Management timely.
Goal is to drive automation and improvements through partnering with internal IT to reduce manual work.
Will be responsible for additional monitoring programs to be rolled out in 2024.
Qualifications:
College Graduate or 1-2 years of work experience in data extraction, data analytics and/or financial analysis. Prior experience of working with large data and MS Excel required. Mail merge preferred.
Strong analytical skills coupled with thoroughness and attention to detail is desired.
Have strong verbal and written communication skills to effectively interact with business partners.
Must be able to work independently and proactively to take initiative to solve problems.
Exceptional organization and time management skills.
Discretion when dealing with confidential information.
Systems: Tableau, Snowflake, PowerBI, PowerPoint and Excel. SQL knowledge a plus. Excel formulas: concatenate, IF statements, lookups, pivot tables equivalent to intermediate level.
Description Details: Are you open to look at candidates willing to relocate at their own expense: Yes What are the top 3-5 skills, experience or education required for this position:
High Excel proficiency – lookup formulas, concatenate, be efficient where possible
Create customer reports with analytical mindset- willing to dig into details and investigate
Respect for processes/controls- follow SOPs with consistent rigor on repetitive tasks Experience with data query tools (how to retrieve data, search criteria)
Ability to work independently once trained and willingness to ask questions when get stuck
Nice to have (but not required) regarding skills, experience, education, or certification: Mail merge experience, ShipTo/SoldTo customer relationship knowledge, ability to summarize data – key takeaways? In what type of environment, would this individual be working? (i.e.: Team; Individual; type of office, etc)
Contribution: 95% Individual, 5% team
Office: Workspace in open floor planDaily
Work Schedule Expectations: M-F, Core business hours (Pacific time zone) Is overtime offered or required? If yes, how many overtime hours do you anticipate being requested/required of this role? Offered, not required Is Travel expected? If so, will it be primarily domestic or international? Minimal domestic travel, Post Office for paper mailings
Interviews: Initial Panel Interview with 2 leaders; Final round would be 2nd interview.
CPRA: The Company is committed to complying with the California Privacy Rights Act (“CPRA”) effective January 1, 2023; and all data privacy laws in the jurisdictions in which it recruits and hires employees. A Notice to California Job Applicants Regarding the Collection of Personal Information can be located on our website. Applicants with disabilities may access this notice in an alternative format by contacting NAhr@spectraforce.com
About Us: Established in 2004, SPECTRAFORCE® is one of the largest and fastest-growing diversity-owned staffing firms in the US. The growth of our company is a direct result of our global client service delivery model that is powered by our state-of-the-art A.I. proprietary talent acquisition platform, robust ISO 9001:2015/ISO 27001 certified processes, and strong and passionate client engaged teams. We have built our business by providing talent and project-based solutions, including Contingent, Permanent, and Statement of Work (SOW) services to over 140 clients in the US, Canada, Puerto Rico, Costa Rica, and India. Key industries that we service include Technology, Financial Services, Life Sciences, Healthcare, Telecom, Retail, Utilities and Transportation. SPECTRAFORCE is built on a concept of “human connection,” defined by our branding attitude of NEWJOBPHORIA®, which is the excitement of bringing joy and freedom to the work lifestyle so our people and clients can reach their highest potential. Learn more at: http://www.spectraforce.com
Benefits: SPECTRAFORCE offers ACA compliant health benefits as well as dental, vision, accident, critical illness, voluntary life, and hospital indemnity insurances to eligible employees. Additional benefits offered to eligible employees include commuter benefits, 401K plan with matching, and a referral bonus program. SPECTRAFORCE provides unpaid leave as well as paid sick leave when required by law.
Equal Opportunity Employer: SPECTRAFORCE is an equal opportunity employer and does not discriminate against any employee or applicant for employment because of race, religion, color, sex, national origin, age, sexual orientation, gender identity, genetic information, disability or veteran status, or any other category protected by applicable federal, state, or local laws. Please contact Human Resources at LOA@spectraforce.com if you require reasonable accommodation. At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws. This position’s starting pay is: $25.00/hr.
