ETL Developer SME

Sentar•Chantilly, VA

1d•Onsite

About The Position

Sentar is seeking an ETL Developer SME in Chantilly, Virginia, to develop, analyze, and maintain software applications for a Federal Law Enforcement customer. The role uses expertise in data analysis, querying, aggregation, visualization, and software development to implement business intelligence and data warehousing solutions that help cyber professionals analyze case data and advance investigations. The position supports an Unclassified, Secret, and Top Secret multi-enclave environment and involves working with cross-functional teams and participating in Agile Release Train activities.

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 a Master's degree with 10 years of experience, or an Associate degree with 13 years of experience, or a high school diploma with 16 years of experience.
Experience with Agile methodologies.
Understanding of data warehousing and business intelligence concepts.
Knowledge of data analysis, querying, aggregation, and visualization techniques.
Knowledge of ETL processes and data transformation.
Knowledge of SQL and database technologies, including MySQL, PostgreSQL, or Microsoft SQL.
Software development fundamentals.
Knowledge of data management and big data technologies.
Experience with version control systems such as Git.

Nice To Haves

Python, JavaScript, or other programming languages.
Elasticsearch or other search platforms.
Data pipeline technologies.
Basic containerization knowledge, such as Docker.
Cloud platform experience, such as AWS.
Agile methodologies.

Responsibilities

Develop ETL mappings to extract data from source systems, transform data according to business requirements, and load it into target systems.
Tune mappings to ensure efficient data processing.
Work across requirements, design, development, testing, and deployment phases of the development life cycle.
Write complex statements, scripts, stored procedures, triggers, and views.
Implement business intelligence and data warehousing solutions.
Apply data warehousing and reporting platform concepts and promote best practices.
Support the Unclassified, Secret, and Top Secret multi-enclave environment.
Participate in Program Increments (PIs) and Agile Release Train (ART) activities.
Collaborate with cross-functional teams to ensure seamless integration.

Benefits

Voluntary medical, dental, and vision coverage, with Health Savings or Flexible Spending Plan options.
Voluntary life, critical illness, accident, and long-term care insurance options.
Group term life, short-term disability, and long-term disability coverage provided to qualifying employees.
401(k) match.
Competitive paid time off plan that increases quickly with years of service.
Holiday schedule and other leave programs, including bereavement, maternity, jury, and military duty leave.
Mental health awareness programs.
Tuition reimbursement.
Professional development reimbursement.
Recognition and awards programs.
Employee ownership.