ETL Administrator

4 weeks ago

Newport News, United States Programmers.io Full time

Job Summary:

Designs, creates, administers, and monitors business process data extracts for data that needs to be extracted, transformed, and loaded into the Enterprise Data Warehouse (EDW) or similar repository. Troubleshoots and resolves ETL and other data movement related issues. Aggregates data from multiple sources into a data warehouse or other data repository to ensure EDW remains operational. Maintains a detailed knowledge base of the underlying data and data structures, and manages data content, current and potential future users, and the quality and integrity of data within the EDW. Captures and analyzes business requirements for an Enterprise Data Warehouse (EDW). Analyzes and supports the reliability of ETLs that export data from the EDW.

Essential Functions, Duties, and Responsibilities:

Create, configure, deploy, and maintain ETL ingestion processes for collecting and/or aggregating data into a database, data warehouse or other multidimensional database structure.

Perform root cause analysis on processes to resolve production issues related to the support of ETL applications.

Monitor and maintain nightly data processing jobs for success. Proactively troubleshoot and rectify any failures or production issues.

Analyzes and plans storage requirements for data warehouse systems.

Working with the database administrator, 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.

Implement ETL procedures for all new data ingestions into the EDW and maintain effective awareness of all production activities according to required standards and provide support to all existing applications.

Perform tests and validate all data flows and prepare all ETL ingestion processes according to business requirements and incorporate all business requirements into all design specifications.

Perform monitoring, tuning and performance analytics on new and existing database systems.

Create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow.

Create plans, test files, and scripts for data warehouse testing, ranging from unit to integration testing.

Dedicated to maintaining confidentiality, availability, accuracy, and integrity of all data on the managed database servers.

Qualifications:

Four-year degree from a college or university specializing in Information Systems, Computer Science, or other related field; 2-years related experience; or equivalent combination of working experience/training required.

Microsoft certification relevant to the database administration field strongly preferred.

Our Keys to Success:

Service Champion – Adopts a service orientation, building trusting relationships and delivering value for associates, members, and communities.

Langley Ambassadors – Demonstrates a passion for Langley’s vision, encouraging diversity, equity and inclusion while considering Langley’s values when making decisions and taking accountability for delivering results.

Agile in Action – Adapts to changes in the business, demonstrating innovation to improve Langley and advance the business into the future.

Team Driven – Collaborates across Langley, communicating with transparency and prioritizing a team-based approach that delivers optimal outcomes for associates, members, and communities.

Continuous Learners – Maintains an understanding of Langley’s business and how value is delivered to members and actively pursues opportunities to grow oneself and strengthen the organization.

Physical Requirements:

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions, duties, and responsibilities of this position. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this Job, the employee is frequently required to sit, use hands and fingers, and to talk and hear. The employee is occasionally required to stand and walk. Specific vision requirements for the job include close vision (at 20 inches or less) and color vision.

Working Conditions:

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Work will be performed in an indoor, climate-controlled environment where the noise level is quiet to moderate.

  • ETL Administrator OR ETL Developer

    3 weeks ago

    Newport News, United States Programmers.io Full time

    One of our client which is having operations globally is looking for ETL Admin/ Developer Hybrid to Newport News, VA. Please find the below job description and request you to share me your resume to srinath.k@programmers.ioTitle: ETL Admin/ DeveloperLocation: Hybrid to Newport News, VADuration: Full time with benefitsNote: Need only USC/GC consultants as it...

  • ETL Administrator

    4 weeks ago

    Newport News, United States Programmers.io Full time

    Job Summary: Designs, creates, administers, and monitors business process data extracts for data that needs to be extracted, transformed, and loaded into the Enterprise Data Warehouse (EDW) or similar repository. Troubleshoots and resolves ETL and other data movement related issues. Aggregates data from multiple sources into a data warehouse or other data...

  • ETL Admin

    3 weeks ago

    Newport News, United States Programmers.io Full time

    Job Summary:Designs, creates, administers, and monitors business process data extracts for data that needs to be extracted, transformed, and loaded into the Enterprise Data Warehouse (EDW) or similar repository. Troubleshoots and resolves ETL and other data movement related issues.Aggregates data from multiple sources into a data warehouse or other data...

  • ETL Admin

    2 weeks ago

    Newport News, United States Programmers.io Full time

    Job Summary:Designs, creates, administers, and monitors business process data extracts for data that needs to be extracted, transformed, and loaded into the Enterprise Data Warehouse (EDW) or similar repository. Troubleshoots and resolves ETL and other data movement related issues.Aggregates data from multiple sources into a data warehouse or other data...

  • Database Administrator

    4 weeks ago

    Newport Beach, United States SmartFinancial Full time

    Job DescriptionJob DescriptionJob Description:We are seeking a highly skilled and motivated Database Administrator (DBA) with expertise in MySQL, PostgreSQL, and AWS to join our team. The ideal candidate will be responsible for the performance, integrity, and security of our databases. This role involves both strategic and operational tasks, ensuring our...

  • Database Administrator

    1 month ago

    Newport Beach, United States SmartFinancial Full time

    Job DescriptionJob DescriptionJob Description:We are seeking a highly skilled and motivated Database Administrator (DBA) with expertise in MySQL, PostgreSQL, and AWS to join our team. The ideal candidate will be responsible for the performance, integrity, and security of our databases. This role involves both strategic and operational tasks, ensuring our...

  • Database Administrator

    3 weeks ago

    Newport Beach, United States SmartFinancial Full time

    Job DescriptionJob DescriptionJoin SmartFinancial: Empowering Insurance Agents with Cutting-Edge TechnologyWelcome to SmartFinancial, where our mission is clear: to drive growth and success for insurance agencies through our industry-leading technology! Voted one of the Best Places to Work for four consecutive years, we are one of the fastest-growing tech...

  • Database Administrator

    3 weeks ago

    Newport Beach, United States SmartFinancial Full time

    Job DescriptionJob DescriptionJoin SmartFinancial: Empowering Insurance Agents with Cutting-Edge TechnologyWelcome to SmartFinancial, where our mission is clear: to drive growth and success for insurance agencies through our industry-leading technology! Voted one of the Best Places to Work for four consecutive years, we are one of the fastest-growing tech...

  • Database Administrator

    2 weeks ago

    Newport Beach, United States SmartFinancial Full time

    Job DescriptionJob DescriptionJoin SmartFinancial: Empowering Insurance Agents with Cutting-Edge TechnologyWelcome to SmartFinancial, where our mission is clear: to drive growth and success for insurance agencies through our industry-leading technology! Voted one of the Best Places to Work for four consecutive years, we are one of the fastest-growing tech...

  • Database Administrator

    1 week ago

    Newport Beach, United States SmartFinancial Full time

    Job DescriptionJob DescriptionJoin SmartFinancial: Empowering Insurance Agents with Cutting-Edge TechnologyWelcome to SmartFinancial, where our mission is clear: to drive growth and success for insurance agencies through our industry-leading technology! Voted one of the Best Places to Work for four consecutive years, we are one of the fastest-growing tech...

  • Database Administrator

    1 week ago

    Newport Beach, United States SmartFinancial Full time

    Job DescriptionJob DescriptionJoin SmartFinancial: Empowering Insurance Agents with Cutting-Edge TechnologyWelcome to SmartFinancial, where our mission is clear: to drive growth and success for insurance agencies through our industry-leading technology! Voted one of the Best Places to Work for four consecutive years, we are one of the fastest-growing tech...

  • Senior Integrations Architect

    2 weeks ago

    Newport Beach, United States Ledgent Technology Full time

    Position Overview:We are in search of experienced professionals with a strong background in data integration and workforce benefits. This role is structured as a W2 hourly position with Ledgent Technology.Job Responsibilities:Reporting directly to the Director and Product Owner of Integrations, the Lead Integrations Engineer will collaborate with various...

  • Lead Integrations Engineer

    1 month ago

    Newport Beach, United States Ledgent Technology Full time

    We are seeking candidates who possess experience with data integration and workforce benefits. This position is W2 hourly with our company.JOB DESCRIPTIONReporting to the Director and Product Owner, Integrations, the Lead Integrations Engineer will partner with our functional areas and corporate teams to deliver a highly integrated framework of solution...

  • Lead Integrations Engineer

    1 month ago

    Newport Beach, United States Ledgent Technology Full time

    We are seeking candidates who possess experience with data integration and workforce benefits. This position is W2 hourly with our company.JOB DESCRIPTIONReporting to the Director and Product Owner, Integrations, the Lead Integrations Engineer will partner with our functional areas and corporate teams to deliver a highly integrated framework of solution...

  • Senior Integrations Architect

    2 weeks ago

    Newport Beach, United States Platinum Resource Group Full time

    Job OverviewREMOTE – Senior Integrations Architect Location: Remote, US POSITION SUMMARYThe Senior Integrations Architect will collaborate with various functional teams and corporate divisions to establish a seamlessly integrated framework of solution providers for Workforce Benefits.Accountable for the implementation of patterns and technological...

  • Lead Integrations Engineer

    1 month ago

    Newport Beach, United States Platinum Resource Group Full time

    Job DescriptionJob DescriptionREMOTE – Lead Integrations Engineer Location; Remote, US JOB DESCRIPTIONReporting to the Director and Product Owner, Integrations, the Lead Integrations Engineer will partner with functional areas and corporate teams to deliver a highly integrated framework of solution providers for Workforce Benefits.Responsible for the...