Marketing Data Analyst

$90,000 - $130,000/Yr

Mutual of Omaha - Irvine, CA

Full-time - Mid Level

Irvine, CA

251-500 employees

Insurance Carriers and Related Activities

About the position

The Marketing Data Analyst at Mutual of Omaha Mortgage is responsible for updating backend data architecture, preparing data, and delivering reporting and business intelligence to end users through Power BI. This role focuses on metadata analysis and threat detection within the Salesforce instance to identify and mitigate performance issues, data exfiltration, and API usage. The ideal candidate thrives in a fast-paced environment and is technically skilled to support internal teams effectively.

Responsibilities

• Interfacing with internal/external business SMEs to create and maintain operational reporting in Salesforce, Power BI, and Excel.
• Collaborating with the team on the implementation/maintenance of logs analytics infrastructure.
• Defining priority event-capture parameters and creating relevant reporting.
• Creating and maintaining performant queries.
• Analyzing and manipulating data as required for ad-hoc analysis.
• Isolating and resolving data source issues with limited supervision and oversight.
• Other tasks as assigned.

Requirements

• 3+ years of experience with T-SQL (window functions, CTEs, views/stored procedures).
• 3+ years of loading, importing, and exporting data into and from databases.
• 2+ years of Salesforce Sales Cloud experience.
• 2+ years of Power BI/DAX experience.
• Advanced Excel skills including Power Query.
• Good written and verbal communication skills.
• Reliable, self-motivated, and accountable for assigned work.
• Self-directed learner with the ability to research and implement novel approaches to business directives.
• Excellent organization, prioritization, and deadline focus.
• Bachelor's degree or equivalent experience.

Nice-to-haves

• Third-party logs analytics platform experience (Datadog, Splunk, etc.).
• Python/VBA skills.
• Git/Azure DevOps experience.
• Salesforce Marketing Cloud experience.
• Mortgage industry experience.

Benefits

• Health insurance
• Dental insurance
• Vision insurance
• 401(k) matching
• Life insurance
• Free Legal Services
• Employee Loan Program