Marketing Data Analyst

Marketing Data Analyst
Location: CA- Irvine
Mutual of Omaha is a Fortune 300 Company. Mutual of Omaha Mortgage is inspired by hometown values and a commitment to being responsible and caring for each other. We exist for the benefit of our customers and employees. 
We offer an extensive compensation package. Benefits include Medical, Dental, and Vision insurance, company paid life insurance, 401K with a generous employer match and additional benefits such as Free Legal Services and an Employee Loan Program.
Mutual of Omaha Mortgage is a full-service lending company offering both Forward and Reverse Mortgage products including a complete line of residential mortgage, refinancing, specialty, and HECM loans. We employ a knowledgeable staff of experienced Loan Officers with an operations team that is second to none. If you are interested in joining a team that promotes from within and works together toward a common goal of helping customers with their mortgage needs, please review and apply for our opening below!
Mutual of Omaha Mortgage continues to expand and is seeking a mid to high level data analyst. The Data Analyst role will be responsible for updating the backend data architecture, data preparation and delivering reporting and business intelligence to end users through Power BI. The main objective of this role will be performing metadata analysis and threat detection against our Salesforce instance to detect and mitigate performance issues, data exfiltration and API usage, among other tasks.
We are seeking a person that thrives in a fast-paced environment and technically talented to provide support for our internal teams. If you are looking for a company that is continuously evolving and growing, this is the place for you.
 

• 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