Senior Data Analyst

Senior Data Analyst E Mortgage Capital, Inc. - 4.4 Santa Ana, CA Job Details Full-time $86,963.95 - $104,730.78 a year 1 day ago Benefits Paid holidays Disability insurance Health insurance Dental insurance Paid time off Vision insurance Life insurance Paid sick time Qualifications Performance dashboard reports Dashboard development Data visualization software proficiency Data Integration (Data management) Tableau SQL Salesforce Cloud Attribution modeling Data quality monitoring Data analytics CRM system proficiency Data validation Python Stakeholder management Database software proficiency Full Job Description Role Summary Seeking a results-driven Data Analyst to turn marketing and CRM data into actionable insights. This role will design dashboards in Tableau, extract/transform/load data from Salesforce and other systems, support marketing analytics initiatives, and maintain high data quality standards to enable data-driven decision-making. Key Responsibilities Build, maintain, and iterate Tableau dashboards and visualizations to support marketing, sales, and executive stakeholders. Extract, transform, and load data from Salesforce, ad platforms, data warehouses, and other sources using ETL tools or scripts. Manage analytical projects to ensure expectations related to scope, budget, and timelines are set and met with accountability.

Perform marketing analytics:

campaign performance, channel attribution, funnel analysis, cohort analysis, LTV/ROI modeling, and A/B test evaluation. Validate and reconcile data across systems; define and enforce data quality rules, data lineage, and issue remediation processes. Collaborate with marketing, sales ops, and engineering to translate business questions into data requirements and measurement frameworks. Create regular and ad-hoc reports, dashboards, and presentations that clearly communicate insights and recommended actions.

Support data governance initiatives:

metadata documentation, naming standards, and access controls. Automate routine data processes and reporting to improve reliability and efficiency. Required Qualifications 2+ years of experience in data analysis, marketing analytics, or business intelligence. Hands-on experience with Tableau (dashboard design, calculations, performance optimization). Strong working knowledge of Salesforce (reporting, data model, SOQL preferred). Experience with ETL processes and tools (e.g., Informatica, Talend, Fivetran, Airflow, SQL-based pipelines). Proficient in SQL for data extraction, transformation, and analysis. Solid understanding of marketing metrics and attribution models. Experience implementing or enforcing data quality checks and remediation. Strong problem-solving, communication, and stakeholder management skills. Preferred Qualifications Experience with a cloud data warehouse (Snowflake, BigQuery, Redshift). Familiarity with Python or R for advanced analytics and automation. Knowledge of marketing automation platforms (Salesforce Marketing Cloud, Marketo, HubSpot) and ad platforms (Google Ads, Meta). Certification(s) in Tableau or Salesforce.

Pay:

$86,963.95 - $104,730.78 per year

Benefits:

Dental insurance Disability insurance Health insurance Life insurance Paid holidays Paid sick time Paid time off Vision insurance

Work Location:

In person