ETL Developer

$103,800 - $162,225/Yr

Noblis - Chantilly, VA

posted 3 months ago

Part-time,Full-time - Mid Level
Chantilly, VA
Professional, Scientific, and Technical Services

About the position

Noblis is seeking to hire an ETL Developer with an ACTIVE Top Secret Clearance. As an ETL Developer, you will be a key player in ensuring the efficient and accurate movement of data across systems. You will design, develop, and maintain robust ETL processes to extract, transform, and load data from various sources into data warehouses and other storage solutions. You will work closely with data analysts, database administrators, and other stakeholders to understand their data needs and provide solutions that support business intelligence and reporting efforts. In this role, you will be responsible for developing, sustaining, and improving the current system data ingest functions and making adjustments as needed by performing analysis, monitoring, and configuring the solution. You will develop ETL mappings to extract data from source systems, transform the data based on business requirements, and load the data into target systems. Conducting performance tuning of the mappings developed will be essential to ensure that the data is processed in a timely manner. You will also develop Business Intelligence (BI) reports using BI software and perform unit testing of the reports developed. Creating or updating detailed design information, accessing and reviewing the code repository, administering code reviews, and maintaining build support, including continuous integration, will be part of your responsibilities. You will work on multiple phases of the Development Life Cycle, including requirements gathering, design, development, testing, and deployment of BI dashboards and reports. Additionally, you will be required to develop necessary documentation in support of the development life cycle.

Responsibilities

  • Develop, sustain, and improve current system data ingest functions.
  • Perform analysis, monitoring, and configuration of the ETL solution as needed.
  • Develop ETL mappings to extract data from source systems and load it into target systems.
  • Conduct performance tuning of ETL mappings to ensure timely data processing.
  • Develop Business Intelligence (BI) reports and perform unit testing of these reports.
  • Create or update detailed design information for ETL processes.
  • Access and review the code repository and administer code reviews.
  • Maintain build support, including continuous integration, and respond to mission-critical requests.
  • Work on multiple phases of the Development Life Cycle for BI dashboards and reports.
  • Develop required documentation in support of the development life cycle.

Requirements

  • Bachelor's degree in computer science, data science, or related field with 8 years of experience; or 14 years of experience in lieu of a degree.
  • Proficiency with Power BI, data analysis, data query, data aggregation, data visualization, software development, system architecture, data transformation, data management, and big data technology.
  • Experience in writing complex statements, scripts, stored procedures, triggers, and views for business intelligence and data warehousing solutions.
  • Solid foundation in data warehousing and reporting platform concepts with the ability to recommend solutions and drive best practices.
  • Experience with data pipelines including extraction, transformation, integration, and loading.
  • Experience developing, monitoring, and troubleshooting ETL workflows and processes.
  • Active Top Secret security clearance with SCI eligibility.

Nice-to-haves

  • Familiarity with multiple business intelligence environments.
  • Experience operating in a scaled agile (SAFe) environment.
  • Experience with Atlassian Suite of tools; Jira, Confluence.
  • Strong self-organization and self-management skills.
  • Strong professional and interpersonal skills.

Benefits

  • Health insurance coverage
  • Life insurance coverage
  • Disability insurance coverage
  • Financial and retirement benefits
  • Paid leave
  • Professional development opportunities
  • Tuition assistance
  • Work-life programs
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service