Sr. Business Intelligence (BI) Data Analyst

Bayview Asset Management; Scottsdale (AZ); Remote; USD 100,000 - 115,000; Full time

Job summary

A leading company in mortgage banking seeks a Senior Business Intelligence Data Analyst to develop and maintain KPIs and reports across its operations. This remote role demands strong analytical and communication skills, requiring a Bachelor’s degree and at least 5 years of BI experience. The position offers a competitive salary, bonuses, and comprehensive benefits from day one.

Benefits

Competitive salary

Annual bonus

Medical benefits starting on day one

Company-matched 401(k)

Qualifications

• Minimum of 5 years of experience in business intelligence/analytics, preferably in mortgage banking.
• Strong technical proficiency in SQL, DAX, and Power BI.
• Experience with large datasets and data analysis.

Responsibilities

• Gather and analyze data to identify trends and improvements.
• Design dashboards and develop KPIs for decision-making.
• Collaborate with business units to optimize data usage.

Skills

Analytical skills

Communication skills

SQL

DAX

PowerQuery

Data warehousing concepts

Education

Bachelor’s degree in relevant fields (Computer Science, Finance, etc.)

Tools

Power BI

MS Excel

Snowflake

SSMS

Job description

Overview

The Senior Business Intelligence (BI) Data Analyst is responsible for developing, publishing, and maintaining a comprehensive catalog of key performance indicators (KPIs) and reports across functional areas of the mortgage business. This includes building and validating metrics, integrating datasets, monitoring data quality, analyzing data, and interpreting results to provide actionable insights that drive business value. The role offers high visibility and cross-functional collaboration across all departments within the Consumer Direct (CD) and Third-Party Originations (TPO) channels. The ideal candidate brings a strong analytical mindset, excellent communication skills, and deep expertise in mortgage banking.

This 100% remote role offers a competitive salary range of $100,000 to $115,000, an annual bonus, medical benefits starting on day one, and a company-matched 401(k).

Responsibilities

• Gather and analyze data from multiple systems to identify trends, opportunities, and areas for improvement within the sales and marketing departments.
• Drive data-informed decision-making by designing dashboards, building out key performance indicators (KPIs), and developing self-service tools to empower internal teams.
• Collaborate with business units across CD and TPO channels to define reporting needs, optimize data usage, and provide actionable recommendations that enhance business strategies.
• Partner with leadership to develop reports that track risk, operational performance, compliance, and customer satisfaction, supporting overall business success.
• Extracting, transforming, and loading data from various sources to create cohesive datasets in Power BI.
• Design dashboards and write code to translate reporting requirements into technical solutions using SQL and Power BI.
• Oversee and manage tickets within Lakeview’s Originations and Correspondents reporting pipeline, ensuring timely and accurate completion.
• Research and analyze key business requirements needed for report requests to translate into analytical solutions.
• Conduct ad-hoc analyses to support business initiatives and address specific inquiries from stakeholders.
• Ensure data integrity and report accuracy by conducting regular quality checks, troubleshooting discrepancies, and validating data across systems.
• Act as the subject matter expert on mortgage reporting tools, methodologies, and industry best practices
• Provide guidance and education to other Business Intelligence Analysts as necessary.
• Other duties as assigned.

Qualifications

• Bachelor’s degree in Computer Science, Finance, Business Administration, Mathematics, Business Intelligence, or related field.
• Minimum of 5 years of experience in business intelligence, analytics, or a related field. Preferably with a focus on the mortgage banking industry
• Encompass and servicing platform experience preferred.
• Strong knowledge of SQL, DAX, and PowerQuery.
• Proficient in using MS Excel, PowerBI, Snowflake, and SSMS.
• Strong analytical skills.
• Experience working with large datasets and data warehousing concepts.
• Excellent communication and presentation skills, with the ability to effectively communicate findings to both technical and non-technical audiences.
• Ability to interact and communicate with stakeholders, particularly executives or senior leaders.
• Ability to work independently and manage multiple priorities in a fast-paced environment.

Lakeview is an Equal Employment Opportunity employer. All aspects of consideration for employment and employment with the Company are governed on the basis of merit, competence and qualifications without regard to race, color, religion, sex, national origin, age, disability, veteran status, sexual orientation, or any other category protected by federal, state, or local law.

#LI-Remote

• Bachelor’s degree in Computer Science, Finance, Business Administration, Mathematics, Business Intelligence, or related field.
• Minimum of 5 years of experience in business intelligence, analytics, or a related field. Preferably with a focus on the mortgage banking industry
• Encompass and servicing platform experience preferred.
• Strong knowledge of SQL, DAX, and PowerQuery.
• Proficient in using MS Excel, PowerBI, Snowflake, and SSMS.
• Strong analytical skills.
• Experience working with large datasets and data warehousing concepts.
• Excellent communication and presentation skills, with the ability to effectively communicate findings to both technical and non-technical audiences.
• Ability to interact and communicate with stakeholders, particularly executives or senior leaders.
• Ability to work independently and manage multiple priorities in a fast-paced environment.

Lakeview is an Equal Employment Opportunity employer. All aspects of consideration for employment and employment with the Company are governed on the basis of merit, competence and qualifications without regard to race, color, religion, sex, national origin, age, disability, veteran status, sexual orientation, or any other category protected by federal, state, or local law.

#LI-Remote

• Gather and analyze data from multiple systems to identify trends, opportunities, and areas for improvement within the sales and marketing departments.
• Drive data-informed decision-making by designing dashboards, building out key performance indicators (KPIs), and developing self-service tools to empower internal teams.
• Collaborate with business units across CD and TPO channels to define reporting needs, optimize data usage, and provide actionable recommendations that enhance business strategies.
• Partner with leadership to develop reports that track risk, operational performance, compliance, and customer satisfaction, supporting overall business success.
• Extracting, transforming, and loading data from various sources to create cohesive datasets in Power BI.
• Design dashboards and write code to translate reporting requirements into technical solutions using SQL and Power BI.
• Oversee and manage tickets within Lakeview’s Originations and Correspondents reporting pipeline, ensuring timely and accurate completion.
• Research and analyze key business requirements needed for report requests to translate into analytical solutions.
• Conduct ad-hoc analyses to support business initiatives and address specific inquiries from stakeholders.
• Ensure data integrity and report accuracy by conducting regular quality checks, troubleshooting discrepancies, and validating data across systems.
• Act as the subject matter expert on mortgage reporting tools, methodologies, and industry best practices
• Provide guidance and education to other Business Intelligence Analysts as necessary.
• Other duties as assigned.