Data Engineer (Finance)

Job Description:

Role
Provides support of our data warehouse environment and analytics tools. This allows our business leaders access to business intelligence data in order to develop strategies for our organization to grow. The Data Engineer assists in setting overall development roadmap and standards for the Bank and helps evaluate and architect the use of data solutions, using industry best practices. As part of this job, you will be working to implement a mixture of on premise and cloud strategies for the future of data processing at the bank.

Essential Duties & Responsibilities

• Responsible for building and maintaining optimal data pipelines, architectures and data sets required for extraction, transformation, and loading of data from a wide variety of data sources using SQL and integration technologies.
• Leverage existing data infrastructure to fulfill all data-related requests, perform necessary data housekeeping, data cleansing, normalization, hashing, and implementation of required data model changes.
• Build and utilize appropriate data platform structures to organize and store data in a particular manner.
• Work with big data technologies on-prem, cloud and hybrid. Implement data lifecycle management strategies around the flow of data within the organization implementing policy and automated approaches.
• Implement BI (business intelligence) platforms both on-premises and cloud.
• Establish governance and strategies around visualization of creating reports and dashboards to help improve upon operational and analytical reporting. Examine, assess, translate, and classify data; recognize, collect and analyze data to encourage the advancement, execution and application of data platform systems.
• Analyze data to spot anomalies, trends and correlate similar data sets.
• Design, develop and implement natural language processing software modules.
• Create models and standards to govern which data is collected, and how it is stored, arranged, integrated, and use in data systems and in organizations.
• Perform major tasks, deliverables, and formal application delivery methodologies; deliver new or enhanced applications. Perform additional database administrator duties, as assigned.
• Performs work independently.
• Considered a high-level specialist who regularly interacts and works with senior management.
• Provides leadership, coaching, and/or mentoring to a subordinate group.
• Helps evaluate and architect the use of data solutions. May act as a team lead.
• Perform other duties as assigned.
• Participate in proactive team efforts to achieve departmental and company goals.
• Must comply with current applicable laws, regulations and bank policies and procedures. Comply with all safety policies, practices and procedures. Report all unsafe activities to supervisor and/or Human Resources.

Knowledge & Skills
Experience

• Five or more years' experience with ETL/ELT tools and development. Experience in a Data Warehouse (DWH) environment with data integration of large and complex data sets.
• Proficient in SQL and scripting languages (e.g., Python)
• Hands-on experience with Snowflake data warehouse, including performance tuning and optimization.
• Experience with cloud-based platforms such as AWS and Azure.
• Knowledge of business intelligence (BI) tools such as Sigma, Power BI, SSRS, or Crystal Reports.
• Strong understanding of data warehousing concepts, dimensional modeling, and data lake architecture.
• Experience with SQL Server and Oracle database management systems.
• Technical proficiency with relational databases: T-SQL, SQL, and stored procedures.

Education/Certifications/Licenses
Bachelor's degree in Computer Science, Information Systems, or another related field required.

Skills
Creative thinking, with the ability to evaluate a business scenario and design user-friendly, low
maintenance software solutions. Excellent written, oral, and interpersonal communication skills.
Effective use of multiple reporting tools. Technical expertise. Analytical thinking skills. Problem-solving skills. Leadership skills. The ability to work in a team environment and motivate or influence others is a critical part of the job, requiring a significant level of diplomacy, influence and trust.

Physical Requirements
Is able to bend, sit, and stand in order to perform primarily sedentary work with limited physical exertion and occasional lifting of up to 10 lbs. Must be capable of climbing / descending stairs in an emergency situation. Must be able to operate routine office equipment including computer terminals and keyboards, telephones, copiers, facsimiles, and calculators. Must be able to routinely perform work on computer for an average of 6-8 hours per day, when necessary. Must be able to work extended hour or travel off site whenever required or requested by management.

Working Conditions
Regular in-office attendance required.

Mental and/or Emotional Requirements
Must be able to perform job functions independently or with limited supervision and work effectively
either on own or as part of a team. Must be able to read and carry out various written instructions and follow oral instructions. Must be able to complete basic mathematical calculations, spell accurately, and understand computer basics. Must be able to speak clearly and deliver information in a logical and understandable sequence. Must be capable of dealing calmly and professionally with numerous different personalities from diverse cultures at various levels within and outside of the organization and demonstrate highest levels of customer service and discretion when dealing with the public. Must be able to perform responsibilities with composure under the stress of deadlines / requirements for extreme accuracy and quality and/or fast pace. Must be able to effectively handle multiple, simultaneous, and changing priorities. Must be capable of exercising highest level of discretion on both internal and external confidential matters.

CapFed® is an equal opportunity employer.