- Troubleshooting Data Issues: Identify and resolve data discrepancies across multiple datasets to ensure data integrity and accuracy.
- Data Management: Utilize tools such as Salesforce Data Loader to efficiently manage and update data.
- Database Understanding: Apply a strong understanding of relational databases and SQL to query and analyze data, identifying root causes of issues.
- Experience: A few years of experience in a data-focused role, with a solid grasp of the concepts mentioned.
- Skills: Proficiency in SQL and experience with Salesforce Data Loader. Familiarity with relational database principles is essential.
location: Burbank, California
job type: Contract
salary: $67 - 75 per hour
work hours: 8am to 4pm
education: Bachelors
responsibilities:
- The CRM Data Analyst will work within a data team and will be asked to support system integration, product catalog loads, and reporting projects. Some representative items are below:
- Analyze denormalized data in Salesforce.com and produce a normalized data structure in SQL Server to hold this data for reporting.
- Design and build data loads using Salesforce UPSERT capabilities.
- Create SQL Server stored procedures to aggregate, cleanse, and harmonize data from multiple systems.
- Write queries comparing Salesforce data and on-premise data from other systems (ERP/contracts, products databases, pricing systems).
- Analyze business rules and write SQL statements to identify records which do not meet these rules.
- Perform data quality analysis for completeness, uniqueness, accuracy, and cross-system consistency between Salesforce.com and on-premise systems.
- Troubleshoot ETL processes to identify sources of error and corrective action.
- Candidates who have succeeded in this role in the past have had strong SQL skills and have been able to create production-level code in SQL Server, including data structures with effective keys and constraints, error-handling in stored procedures, functions, table variables, CTEs, and procedures which call other procedures and pass parameters
- Candidates have been familiar with data conventions in Salesforce.com, including options to read and write Salesforce data via APIs and ETL tools. These candidates have been familiar with Salesforce concepts such as master/detail and related relationships, governor limits, validation rules, and multi-select picklists.
qualifications:
- Experience level: Experienced
- Minimum 5 years of experience
- Education: Bachelors
skills:
- SQL
- Salesforce
- Data Analysis
- Great communicator
Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.
At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact HRsupport@randstadusa.com.
Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including: medical, prescription, dental, vision, AD&D, and life insurance offerings, short-term disability, and a 401K plan (all benefits are based on eligibility).
This posting is open for thirty (30) days.
It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.
Qualified applicants in San Francisco with criminal histories will be considered for employment in accordance with the San Francisco Fair Chance Ordinance.
Qualified applicants in the unincorporated areas of Los Angeles County with criminal histories will be considered for employment in accordance with the Los Angeles County's Fair Chance Ordinance for Employers.
We will consider for employment all qualified Applicants, including those with criminal histories, in a manner consistent with the requirements of applicable state and local laws, including the City of Los Angeles' Fair Chance Initiative for Hiring Ordinance.
