Data Engineer

Description

About BankFund:

BankFund Credit Union is a full-service financial cooperative that was organized and chartered in 1947 as a convenient place for employees of the World Bank Group and International Monetary Fund and their families to save and to obtain credit. Located in Washington, DC, BankFund maintains three full-service branches downtown with our headquarters located near Farragut West metro station. This position is classified as a hybrid role which means that on-site work will be expected. After completion of training for the role, staff generally work on site 40% of the time but this is subject to change based on health and safety standards and operational need.

Summary:

The Data Engineer is responsible for developing, maintaining and documenting BankFund’s data pipelines that flow into its enterprise data warehouse and other sources. This role is foundational in mitigating data quality and data management risks and enables business users to generate valuable insights in a self-service capacity. The position requires close collaboration with business units and project teams to understand and translate data requirements into consumable data assets. The position requires proficiency in framing problems, challenges and opportunities identified by executives and business users, then translating those needs into the defined requirements that support the development of data-centric solutions. Success in the position requires proactive and ongoing communication with stakeholders to assist with needs assessments, goal setting and execution.

The Data Engineer acts as an advocate for the effective, appropriate and beneficial use of the data that is owned and generated by the organization. These sources are stored in scores of systems that are administered, managed and directed by designated authorized staff and trusted third party partners. The Data Engineer’s primary domain of responsibility is the enterprise data warehouse, with focus on maintaining current environments, supporting data transformation processes, and serving as the lead advocate and catalyst for expanding those systems to include additional beneficial data sources and data enhancements.

The Data Engineer applies industry-standard principles for data modeling, stored procedures, replication, regulations, and security to meet technical, business and regulatory requirements. The position works to streamline data flows and models; to optimize consistency, quality, accessibility, and security; to eliminate unnecessary costs; and to facilitate effective and productive data accessibility across the organization.

Responsibilities:

• Design, build and maintain batch or real-time data pipelines into BankFund’s enterprise data warehouse. 
• Maintain and optimize the data infrastructure required for accurate extraction, transformation, and loading of data from a wide variety of data sources. 
• Automate data workflows such as data ingestion, aggregation, and ETL processing.
• Prepare & document raw data in the organization’s Enterprise Data Warehouse into consumable datasets for both technical and non-technical stakeholders. 
• Be proficient and able to execute the processes associated with integrating and certifying moderate complexity data sources to the central data warehouse system. 
• Partner with departmental analysts and functional leaders in sales and marketing to deploy prescriptive analytics and advanced analytic efforts in production. 
• Facilitate the standardization of a series of re-deployable data model templates to facilitate faster and efficient deployment for analytic opportunities that share common data sources.
• Be an advocate and solution resource for applying a variety of data science techniques, including predictive analytics, artificial intelligence, and machine learning, to address business problems and opportunities.
• Build, maintain, and deploy data assets for analytics teams through cloud platforms (e.g. AWS, Azure, GCP). 
• Leverage data controls to maintain data privacy, security, compliance, and quality for allocated areas of ownership.
• Coordinate with IT to establish continuous monitoring of database viability, application availability and system health as measured by storage availability & utilization, memory use and query optimization.
• Under the direction of Analytics management, maintain, publish, curate and make accessible for common access a catalog of standard & custom data sources to include documentation containing an application overview, citation of data sources & architecture diagrams, references to source code, file locations and output examples.
• Adhere to corporate data governance and classification standards. 
• Maintain and enhance professional knowledge of analytics and related technologies by attending technical training, reviewing professional publications and establishing personal connections and professional networks of peers.
• Provide periodic project status updates to data governance committees and facilitate discussion on project priorities.
• Successfully participate in annual Information Security refresher training. Comply with the In-formation Security Policy, including the immediate reporting of unusual or suspicious activity to management and the Information Security Officer. Follow all procedures to protect company computers from viruses, and to maintain the security and confidentiality of Credit Union data. 
• Participate in annual Bank Secrecy Act (BSA) and Office of Foreign Assets Control (OFAC) training and demonstrate knowledge and understanding of the BSA and OFAC, including the immediate reporting of unusual or suspicious activity to the Risk Management Department.  Undertakes additional training specific to daily responsibilities and as required to ensure continued compliance with all applicable regulations.
• Ensures the Credit Union’s safe harbor protections as allowed by the BSA.  Understand that if confronted with knowledge of existence of a Suspicious Activity Report (SAR), an obligation exists to preserve the confidentiality of that SAR, as well as any information that may reveal the existence of a SAR.  Maintain awareness of, and immediately report to the Compliance Officer, any unauthorized disclosure of a SAR, or unauthorized disclosure of information related to a SAR. Understand that failure to do so is a violation of federal law and may lead to both civil and criminal penalties for SAR disclosure violations.
• Maintain a professional, positive attitude at all times. 
• Undertake other work-related duties as assigned by the Analytics Manager

Requirements

Minimum Qualifications or Knowledge, Skills and Abilities Required 

Education:  

• Bachelor’s Degree, preferably in Data Analytics, Management Information Systems, Information Technology, Mathematics, Applied Statistics or a related field.
• A CDMP (Certified Data Management Professional) certification, or equivalent, is preferred. 

Experience & Skills:

• Advanced SQL skills and experience with relational databases and database design.
• 3 years of experience working with cloud Data Warehouse solutions (e.g., Snowflake, Redshift, BigQuery, Azure, etc.). 
• Working knowledge of Cloud-based solutions (e.g. AWS, Azure, GCP).
• 3 years of operational financial institution experience (credit union, banks and/or financial services).
• Broad knowledge of credit unions, banks and/or financial services, preferred.
• Experience building and deploying machine learning models in production, preferred.
• Familiarity with programming and scripting languages, including C/C , Perl, R, Python & Java.
• Ability to thrive in an environment with ambiguity by envisioning and mapping alternative solutions.
• Solid understanding of regulatory and reporting requirements. 
• Effective communicator able to engage colleagues at all levels of the organization.
• Ability to learn new concepts quickly and thoroughly; comfortable asking questions and challenging assumptions; and willing to take measured risks when warranted.
• Ability to work both independently and as part of a team.
• Must demonstrate critical thinking, quantitative & qualitative analytical skills, and an ability to apply logic and reasoning to identify the strengths and weaknesses of multiple solutions, conclusions or approaches to solving problems. 
• Ability to work well under pressure and to efficiently handle multiple, concurrent demands and appropriately prioritize responsibilities. 

For internal purposes, this position is graded as Exempt-12. 

The anticipated annualized base salary range for this position is $100,000 to $126,000. Final base salary for this role will be based on the individual’s job-related experience, skillset, training, certifications and market demands. The benefits available for this full-time position include but are not limited to: medical, dental, and vision insurance, 401(k) plan, life insurance coverage, disability benefits, tuition assistance program and paid time off, including paid parental leave benefits. In addition to base compensation salary, this role position is eligible for an annual incentive plan.

Salary : $100,000 - $126,000