Playing an essential role in the U.S. economy, Fannie Mae is foundational to housing finance. Here, your expertise can help fuel purpose-driven innovation that expands access to homeownership and affordable rental housing across the country. Join Fannie Mae to grow your career and help people find a place to call home.
Job Description
As a valued colleague on our team, you will provide expert advice and guidance to the team regarding the development of data infrastructures and pipelines to capture, integrate, organize, and centralize data while testing and ensuring data is readily accessible and in a usable state, including quality assurance.
THE IMPACT YOU WILL MAKE
The Enterprise Data - Data Engineering - Lead 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:
- Assess 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.
- Lead the team to organize and integrate data into readily available formats while maintaining existing structures and govern their use according to business requirements.
- Lead the analysis of new data sources and monitoring of performance, scalability, and security of data.
- Analyze the initial analysis and deliver the user interface (UI) to the customer to enable further analysis.
THE EXPERIENCE YOU BRING TO THE TEAM
Minimum Required Experiences
Desired Experiences
- Bachelor degree or equivalent
Skills
- The group of skills related to Risk Assessment and Management including evaluating and designing controls, conducting impact assessments, identifying control gaps, remediating risk, etc.
- The group of skills related to Product Testing including testing and evaluating software, usability testing, UAT, and using relevant product testing technology
- Skilled in discovering patterns in large data sets with the use of relevant software such as Oracle Data Mining or Informatica
- 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
- Skilled in cloud technologies and cloud computing
- Experience using software and computer systems' architectural principles to integrate enterprise computer applications such as xMatters, AWS Application Integration, or WebSphere
- Determining causes of operating errors and taking corrective action
- Experience in the process of analyzing data to identify trends or relationships to inform conclusions about the data
- Skilled in creating and managing databases with the use of relevant software such as MySQL, Hadoop, or MongoDB
- The group of skills related to Business Insight including advising, designing business models, interpreting customer and market insights, forecasting, benchmarking, etc.
- The group of skills related to Programming including coding, debugging, and using relevant programming languages
- 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 monitoring and managing operation systems (OS), and staying current on patches, upgrades, and other elements of the OS
- The group of skills related to Governance and Compliance including creating policies, evaluating compliance, conducting internal investigations, developing data governance, etc.
- Experience helping an organization to plan and manage change in effort to meet strategic objectives
- Ability to transform business processes using BPA, RPA, or other technology-enabled automation
- The group of skills related to Product Development including designing products, developing product roadmaps, translating design requirements, prototyping, 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
- Expertise in developing websites for hosting via intranet or Internet, which may also include web design, web content development, scripting, and/or network security configuration
- Adept at managing project plans, resources, and people to ensure successful project completion
- Working with people with different functional expertise respectfully and cooperatively to work toward a common goal
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
Target Salary: $138,000 to $180,000 a year
Qualifications
Active Directory (AD), Active Directory (AD), Amazon Web Services (AWS), Artificial Intelligence (AI), Atlassian JIRA, Authentication Management, Backup and Recovery (Software), Business Insight Skills, Business Process Management Skills, Calendar and Scheduling Tools, Cleaning and Transforming Data, Cloud Technology, Collaborating Cross-Functionally, Communicating in Technical Writing, Communicating Technical Information, Communication, Configuration Management (CM), Conflict Resolution, Coordination, Customer and Market Insights, Customer Relationship Management (CRM), CyberArk, Cybersecurity Analysis, Data Analysis, Data Analysis Interpretation {+ 60 more}
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 expected 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:
138000to 180000