ETL Developer SME

Sentar

$90K — $130K *
Education, Government & Non-Profit
8 - 10 years of experience
Job Overview by Ladders

Qualifications

  • Active Top Secret (TS) clearance with eligibility for Sensitive Compartmented Information (SCI) and ability to obtain a Counterintelligence (CI) Polygraph.
  • Bachelor's degree in Computer Science, Data Science, Engineering, or related field, or equivalent experience.
  • Experience with Agile methodologies and development life cycle processes.
  • Solid understanding of data warehousing, business intelligence, and ETL processes.
  • Proficiency in SQL and familiarity with various database technologies like MySQL, PostgreSQL, and Microsoft SQL.

Responsibilities

  • Develop ETL mappings to facilitate data extraction, transformation, and loading.
  • Conduct performance tuning of mappings to enhance efficiency in data processing.
  • Involve in all phases of the development life cycle from requirements to deployment.
  • Write complex SQL scripts, triggers, and views for data management.
  • Implement robust business intelligence and data warehousing solutions for analytical purposes.
  • Support operation across different secure enclaves including Unclassified, Secret, and Top Secret.
  • Collaborate with various cross-functional teams for seamless integration of solutions.

Benefits

  • Voluntary Medical, Dental, and Vision plans with Health Savings or Flexible Spending options.
  • Group term life, short-term and long-term disability coverage provided by Sentar.
  • Generous 401(k) match to support retirement saving.
  • Competitive paid time off (PTO) that increases with service years.
  • Tuition reimbursement and professional development reimbursement programs.
  • Mental health awareness programs to support employee well-being.
Full Job Description
Sentar is seeking a ETL Developer SME in Chantilly, VA.

Role Description:

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

Qualifications:

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:
• 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)

?Desired Qualifications
• Python, JavaScript, or other programming languages?
• Elasticsearch or other search platforms?
• Data pipeline technologies?
• Containerization basics (Docker)?
• Cloud platforms (AWS)?
• Agile methodologies?

Benefits at Sentar:

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

If you are not ready to apply for this position, submit your resume here to join our talent community. We'll keep you updated occasionally on new job opportunities.

Similar Jobs

More Jobs at Sentar

  • ETL Developer SME
    $90K — $130K *
    Chantilly, VA 20152 (Loudoun County)
    Education, Government & Non-Profit
    In-Person
  • Computer and Information Systems Manager - SME
    $100K — $130K *
    Scott Air Force Base, IL 62225 (Saint Clair County)
    Information Technology
    In-Person
  • Systems Engineer
    $85K — $130K *
    Aurora, NE 68818 (Hamilton County)
    Aerospace & Defense
    In-Person
  • Systems Engineer
    $85K — $130K *
    Wrangell, AK 99929 (Wrangell County)
    Aerospace & Defense
    In-Person
  • Data Scientist 2
    $90K — $120K *
    Fort George G Meade, MD 20755 (Anne Arundel County)
    Aerospace & Defense
    In-Person

More Education, Government & Non-Profit Jobs

Find similar ETL Developer SME jobs: