Part of a team converting SAS jobs to Snowflake.
Responsible for production support of existing SAS jobs, trouble shooting, impact analysis and data mapping.
Able to read existing SAS code and understand data sources, dependencies and impact analysis.
Skillset: SAS, problem solving, production support, data mapping
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.
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.
- At least 6 years of related experience, including at least 4 years in a hands-on software development role.
- Significant experience with at least one major RDBMS product.
- Experience working with and supporting Unix/Linux and Windows systems.
- Proficient in relational database modeling concepts and techniques.
- Solid conceptual understanding of distributed computing principles.
- Working knowledge of application and data security concepts, best practices, and common vulnerabilities.
- Experience in 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.
- Financial industry experience is a plus.
Required Skills : SAS
Background Check :Yes
Drug Screen :Yes
Notes :
Selling points for candidate :
Project Verification Info :The information provided below is for Apex Systems AV use only and is not to be distributed publicly, or to any third party.
Any distribution of the below information will result in corrective action from Apex Systems Vendor Management.
MSA: Restricted Client Letter: Will Provide
Candidate must be your W2 Employee :Yes
Exclusive to Apex :No
Face to face interview required :No
Candidate must be local :Yes
Candidate must be authorized to work without sponsorship ::No
Interview times set : :No
Type of project :Development/Engineering
Master Job Title :ETL Developer
Branch Code :Cincinnati