Senior ETL Administrator

Langley Federal Credit Union•Newport News, VA

8d•Hybrid

About The Position

Langley Federal Credit Union is seeking a Full-Time Senior ETL Administrator to work in a hybrid capacity from their City Center location in Newport News, VA. This role is responsible for designing, creating, administering, and monitoring business process data extracts, transforming and loading data into the Enterprise Data Warehouse (EDW) or similar repositories. The Senior ETL Administrator will troubleshoot and resolve ETL and other data movement related issues, aggregate data from multiple sources, and maintain a detailed knowledge base of the data and data structures within the EDW. Collaboration with other Data Science team members, Database Administrators, and business unit stakeholders is essential for designing ETL data-related solutions. The position requires enforcing data governance policies, access controls, and data security measures to protect sensitive data and maintain compliance.

Requirements

Four-year degree from a college or university specializing in Information Systems, Computer Science, or other related field; or equivalent combination of working experience/training.
Five years of experience with Database systems (e.g., SQL Server, MySQL) related to data warehousing concepts and methodologies is required.
Five years of experience in ETL development and administration with expertise in one or more ETL tools is required such as Azure Data Factory, Microsoft SSIS, etc.
At least one year of knowledge related to data modeling and data integration best practices is required.
At least one year of knowledge related to data governance, data security, and data quality principles is required.
Analytical and problem-solving skills to troubleshoot and resolve ETL-related issues.
Ability to adapt to changing technologies and learn new tools quickly.

Nice To Haves

Experience in Continuous Integration/Continuous Deployment working with Configuration Management tools (i.e., Bitbucket, Bamboo, GitHub) preferred.
Microsoft certification relevant to the database administration field strongly preferred.

Responsibilities

Enforces data governance policies, access controls, and data security measures to protect sensitive data and maintain data compliance.
Provides support for the SQL Server-based Data Warehouse ETL processes as needed.
Creates, configures, deploys, and maintains ETL ingestion processes for collecting and/or aggregating data into a database, data warehouse or other multidimensional database structures.
Performs root cause analysis on processes to resolve production issues related to the support of ETL applications.
Monitors and maintains nightly data processing jobs for success.
Proactively troubleshoots and rectifies any failures or production issues.
Analyzes and plans storage requirements for data warehouse systems.
Works with the database administrators to configure, deploy, and maintain data warehouse or other multidimensional database servers.
Uses SQL data warehouse tools to maintain integrity between various Langley FCU disparate systems.
Implements ETL procedures for all new data ingestions into the Enterprise Data Warehouse and maintains effective awareness of all production activities according to required standards and provides support to all existing applications.
Performs tests, validates all data flows, and prepare all ETL ingestion processes according to business requirements; incorporates all business requirements into all design specifications.
Creates supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow.
Creates plans and tests files and scripts for data warehouse testing, ranging from unit to integration testing.
Maintains confidentiality, availability, accuracy, and integrity of all data during extraction, transformation, and loading.

Benefits

Affordable medical, dental, and vision plans
Educational Assistance, encompassing books, lab fees, registration costs, and more.
Support for Student Loan Repayment.
Abundant Career Growth Opportunities.
Generous Paid Vacation that starts accumulating from day one, progressively increasing with every five years of service, up to a maximum cap.
13 Paid Holidays, including your birthday and the day following Thanksgiving; enjoy Floating Holidays too!
Paid Sick Time for all team members.
Highly competitive 401K plan featuring a 6% company match, with immediate vesting with a ROTH IRA option.
Company-covered short- and long-term disability insurance.
Complimentary Life Insurance and the choice of additional Voluntary Life Insurance.
Flexible Health Care and Dependent Care benefits.