What are the responsibilities and job description for the Data Analyst IV position at West Coast Consulting LLC?
Job Details
Job Description
About the Role:
We are seeking a Data Operations specialist to support our marketing, CRM, and audience activation systems through precise, hands-on execution. This role is responsible for managing the day-to-day development, maintenance, and troubleshooting of the datasets and workflows that power targeting, segmentation, and reporting.
You ll be deeply embedded in the data layer, working with Hive, SQL, Python, Tableau, and internal platforms to ensure clean, accurate, and reliable data flows across marketing and CRM use cases. This is a tactical and technical role, ideal for someone who is detail-oriented, comfortable in complex data environments, and passionate about keeping systems running smoothly.
Responsibilities:
Build and maintain Hive tables, SQL queries, and data models for marketing and CRM workflows.
Support audience segmentation, customer targeting, campaign enablement, and measurement through hands-on data work.
Own the execution and delivery of data requests from new table builds to data fixes and validation.
Troubleshoot data issues across systems and workflows, collaborating with Engineering and MarTech partners as needed.
Perform data validation, QA, and hygiene to ensure accuracy and consistency across datasets.
Help document data flows, schemas, and transformations for cross-functional reference and enablement.
Participate in privacy review processes by documenting data use cases and ensuring compliant data handling.
Serve as a reliable go-to partner for operational data needs across Marketing, CRM, and Analytics teams.
Minimum Qualifications:
5 years of hands-on experience in data operations, data engineering, or data analyst roles, ideally supporting marketing or CRM teams.
Strong expertise in Hive and SQL capable of writing complex queries and managing large datasets.
Experience with data modeling, ETL pipelines, and managing workflows across multiple systems.
Excellent attention to detail and commitment to data accuracy and reliability.
Comfort working independently on technical execution tasks in a fast-paced, cross-functional environment.
Familiarity with data privacy requirements and documentation in regulated settings.
Preferred Qualifications:
Experience with Salesforce Marketing Cloud, Salesforce Data Cloud, or similar MarTech tools.
Prior experience supporting audience targeting, segmentation, or campaign measurement through structured data.
Strong troubleshooting skills and ability to diagnose issues across multiple layers of a data pipeline.
Clear and concise communicator, especially when writing data documentation or resolving issues with stakeholders.
Pursuant to the California Fair Chance Act, Los Angeles County Fair Chance Ordinance for Employers, Los Angeles Fair Chance Initiative for Hiring Ordinance, and San Francisco Fair Chance Ordinance, qualified applicants will be considered for assignment with arrest and conviction records. Criminal history may have a direct, adverse, and negative relationship with some of the material job duties of this position. These include the duties and responsibilities listed above, as well as the abilities to adhere to company policies, exercise sound judgment, effectively manage stress and work safely and respectfully with others, exhibit trustworthiness, meet client expectations, standards, and accompanying requirements, and safeguard business operations and company reputation.
About the Role:
We are seeking a Data Operations specialist to support our marketing, CRM, and audience activation systems through precise, hands-on execution. This role is responsible for managing the day-to-day development, maintenance, and troubleshooting of the datasets and workflows that power targeting, segmentation, and reporting.
You ll be deeply embedded in the data layer, working with Hive, SQL, Python, Tableau, and internal platforms to ensure clean, accurate, and reliable data flows across marketing and CRM use cases. This is a tactical and technical role, ideal for someone who is detail-oriented, comfortable in complex data environments, and passionate about keeping systems running smoothly.
Responsibilities:
Build and maintain Hive tables, SQL queries, and data models for marketing and CRM workflows.
Support audience segmentation, customer targeting, campaign enablement, and measurement through hands-on data work.
Own the execution and delivery of data requests from new table builds to data fixes and validation.
Troubleshoot data issues across systems and workflows, collaborating with Engineering and MarTech partners as needed.
Perform data validation, QA, and hygiene to ensure accuracy and consistency across datasets.
Help document data flows, schemas, and transformations for cross-functional reference and enablement.
Participate in privacy review processes by documenting data use cases and ensuring compliant data handling.
Serve as a reliable go-to partner for operational data needs across Marketing, CRM, and Analytics teams.
Minimum Qualifications:
5 years of hands-on experience in data operations, data engineering, or data analyst roles, ideally supporting marketing or CRM teams.
Strong expertise in Hive and SQL capable of writing complex queries and managing large datasets.
Experience with data modeling, ETL pipelines, and managing workflows across multiple systems.
Excellent attention to detail and commitment to data accuracy and reliability.
Comfort working independently on technical execution tasks in a fast-paced, cross-functional environment.
Familiarity with data privacy requirements and documentation in regulated settings.
Preferred Qualifications:
Experience with Salesforce Marketing Cloud, Salesforce Data Cloud, or similar MarTech tools.
Prior experience supporting audience targeting, segmentation, or campaign measurement through structured data.
Strong troubleshooting skills and ability to diagnose issues across multiple layers of a data pipeline.
Clear and concise communicator, especially when writing data documentation or resolving issues with stakeholders.
Pursuant to the California Fair Chance Act, Los Angeles County Fair Chance Ordinance for Employers, Los Angeles Fair Chance Initiative for Hiring Ordinance, and San Francisco Fair Chance Ordinance, qualified applicants will be considered for assignment with arrest and conviction records. Criminal history may have a direct, adverse, and negative relationship with some of the material job duties of this position. These include the duties and responsibilities listed above, as well as the abilities to adhere to company policies, exercise sound judgment, effectively manage stress and work safely and respectfully with others, exhibit trustworthiness, meet client expectations, standards, and accompanying requirements, and safeguard business operations and company reputation.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
