ETL Developer SME at Sentar Inc. in Chantilly, VA

Job description

• Sentar is seeking a ETL Developer SME in Chantilly, VA.

Responsibilities

• 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.
• • 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?
• • 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?

Requirements

• Clearance Level: Active Top Secret (TS) clearance with eligibility for Sensitive Compartmented Information (SCI) and ability to obtain a Counterintelligence (CI) Polygraph.
• Education: 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)
• • Agile methodologies?

Skills

Required

• ETL processes and data transformation
• Software development fundamentals
• Version control systems (Git)
• Agile methodologies

Preferred

• Elasticsearch or other search platforms
• Data pipeline technologies
• Containerization basics (Docker)
• Cloud platforms (AWS)

Benefits

• Our unique ownership model attracts top talent, giving employees the freedom to take initiative and drive meaningful improvements. In addition to cultivating a thriving and inclusive work environment, Sentar offers an extensive benefits package designed to support the well-being of employees and their families. Employee ownership is the foundation of our culture, promoting participation, teamwork, and accountability while ensuring long-term financial security and a commitment to excellence.
• 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