PENNYMAC · 2 weeks ago
Sr Data Platform Engineer - SQL Server Specialist
Westlake Village, CA
Full-time
Onsite
Mid, Senior Level
$90K/yr - $150K/yr
5+ years expPennymac is a specialty financial services firm focused on the production and servicing of U.S. mortgage loans. The Sr Data Platform Engineer - SQL Server Specialist will lead the design, optimization, and management of the enterprise data platform infrastructure, primarily focusing on advanced SQL Server implementations to support critical business functions and AI/ML initiatives.
BankingFinanceFinancial ServicesLendingMortgage
Responsibilities
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
Qualification
Required
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
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
Experience architecting or supporting data pipelines for AI/ML workloads, including feature engineering, data preparation, and model-serving infrastructure
Experience with Snowflake, cloud data warehousing concepts, and hybrid on-premises/cloud database strategies
Financial Services and mortgage industry experience, particularly with regulatory reporting, risk management, and loan servicing data requirements
Benefits
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
Company
PENNYMAC
Pennymac is a home loan lending company that offers financial services.
1001-5000 employees
H1B Sponsorship
PENNYMAC has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (48)
2024 (42)
2023 (33)
2022 (44)
2021 (65)
2020 (34)
Funding
Current Stage
Public CompanyTotal Funding
$2.33B2025-12-11Post Ipo Debt· $75M
2025-08-07Post Ipo Debt· $650M
2024-05-20Post Ipo Debt· $850M
Leadership Team
Amar Nadig
Senior Vice President of Enterprise Data
Kevin Ryan
Senior Managing Director and Chief Strategy Officer
Recent News
MarketScreener
2025-12-20
2025-12-16
2025-11-06
Company data provided by crunchbase