ETL Developer (SME)

Fusion Technology•Chantilly, VA

2d•Hybrid

About The Position

As a Developer SME, you will be responsible for developing, analyzing, and maintaining software applications for a Federal Law Enforcement customer. You will utilize your expertise in data analysis, data query, data aggregation, data visualization, and software development to implement business intelligence and data warehousing solutions that enable cyber professionals to effectively analyze case data and advance investigations.

Requirements

Active TS/SCI with polygraph is required
Bachelor's Degree in Computer Science, Software Engineering, or related field with 10+ years, Associate with 13+ years or High School Diploma with 16+ of experience in DevOps engineering or a related field
Understanding of data warehousing and business intelligence concepts
Data analysis, query, aggregation, and visualization techniques
ETL processes and data transformation
SQL and database technologies (MySQL, PostgreSQL, Microsoft SQL)
Software development fundamentals
Data management and big data technologies
Version control systems (Git)
Basic scripting and programming
Python, JavaScript, or other programming languages
Elasticsearch or other search platforms
Data pipeline technologies
Containerization basics (Docker)
Cloud platforms (AWS)
Agile methodologies

Responsibilities

Develop ETL mappings to extract data from source systems, transform data based on business requirements, and load into target systems
Conduct performance tuning of mappings to ensure data is processed efficiently
Develop Business Intelligence (BI) reports using BI software and perform unit testing
Work across multiple phases of the Development Life Cycle (requirements, design, development, testing and deployment)
Utilize Power BI and other tools for data analysis, visualization, and management
Write complex statements, scripts, stored procedures, triggers, and views
Implement business intelligence and data warehousing solutions
Apply data warehousing and reporting platform concepts and drive best practices
Support the multi-enclave environment (Unclassified, Secret, and Top Secret)
Participate in Program Increments (PIs) and Agile Release Train (ART) activities
Collaborate with cross-functional teams to ensure seamless integration