Data Engineer I

Summary

Centennial Bank is seeking a Data Engineer I to support its database, infrastructure, and data operations. The role designs and administers database systems, develops ETL processes and data models, maintains cloud and database infrastructure, troubleshoots applications, and supports related technology projects.

Responsibilities

• Design, implementation, and administration of database systems in a team environment
• Maintain awareness and knowledge of industry/vendor technology and trends in order to ensure optimal use and value of the LAN/WAN resources
• Oversee projects from the planning stage to completion to meet the organization's requirements
• Oversee regular maintenance of our database systems
• Assist in maintaining and troubleshooting existing and new software applications
• Provide guidance to level one engineers and technicians in issue troubleshooting and resolution
• Conduct research and consult with VP Network Administration concerning new storage, applications, and systems related purchases
• The ability to work in a constant state of alertness and in a safe manner
• Completes required BSA/AML training and other compliance training as assigned
• Perform any other related duties as required or assigned

Skills

• Knowledge of a specialized field (however acquired), such as basic accounting, computer, etc. Equivalent of four years in high school, plus night, trade extension, or correspondence school specialized training, equal to two years of college, plus 2 years related experience and/or training, or equivalent combination of education and experience
• Ability to read a limited number of words and recognize similarities and differences between words and between series of numbers; ability to write and speak simple sentences as a means for basic communication
• Ability to read and understand simple instructions, short correspondence, notes, letters and memos; ability to write simple correspondence
• Ability to read and understand documents such as policy manuals, safety rules, operating and maintenance instructions, and procedure manuals; ability to write routine reports and correspondence
• Ability to effectively communicate information and respond to questions in person-to-person and small group situations with customers, clients, general public and other employees of the organization
• Ability to read, analyze, and understand general business/company related articles and professional journals; ability to speak effectively before groups of customers or employees
• Ability to write reports, business correspondence, and policy/procedure manuals; ability to effectively present information and respond to questions from groups of managers, clients, customers, and the general public
• Ability to read, analyze, and understand common scientific and technical journals, financial reports, and legal documents; ability to respond to complex or difficult inquiries or complaints from customers, regulatory agencies, or members of the business community
• Ability to calculate figures and amounts such as discounts, interest, commissions, proportions, percentages, area, circumference, and volume
• Ability to apply concepts such as fractions, ratios, and proportions to practical situations
• Ability to solve practical problems and deal with a variety of known variables in situations where only limited standardization exists
• Ability to interpret a variety of instructions furnished in written, oral, or diagram formats
• Advanced: Database
• Intermediate: Programming Languages, Spreadsheet
• Basic: 10-Key, Accounting, Alphanumeric Data Entry, Presentation/PowerPoint, Word Processing/Typing
• Periodically exposed to such elements as noise, intermittent standing, walking, pushing, carrying, or lifting; but none are present to the extent of being disagreeable
• While performing the functions of this job, the employee is occasionally exposed to risk of electrical shock. The noise level in the work environment is usually moderate
• Semi-repetitive, low physical. Semi-repetitive type work which requires periods of concentration for varied time cycles as prescribed by the tasks
• While performing the functions of this job, the employee is continuously required to sit; regularly required to stand, walk, reach with hands and arms, climb or balance, stoop, kneel, crouch, or crawl, talk or hear; frequently required to use hands to finger, handle, or feel. The employee must occasionally lift and/or move up to 50 pounds. Specific vision abilities required by this job include close vision
• 3 + years of experience installing, maintaining and troubleshooting Microsoft SQL Server
• 3 + years of experience installing, maintaining and troubleshooting Microsoft Server Products
• Must be well organized with excellent technical documentation skills
• Strong interpersonal, written, and oral communication skills
• Ability to conduct research into networking issues and products as required
• Must be self-motivated and work with minimal supervision
• Basic understanding of scripting and PowerShell
• Azure Cloud Certification
• Microsoft Certification
• Power BI Certification
• 3+ years' experience with Citrix, VMWare, SharePoint, SQL 2017, and PureStorage
• 3+ years' experience with enterprise monitoring products
• Knowledge of and experience with firewalls and network security

Qualifications

Must Haves

• Knowledge of a specialized field (however acquired), such as basic accounting, computer, etc. Equivalent of four years in high school, plus night, trade extension, or correspondence school specialized training, equal to two years of college, plus 2 years related experience and/or training, or equivalent combination of education and experience
• Ability to read a limited number of words and recognize similarities and differences between words and between series of numbers; ability to write and speak simple sentences as a means for basic communication
• Ability to read and understand simple instructions, short correspondence, notes, letters and memos; ability to write simple correspondence
• Ability to read and understand documents such as policy manuals, safety rules, operating and maintenance instructions, and procedure manuals; ability to write routine reports and correspondence
• ability to effectively communicate information and respond to questions in person-to-person and small group situations with customers, clients, general public and other employees of the organization
• Ability to read, analyze, and understand general business/company related articles and professional journals; ability to speak effectively before groups of customers or employees
• ability to write reports, business correspondence, and policy/procedure manuals; ability to effectively present information and respond to questions from groups of managers, clients, customers, and the general public
• Ability to read, analyze, and understand common scientific and technical journals, financial reports, and legal documents; ability to respond to complex or difficult inquiries or complaints from customers, regulatory agencies, or members of the business community
• Ability to calculate figures and amounts such as discounts, interest, commissions, proportions, percentages, area, circumference, and volume
• Ability to apply concepts such as fractions, ratios, and proportions to practical situations
• Ability to solve practical problems and deal with a variety of known variables in situations where only limited standardization exists
• Ability to interpret a variety of instructions furnished in written, oral, or diagram formats
• Advanced: Database
• Intermediate: Programming Languages, Spreadsheet
• Basic: 10-Key, Accounting, Alphanumeric Data Entry, Presentation/PowerPoint, Word Processing/Typing
• Periodically exposed to such elements as noise, intermittent standing, walking, pushing, carrying, or lifting; but none are present to the extent of being disagreeable
• While performing the functions of this job, the employee is occasionally exposed to risk of electrical shock. The noise level in the work environment is usually moderate
• Semi-repetitive, low physical. Semi-repetitive type work which requires periods of concentration for varied time cycles as prescribed by the tasks
• While performing the functions of this job, the employee is continuously required to sit; regularly required to stand, walk, reach with hands and arms, climb or balance, stoop, kneel, crouch, or crawl, talk or hear; frequently required to use hands to finger, handle, or feel. The employee must occasionally lift and/or move up to 50 pounds. Specific vision abilities required by this job include close vision
• 3 + years of experience installing, maintaining and troubleshooting Microsoft SQL Server
• 3 + years of experience installing, maintaining and troubleshooting Microsoft Server Products
• Must be well organized with excellent technical documentation skills
• Strong interpersonal, written, and oral communication skills
• Ability to conduct research into networking issues and products as required
• Must be self-motivated and work with minimal supervision
• Basic understanding of scripting and PowerShell

Nice to Haves

• Azure Cloud Certification
• Microsoft Certification
• Power BI Certification
• 3+ years' experience with Citrix, VMWare, SharePoint, SQL 2017, and PureStorage
• 3+ years' experience with enterprise monitoring products
• Knowledge of and experience with firewalls and network security

Benefits

• Remote work