Pennymac
Pennymac has the mindset and agility of a startup, with the power and backing of a large public company.
Los Angeles, CA

Sr SQL Developer at Pennymac

| Los Angeles, CA
Sorry, this job was removed at 8:49 a.m. (CST) on Thursday, February 3, 2022
Find out who's hiring in Los Angeles, CA.
See all Developer + Engineer jobs in Los Angeles, CA
Apply Now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Overview
As a senior SQL developer in the data-warehouse team, this role will be responsible for design, development, testing, and implementation of a set enterprise level data warehouse systems and solutions. This involves leading projects from a technical development perspective including oversight over junior SQL developers. This role requires following strict Software Development Life Cycle development and implementation guidelines. Responsibilities also include technical leadership and effective communication, conducting peer code review and suggesting remediation path, supporting business needs with ad-hoc needs requests and organizing and presenting data to multiple levels of management.
Job Description
  • Facilitate data retrieval and manipulation through implementation of views, stored procedures, triggers and cursors
  • Design and develop ETLs to move data across internal servers utilizing input variables for easier deployment to different environments
  • Design and develop ETLs to move data across external SFTP utilizing input variables for easier deployment to different environments
  • Apply ETL error handling and package logging that stores results into SQL tables for ease of troubleshooting
  • Optimize query performance by modifying existing queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing tables objects
  • Optimize query performance tuning by reading executing plans, maintaining indexes, database refactoring (making code more efficient and maintainable)
  • Knowledgeable of cloud services such as Snowflake, Amazon AWS and Microsoft Azure
  • Deploy SSIS packages for ETL using Integration Catalog utilizing input variables for easier deployment to different environments
  • Architect ETL enhancements to increase the performance data warehouse using query manager and optimizer
  • Conduct peer code review on ETL, stored procedures, views, functions to identify performance problems, inadequate programming and data duplication and suggest a remediation path
  • Proactively research, present and make recommendations regarding new SQL features
  • Organize, prepare, and present data to senior management
  • Provide leadership, training, and oversight of other analysts' activities, deliverables, and performance
  • Follow strict Software Development Life Cycle development and implementation guidelines
  • Perform other related duties as required and assigned
  • Demonstrate behaviors which are aligned with the organization's desired culture and values
Ideal Candidate will have the following:
  • 5+ years of MS SQL database and SQL Information Services knowledge and development experience
  • Ability to design, code, test, debug, package and deploy quality, scalable and well documented SQL solutions
  • Experience with SSIS, Informatica or other ETL tools
  • Programming experience with emphasis on designing complex SQL queries and business components
  • Ability to collaborate with other developers, business analysts, project managers, business users, vendors, and management
  • Team player with strong communication and interpersonal skills, possess a high degree of self-motivation and ability to work independently with minimal supervision
  • Proven track record at delivering timely and accurate information in a fast-paced environment
  • Financial Services and, if possible, mortgage industry experience preferred
  • Strong business acumen and ability to interface with executive management
Years of Experience:
3Education:
Bachelor's Degree
See More
Apply Now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
    • .NETLanguages
    • PerlLanguages
    • PythonLanguages
    • RubyLanguages
    • AWS Cloud ServicesLanguages
    • jQueryLibraries
    • jQuery UILibraries
    • ReactLibraries
    • ReduxLibraries
    • AngularJSFrameworks
    • Node.jsFrameworks
    • Ruby on RailsFrameworks
    • SpringFrameworks
    • MongoDBDatabases
    • MySQLDatabases
    • PostgreSQLDatabases
    • TableauAnalytics
    • ConfluenceManagement
    • Google DriveManagement
    • Google DocsManagement
    • Google SlidesManagement
    • JIRAManagement
    • GitLabManagement
    • SalesforceCRM
Previous
Next

What are Pennymac Perks + Benefits

Pennymac Benefits Overview

Pennymac puts its people first. Our generous health, dental and vision benefits are available to all full-time employees. Our tech department also hosts fun, team-building events and activities.

Culture
Volunteer in local community
Partners with Nonprofits
Friends outside of work
Eat lunch together
Intracompany committees
Daily sync
Open door policy
Team owned deliverables
Team based strategic planning
Group brainstorming sessions
Pair programming
Open office floor plan
Diversity
Dedicated Diversity/Inclusion Staff
Highly diverse management team
Unconscious bias training
Diversity manifesto
Diversity Employee Resource Groups
Hiring Practices that Promote Diversity
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Wellness Programs
Onsite Gym
Mental Health Benefits
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Company Equity
Employee Stock Purchase Plan
Performance Bonus
Child Care & Parental Leave Benefits
Family Medical Leave
Vacation & Time Off Benefits
Generous PTO
Paid Holidays
Paid Sick Days
Perks & Discounts
Casual Dress
Commuter Benefits
Company Outings
Game Room
Stocked Kitchen
Some Meals Provided
Fitness Subsidies
Professional Development Benefits
Job Training & Conferences
Diversity Program
Lunch and learns
Promote from within
Mentorship program
Time allotted for learning
Online course subscriptions available
Customized development tracks

An Insider's view of Pennymac

What are some social events your company does?

Our Tech team has great events, including casino & trivia nights, virtual happy hours, gaming - we’ve even sponsored a video game tournament against our industry competitors! We’re nationally disbursed, but regardless of where people live, we’re all part of one interactive, linked community, and it’s easy to find others who share your interests.

Juan

Senior Developer, Production

How do you collaborate with other teams in the company?

The culture at Pennymac has cultivated a great sense of teamwork in which we all succeed, fail, and learn together. We collaborate in many ways - from video calls to morning coffee hours, ad hoc huddles, email, chat, and sometimes while playing ping pong or pool in the cafeteria. Everyone is encouraged to work together to accomplish a common goal.

Mandy

Vice President, IT Program Management

How has your career grown since starting at the company?

My time at Pennymac has rocketed my career as a software dev. In two years I went from having no professional coding background to managing three applications in production, managing two direct staff and contributing to open-source libraries. My time has given me the experience and skills to successfully create new tech products that make money.

John

Assistant Vice President, Application Development

How do your team's ideas influence the company's direction?

As a company, we're one very cohesive, supportive team with various areas of expertise. It's like a potluck - everyone brings something different, but it all comes together perfectly. Company management believes in us, trusts us, and invests in us. That provides the opportunity to build positive outcomes for our business and our customers.

Nick

Managing Director, Technology Infrastructure

What are some things you learned at the company?

Our team constantly works to better itself by delivering software on time without shortcuts or compromising quality. At Pennymac, I have the opportunity to own many critical day-to-day database operations. I've had the flexibility to be innovative, which has allowed me to grow as a developer.

Pavan

Senior Developer, Database

More Jobs at Pennymac