Marketing Data Analyst

Mutual of Omaha Mortgage; Irvine (CA); On-site; USD 65,000 - 95,000; Full time

Job summary

Join a forward-thinking company as a Marketing Data Analyst, where your expertise in data architecture and business intelligence will drive impactful decisions. In this dynamic role, you'll collaborate with internal teams to enhance operational reporting and tackle data challenges using tools like Power BI and Salesforce. Your contributions will be vital in optimizing performance and ensuring data integrity. If you're passionate about data and thrive in a fast-paced environment, this opportunity offers a chance to grow and make a difference in a supportive and evolving workplace.

Benefits

Medical Insurance

Dental Insurance

Vision Insurance

401K with employer match

Free Legal Services

Employee Loan Program

Qualifications

• 3+ years of experience with T-SQL, loading and exporting data.
• 2+ years of experience with Salesforce and Power BI.

Responsibilities

• Create and maintain operational reporting in Salesforce and Power BI.
• Analyze and manipulate data for ad-hoc analysis.

Skills

T-SQL

Salesforce Sales Cloud

Power BI

Advanced Excel

Data Analysis

Communication Skills

Self-Motivation

Organization Skills

Education

Bachelor's degree or equivalent experience

Tools

Salesforce

Power BI

Excel

Git

Azure DevOps

Job description

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