Systems Analyst

Castellum, Inc.

$70K — $95K *
Information Technology
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • US Citizen with ability to obtain Public Trust security clearance
  • Bachelor's degree in Data, Statistics, or IT
  • 3+ years of data analysis experience
  • 1+ year experience with Tableau, PowerBI, Oracle, Python
  • Experience with a variety of data formats and types
  • Advanced knowledge of SQL
  • Strong written and verbal communication skills

Responsibilities

  • Collaborate with teams to define system requirements and optimize data flows
  • Support data migration efforts between legacy and modern systems
  • Create reports and dashboards with Tableau and PowerBI for decision support
  • Conduct advanced analytics and automation tasks using SQL and Python
  • Monitor and improve system performance to meet operational needs
  • Work with cross-functional teams ensuring systems meet regulatory standards

Benefits

  • Comprehensive health coverage
  • Retirement savings plan
  • Paid time off and holidays
  • Professional development opportunities
  • Flexible work environment
Full Job Description
JOB SUMMARY

This position focuses on systems analysis, querying various data systems, and ensuring seamless data flow across platforms. The Data Analyst will play a critical role in supporting legal and operational teams within the US Department of Justice (USDOJ), running complex queries, creating interactive dashboards, and ensuring data integrity. The ideal candidate will have a solid background in IT systems, data analytics, and experience working with large databases. Excellent analytical, problem-solving skills, and a collaborative mindset are essential for success in this role.

RESPONSIBILITIES

  • Collaborate with management, senior data analysts, and legal teams to gather system requirements, analyze data flows, and identify potential optimizations.
  • Support the migration of different file and media types between legacy and modern systems.
  • Create detailed reports and interactive dashboards using Tableau and PowerBI to assist USDOJ teams in decision-making.
  • Perform advanced analytics and automation using SQL and Python.
  • Monitor, troubleshoot, and improve system performance to support the operational needs of the organization.
  • Work closely under the supervision of a senior data analyst with cross-functional teams, including IT, legal, and operational teams, to ensure systems meet business and regulatory requirements.


QUALIFICATIONS:

Minimum Qualifications include:
  • Must be a US Citizen and have ability to obtain Public Trust security clearance.
  • Bachelor's degree in Data, Statistics, or IT related field
  • At least 3 years' experience performing data analysis
  • At least one (1) year hands-on experience working with Tableau, PowerBI, Oracle, Python.
  • Experience processing both standard data types and special data formats that may be proprietary, mobile devices, social media, forensic images, audio/video, etc
  • Have advanced understanding of SQL
  • Have strong written and verbal communication skills


Preferred Qualifications:
  • Experience working with Oracle Database
  • Understanding of legal terminology and processes
  • Experience with US Government contracts


PHYSICAL DEMANDS:

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of the job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this job, the employee is required to reach with hands and arms. The employee is frequently required to sit, stand and walk. The employee may be required to move ten pounds and could occasionally lift or move up to twenty-five pounds.

Disclaimer: The listed duties are not intended to serve as a comprehensive list of all duties performed by all employees in this classification, only a representative summary of primary duties and responsibilities.

Similar Jobs

More Jobs at Castellum, Inc.

  • Systems Analyst
    $80K — $110K *
    Washington, DC 20011 (District Of Columbia County)
    Information Technology
    In-Person
  • Systems Analyst
    $70K — $95K *
    Fort Washington, MD 20744 (Prince Georges County)
    Information Technology
    In-Person
  • RF Spectrum Policy Analyst
    $90K — $120K *
    Arlington, VA 22204 (Arlington County)
    Telecommunications & Hardware
    In-Person
  • Agile Project Lead (SCRUM Master)
    $100K — $130K *
    Lakehurst, NJ 08733 (Ocean County)
    Aerospace & Defense
    In-Person
  • Software Engineer
    $90K — $120K *
    Lakehurst, NJ 08733 (Ocean County)
    Aerospace & Defense
    In-Person

More Information Technology Jobs

Find similar Systems Analyst jobs: