Top Skills' DetailsNeed to be LOCAL to Cincinnati

Top skills:

1. Data Architecture – demonstrated understanding and worked within relational databases

2. Data Modeling – demonstrated understanding

3. ETL tool experience – they use Nifi and Kafka (for streaming) and transform into Snowflake (he looks for aptitude on type of skills but he’d consider datastage for these upcoming roles. (Talend is from an old JD, just a pre packaged list that populated) E and L done with Nifi and Kafka and then the T is within Snowflake.

4. Ability to work with external orgs and conform to internal data standards

5. SnowFlake experience are a bonus

Nice to have; Apache Kafka

Cloud Data Warehousing - Snowflake preferred

ETL Tools: - Talend BigData 7.x/6.x, Talend Integration Suite 7.x/6.x, Talend ESB, Matillion ETL for Redshift 1.39.9, Datastage 11.x/9.x/8.x/7.x PX, Quality Stage, profile stage, Information Analyzer, Fast Track, Business Glossary, Metadata Work Bench, Informatica. Languages: - SQL, PL/SQL, UNIX Shell Script, Java, Python, SCALA, Basic C & C++, Amazon Redshift databases Databases: - Big Data, Hadoop, Hive, NoSQL, Oracle 8i/9i/10g, IBM DB2, TeraData, SQL Server, Sybase, MS-Access 2007 Other DW-BI Application Tools: - Toad 7.x, DB2-AQT 7.x, Datastage version control tool, HP-PVCS Versioning tool, Micro strategy 8.1.0, Business Objects, Cognos, Qlikview, Tableau. Environment: - Spark-Hadoop v2.4.2, AIX Unix 5.2, Windows 98, XP, 2K, Windows7/10, AWS. Methodologies: - ER*win Data Modeler, Dimension Modeling, ER Modeling

Description:

JOB DESCRIPTION

ONSITE SCHEDULE: M-F

CONTRACT ONLY

is doing a major digital transformation, where they are moving all of their core banking systems to a new third party platform. This project will sit within Deposits that includes both legacy and modernization efforts. These roles will be in the modernization arm of the org.

Deposits can mean traditional checking, ATM, debit, safe boxes, IRAs and time deposits. Checking/debit space is where they will be. They will be primarily responsible for leveraging our modern technologies to facilitate data movement between internal it systems and our external monitor banking platform, that can be in the form of real time streaming or batch kind of more traditional ETL type work, leveraging our cloud data warehouse for publishing that data, that information for consumption of our downstream systems and analytic teams.

The initial project this person is being brought on for is a special project. They want a data engineer to build out an internal framework to produce internal measures, operational effectiveness, how can we measure ourselves and efficiency maybe build this out into a dashboard or a data hub of some sort to share with executives to meet operational resiliency. Call out weaknesses and strengths – collect data from wide variety of sources, package up and then easily consumable and sustain and support then they’d move to Deposits work after this first 6 to 8 months

Once they move to the deposit work, they will be working with checking/savings/ATM to Debit, IRA – these will focus more on checking / savings and debit, leverage modern tech between internal systems to external modern banking platform. Leverage cloud data warehouse for consumption of downstream data analytics.

GENERAL FUNCTION:

The data engineer designs and builds platforms, tools, and solutions that help the bank manage, secure, and generate value from its data. The person in this role creates scalable and reusable solutions for gathering, collecting, storing, processing, and serving data on both small and very large (i.e. Big Data) scales. These solutions can include on-premise and cloud-based data platforms, and solutions in any of the following domains ETL, business intelligence, analytics, persistence (relational, NoSQL, data lakes), search, messaging, data warehousing, stream processing, and machine learning.

Responsible and accountable for risk by openly exchanging ideas and opinions, elevating concerns, and personally following policies and procedures as defined. Accountable for always doing the right thing for customers and colleagues, and ensures that actions and behaviors drive a positive customer experience. While operating within the Bank's risk appetite, achieves results by consistently identifying, assessing, managing, monitoring, and reporting risks of all types.

ESSENTIAL DUTIES AND RESPONSIBILITIES:

• Responsible for design, Development, and Support of data solutions, APIs, tools, and processes to enable rapid delivery of business capabilities.

• Work closely with IT application teams, Enterprise architecture, infrastructure, information security, and LOB stakeholders to translate business and technical strategies into data-driven solutions for the Bank.

• Act as a technical Expert addressing problems related to system and application design, performance, integration, security, etc.

• Conduct research and Development based on current trends and technologies related to the banking industry, data engineering and architecture, data security, and related topics.

• Work with developers to Build CI/CD pipelines, Self-service Build tools, and automated deployment processes.

• Evaluate software products and Provide documented recommendations as needed.

• Provide Support and troubleshooting for data platforms. Must be willing to Provide escalated on-call Support for complicated and/or critical incidents.

• Participate in the planning process for hardware and software.

• Plan and work on internal projects as needed, including legacy system replacement, Monitoring and analytics improvements, tool Development, and technical documentation.

• Provide technical guidance and mentoring for other team members.

• Manage and prioritize multiple assignments.

SUPERVISORY RESPONSIBLITIES: None

MINIMUM KNOWLEDGE, SKILLS, AND ABILITIES REQUIRED:

• Bachelor's degree in Computer Science/Information Systems or equivalent combination of education and experience.

• Must be able to communicate ideas both verbally and in writing to management, business and IT sponsors, and technical resources in language that is appropriate for each group.

• Fundamental understanding of distributed computing principles

• Knowledge of application and data security concepts, best practices, and common vulnerabilities.

• Conceptual understanding of one or more of the following disciplines preferred big data technologies and distributions, metadata management products, commercial ETL tools, Bi and reporting tools, messaging systems, data warehousing, Java (language and run time environment), major version control systems, continuous integration/delivery tools, infrastructure automation and virtualization tools, major cloud, or rest API design and development.

Skills:

data architecture, data modeling, etl, etl tool experience

Top Skills Details:

data architecture,data modeling,etl,etl tool experience

Additional Skills & Qualifications:

This will sit on site 5 days a week.

The manager will be looking for if these candidates know how to demonstrated competency and aptitude in one tool and have been successful delivering solutions with that and another organization. Also understanding of data architecture and data modeling technique, work within relational databases, experience with leveraging ETL tools.

About TEKsystems:

We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.

The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.