Business Analyst- CRM

LHH; San Diego (CA); On-site; USD 52,348 - 59,236; Full time

Benefits offered by this job

Medical insurance

Vision insurance

401(k) plan

Job summary

A leading recruitment agency is seeking a detail-oriented Business Analyst in Downtown San Diego to support data operations and CRM enhancements. The ideal candidate will have strong SQL skills and experience in data transformation and documentation. Responsibilities include writing SQL queries, loading data, and collaborating with stakeholders on CRM updates. This role offers competitive compensation based on experience, with an emphasis on teamwork and communication.

Qualifications

• 3–5 years of relevant experience in business analysis or CRM support.
• Experience in audited or regulated environments.
• Familiarity with Agile methodologies and Jira Software.

Responsibilities

• Write and optimize SQL queries to extract insights.
• Load customer list data and use tools for data cleansing.
• Create and maintain documentation of data sources and business processes.

Skills

SQL skills

Data transformation

Excellent communication

Tools

SQL Server

Alteryx

Jira Software

Job description

This range is provided by LHH. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Base pay range

$38.00/hr - $43.00/hr

Business Analyst

Location: Downtown San Diego (On-Site 3 days per week)

Employment Type: Contract-to-Hire

Compensation: $38-43/hr

Position Summary

We are seeking a detail-oriented and analytical Business Analyst to support data operations, CRM enhancements, and business process documentation. This role is ideal for someone with strong SQL skills, experience in data transformation, and a background in working within audited environments. The successful candidate will collaborate with internal stakeholders and development teams to ensure data integrity, implement new CRM features, and maintain comprehensive documentation.

Key Responsibilities

SQL & Database Knowledge

• Write and optimize SQL queries to extract insights and support reporting.
• Understand database schemas and join tables to support data analysis.

Data Loading & Transformation

• Load customer list data on a weekly/monthly cadence.
• Use tools like Alteryx for data cleansing and transformation.
• Identify and resolve data inconsistencies, escalate issues, and advise on solutions.
• Collaborate with stakeholders to gather requirements for CRM updates.
• Translate business needs into Jira tickets for the development team.
• Conduct DEV/UAT/PROD testing for new fields and features.
• Process mass update requests and maintain CRM data quality.
• Maintain documentation of CRM configurations, processes, and requirements.

Troubleshooting

• Investigate data issues and provide actionable solutions.
• Review field logic and verify updates through testing.

Documentation

• Create and maintain documentation of data sources, field mappings, and business processes.
• Ensure documentation reflects the most current state of systems and data.
• Use Jira Software to manage and track development tasks.
• Participate in Agile ceremonies and collaborate with cross-functional teams.

Qualifications

• 3–5 years of relevant experience in business analysis, data operations, or CRM support.
• Strong SQL skills and experience with data transformation tools (e.g., Alteryx).
• Experience working in audited or regulated environments.
• Familiarity with Agile methodologies and Jira Software.
• CRM experience strongly preferred, especially in data maintenance and feature implementation.
• Excellent communication and documentation skills.

Preferred Skills & Tools

• SQL Server or similar relational database platforms
• Alteryx or other ETL/data transformation tools
• Jira Software for Agile project management
• Experience with CRM platforms and data governance
• Understanding of audit compliance requirements

Benefit offerings include medical, dental, vision, life insurance, short-term disability, additional voluntary benefits, EAP program, and 401K plan. Our program provides employees the flexibility to choose the type of coverage that meets their individual needs. Available paid leave may include Paid Sick Leave, where required by law; any other paid leave required by Federal, State, or local law; and Holiday pay upon meeting eligibility criteria.

Equal Opportunity Employer/Veterans/Disabled

To read our Candidate Privacy Information Statement, which explains how we will use your information, please navigate to https://www.lhh.com/us/en/candidate-privacy

The Company will consider qualified applicants with arrest and conviction records in accordance with federal, state, and local laws and/or security clearance requirements, including, as applicable:

• The California Fair Chance Act
• Los Angeles City Fair Chance Ordinance
• Los Angeles County Fair Chance Ordinance for Employers
• San Francisco Fair Chance Ordinance

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Analyst and Information Technology

Referrals increase your chances of interviewing at LHH by 2x

Inferred from the description for this job

Medical insurance

Vision insurance

401(k)

Get notified when a new job is posted.

Sign in to set job alerts for “Business Analyst” roles.

Business / Functional Analyst – Process Discovery | User Stories | CONOPS (Hybrid Role)

Business Analyst - State, Local & Education (SLED)

Senior Business Analyst with AppDynamics, 1000Eyes and Dynatrace experience

Poway, CA $51,650.00-$87,290.00 5 days ago

Lender - Technical Business Analyst (Web B2C/B2B Applications)

Staff Business Process Analyst, Source to Pay Process Excellence (SAP)

Business Systems Analyst & Project Manager/Hybrid - 136152

Sr. Business Analyst, Contract Performance Management Group

Business Analyst – Financial Services PMO

10754 - Sr. SAP SD/LE & CRM Business Process Analyst

San Diego, CA $98,060.00-$151,008.00 5 hours ago

10446 – Sr. SAP FI/CO Business Process Analyst

Business Systems Analyst & Project Manager/Hybrid - 136152

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.