ETL Developer SME

Sentar•Chantilly, VA

19h•Onsite

About The Position

As an ETL 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 Top Secret (TS) clearance with eligibility for Sensitive Compartmented Information (SCI) and ability to obtain a Counterintelligence (CI) Polygraph.
Bachelor's degree OR Master's degree with 10 years of experience OR Associate degree with 13 years of experience OR High School/Diploma with 16 years of experience.
Bachelor's degree in Computer Science, Data Science, Engineering, or related field
Experience with Agile methodologies
Understanding of data warehousing and business intelligence concept
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)

Nice To Haves

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
Work across multiple phases of the Development Life Cycle (requirements, design, development, testing and deployment)
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

Benefits

Voluntary Medical, Dental, Vision, with Health Savings or Flexible Spending Plan options
Voluntary Life, Critical Illness, Accident, and Long Term Care insurance options
Group Term Life, Short-Term and Long-Term Disability is provided by Sentar to all qualifying employees
Generous 401(k) match
Competitive PTO plan that graduates quickly with years of service
Other leave programs; holiday schedule along with bereavement, maternity, jury and military duty
Mental health awareness programs
Tuition reimbursement
Professional development reimbursement
Recognition and Awards programs