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 data systems (databases, files, etc.), transform the data based on business requirements, and load the data into target data systems (databases, files, etc.). Conducting performance tuning of the mappings developed will be essential to ensure that the data is extracted, transformed, and loaded in a reasonable amount of time based on the requirements. 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, adjusting unit testing, maintaining build support, including continuous integration, and sustaining operational support activities will be part of your responsibilities. You will work with application development tools, standards, and languages, and be involved in multiple phases of the Development Life Cycle (requirements, design, development, testing, and deployment) of BI Dashboards and reports. Additionally, you will develop required documentation in support of the development life cycle.

Responsibilities

  • Develop, sustain, and improve the current system data ingest functions.
  • Perform analysis, monitoring, and configuration of the solution as needed.
  • Develop ETL mappings to extract data from source systems and load it into target systems.
  • Conduct performance tuning of the mappings to ensure efficient data processing.
  • Develop Business Intelligence (BI) reports and perform unit testing of these reports.
  • Create or update detailed design documentation.
  • Access and review the code repository and administer code reviews.
  • Adjust unit testing and maintain build support, including continuous integration.
  • Sustain operational support activities 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
  • Paid leave
  • Professional development opportunities
  • Tuition assistance
  • Work-life programs
  • Employee recognition programs
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service