P

Pennymac

First Vice President, Data & Analytics

Data Management +1Confirmed live in the last 24 hours
Full-timeCarrollton, TX, USA

About the Job

Requirements

  • Deep expertise in SQL against large production datasets, including traditional relational database management systems such as SQL Server and T-SQL, and Snowflake.
  • Proven experience owning or leading enterprise data mart, hub, or warehouse engineering, including extract-transform-load or extract-load-transform processes, stored procedures, and pipeline reliability; report development alone is insufficient.
  • Experience adopting and leading teams in AI-assisted engineering workflows; Cursor is preferred, with rigorous review of AI-generated code and SQL.
  • Strong understanding of financial and operational drivers in financial services; mortgage banking, servicing, or production finance experience is strongly preferred.
  • Hands-on fluency with data quality, reconciliation, and validation methods at scale, including completeness, accuracy, and schema or contract drift.
  • Experience with platform migration and dual-running environments involving legacy SQL Server and Snowflake, including timing windows, type alignment, and cutover risk management.
  • Familiarity with continuous integration and continuous delivery for data, such as Git-based change management and Liquibase or equivalent, and structured collaboration with IT release processes.
  • Ability to decode and communicate field-level business logic and lineage to executives, auditors, and downstream analytics consumers.
  • Ability to prioritize multiple concurrent initiatives in a dynamic production environment.
  • Proficiency with Excel and presentation tools for stakeholder communication; advanced spreadsheet work is supporting rather than the core craft.
  • Track record of delivering timely, accurate information under operational pressure.
  • Ability to interface with executive management, IT, and control partners.
  • Ability to lead engineers while remaining technically credible, with high attention to detail.

Responsibilities

  • Own strategy and delivery for Production Finance Data Mart and Hub assets, including tables, stored procedures, and pipelines that transform enterprise information into consumption-ready structures.
  • Set engineering standards for sequential, high-performance SQL in legacy T-SQL and Snowflake SQL, deployment discipline, and operational reliability.
  • Partner with IT on storage, transformation, security, and change-control protocols across on-premises SQL Server and Snowflake.
  • Drive modernization of legacy SQL Server data platforms to Snowflake, maintaining strict standards for timing, syntax, and data-type alignment during cutover.
  • Establish and scale team standards for AI-assisted development using Cursor and related AI coding tools for SQL authoring, migration, validation, lineage analysis, and operational triage.
  • Define guardrails to ensure AI-assisted development preserves data correctness, security, change control, and production deployment discipline.
  • Coach engineers on human-in-the-loop use of Cursor, including prompt discipline, review of AI-generated SQL and scripts, and accountability for outcomes.
  • Evaluate opportunities to improve throughput and consistency through AI-augmented workflows while keeping ownership of production decisions with the team.
  • Lead the division’s data governance framework by identifying, designing, implementing, and supporting data quality improvement initiatives using manual and automated controls.
  • Establish continuous monitoring to detect, correct, and prevent invalid data; own issue tracking, remediation with business and IT partners, and quality metrics tied to organizational standards.
  • Direct validation and triage practices, including schema alignment, completeness, and cell-level reconciliation, so production hubs remain trusted sources for risk, operations, and finance outcomes.
  • Ensure field-level business logic and lineage are documented and explainable to downstream consumers and control partners.
  • Enable executive reporting and analytics by ensuring hubs, metric definitions, and data contracts support monthly executive management reporting, business reviews, and recurring daily, weekly, and monthly management metrics.
  • Provide leadership and prioritization so operations and finance leaders receive accurate, timely data for planning, efficiency, controls, and client experience; coordinate with reporting and analytics partners rather than building dashboards or presentation layers as the team’s core product.
  • Evaluate and implement strategies for using data and metrics to predict, improve, and measure fundamental risks to the division and operation.
  • Oversee development of operational capacity and forecast inputs, including volumes and staffing drivers, insofar as they depend on hub data products, metric definitions, and reliable historical and current-state data.
  • Lead delivery of key corporate and financially material data initiatives affecting Production Finance.
  • Oversee investor and business partner contractual obligations related to data and reporting delivery, including definitions, timeliness, reconciliation, and change management.
  • Align internal and external parties on data handoffs and process integrity for financially impacting workflows that depend on hub outputs.
  • Perform other related duties as required and assigned.

Desired Qualifications

  • Cursor experience is preferred.
  • Mortgage banking, servicing, or production finance experience is strongly preferred.

About the Company

Company size
Not listed
Company stage
Not listed
Total funding
Not listed
Headquarters
Not listed
Founded
Not listed

Recently Posted Jobs

Explore more opportunities at Pennymac

See more jobs