Pennymac
Pennymac has the mindset and agility of a startup, with the power and backing of a large public company.
Moorpark
Hybrid

SQL Developer at Pennymac

Sorry, this job was removed at 8:49 a.m. (CST) on Thursday, February 3, 2022
Find out who's hiring in Other US Location.
See all Data + Analytics jobs in Other US Location
Apply
By clicking Apply Now you agree to share your profile information with the hiring company.
Overview
The SQL Developer provides responsibilities include maintenance for SQL objects (stored procedures, tables, views, functions) DTSX/ETL packages, examination of business processes, preparing process flows, and writing business requirements and test scripts for technology projects and organizing and presenting data to management and providing analytical support to senior leadership. Actively participates in strategic department meetings and provides technical insight to management to create client processes. Works with internal and external business partners to collaborate and deliver enterprise related project and divisional projects as appropriate.
Job Description
  • Maintenance/New development of SQL objects (stored procedures, tables, views, functions)
  • Maintenance/New development of DTSX/ETL packages
  • Perform complex User acceptance testing
  • Ability to manage multiple projects end to end from analysis, requirements gathering and documentations, UAT, and Post Production verification
  • Monitor and send recurring reporting
  • Querying for ad-hoc data requests
  • Creation of reporting Views
  • Gather requirements for new reporting
  • Develop of new reporting views
  • Organize, prep, and present data to management
  • Develop and perform complex analysis and modeling
  • Provide Training to other team members
  • Take part in strategic department and divisional projects
  • Performs other related duties as required and assigned
  • Demonstrates behaviors which are aligned with the organization's desired culture and values
Ideal Candidate will have the following:
  • Advanced skills with SQL database (stored procedures, views, functions, etl processes)
  • Strong skills with MS Office Excel and VBA
  • Must be a team player with strong attention to detail and able to work independently
  • Proven track record at delivering timely and accurate information in a fast-paced environment
  • Excellent critical thinking, problem solving, mathematical skills and sound judgment
  • 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 Apply Now you agree to share your profile information with the hiring company.

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

More Jobs at Pennymac

Apply Now
By clicking Apply Now you agree to share your profile information with the hiring company.
Learn more about PennymacFind similar jobs like this