Hybrid Business Intelligence Analyst bei Verus Mortgage Capital
Verus Mortgage Capital · Washington, Vereinigte Staaten Von Amerika · Hybrid
- Professional
- Optionales Büro in Washington
Responsibilities and Duties:
- Use data manipulation tools such as SQL and VBA to collect, clean, manage and/or interpret large and/or complex datasets for organizational analysis.
- Perform advanced and/or large-scale data modeling to identify trends, forecast resource needs, and assess operational risks.
- Develop and manage a centralized data repository to ensure data integrity and accessibility.
- Design and implement interactive dashboards using tools like Tableau, Power BI, and advanced Excel functionalities for data manipulation and automation (macros, Power Query).
- Translate organizational metrics involving companies in mortgage and/or financial services industries, such as productivity, performance, and engagement, into actionable insights through predictive modeling.
- Generate periodic and ad hoc reports to support business strategy and performance reviews.
- Partner with leadership to develop data-driven compensation models incorporating industry benchmarks.
- Analyze pay equity and recommend adjustments to ensure compliance and competitiveness.
- Develop performance scorecards aligned with organizational goals, utilizing KPIs to enhance evaluation processes.
- Conduct in-depth analyses of trends to support strategic planning in areas such as resource allocation, turnover, and optimization.
- Present findings and strategic recommendations to senior leadership, ensuring data is translated into actionable strategies.
- Support decision-making processes with scenario planning and predictive analytics.
- Collaborate with IT and other teams to automate data collection and reporting processes for improved efficiency.
- Enhance data visualization processes to simplify complex data for stakeholders.
- Evaluate and recommend new business intelligence tools and technologies to improve analytics capabilities.
- Manage sensitive data with strict adherence to confidentiality and data protection policies.
- Ensure compliance with applicable regulations in data handling, storage, and reporting.
Education and Experience:
- Bachelor’s degree, or its foreign equivalent, in Data Analytics, Business Intelligence, Economics, Finance, or a related quantitative field
- 3 years of experience in business intelligence, data analytics, or financial analysis involving large-scale data modeling, complex datasets and reporting, including at least 1 year of experience: (a) using SQL and VBA for data manipulation; (b) involving metrics and analytics specific to the mortgage or financial services industry; and
- Proficiency in Excel for data manipulation and automation (candidate must be able to pass a test administered by Criteria Corp and achieve a score of Advanced).
- Travel to Minnesota office will be required (appx. 10% of the time).
- Advanced Data Analysis & Modeling: Skilled in SQL, VBA, and large-scale data modeling to identify trends, forecast needs, and assess risks.
- Business Intelligence & Visualization: Proficient in Tableau, Power BI, and advanced Excel for creating interactive dashboards and translating metrics into actionable insights.
- Strategic Thinking & Decision Support: Ability to conduct in-depth trend analyses, develop strategic recommendations, and support leadership decision-making.
- Compensation & Performance Analytics: Expertise in developing data-driven compensation models, pay equity analysis, and performance scorecards.
- Technology Integration & Automation: Experience collaborating with IT to automate reporting, streamline data collection, and evaluate new BI tools.
- Data Governance & Compliance: Strong adherence to data security standards and regulatory compliance in data handling and reporting.
How This Role Demonstrates Our Values:
- Integrity: Ensures data accuracy, confidentiality, and compliance with all regulatory requirements
- Collaboration: Works closely with leadership, IT, and cross-functional teams to deliver insights that support company-wide goals.
- Excellence: Produces high-quality analytics, visualizations, and reports that enhance strategic decision-making.
- Critical Curiosity: Proactively explores new tools, technologies, and analytical approaches to uncover deeper insights and innovative solutions.
Benefits
Position requires: a Bachelor’s degree, or its foreign equivalent in Data Analytics, Business Intelligence, Economics, Finance, or a related quantitative field plus 3 years of experience in business intelligence, data analytics, or financial analysis involving large-scale data modeling, complex datasets and reporting, including (i) at least 1year of experience: (a) using SQL and VBA for data manipulation; (b) involving metrics and analytics specific to the mortgage or financial services industry; and (ii) Proficiency in Excel for data manipulation and automation [Candidate must be able to pass a test administered by Criteria Corp and achieve a score of Advanced]. Travel to Minnesota office will be required (appx. 10% of the time). Salary range is: $111,000 - $131,000/year.
Apply on-line at: https://invictus-verus.pinpointhq.com/verus-mortgage or e-mail resume with cover letter to: [email protected]
Benefits
- Great compensation package
- Attractive benefits plans and paid time off
- 401(k) w/ company matching
- Professional learning and development opportunities
- Tuition Reimbursement
- And much more!
Successful applicants will exemplify strong ethics, integrity, respect for others, accountability for decisions and actions, and good citizenship.
Maintaining a reliable, uninterrupted high speed internet connection is a requirement of hybrid or remote positions.