Marketing Data Analyst
Mutual of Omaha Mortgage
- Irvine, CA
- Permanent
- Full-time
- Responsibilities and Duties
- Interfacing with internal / external business SMEs to create and maintain operational reporting in Salesforce, Power BI and Excel
- Collaborating with team on 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
- Required Qualifications and Skills
- 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
- Desired Qualifications and Skills
- Third-party logs analytics platform experience (Datadog, Splunk, etc.)
- Python / VBA
- Git / Azure DevOps
- Salesforce Marketing Cloud
- Mortgage industry experience