Data Engineer

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 role 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. Depending on your level of relevant experience and certification, you will be considered for one of four job levels which include Data Engineer I, Data Engineer II, Data Engineer III or Senior Data Engineer.

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 such as Power BI 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.

• 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 as part of a team. Helps evaluate and architect the use of data solutions. 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

Up to two or more years of experience. Experience with ETL tools (SSIS). Experience in a Data Warehouse (DWH) environment with data integration/ETL of large and complex data sets.

Expertise in performance tuning and scaling Microsoft SQL databases. Knowledge of data modeling and understanding of different data structures and their benefits and limitations under particular use cases. Experience with visualization tools (Power BI, SSRS, and Crystal reports). Experience with C# and Python.

Experience with cloud-based data platforms, and service models (AWS, Azure Data Factory, Azure Analysis Services, Azure Synapse, Snowflake, or Snowpipe). 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 hours 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. We celebrate diversity and are committed to creating an inclusive environment for all employees.