Lead Database Engineer - Redshift and Data Warehousing

You need to sign in or
create an account to save a job.
Company Description

At Fannie Mae, futures are made. The inspiring work we do makes an affordable home areality and a difference in the lives of Americans. Every day offers compelling opportunities to modernize the nation's housing finance system while being part of an inclusive team using new, emerging technologies. Here, you will help lead our industry forward, enhance your technical expertise, and make your career.

Job Description

As a valued colleague on our team, you will act as the team lead in designing and developing advanced solutions for information technology (IT) infrastructure environments, including coding, testing, and certifying technology platforms, software, and applications, as well as coach and mentor team members.


The Lead Database Engineer - Redshift and Data Warehousingrole will offer you the flexibility to make each day your own, while working alongside people who care so that you can deliver on the following responsibilities:
  • Apply your advanced skills and knowledge to develop solutions for application design and IT infrastructure components.
  • Understand the end-to-end performance of IT platforms and account for interrelated functionality and processes when developing designs.
  • Establish and maintain policies, guidelines, and standard operating procedures.
  • Monitor performance and capacity metrics for technology solutions and lead the team in addressing identified issues



Minimum Required Experiences
  • 5+ years

Desired Experiences
  • Bachelor degree or equivalent
  • Datawarehouse with Redshift
  • Python and/or Java experience

  • Working with people with different functional expertise respectfully and cooperatively to work toward a common goal
  • Ability to effectively address technical questions/with various audiences, including non-technical teams, at all levels in the organization
  • Experience in designing and implementing Cloud service solutions including aspects like compute, network, storage, security, monitoring, automation, and cost optimization
  • Communication including excellent verbal and written communication skills with a high degree of comfort with both large and small audiences
  • Experience in engineering and developing, solutions that require integration with various cloud services.
  • Data warehouse development/admin experience for both on prem and cloud technologies.
  • Knowledge of Redshift, AWS RDS, Aurora, DynamoDB, S3 and other datastore cloud surrounding technologies.
  • Solid knowledge of cloud Security skills specifically on common controls for API security (SSO, OAuth, Threat Protection)
  • Ability to frame ideas as systems and analyzing the inputs, outputs, and process
  • Determining causes of operating errors and taking corrective action
  • Adept at managing project plans, resources, and people to ensure successful project completion
  • Experience in various data types such as XML, JSON, Parquet
  • UNIX Shell Scripting, Windows PowerShell, Python, PL/SQL, SQL

  • AWS
  • Datawarehouse appliances (Redshift, Netezza) and services
  • Data migration technologies
  • Bitbucket
  • MyServices
  • JIRA

Additional Information

Job REF ID: REF8724Q

The future is what you make it to be. Discover compelling opportunities at Fanniemae.com/careers.

Fannie Mae is an Equal Opportunity Employer, which means we are committed to fostering a diverse and inclusive workplace. All qualified applicants will receive consideration for employment without regard to race, religion, national origin, gender, gender identity, sexual orientation, personal appearance, protected veteran status, disability, age, or other legally protected status. For individuals with disabilities who would like to request an accommodation in the application process, email us at careers_mailbox@fanniemae.com.