Sr AWS Data Engineer

At Fannie Mae, the inspiring work we do helps make a home a possibility for millions of homeowners and renters. Every day offers compelling opportunities to impact the future of the housing industry while being part of a collaborative team thriving in an energizing environment. Here, you will grow your career and help create access to affordable housing finance.

Job Description

As a valued colleague on our team, you will contribute to developing data infrastructure and pipelines to capture, integrate, organize, and centralize data while testing and ensuring the data is readily accessible and in a usable state, including quality assurance.

THE IMPACT YOU WILL MAKE
 

The Sr AWS Data Engineer  role 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:

• Identify customer needs and intended use of requested data in the development of database requirements and support the planning and engineering of enterprise databases.

• Maintain comprehensive knowledge of database technologies, complex coding languages, and computer system skills.

• Support the integration of data into readily available formats while maintaining existing structures and govern their use according to business requirements.

• Analyze new data sources and monitor the performance, scalability, and security of data.

• Create an initial analysis and deliver the user interface (UI) to the customer to enable further analysis.

Minimum Required Experiences

• 2 years of Experience

Desired Experiences

• 5 years of Experience

• Bachelor degree or equivalent

Skills

• Hands-on in Designing and developing Microservices Java, Spring Boot

• Experience processing large amounts of structured and unstructured data

• Must have experience designing and building Integration solution (API) using modern technology stack

• Experience with Spark Amazon EMR & PySpark

• Skilled in cloud technologies and cloud computing
  Experience helping an organization to plan and manage change in effort to meet strategic objectives

• Experience monitoring and managing operation systems (OS), and staying current on patches, upgrades, and other elements of the OS

• Skilled in documentation and database reporting for the purposes of analysis, data discovery, and decision-making with the use of relevant software such as Crystal Reports, Excel, or SSRS

• The group of skills related to Governance and Compliance including creating policies, evaluating compliance, conducting internal investigations, developing data governance, etc.

• Determining causes of operating errors and taking corrective action

• Ability to frame ideas as systems and analyzing the inputs, outputs, and process

• Ability to transform business processes using BPA, RPA, or other technology-enabled automation

• Skilled in creating and managing databases with the use of relevant software such as MySQL, Hadoop, or MongoDB

• Skilled in discovering patterns in large data sets with the use of relevant software such as Oracle Data Mining or Informatica

• Adept at managing project plans, resources, and people to ensure successful project completion

• Experience using software and computer systems' architectural principles to integrate enterprise computer applications such as xMatters, AWS Application Integration, or WebSphere

• Working with people with different functional expertise respectfully and cooperatively to work toward a common goal

• The group of skills related to Communication including communicating in writing or verbally, copywriting, planning and distributing communication, etc.

• Skilled in the graphical representation of information in the form of a charts, diagrams, pictures, and dashboards with programs and tools such as Excel, Tableau, or Power BI

Tools

• Skilled in using UNIX

• Skilled in Oracle Database

• Skilled in AWS Analytics such as Athena, EMR, or Glue

• Skilled in AWS Database products such as Neptune, RDS, Redshift, or Aurora

• Skilled in Jenkins

• Skilled in SQL

• Skilled in TOAD SQL database management tool

• Skilled in Tableau

• Skilled in Excel

• Skilled in AWS Compute such as EC2, Lambda, Beanstalk, or ECS

• Skilled in Amazon Web Services (AWS) offerings, development, and networking platforms

• Skilled in MySQL Workbench

• Skilled in AWS Management and Governance suite of products such as CloudTrail, CloudWatch, or Systems Manager

• Skilled in JavaScript

• Experience using APIs for developing or programming software

• Skilled in Oracle PL SQL

• Skilled in Microsoft SQL Server

• Skilled in XML

• Skilled in Java

• Skilled in Power BI

• Skilled in Python object-oriented programming

• Skilled in Informatica

• Experience using JIRA

• Skilled in Alteryx for data analytics applications

• Skilled in JSON

Qualifications

Education:

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

For most roles, employees are encouraged to work onsite on a regular basis at their designated office location. In-office work cadence is determined by your manager. Proximity within a reasonable commute to your designated office location is preferred unless the job is noted as open to remote.

Fannie Mae is an equal opportunity employer and considers qualified applicants for employment without regard to race, color, religion, sex, national origin, disability, age, sexual orientation, gender identity/gender expression, marital or parental status, or any other protected factor. Fannie Mae is committed to providing reasonable accommodations to qualified individuals with disabilities who are employees or applicants for employment, unless to do so would cause undue hardship to the company. If you need assistance using our online system and/or you need a reasonable accommodation related to the hiring/application process, please complete this form.

The hiring range for this role is set forth below. Final salaries will generally vary within that range based on factors that include but are not limited to, skill set, depth of experience, certifications, and other relevant qualifications. This position is eligible to participate in a Fannie Mae incentive program (subject to the terms of the program). As part of our comprehensive benefits package, Fannie Mae offers a broad range of Health, Life, Voluntary Lifestyle, and other benefits and perks that enhance an employee's physical, mental, emotional, and financial well-being. See more here.

Requisition compensation:

to