Pennymac (NYSE: PFSI) is a specialty financial services firm with a comprehensive mortgage platform and integrated business focused on the production and servicing of U.S. mortgage loans and the management of investments related to the U.S. mortgage market. 

At Pennymac, our people are the foundation of our success and at the heart of our dynamic work culture. Together, we work towards a unified goal of helping millions of Americans achieve aspirations of homeownership through the complete mortgage journey.

The Sr Data Platform Engineer - SQL Server Specialist leads the design, optimization, and management of our enterprise data platform infrastructure, with a primary focus on advanced SQL Server implementations. This role supports critical business functions through sophisticated database platform development, including pricing analytics, trading systems, hedging models, and pooling operations, ensuring scalable, performant, and reliable data solutions across the organization. You'll leverage modern AI-assisted development tools to accelerate development cycles while also architecting data solutions that power AI/ML initiatives across the business—from predictive analytics to intelligent automation.

The Sr Data Platform Engineer - SQL Server Specialist will:

• Advanced SQL Server Expertise - Architect, optimize, and manage complex SQL Server environments including Always On Availability Groups, Replication, Mirroring, and performance tuning at enterprise scale
• Expert T-SQL Development - Design and implement advanced features including stored procedures, dynamic SQL, Common Table Expressions (CTEs), window functions, and query optimization for complex data operations
• Database Architecture & Design - Lead enterprise data modeling, dimensional modeling, and modern database design patterns in SQL Server
• High Availability & Disaster Recovery - Design and manage SQL Server HA/DR solutions including backup strategies, failover clustering, and business continuity planning
• Strong proficiency with Python 3, Object-Oriented Programming & Design Patterns for data pipeline development
• Solid experience with Amazon Web Services (AWS) and serverless technologies for data integration
• Strong experience with advanced SQL, query optimization, and database performance tuning
• Experience with REST APIs and data integration patterns
• Experience with Git and collaborative development workflows
• Experience with comprehensive testing strategies including unit and integration testing
• Experience with event-driven architectures and microservices in data contexts
• Experience with Infrastructure as Code (CloudFormation, CDK, Terraform)
• Knowledge of DataOps practices (CI/CD for data pipelines, automated testing)
• Knowledge of Agile, Scrum, Jira methodologies
• Preferred: Experience with AI-assisted development tools (Cursor, GitHub Copilot, ChatGPT, etc.) to accelerate coding and architecture design
• Preferred: Experience architecting or supporting data pipelines for AI/ML workloads, including feature engineering, data preparation, and model-serving infrastructure
• Preferred: Experience with Snowflake, cloud data warehousing concepts, and hybrid on-premises/cloud database strategies

• Degree in Computer Science, Data Engineering, Engineering, or similar technical major
• 5+ years of software development experience with 4+ years of advanced SQL Server experience
• Expert-level SQL Server skills including performance optimization, High Availability/Disaster Recovery, cost management, and enterprise-scale implementations
• Deep understanding of relational database concepts, ETL/ELT patterns, OLTP/OLAP, and modern data architecture principles
• Extensive experience with SQL Server administration, including indexing strategies, query execution plans, and performance monitoring
• Extensive experience with databases at enterprise scale, including both relational and NoSQL technologies
• Demonstrated ability to master advanced database platform technologies such as replication, streaming, data orchestration, governance, security, monitoring, or performance optimization
• Proven track record of architecting and implementing business-critical database solutions that improve stability, security, performance, and scalability
• Demonstrated ability to effectively communicate complex database architecture concepts to engineers, product owners, project managers, and business stakeholders
• Demonstrated experience in multi-team collaboration and agile development practices, particularly in data-focused environments
• Ability to collaborate across teams and design database systems that address architectural gaps and scalability challenge
• Comfort learning and adopting emerging technologies, including AI-assisted development tools and AI-driven data solutions
• Preferred: Financial Services and mortgage industry experience, particularly with regulatory reporting, risk management, and loan servicing data requirements

As one of the top mortgage lenders in the country, Pennymac has helped over 4 million lifetime homeowners achieve and sustain their aspirations of home. Our vision is to be the most trusted partner for home. Together, 4,000 Pennymac team members across the country are guided by our core values: to be Accountable, Reliable and Ethical in all that we do. Pennymac is committed to conducting a business that makes positive contributions and promotes long-term sustainable growth and to fostering an equitable and inclusive environment, where all employees and customers feel valued, respected and supported. 

Benefits That Bring It Home: Whether you're looking for flexible benefits for today, setting up short-term goals for tomorrow, or planning for long-term success and retirement, Pennymac's benefits have you covered. Some key benefits include: 

• Comprehensive Medical, Dental, and Vision
• Paid Time Off Programs including vacation, holidays, illness, and parental leave 
• Wellness Programs, Employee Recognition Programs, and onsite gyms and cafe style dining (select locations)
• Retirement benefits, life insurance, 401k match, and tuition reimbursement 
• Philanthropy Programs including matching gifts, volunteer grants, charitable grants and corporate sponsorships

To learn more about our benefits visit: https://pennymacnews.page.link/benefits

For residents with state required benefit information, additional information can be found at: https://www.pennymac.com/additional-benefits-information

Compensation: Individual salary may vary based on multiple factors including specific role, geographic location / market data, and skills and experience as defined below:

• Lower in range - Building skills and experience in the role
• Mid-range - Experience and skills align with proficiency in the role 
• Higher in range - Experience and skills add value above typical requirements of the role 

Some roles may be eligible for performance-based compensation and/or stock-based incentives awarded to employees based on company and individual performance.