Power BI Development Analyst

Overview

The Power BI Development Analyst will be responsible for querying, leveraging relational databases, and transforming large data sets through Power BI into reports and visualizations to inform senior-level decision-making and improve operational processes with our servicing partners.

The Power BI Development Analyst must have a strong understanding of SQL and frameworks to enhance data reporting capabilities. This position is responsible for working with the MSR Portfolio Management Team to develop dashboards, perform database testing, warehouse documentation, handle operational priority requests, and support the MSR business initiatives. The ideal candidate would have experience working in mortgage servicing with familiarity with government mortgages.

This is a hybrid position, reporting to our office in Fort Lauderdale, FL, three days per week. This position offers a competitive salary range of $75,000 to $86,000, an annual bonus, benefits starting on day one, and a company-matched 401(k) plan.

• Compile, clean, and structure large datasets to enable accurate and comprehensive analysis
• Develop and maintain Power BI dashboards, conduct data testing, and collaborate with business stakeholders on reporting solutions
• Write and optimize complex SQL queries while ensuring accuracy, consistency, and data integrity
• Automate data extraction from multiple sources and leverage Microsoft Power BI to build, support, and enhance dashboards
• Identify and implement opportunities for process improvements and operational efficiencies
• Perform ad hoc data quality checks and apply manual corrections to pipeline data to support data governance and issue remediation
• Derive and clearly communicate actionable insights that inform business decisions
• Simplify and translate complex datasets into clear, meaningful narratives for non-technical audiences
• Thrive under pressure by effectively managing multiple priorities and deadlines

• A master’s degree in Computer Science, Big Data, or Information Management is desired
• Minimum of 1 year of professional experience in data governance and data quality management, with hands-on use of data quality tools
• Strong expertise in relational databases (SQL Server, MySQL) and ORM frameworks, with a solid foundation in database design and optimization
• Proficient in the Microsoft Power BI ecosystem, including Power BI Desktop, Power BI Service, and Power Query, with experience in dashboard design and reporting
• Proficient in programming languages such as Python, R, or similar data analysis and automation tools
• Knowledgeable in data profiling, statistical analysis, data cleansing, and standardization techniques to ensure accuracy and reliability of insights
• Familiarity with data warehouse development, including reconciliation and validation frameworks, is considered an asset
• Mortgage industry exposure is preferred, as well as an understanding of domain-specific data and reporting requirements

• Relevant certifications (e.g., Microsoft Power BI, Data Science, or data quality tools) are a plus

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.