Enterprise Data - Data Engineering - Associate
Reston, VA
| Employer: | Fannie Mae |
Description | |
|
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 assist with monitoring customer needs and intended uses of requested data in the development of database requirements and assist in the planning and engineering of enterprise databases. THE IMPACT YOU WILL MAKE The Enterprise Data - Data Engineering - Associate 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:
THE EXPERIENCE YOU BRING TO THE TEAM Desired Experiences
Skills Support Fannie Mae's financial data need from external and internal data sources and partners, and facilitate the inquiry and acquisition of financial data from them through technology developed both internally and externally. Provide ongoing analysis of new products or asset classes, and suggest program modifications as necessary. May test applications for accuracy and functionality before putting them into service. Determining causes of operating errors and taking corrective action The group of skills related to Product Testing including testing and evaluating software, usability testing, UAT, and using relevant product testing technology 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. Ability to frame ideas as systems and analyzing the inputs, outputs, and process Experience in the process of analyzing data to identify trends or relationships to inform conclusions about the data Skilled in cloud technologies and cloud computing Experience helping an organization to plan and manage change in effort to meet strategic objectives 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 Understand how application is setup in AWS and how to test applications hosted in AWS. Communicate with internal teams to answer business questions, clarify requirements and perform UAT Understand how external market data, mainly securities and derivatives prices, various interest rates, and analytics flowing from external data vendors and partners, into Fannie Mae's internal systems, and understand how the data get transformed into different xml and json formats and how the data feed into downstream systems Communicate with existing external data vendors and partners for any data issues in delivery, consistence, and precision, and connect internal customer demand with external vendors. Search data and data sources among external data vendors based on Fannie Mae's business needs, find proper channel like SFTP, HTTPS, curl to bring that data into the company, familiar with how public data is provided by the Treasury, SEC, and Federal Reserve and how to acquire it Use and modify formula to calculate and verify analytics feed into internal systems based on the security value changes caused by the market move when needed. Support existing internally developed applications that bring in the external data, trouble shoot data issues, help development team and operations team to support internal infrastructure, interfaces, and registration. 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 Experience using JIRA Skilled in Alteryx for data analytics applications Skilled in JSON Qualifications Education: Bachelor's Level Degree (Required) 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: 107000 to 139000 | |