Systems Analyst

Castellum, Inc.

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

Qualifications

  • Must be a US Citizen with the ability to obtain a Public Trust security clearance.
  • Bachelor's degree in Data, Statistics, or related IT field.
  • Minimum 3 years of experience in data analysis.
  • At least 1 year of hands-on experience with Tableau, PowerBI, Oracle, and Python.
  • Familiar with both standard data types and proprietary, mobile, and forensic data formats.
  • Advanced understanding of SQL is essential.
  • Strong written and verbal communication skills are necessary.

Responsibilities

  • Collaborate with management and legal teams to gather system requirements and assess data flows.
  • Support the migration of diverse file types between legacy and modern systems.
  • Create detailed reports and dashboards using Tableau and PowerBI for decision support.
  • Perform advanced analytics and automation using SQL and Python.
  • Monitor and enhance system performance aligned with operational needs.
  • Work under the supervision of a senior analyst to ensure compliance with business and legal requirements.

Benefits

  • Opportunity to work closely with the US Department of Justice.
  • Engagement in meaningful projects that support critical legal and operational functions.
  • Access to advanced tools like Tableau and PowerBI for data visualization and analysis.
  • Collaborative work environment involving cross-functional teams.
  • Potential for professional growth within a government agency.
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.

More Information Technology Jobs

Find similar Systems Analyst jobs: