SQL Developer

| Moorpark
Apply Now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
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
Read Full Job Description
Apply Now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Technology we use

  • Engineering
    • .NETLanguages
    • JavaLanguages
    • PerlLanguages
    • PythonLanguages
    • RubyLanguages
    • SqlLanguages
    • jQueryLibraries
    • jQuery UILibraries
    • ReactLibraries
    • ReduxLibraries
    • AngularJSFrameworks
    • Node.jsFrameworks
    • Ruby on RailsFrameworks
    • SpringFrameworks
    • Microsoft SQL ServerDatabases
    • MongoDBDatabases
    • MySQLDatabases
    • PostgreSQLDatabases

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
Apply Now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Save jobView Pennymac's full profileSee more Pennymac jobs